I'm glad it worked!<br><br><div class="gmail_quote">On Wed, Mar 7, 2012 at 11:29 AM, Bob Basques <span dir="ltr"><<a href="mailto:Bob.Basques@ci.stpaul.mn.us">Bob.Basques@ci.stpaul.mn.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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">All,</font> </p>
<br>
<p style="margin-bottom:0;margin-top:0">
<font face="Comic Sans MS" size="3">I'm no expert in postgis by any means, but I did try that, and I only got a return with the POSTGIS version. I know that all those components are there (Since I eventually got it working, but that way the POSTGIS reports things like permission error and such is very subtle IMO, and some things need to be considered in different ways.</font> </p>
<br>
<p style="margin-bottom:0;margin-top:0">
<font face="Comic Sans MS" size="3">I ended up switching LAT/LON for LON/LAT in my query, which was giving me a permission denied error. Once I switched the numbers around, it all worked fine, no permission changes or anything. I've since been informed, that my erroneous query was trying to add a spatial project that didn't exist, hence the permissions error. </font> </p>
<br>
<p style="margin-bottom:0;margin-top:0">
<font face="Comic Sans MS" size="3">All makes sense once it's explained, but coming into to it cold . . . another story. :c)</font> </p>
<br>
<p style="margin-bottom:0;margin-top:0">
<font face="Comic Sans MS" size="3">bobb</font> </p><div><div class="h5">
<br> <br>
<p style="margin-bottom:0;margin-top:0">
<br>
<br>
>>> George Silva <<a href="mailto:georger.silva@gmail.com" target="_blank">georger.silva@gmail.com</a>> wrote:<br> </p>
<table bgcolor="#f3f3f3" style="font-size:1em;margin-right:0;margin-top:0;margin-left:15px;margin-bottom:0" border="0">
<tbody><tr>
<td>
<div style="border-left:solid 1px #050505;padding-left:7px">
<p style="margin-bottom:0;margin-top:0">
Also you can confirm if PROJ4 is installed by: </p>
<div>
<p style="margin-bottom:0;margin-top:0">
<br>
</p>
</div>
<div>
<p style="margin-bottom:0;margin-top:0">
SELECT * FROM POSTGIS_FULL_VERSION(); </p>
</div>
<div>
<p style="margin-bottom:0;margin-top:0">
<br>
</p>
</div>
<div>
<p style="margin-bottom:0;margin-top:0">
If PROJ4 is installed, it should appear in that string. </p>
</div>
<div>
<p style="margin-bottom:0;margin-top:0">
<br>
</p>
</div>
<div>
<p style="margin-bottom:0;margin-top:0">
George<br><br> </p>
<div class="gmail_quote">
<p style="margin-bottom:0;margin-top:0">
On Tue, Mar 6, 2012 at 3:48 PM, Mike Toews <span dir="ltr"><<a href="mailto:mwtoews@gmail.com" target="_blank">mwtoews@gmail.com</a>></span> wrote:<br> </p>
<blockquote class="gmail_quote" style="margin-right:0;margin-top:0;border-left:1px #ccc solid;margin-left:0;margin-bottom:0;padding-left:0">
<p style="margin-bottom:0;margin-top:0">
On 7 March 2012 06:10, Bob Basques <<a href="mailto:Bob.Basques@ci.stpaul.mn.us" target="_blank">Bob.Basques@ci.stpaul.mn.us</a>> wrote:<br>> ...<br> </p>
<div>
<p style="margin-bottom:0;margin-top:0">
> ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric,<br>> part4::numeric),4326)), 200068) as geom_city<br> </p>
</div>
<p style="margin-bottom:0;margin-top:0">
> ...<br> </p>
<div>
<p style="margin-bottom:0;margin-top:0">
> ERROR: function st_transform(geometry) does not exist<br>> LINE 4: ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa...<br><br> </p>
</div>
<p style="margin-bottom:0;margin-top:0">
It looks like "4326)), 200068)" should be "4326), 200068))"<br><span><font color="#888888"><br style="color:#888888">-Mike<br style="color:#888888"></font></span> </p>
<div>
<div>
<p style="margin-bottom:0;margin-top:0">
_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> </p>
</div>
</div>
</blockquote>
</div>
<p style="margin-bottom:0;margin-top:0">
<br>
<br clear="all">
</p>
<div>
<p style="margin-bottom:0;margin-top:0">
<br>
</p>
</div>
<p style="margin-bottom:0;margin-top:0">
--<br>George R. C. Silva<br><br>Desenvolvimento em GIS<br><a href="http://geoprocessamento.net" target="_blank">http://geoprocessamento.net</a><br><a href="http://blog.geoprocessamento.net" target="_blank">http://blog.geoprocessamento.net</a> </p>
<div style="padding-left:0px;padding-right:0px;line-height:130%;padding-top:0px;text-align:left;font-size:10px;margin-left:0px;margin-top:0px;padding-bottom:0px">
<br>
</div>
<div style="padding-left:0px;padding-right:0px;line-height:130%;padding-top:0px;text-align:left;font-size:10px;margin-left:0px;margin-top:0px;padding-bottom:0px">
<br>
</div>
<div style="padding-left:0px;padding-right:0px;line-height:130%;padding-top:0px;text-align:left;font-size:10px;margin-left:0px;margin-top:0px;padding-bottom:0px">
<br>
</div>
<p style="margin-bottom:0;margin-top:0">
<br>
</p>
</div>
</div>
</td>
</tr>
</tbody></table>
</div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>George R. C. Silva<br><br>Desenvolvimento em GIS<br><a href="http://geoprocessamento.net" target="_blank">http://geoprocessamento.net</a><br><a href="http://blog.geoprocessamento.net" target="_blank">http://blog.geoprocessamento.net</a><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%">
</div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%">
</div><br>