Hello! Im confused about this issue:
I have a street (polyline) duplicated, one on top of the other, exact same features, same "the_geom", but one bears the street name (column:"street") "main street" and the other bears "N/A" as street name. Now my maps shows the street but the name that shows is "N/A", and I would like to delete the "N/A" polyline, how can i do basically this:
delete from mystreets_table street = 'N/A' where 'N/A' = street 'main street'.the_geom
(delete from mystreets table the street named 'N/A' where the_geom in 'N/A' equals the_geom in street "main street") another words, delete only the N/A streets that the_geom is same as "main street",
I hope you understand,
Thanks!
Thanks Regina, Chris and all of you for your help. Im truly newby but with such help Im ready to start the procedures, Ill keep you posted of my progress or else if some issue comes along that may require some light from you, Thanks again and I hope my problem/solution may be of help to many others,
Thanks again!
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
