[OSM-dev] Hstore revolution
lists at fuchsschwanzdomain.de
Tue May 18 22:19:13 BST 2010
Jukka Rahkonen <jukka.rahkonen at latuviitta.fi> wrote:
> Sven Geggus has made a pretty good job with adding this fine
> feature into osm2pgsql.
Thanks. Credits should also go to Jochen Topf for suggesting hstore
as a well suited storage Method for OSM Data in the first place :)
Peter and the the other Wikipedia People are currently running a
hstore enabled Database of the whole Planet featuring minutely
updates. Query-to-map is using this Database since Saturday.
As far as Database queries are concerned one should use something
like this for performance reasons:
select ... from planet_osm_point where (tags @> 'amenity=>fire_station');
select ... from planet_osm_point where (tags->'amenity' = 'fire_station');
Which is quite slow.
"If you don't make lower-resolution mapping data publicly
available, there will be people with their cars and GPS
devices, driving around with their laptops" (Tim Berners-Lee)
/me is giggls at ircnet, http://sven.gegg.us/ on the Web
More information about the dev