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

Tom Hughes tom at compton.nu
Fri Mar 6 09:20:57 GMT 2009


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 you have the XML data? or have 
you loaded it into a relational database - presumably you have if you 
want to use SQL, but what schema are you using?

I'm guessing it is either the MySQL schema used by the API or the 
postgis format used for mapnik rendering?

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/




More information about the talk mailing list