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

[Bob Basques]

Ok, it looks like I may not have PROJ support compiled in, but wouldn't the existence of the SPATIAL_REF_SYS mean that PROJ is installed?? 

bobb 



>>> "Bob Basques" <Bob.Basques at ci.stpaul.mn.us> wrote:


All, 


made nice progress from Simon's suggestions, but . . . 


Ok, I'm probably trying to push this harder than I need to, but, I'm trying to ST_Transform the data from 4326 to 200068 (Our private projection) in the construction of the view, but I keep hitting permission errors.   


NOTE: we use the 200068 projection for all of our data, have for years.  It's definition in SPATIAL_REF_SYS is correct.   


This works fine: 


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 
      from 
          (select rxtime, 
                  split_part(cmd, ',', 3) as part3, 
                  split_part(cmd, ',', 4) as part4 
             from  
                  cmdstpinfo 
            where cmd  
             like '>Plot:%') AS first_pass; 


But this give me an error, do I have the ST_Transform in the right spot, is 8.4.2 too old of a release? : 


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; 


Like: 


ERROR:  function st_transform(geometry) does not exist
LINE 4:            ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa...
                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. 

  

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

  

ERROR: function st_transform(geometry) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Character: 212 




Thanks 


bobb 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120306/da35ac98/attachment.html>