[Routing] render the postgresql query into openlayers (GeoJSON output)

[Daniel Kastl]

On Thu, Aug 11, 2011 at 2:43 AM, javad sadidi <jsadidi at gmail.com> wrote:

> yes.but in your example Id dont know how can I replace the edge variable
> $edge with my query result.
> select * from ways where street name is somthing.


How does your query result look like?
I don't understand what you want to replace there?

Your query "select * from ways where street name is somthing" needs to
return at least the geometries of your route segments. And GeoJSON is a
convenient format if you later want to use OpenLayers.

Daniel




>
>
>
> On Wed, Aug 10, 2011 at 7:02 PM, Daniel Kastl <daniel at georepublic.de>wrote:
>
>> Hi Javad,
>>
>> hi to all.
>>>  I am working on pgrouting project.I am using OSM data to find the best
>>> route.
>>> but I want to take a query into postgresql by php server side and returen
>>> the result on the browser with GeoJSON format. for example I want bring the
>>> result of this query as selected streets on the browser by openlayers.
>>> select * from table where streetname is x or y;
>>>
>>
>> You mean this?
>> http://workshop.pgrouting.org/chapters/php_server.html#geojson-output
>>
>>
>>> then bring the result by Geojson output to the browser,I would like to
>>> display these streets as red color in the browser for clients.
>>> who can help me?
>>>
>>
>> Here is an example with GeoExt:
>> http://workshop.pgrouting.org/chapters/geoext_client.html#full-source-code
>>
>> Daniel
>>
>>
>>> it the simplest example.
>>> danke
>>>
>>>
>>>
>>> _______________________________________________
>>> Routing mailing list
>>> Routing at openstreetmap.org
>>> http://lists.openstreetmap.org/listinfo/routing
>>>
>>>
>>
>>
>> --
>> Georepublic UG & Georepublic Japan
>> eMail: daniel.kastl at georepublic.de
>> Web: http://georepublic.de
>>
>> _______________________________________________
>> Routing mailing list
>> Routing at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/routing
>>
>>
>
> _______________________________________________
> Routing mailing list
> Routing at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/routing
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/routing/attachments/20110811/01c2bc1a/attachment.html>