[OpenLayers-Users] displaying PL/pgSQL shortest path function using openlayer

[Glenn Mullett]

Hi Sushma

I have used plpgsql very successfully together with Tobin Bradley's
RESTful Web Service Framework (www.fuzzytolerance.info/projects ).
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.

It is also possible to use the same framework with gml instead of
geojson (but I prefer the geojson way...)

Hope this helps.

Regards

Glenn Mullett
BTech(Nature Cons) PGDip(UNIGIS)
H.O.D. GIS
Lidwala Consulting Engineers



On Wed, 2011-08-17 at 17:27 +0100, Sush Pokharel wrote:
> Hi guys,
> 
> 
> I want to implement pgrouting using openlayer. I want to get the
> shortest route from one building to another building
> 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
> 
> Can any of you guys suggest me how PL/pgSQL function can be displyed
> on map using openlayer.
> 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 .
> 
> 
> Regards,
> Sushma
> 
> _______________________________________________
> Users mailing list
> Users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/openlayers-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20110818/ec538284/attachment.html