<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<STYLE type=text/css>P {
MARGIN: 0px
}
</STYLE>
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>Sophie,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>The 1.3.4 is well not actually released yet, but you can
get it from the svn repository</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>By following the instructions here</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2><A
href="http://postgis.refractions.net/download/">http://postgis.refractions.net/download/</A>
(on how to connect to the repository)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>Then checkout the branches/1.3</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>I was hoping it would be a bit easier - to just download
the postgis-svn.tar.gz (but looking at that - that looks like the 1.4 version
which is kind of unstable at the moment I think).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>HINT HINT to someone in dev group: Maybe we should
also output the 1.3 branch as a tar.gz?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>After you have compiled etc, it outputs just the geojson
part, so you'll need to glue the strings (forming your attribute) together with
your favorite web language e.g. PHP, python, .NET, Perl,
whatever</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>and then you could use OpenLayers which has a driver for
GeoJSON format as described</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>here: <A
href="http://dev.openlayers.org/docs/files/OpenLayers/Format/GeoJSON-js.html">http://dev.openlayers.org/docs/files/OpenLayers/Format/GeoJSON-js.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>and example here (actually this one you can cut and paste
an individual GeoJSON output geometry to see how it looks - take for example
Paul's example below - get rid of the line breaks and paste
in)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2><A
href="http://dev.openlayers.org/sandbox/tschaub/feature/examples/geojson.html">http://dev.openlayers.org/sandbox/tschaub/feature/examples/geojson.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=807403410-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Sophie GRAS<BR><B>Sent:</B> Friday, August 01, 2008 6:20 AM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
JSON<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="COLOR: #000000; FONT-FAMILY: Times New Roman">Hi everybody,<BR>i
want to use the asgeojson function.<BR>Do you know where we can find the 1.3.4
version of postgis ?<BR>once you have your data in the "geojson format", how do
you "call" it in the json file ?<BR>Thanks for your
help<BR><BR>Sophie<BR><BR>----- Mail Original -----<BR>De: "Paragon Corporation"
<lr@pcorp.us><BR>À: "PostGIS Users Discussion"
<postgis-users@postgis.refractions.net><BR>Envoyé: Jeudi 31 Juillet 2008
07:16:24 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm /
Vienne<BR>Objet: RE: [postgis-users] JSON<BR><BR>We should update the docs to
have an Availability section for the Geometry<BR>Outputs. Well at the very
least for the ST_AsGeomJson.<BR><BR>It confused me too when I tried to use
that function and realized it was in<BR>an unreleased
version.<BR> <BR><BR>-----Original Message-----<BR>From:
postgis-users-bounces@postgis.refractions.net<BR>[mailto:postgis-users-bounces@postgis.refractions.net]
On Behalf Of Paul<BR>Ramsey<BR>Sent: Wednesday, July 30, 2008 7:29 PM<BR>To:
PostGIS Users Discussion<BR>Subject: Re: [postgis-users] JSON<BR><BR>I think
it's unreleased on the 1.3 branch. I have it here on my development<BR>box.
So 1.3.4 would have it.<BR><BR># select st_asgeojson(geom) from fe_edges
limit 1;<BR>
st_asgeojson<BR>----------------------------------------------------------------------------<BR>----------------------------------------------------<BR> <BR>{"type":"MultiLineString","coordinates":[[[-89.734634999999997,31.4920720000<BR>00000],[-89.734955999999997,31.492237999999997]]]}<BR>(1
row)<BR><BR><BR>On Wed, Jul 30, 2008 at 4:16 PM, Jim
<jbucher@cnrit.tamu.edu> wrote:<BR>> I just installed 1.3.3 and I don't
see an ST_AsGeoJson or an AsGeoJson <BR>> function.<BR>><BR>> Paul
Ramsey wrote:<BR>>><BR>>> Jim,<BR>>><BR>>> We've got
that contribution already,<BR>>><BR>>><BR>>>
http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2<BR>>>
975494<BR>>><BR>>> Thanks though!<BR>>><BR>>>
Paul<BR>>><BR>><BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> postgis-users@postgis.refractions.net<BR>>
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>><BR>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR><BR><BR>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>