[postgis-users] Spatial column from text via a VIEW, Possible?
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:
SELECT * FROM POSTGIS_FULL_VERSION();
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:
> 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...
More information about the postgis-users