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 <[email protected]> wrote: > > > On Thu, Aug 11, 2011 at 2:43 AM, javad sadidi <[email protected]> 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 <[email protected]>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 >>>> [email protected] >>>> http://lists.openstreetmap.org/listinfo/routing >>>> >>>> >>> >>> >>> -- >>> Georepublic UG & Georepublic Japan >>> eMail: [email protected] >>> Web: http://georepublic.de >>> >>> _______________________________________________ >>> Routing mailing list >>> [email protected] >>> http://lists.openstreetmap.org/listinfo/routing >>> >>> >> >> _______________________________________________ >> Routing mailing list >> [email protected] >> http://lists.openstreetmap.org/listinfo/routing >> >> > > > -- > Georepublic UG & Georepublic Japan > eMail: [email protected] > Web: http://georepublic.de > > _______________________________________________ > Routing mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/routing > >
_______________________________________________ Routing mailing list [email protected] http://lists.openstreetmap.org/listinfo/routing
