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

[javad sadidi]

yes. I will change my questions direction to Openlayers mailing list.
but I think you are the most skill full person in this case. because you
wrote the workshop.
I always test my self at first and while I dont get result , I mail to you.
but in this case , I dont get any result, there is no error. for example I
changed the codes according to your email but nothing happens abou
displaying closed streets on my map.
I have added the following lines to the pgrouting-final.html file of the
workshop to display the result of the PHP codes.but for example for the
Store of the route that shows the result of routing as a line , there is
some triggers to run its php file. for example when you hit points or move
them or change the method of routing.
but for my added codes what is its trigger to execute the related php file.
// create the layer where the Closed streets will be drawn

var closed_streets = new OpenLayers.Layer.Vector("streets", {
            styleMap: new OpenLayers.StyleMap(new OpenLayers.Style({
                strokeColor: "#1589FF",
                strokeWidth: 6
            }))
        });

then
map.addLayers([points_layer, route_layer, closed_streets]);

and then

/ create the new store to query the web service for dispalying the CLOSED
streets
        var store1 = new GeoExt.data.FeatureStore({
            layer: closed_streets,
            fields: [
                {name: "length"}
            ],
            proxy: new GeoExt.data.ProtocolProxy({
                protocol: new OpenLayers.Protocol.HTTP({
                    url: "./php/closedstreets.php",
                    format: new OpenLayers.Format.GeoJSON({
                        internalProjection: epsg_900913,
                        externalProjection: epsg_4326
                    })
                })
            })
        });


those are all things that I added to the pgrouting-final.html of the
workshop.
does it need to trigger to execute the closedstreets.php or it is executed
automatically?
is these lines enough to have my query result as lines in the browser?

danke




On Thu, Aug 11, 2011 at 4:23 PM, Daniel Kastl <daniel at georepublic.de> wrote:

> Hi Javad,
>
> Why don't you just try it and then see if it works?
> And if it doesn't and you can't find the reason why, then you come back
> here and tell us the error you get.
> Btw., you're now more asking questions about OpenLayers than about routing
> and OSM.
>
>
>
>> you said me that I have to delete the Properties but I dont know exactly
>> which lines. please delete the Property in my php code and copy the correct
>> file for me. and also look to added line in the lines that I added to
>> display the result of PHP file in the browser. for example if you look to my
>> added lines you see that I created a new seore(var store1) . is that
>> right?
>> why the codes doest work? what was the problem?
>> thanks
>>
>>
> You could search for "properties" in the PHP code and then you would find
> it. It's a key/value of the GeoJSON output you want to return.
>
> If you don't know what I mean, change your SQL to
>
> SELECT gid, ST_AsGeoJSON(the_geom) AS geojson, length(the_geom) AS length
> FROM ways WHERE ...
>
> It should work then as it is.
> And once again, consider to change to the OpenLayers mailing list if your
> questions are not related to routing anymore.
>
> Daniel
>
>
>
>> On Thu, Aug 11, 2011 at 4:01 AM, Daniel Kastl <daniel at georepublic.de>wrote:
>>
>>>
>>>
>>>> .is it ok?
>>>>
>>>
>>> More or less, but you need to to try it yourself. (Remove the
>>> "properties" from the GeoJSON, because you don't query for them, or add them
>>> to the query)
>>>
>>>
>>>>
>>>> then to display it in html file with opn layers:  I have to the
>>>> following steps:
>>>> 1-create the layer where the query result will be drown
>>>> 2- add the layer to the map
>>>>
>>>
>>> Yes, it's all described in the workshop. You just need one more layer.
>>>
>>> Daniel
>>>
>>>
>>>
>>>
>>>>
>>>>
>>>> thanks
>>>>
>>>>
>>>>
>>>>
>>> --
>>> 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/20110811/fa36913f/attachment-0001.html>