Brett Henderson wrote: > > On Wed, Apr 23, 2008 at 7:54 AM, Frederik Ramm <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hi, > > > Since the minute-diff was introduced OSMXAPI has been running, on > > average, about 6 minutes behind the main database. > > Sigh, this project is too large already for one person to keep the > overview. Minute diffs you say. Hadn't heard of them until now, thanks > ;-) > > > I really should do some more advertising, this has come up a few times > now :-) > > I've also created tasks for populating a PostGIS "simple" schema which > is useful for maintaining a local replica of OSM data. Latest SVN > osmosis has tasks for merging changesets into it so you could in theory > have a PostGIS database kept within 6 minutes of the main API. It > should be very efficient at serving bounding boxes although only > real-world testing will confirm this. There's still a few TODOs in > terms of keeping a database in sync that only stores a subset of the > planet, at the moment I can only apply whole planet diffs. > Oh, that would be very useful for e.g. the Garmin map makers like myself.
I extract bboxes from a fresh planet file every week now and realise that I'm downloading most of the data every week again and that the map making process is delayed by the need to fetch 4 GB of data first. Being able to keep a PostGIS database up to date with small updates and efficiently (hopefully!) extract bboxes would be very welcome! It would be of benefit for the NL tileserver that runs of a PostGIS database as well, I think. Hopefully the scheme used by Mapnik and your 'simple' scheme does not differ too much... _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
