[postgis-users] Updated shapefile to update postgres database

[SenTnel]

Hello Regina! Thanks for your help, but when I try running it I got this
error message:


ERROR:  function st_equals(geometry, geometry) does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.

:confused:
Thanks!



Paragon Corporation-2 wrote:
> 
> Here is a thought, but not sure how slow this will be
> 
> DELETE FROM mystreets_table
> WHERE street = 'N/A' AND 
> EXISTS (SELECT n.street FROM mystreets_table n  WHERE (n.street <> 'N/A'
> AND
> n.street > '')  AND ST_Equals(n.the_geom, mystreets_table.the_geom))
> 
> The st_equals might be better to replace with ~=  if you want to match
> exact
> vertices.  I presume ~= is actually more efficient
> 
> Hope that helps,
> Regina 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> SenTnel
> Sent: Saturday, June 07, 2008 2:25 AM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Updated shapefile to update postgres database
> 
> 
> 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! 
> 
> 
> 
> 
> SenTnel wrote:
>> 
>> 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
>>> 
>> 
>> 
> 
> --
> View this message in context:
> http://www.nabble.com/Updated-shapefile-to-update-postgres-database-tp170535
> 62p17705777.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
> 
> 

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