[postgis-users] JSON

[Courtin Olivier]

On Aug 1, 2008, at 12:20 PM, Sophie GRAS wrote:

Hi Sophie,

> i want to use the asgeojson function.
> Do you know where we can find the 1.3.4 version of postgis ?

This version is not yet released,
You could use the current SVN version from 1.3 branch:

svn checkout http://svn.refractions.net/postgis/branches/1.3 postgis-1.3

(require to have an svn client already installed, cf http://subversion.tigris.org/)

> once you have your data in the "geojson format", how do you "call"  
> it in the json file ?


Not sure to really understand the question, below a working use case:

SELECT ST_AsGeoJson(the_geom) FROM your_table LIMIT 1;

and copy/paste the result in OpenLayers:
cf <http://openlayers.org/dev/examples/vector-formats.html>


HTH,

--
Olivier