Re: [GENERAL] Uploading data to postgresql database

2009-03-18 Thread Scott Marlowe
On Tue, Mar 17, 2009 at 6:31 AM, Subha Ramakrishnan su...@gslab.com wrote: I use postgresql 8.3.1 with postgis 1.3.3. Don't know about the other stuff, but is there a good reason you're running such an old release of 8.3? - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Uploading data to postgresql database

2009-03-18 Thread Subha Ramakrishnan
No specific reason for using the old version. Still in the process of upgrading the softwares that we are using in the project. Soon, we'll be using the latest version. Does using an old version stop me from using a particular functionality? Subha Scott Marlowe wrote: On Tue, Mar 17, 2009 at

Re: [GENERAL] Uploading data to postgresql database

2009-03-18 Thread Scott Marlowe
On Wed, Mar 18, 2009 at 1:31 AM, Subha Ramakrishnan su...@gslab.com wrote: No specific reason for using the old version. Still in the process of upgrading the softwares that we are using in the project. Soon, we'll be using the latest version. Does using an old version stop me from using a

Re: [GENERAL] Uploading data to postgresql database

2009-03-18 Thread Brent Wood
ogr2ogr can write most formats to most other formats. It can certainly write to a PostGIS database, read KML., so if it can write it to shape, it can write direct to Postgis You just need to set your output format to postgis. Note: depending on where you got GDAL (ogr2ogr) from, it may or may

Re: [GENERAL] Uploading data to postgresql database

2009-03-18 Thread Subha Ramakrishnan
That would be great. I do have GDAL compiled with postgis. I'll definitely try this option. Thanks a lot. Subha Brent Wood wrote: ogr2ogr can write most formats to most other formats. It can certainly write to a PostGIS database, read KML., so if it can write it to shape, it can write

[GENERAL] Uploading data to postgresql database

2009-03-17 Thread Subha Ramakrishnan
Hi All, I wanted to know if there is a way to upload kml/gpx data directly to the DB. 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

Re: [GENERAL] Uploading data to postgresql database

2009-03-17 Thread Tino Wildenhain
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

Re: [GENERAL] Uploading data to postgresql database

2009-03-17 Thread Stephen Frost
* Subha Ramakrishnan (su...@gslab.com) wrote: 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. Have you looked at ogr2ogr? It looks to support KML as a format, and has PostGIS support, though I'm not sure if it can

Re: [GENERAL] Uploading data to postgresql database

2009-03-17 Thread Subha Ramakrishnan
Hi, Thanks for the reply. I did take a look at ogr2ogr which can convert kml to shape. But i was wondering if there's some direct way..:) And by upload I meant adding geometry data to the DB. Thanks regards, Subha Stephen Frost wrote: * Subha Ramakrishnan (su...@gslab.com) wrote: So