From: | "Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz> |
---|---|
To: | <subha(at)gslab(dot)com>, <sfrost(at)snowman(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Uploading data to postgresql database |
Date: | 2009-03-18 08:43:09 |
Message-ID: | 49C16AED0200007B00019E84@gwia1.ham.niwa.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gslab(dot)com> 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(at)gslab(dot)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 handle the direction
> you're asking for.
>
> Stephen
>
-
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Subha Ramakrishnan | 2009-03-18 08:55:42 | Re: Uploading data to postgresql database |
Previous Message | Scott Marlowe | 2009-03-18 08:35:25 | Re: postmaster never finishes starting up, silent to boot |