Re: [postgis-users] Bogus unknown geometry error from ST_Transform

El 18/02/2012 11:29 p.m., Aren Cambre escribió: ST_Transform is returning a bogus error of* Input geometry has unknown (-1) SRID*. Here's the query: *UPDATE gis."gz_2010_48_160_00_500k"* *SET "the_geom_3081" = ST_Transform(the_geom, 3081);* I said "bogus" because the database's *public.geometr

[postgis-users] Bogus unknown geometry error from ST_Transform

ST_Transform is returning a bogus error of* Input geometry has unknown (-1) SRID*. Here's the query: *UPDATE gis."gz_2010_48_160_00_500k"* *SET "the_geom_3081" = ST_Transform(the_geom, 3081);* I said "bogus" because the database's *public.geometry_columns* table has valid values for these two col

Re: [postgis-users] postgis-2.0.0alpha5

PostGIS 2.0 pre-releases are now available to OS X users through the Homebrew package manager . Install thusly: brew install postgis --devel One data point: Compiled 2.0alpha5 using Clang from Xcode 4.3 and it appears to be working nicely---at least for the

[postgis-users] Landtype minus parcels ?

Hi Birgit- thank you for the reply.. I admit that I have not compared your solution to my own carefully, but instead have written a lot more code, and solved the problem. using psycopg2 and python's threading and Queue , I built a multi- core parallel version. Since the logic loops throu

Re: [postgis-users] Need help detecting lassos

Hi, Not having tried this, but perhaps: Use ST_Polygonize() on the linestrings as in the example here: http://postgis.org/docs/ST_Polygonize.html You could use ST_Dump() to return the polygons & wrap it up in count() for the where clause, so only linestrings able to generate one or more polygon

[postgis-users] Need help detecting lassos

I'd like to be able to detect all line loops that are not closed, but where one end of the line loops around and terminates on another line (a lasso). Querying a table containing several of these returns no ST_IsClosed=true, or ST_IsValid=false, or ST_IsSimple=false. Ultimately, I'd like to spli

Re: [postgis-users] st_dumpaspolygons

Yes From: postgis-users-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] On Behalf Of Jose Carlos Martinez Llario [jomar...@cgf.upv.es] Sent: Saturday, February 18, 2012 2:54 PM To: postgis-users@postgis.refractions.net Subje

[postgis-users] st_dumpaspolygons

Hi, Should st_dumpaspolygons make valid polygons? If the answer is yes I ll open a ticket. Best, Jose ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users