[postgis-users] Spatial column from text via a VIEW, Possible?

[Bob Basques]

All, 

I hit this earlier in my testing, so I must have had things in the right order at some earlier point in the process. 

This : 

select 
           ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326) as geom, 
           ST_AsText(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)) as geom_text, 
           ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326), 200068)) as geom_city 
      from 
          (select rxtime, 
                  split_part(cmd, ',', 3) as part3, 
                  split_part(cmd, ',', 4) as part4 
             from  
                  cmdstpinfo 
            where cmd  
             like '>Plot:%') AS first_pass; 

is producing this (which I did hit early on but thought I had the syntax wrong at the time) : 

ERROR:  transform: couldn't project point (44.9677 -93.1268 0): latitude or longitude exceeded limits (-14) 

  

********** Error ********** 

  

ERROR: transform: couldn't project point (44.9677 -93.1268 0): latitude or longitude exceeded limits (-14)
SQL state: XX000 

This indicates to me that the transform stuff is there , but that it failed.  I haven't found many references to this error online.  The numbers above are the numbers from the first record in the table.  When I hit this earlier, I thought I might be trying to transform against the TEXT (those numbers) object vs the GEOM object (which I'm supposed to use, right??).  The result of the ST_SetSRID seems to be the correct type of object to pass to ST_Transform based on what I found in my searches.  Maybe I'm not supposed to try the transform in this manner. 

bobb 






>>> Mike Toews <mwtoews at gmail.com> wrote:


On 7 March 2012 06:10, Bob Basques <Bob.Basques at ci.stpaul.mn.us> wrote:
> ...
>            ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric,
> part4::numeric),4326)), 200068) as geom_city
> ...
> ERROR:  function st_transform(geometry) does not exist
> LINE 4:            ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa...

It looks like "4326)), 200068)" should be "4326), 200068))"

-Mike
_______________________________________________
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/20120306/212128a9/attachment.html>