[OSM-dev] MySQL GIS extensions - some tipps

[marcus.wolschon at googlemail.com]

On Tue, 21 Jul 2009 13:53:20 +0200, Andreas Kalsch <andreaskalsch at gmx.de>
wrote:
> Roland,
> 
> Which MySQL branch have you used?
> I use a sandboxed 5.1.35 source distribution for testing, which 
> implements _full_ OpenGIS functionality - it works pretty accurate and 
> for me fast enough.


Well, what are you doing with it?

Is is fast enough for interactive rendering
slightly below a city-level? (Above that I am
using simplified maps to scale up to rendering
continents.)

Can you decompose a POINT into lat+lon in an SQL-query?
If not, how much space is wasted by having all coordinates
twice?

Marcus