[OSM-dev] Spatial queries in Mysql

[marcus.wolschon at googlemail.com]

https://sourceforge.net/apps/phpbb/travelingsales/viewtopic.php?f=4&t=93

Does anyone have experience with Mysql and 2d-range-queries?

I am looking for the optimal way of:
a) selecting all nodes in a given bounding-box  and
b) selecting all ways intersecting a given bounding-box.

I am not bound to any existing schema.

What works best?
* index on "lat" and index on "lon"
* throwing the first normal form out the window and having a geometry-POINT
plus the coordinates in a node -table
* using an interleaved "tilenumber" -column
* ...


Marcus