Subha Ramakrishnan wrote:
Hi All,I wanted to know if there is a way to upload kml/gpx data directly to the DB.
By upload you mean...? You can always just insert the date opaque as raw field or text or use large object (lo).
So far, I have been using shp2pgsql to upload data from shape files. I don't want to convert it to shape and then upload it.If someone knows of a way to upload without converting to shape file, please let me know.
If you plan to do anything with the data inside the database (and your reference to PostGIS indicates that) you need to insert it in a structured way as opposed to just "upload the data". What is wrong with the conversion step you mention? Regards Tino
<<attachment: smime.p7s>>