[OSM-dev] first pass of albanian translation for openstreetmap ready

2010-05-18 Thread jamesmikedup...@googlemail.com
Hi, The first pass at translating opensteretmap, potlatch and slippy maps into albanian is finished, now we will have to review them and do some corrections. I think in 2-3 weeks we will have a complete and checked translation. OSM webpage : http://translatewiki.net/w/i.php?title=Special%3ATransl

Re: [OSM-dev] Hstore revolution

2010-05-18 Thread Peter Körner
Am 18.05.2010 23:19, schrieb Sven Geggus: > 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'); > > rather than > > select ... from planet_osm_point where (tags->'amenit

Re: [OSM-dev] Hstore revolution

2010-05-18 Thread Sven Geggus
Jukka Rahkonen 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 curr

[OSM-dev] Hstore revolution

2010-05-18 Thread Jukka Rahkonen
Hi, I noticed that a new osm2pgsql for Windows at http://tile.openstreetmap.org/osm2pgsql.zip supports now also the -k switch for importing all the tags into a PostGIS hstore column. I had a try and played a bit with hstore and Mapserver. Hstore seems to give very nice possibilities. It is very

Re: [OSM-dev] keeping up to date an extract of planet.osm

2010-05-18 Thread Stefano Salvador
Thanks for the fast reply > If you intend to do it for a rather small area my area is about 150km x 150km, I'll make some test to see how much resources are neeeded. Bye, Stefano ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.

Re: [OSM-dev] keeping up to date an extract of planet.osm

2010-05-18 Thread Frederik Ramm
Hi, Stefano Salvador wrote: > I would like to set up a copy of OSM DB only for a small region and > then keeping it up to date with the replicates, is this possible ? You will need to apply the full diffs and afterwards cut off anything you're not interested in. If you intend to do it for a rat

[OSM-dev] keeping up to date an extract of planet.osm

2010-05-18 Thread Stefano Salvador
Hi, I've read everything I can find on wiki and ML about replicating the OSM DB, but I can figure out if it is possible to keep up to date only a part of the planet. I would like to set up a copy of OSM DB only for a small region and then keeping it up to date with the replicates, is this possibl

Re: [OSM-dev] own OSM-Server

2010-05-18 Thread Peter Körner
Ansgar Jazdzewski schrieb: > and now i look for a way to render the tiles and use them in a own OSM > webinterface Please take a look at the wiki and search for Mapnik and tirex. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetm