[postgis-users] Updated shapefile to update postgres database

SenTnel elvin.pimentel at gmail.com
Tue May 6 22:50:12 PDT 2008


Thanks! Thats exactly what I want to do, but just don't know how to. I don't
pretend for you to give me a step by step indication but Ill apreciate some
instructions since Im really new to this and im eager to learn more about
it. Thanks again!


Chris Hermansen wrote:
> 
> Presumably what you mean by "update" is that you want to replace old
> versions of roads already in PostGIS with new versions of the same roads
> from shapefiles, and you want to keep the old street type in conjunction
> with the updated geometry?
> 
> SenTnel wrote:
>> 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
>>   
> 
> 
> -- 
> Regards,
> 
> Chris Hermansen         mailto:chris.hermansen at timberline.ca
> tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.232.0644
> Timberline Natural Resource Group · http://www.timberline.ca
> 401 · 958 West 8th Avenue  · Vancouver BC · Canada · V5Z 1E5
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Updated-shapefile-to-update-postgres-database-tp17053562p17097758.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list