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

[javad sadidi]

it is very easy.
I am using pgrouting workshop2010 material and find the best route. I do it.
but I also want to select special streets in pgsql and show them in red
color in the browser.
for this I have added a filed in the name of "Status" in the pgsql database
. then for some streets that I want to show them in the browser I set the
Status field to CLOSE:
then I want to show the records which the STATUS of them set to  CLOSE  with
red line in the browser. I mean this query:select * from ways where Status
is CLOSE,
with this command I select the streets taht are CLOSE, then I want to show
them in the browser with red color.
I want to select the records that are CLOSE and bring and show them by
geoext format .
do you understand my mean?

On Wed, Aug 10, 2011 at 7:55 PM, Daniel Kastl <daniel at georepublic.de> wrote:

>
>
> 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
>
> _______________________________________________
> Routing mailing list
> Routing at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/routing
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/routing/attachments/20110810/3f589f41/attachment-0001.html>