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