[Qgis-user] postgis / PHP

[uk52rob]

Thanks Andreas, I will give that a go.

 

 

Date: Thu, 09 Feb 2012 17:21:15 +0100

From: Andreas Neumann <a.neumann at carto.net>

Subject: Re: [Qgis-user] postgis / PHP

To: <qgis-user at lists.osgeo.org>

Message-ID: <c45ab8cba3c98432ac7ed27f2108961b at carto.net>

Content-Type: text/plain; charset=UTF-8; format=flowed

 

Hi,

 

You can use the Postgis commands "ST_AsText()" and "ST_GeomFromText()" 

 for this purpose. If you want to extract x/y you can use

ST_AsText(ST_X(the_geom)) AS x.

 

Hope this helps? It is really easy - not complicated at all.

 

Andreas

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120209/7dcad6ee/attachment.html>