Re: [OSM-talk] SQL to query street name within a define bbox

Thanks Jukka, You resolved my question. On Thu, Mar 5, 2009 at 9:26 PM, Jukka Rahkonen wrote: > John3478 John3478 gmail.com> writes: > > > > > Hi,Did any one know how to query street name within a define bbox?And > second > question, how to find lat, lon mid point of a street.Thank you in > adv

Re: [OSM-talk] SQL to query street name within a define bbox

John3478 John3478 wrote: > Thanks, actually, I have the planet data and I want to use sql query to > query exactly the same way as the osmxapi that you have. Do you know what is > that sql? Before we can answer that we need to know what format you have the planet data in... Do you just mean the

Re: [OSM-talk] SQL to query street name within a define bbox

On Fri, Mar 6, 2009 at 5:21 AM, John3478 John3478 wrote: > Thanks, actually, I have the planet data and I want to use sql query to > query exactly the same way as the osmxapi that you have. Do you know what is > that sql? > XAPI uses a schemaless database so there's no SQL. > > On Thu, Mar 5,

Re: [OSM-talk] SQL to query street name within a define bbox

John3478 John3478 gmail.com> writes: > > Hi,Did any one know how to query street name within a define bbox?And second question, how to find lat, lon mid point of a street.Thank you in advance,john > Hi, Import data into PostGIS with osm2pgsql and continue there. For example the latter goes t

Re: [OSM-talk] SQL to query street name within a define bbox

Thanks, actually, I have the planet data and I want to use sql query to query exactly the same way as the osmxapi that you have. Do you know what is that sql? On Thu, Mar 5, 2009 at 7:19 PM, 80n <80n...@gmail.com> wrote: > > http://osmxapi.hypercube.telascience.org/api/0.5/way[name=Broadway][bbox

Re: [OSM-talk] SQL to query street name within a define bbox

http://osmxapi.hypercube.telascience.org/api/0.5/way[name=Broadway][bbox=-74,40.6,-73.9,40.8] On Fri, Mar 6, 2009 at 2:56 AM, John3478 John3478 wrote: > Hi, > > Did any one know how to query street name within a define bbox? This will get you all the ways named Broadway in Manhattan: http://osm

[OSM-talk] SQL to query street name within a define bbox

Hi, Did any one know how to query street name within a define bbox? And second question, how to find lat, lon mid point of a street. Thank you in advance, john ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk