Re: [OSM-dev] Minutely Database Update of Planet Extract

2011-01-25 Thread Stephan Knauss
On 25.01.2011 21:54, Graham Jones wrote: I think that is the answer I was looking for - I think your SQL is deleting ways etc. that do not refer to existing nodes in the db? It might miss to delete some relations. And not sure what will happen with recursive relations. I will give it a go, a

Re: [OSM-dev] Minutely Database Update of Planet Extract

2011-01-25 Thread Graham Jones
Thanks Stefan, I think that is the answer I was looking for - I think your SQL is deleting ways etc. that do not refer to existing nodes in the db? I will give it a go, and see if my poor little virtual machine can cope - it is certainly struggling now the database has got so big. Would you mind i

Re: [OSM-dev] Minutely Database Update of Planet Extract

2011-01-25 Thread Stephan Knauss
On 25.01.2011 21:28, Graham Jones wrote: Is there a trick I am missing to do the bounding box extraction correctly? applying only a bounding box is not supported. You have to clean out ways and relations from time to time. http://wiki.openstreetmap.org/wiki/User:Stephankn/knowledgebase#Clean

[OSM-dev] Minutely Database Update of Planet Extract

2011-01-25 Thread Graham Jones
Hi All, I think this has been asked before, but I have not managed to find the answer, sorry! I am trying to maintain an up-to date database of the UK for mapnik rendering. I have had it working fine previously using daily diffs, but am trying to get minutely updates going using osmosis using th