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

[80n]

On Fri, Mar 6, 2009 at 5:21 AM, John3478 John3478 <john3478 at gmail.com>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, 2009 at 7:19 PM, 80n <80n80n at gmail.com> wrote:
>
>>
>> http://osmxapi.hypercube.telascience.org/api/0.5/way[name=Broadway][bbox=-74,40.6,-73.9,40.8]<http://osmxapi.hypercube.telascience.org/api/0.5/way%5Bname=Broadway%5D%5Bbbox=-74,40.6,-73.9,40.8%5D>
>>
>> On Fri, Mar 6, 2009 at 2:56 AM, John3478 John3478 <john3478 at gmail.com>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://osmxapi.hypercube.telascience.org/api/0.5/way[name=Broadway][bbox=-74,40.6,-73.9,40.8]<http://osmxapi.hypercube.telascience.org/api/0.5/way%5Bname=Broadway%5D%5Bbbox=-74,40.6,-73.9,40.8%5D>
>>
>> SQL? Nah.
>>
>> 80n
>>
>>
>>>
>>> And second question, how to find lat, lon mid point of a street.
>>>
>>> Thank you in advance,
>>> john
>>>
>>> _______________________________________________
>>> talk mailing list
>>> talk at openstreetmap.org
>>> http://lists.openstreetmap.org/listinfo/talk
>>>
>>>
>>
>
> _______________________________________________
> talk mailing list
> talk at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090306/d9d09994/attachment.html>