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

[Daniel Kastl]

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

> 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?


You need to do like

SELECT ST_AsGeoJSON(the_geom) AS geojson FROM ways WHERE status = 'closed';

Then you get a list of road segments which you wrap into a GeoJSON format
that OpenLayers GeoJSON layer can read, like:
http://workshop.pgrouting.org/chapters/php_server.html#geojson-output

Daniel


Daniel




>
>
> 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
>>
>>
>
> _______________________________________________
> 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/2a0d5066/attachment.html>