[Qgis-user] postgis / PHP

[Andreas Neumann]

 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

 On Thu, 9 Feb 2012 16:04:29 -0000, uk52rob wrote:
> Does anyone know of a simple PHP script which can be used to connect
> to a postgis DB and load / update a point layer?
>
> I really need something that would decode the 'the_geom' field to X/Y
> values, then re-encode on update.
>
> Thanks

-- 
 --
 Andreas Neumann
 Böschacherstrasse 10A
 8624 Grüt (Gossau ZH)
 Switzerland