[postgis-users] Bogus unknown geometry error from ST_Transform

[Aren Cambre]

Nope. BTW, there is an extraneous parenthesis in your example. Here's what
I used:
*UPDATE gis."gz_2010_48_160_00_500k"*
*SET "the_geom_3081" = ST_Transform(ST_Setsrid(the_geom, 4629),3081);*

(BTW, I said 4326 earlier, but I should have been using 4269. Not sure that
explains the errors, however.)

Now I get this:
*ERROR: new row for relation "gz_2010_48_160_00_500k" violates check
constraint "enforce_geotype_the_geom_3081"*

This is just bizarre because the source and destination column are POLYGON
types.

Here's what I get when running *ST_AsEWKT(the_geom)*:
*"POLYGON((-94.940569 29.330815,-94.93334 29.329038,-94.930971
29.327708,-94.929679 29.32634,-94.938834 29.320412,-94.946644
29.323065,-94.946988 29.326066,-94.94085 29.330469,-94.940569 29.330815))"*

I just double-checked, and there are no other rows in
public.geometry_columns describing anything in the
*gz_2010_48_160_00_500k*table besides the two rows I pasted earlier.

Here's that constraint:
*enforce_geotype_the_geom_3081 CHECK (geometrytype(the_geom_3081) =
'POLYGON'::text OR the_geom_3081 IS NULL);*

Aren

On Sun, Feb 19, 2012 at 2:10 AM, <pcreso at pcreso.com> wrote:

> Does this work?
>
> *UPDATE gis."gz_2010_48_160_00_500k"*
> *SET "the_geom_3081" = ST_Transform((ST_Setsrid(the_geom, 4326),3081);*
>
> ie:: is the problem finding the srid from geometry_columns or finding it
> but ST_Transform() fails even when given the srid?
>
> Even if there is a bug, this may work for you until fixed?
>
> Brent Wood
>
> --- On *Sun, 2/19/12, René Romero Benavides <ichbinrene at gmail.com>* wrote:
>
>
> From: René Romero Benavides <ichbinrene at gmail.com>
> Subject: Re: [postgis-users] Bogus unknown geometry error from ST_Transform
> To: postgis-users at postgis.refractions.net
> Date: Sunday, February 19, 2012, 8:37 PM
>
>
>  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.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
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at postgis.refractions.net <http://mc/compose?to=postgis-users@postgis.refractions.net>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  I thought a SRID of -1 was a synonym for the default one (4326). But
> don't take my word for it, I'm beginning with postgis.
> --
>  http://sharingtechknowledge.blogspot.com/
>
> -----Inline Attachment Follows-----
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net<http://mc/compose?to=postgis-users@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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120219/0b1f7f55/attachment.html>