I was interested in a similar thing once, but the ogr2ogr option names
are misleading.
"-update" means add to an existing data source (ie the database in
Postgres). Otherwise ogr2ogr will try to create a new database, and
fail if it exists.
"-append" means add to an existing layer (or, the table within the
database) within a data source. Otherwise it will try to create a new
table, and fail if it exists.
Update will not replace any attributes or geometry for a feature that
already exists with the same FID, but will stop with a duplicate key
error.
On May 6, 2008, at 6:06 PM, Martin Chapman wrote:
Ogr2Ogr at http://www.gdal.org/ogr/ogr2ogr.html has append and update
options. As long as your new columns were added to the end of the
table it
will probably will work fine.
Best regards,
Martin
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
SenTnel
Sent: Tuesday, May 06, 2008 4:40 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Updated shapefile to update postgres database
Hello!
I would like some help updating a postgres database. This is the
problem: We
created the database using shp2pgsql to convert a shapefile that
contains a
city's street details (centerline), after we created the database we
also
created an aditional column to classify the street types (eg: street,
avenues, highways, etc.), now we are working on the original
shapefile,
updating new roads, changes made to highways due to constructions
modifications, etc., and we want to upload the "updated" shapefile,
without
afecting the actual database, another words, we would like to
convert to
postgres the updated shapefile with the new information (it cuold be
the
whole shapefile) but to keep the added clasiffication column intact.
How can
we do that?
Thanks
--
View this message in context:
http://www.nabble.com/Updated-shapefile-to-update-postgres-database-tp170535
62p17053562.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/
The equator is so long, it could encircle the earth completely once.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
