[postgis-users] Updated shapefile to update postgres database

Martin Chapman mchapman at texelinc.com
Wed May 7 08:01:00 PDT 2008


Thanks for that info William.  

Best regards,
Martin

-----Original Message-----
From: William Kyngesburye [mailto:woklist at kyngchaos.com] 
Sent: Tuesday, May 06, 2008 5:56 PM
To: PostGIS Users Discussion
Cc: Martin Chapman; SenTnel
Subject: Re: [postgis-users] Updated shapefile to update postgres database

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: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of  
> SenTnel
> Sent: Tuesday, May 06, 2008 4:40 PM
> To: postgis-users at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at 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.





More information about the postgis-users mailing list