<html>
<head>
</head>
<body style="margin-right: 4px; margin-top: 4px; margin-left: 4px; margin-bottom: 1px; line-height: normal; font-variant: normal">
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">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??</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">bobb</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br>
>>> "Bob Basques" <Bob.Basques@ci.stpaul.mn.us> wrote:<br> </p>
<table bgcolor="#f3f3f3" style="font-size: 1em; margin-right: 0; margin-top: 0; margin-left: 15px; margin-bottom: 0" border="0">
<tr>
<td>
<div style="border-left: solid 1px #050505; padding-left: 7px">
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">All,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">made nice progress from Simon's suggestions, but . . .</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">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. </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">NOTE: we use the 200068 projection for all of our data, have for years. It's definition in SPATIAL_REF_SYS is correct. </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">This works fine:</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3">select</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326) as geom,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_AsText(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)) as geom_text</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> (select rxtime,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 3) as part3,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 4) as part4</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> cmdstpinfo</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> where cmd </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> like '>Plot:%') AS first_pass;</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">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? :</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3">select</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326) as geom,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_AsText(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)) as geom_text,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)), 200068) as geom_city</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> (select rxtime,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 3) as part3,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 4) as part4</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> cmdstpinfo</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> where cmd </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> like '>Plot:%') AS first_pass;</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">Like:</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New">ERROR: function st_transform(geometry) does not exist<br style="font-family: Courier New">LINE 4: ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa...<br style="font-family: Courier New"> ^<br style="font-family: Courier New">HINT: No function matches the given name and argument types. You might need to add explicit type casts.</font> </p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New"> </font> </p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New">********** Error **********</font> </p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New"> </font> </p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New">ERROR: function st_transform(geometry) does not exist<br style="font-family: Courier New">SQL state: 42883<br style="font-family: Courier New">Hint: No function matches the given name and argument types. You might need to add explicit type casts.<br style="font-family: Courier New">Character: 212</font> </p>
</div>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">Thanks</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">bobb</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br>
</p>
</div>
</td>
</tr>
</table>
</body>
</html>