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

[George Silva]

I'm glad it worked!

On Wed, Mar 7, 2012 at 11:29 AM, Bob Basques <Bob.Basques at ci.stpaul.mn.us>wrote:

>  All,
>
>  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)
>
>  bobb
>
>
>
>
> >>> 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.
>
>
>   George
>
>   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))"
>>
>> -Mike
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
>   --
> George R. C. Silva
>
> Desenvolvimento em GIS
> http://geoprocessamento.net
> http://blog.geoprocessamento.net
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
George R. C. Silva

Desenvolvimento em GIS
http://geoprocessamento.net
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120307/e21c3a6f/attachment.html>