[Routing] render the postgresql query into openlayers (GeoJSON output)
javad sadidi
jsadidi at gmail.com
Fri Aug 12 18:42:14 BST 2011
hi daniel
when I execute closedstreets.php there is only a white page in the browser,
I mean nothing,
when I see error.log there is nothing as error related to closedstreets.php
btw, I attached the both codes, you can examine the. but I think there is
some thing in pgrouting-final.html which I have not declared for the
execution of the cloesdstreets.php. for example to bring the OSM layer into
the browser we call the Ext.onReady(function() but for the closed
streets.php , there is nothing to act as trigger,
danke
On Fri, Aug 12, 2011 at 3:35 AM, Daniel Kastl <daniel at georepublic.de> wrote:
> What does ./php/closedstreets.php return?
> Do you use Firebug to check the AJAX request?
> What can you see in /var/log/apache2/error.log?
>
> Daniel
>
>
> On Fri, Aug 12, 2011 at 5:09 AM, javad sadidi <jsadidi at gmail.com> wrote:
>
>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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/20110812/37573265/attachment-0002.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/routing/attachments/20110812/37573265/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: closedstreets.php
Type: application/x-httpd-php
Size: 1224 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/routing/attachments/20110812/37573265/attachment-0001.php>
More information about the Routing
mailing list