[postgis-users] Bogus unknown geometry error from ST_Transform

[pcreso at pcreso.com]

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 list
postgis-users at 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://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120219/898477b6/attachment.html>