[postgis-users] Bogus unknown geometry error from ST_Transform

Aren Cambre aren at arencambre.com
Sat Feb 18 21:29:22 PST 2012


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 columns, and neither has SRID of -1:
*34281;"''";"gis";"gz_2010_48_160_00_500k";"the_geom";2;4326;"POLYGON"*
*34276;"''";"gis";"gz_2010_48_160_00_500k";"the_geom_3081";2;3081;"POLYGON"*

What gives?

Aren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120218/90c64261/attachment.html>


More information about the postgis-users mailing list