<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
</HEAD>
<BODY>
Hi Sushma<BR>
<BR>
I have used plpgsql very successfully together with Tobin Bradley's RESTful Web Service Framework (<A HREF="http://www.fuzzytolerance.info/projects">www.fuzzytolerance.info/projects</A> ).<BR>
All I do is set the function to return a text data type and then format the in-function result as a geojson string. The geojson response can then be directly displayed in openlayers or even loaded into a GeoExt featuregrid.<BR>
<BR>
It is also possible to use the same framework with gml instead of geojson (but I prefer the geojson way...)<BR>
<BR>
Hope this helps.<BR>
<BR>
Regards<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
<B>Glenn Mullett</B><BR>
<I><FONT SIZE="1"><FONT COLOR="#333333">BTech(Nature Cons) PGDip(UNIGIS)</FONT></FONT></I><BR>
<FONT SIZE="2"><FONT COLOR="#333333">H.O.D. GIS</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#333333">Lidwala Consulting Engineers</FONT></FONT><BR>
<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
On Wed, 2011-08-17 at 17:27 +0100, Sush Pokharel wrote:
<BLOCKQUOTE TYPE=CITE>
Hi guys,
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
I want to implement pgrouting using openlayer. I want to get the shortest route from one building to another building
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
and i have written a PL/pgSQL(this is an procedural language which helps to iterate and put more than one sql queries together) function to find the shortest route from one building to another and i wanted to use this PL.pgSQL function in openlayer such that the routes can be return on the map<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
Can any of you guys suggest me how PL/pgSQL function can be displyed on map using openlayer.
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
So far i can display the map from postgis database using geoserver and openlayer and can set the start and end point as a layer using openlayer .
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
Regards,
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
Sushma
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<PRE>
_______________________________________________
Users mailing list
<A HREF="mailto:Users@lists.osgeo.org">Users@lists.osgeo.org</A>
<A HREF="http://lists.osgeo.org/mailman/listinfo/openlayers-users">http://lists.osgeo.org/mailman/listinfo/openlayers-users</A>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>