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

Bob Basques Bob.Basques at ci.stpaul.mn.us
Wed Mar 7 06:29:44 PST 2012


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. 

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.   

All makes sense once it's explained, but coming into to it cold . . .  another story.   :c) 


>>> George Silva <georger.silva at gmail.com> wrote:

Also you can confirm if PROJ4 is installed by: 


If PROJ4 is installed, it should appear in that string. 


On Tue, Mar 6, 2012 at 3:48 PM, 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))"

postgis-users mailing list
postgis-users at postgis.refractions.net

George R. C. Silva

Desenvolvimento em GIS

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

More information about the postgis-users mailing list