Search Postgresql Archives

Re: Uploading data to postgresql database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 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 not have PostGIS drivers compiled in, if it doesn't you can compile it yourself against Postgres/PostGIS to enable this on your platform.


Brent Wood

Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
Subha Ramakrishnan <subha@xxxxxxxxx> 03/18/09 7:04 PM >>>
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 (subha@xxxxxxxxx) 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 handle the direction
you're asking for.

	Stephen


-
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.



-
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux