[OSM-talk] Tag statistics
lester at lsces.co.uk
Wed Mar 7 08:11:42 GMT 2007
Robert (Jamie) Munro wrote:
> Lester Caine wrote:
>> I've just finally scanned last weeks planet file :)
>> Main problem was that I ha to switch off the foreign key constraints
>> since there are segments without nodes and then ways without segments.
>> So we do need something to go through and tidy the raw data.
>> I'm running all this on a couple of slowish machines so its taking a few
>> hours each time before problems crop up, but I'm about to re-run with
>> this weeks file on a faster setup that I've been putting together in the
>> Once I have the whole lot in Firebird I can start looking at using the
>> data for searching :)
> I'm a bit out of date with Firebird. Does it do R-Tree indexes yet, or
> is it going to?
Out on site yesterday ( 400 miles of tracks to upload ;) )
Firebird version 2 has made some major changes to the index structure,
and while r-tree is not provided, the new structure should handle things
a lot faster than the older simple b-tree structure. One of the reasons
for wanting to get the data loaded is to check out the performance
against both FB1.5 and other options.
Only problem I can see at the moment is how to keep thing in sync, since
uploading the whole planet.osm every time seems a little drastic. While
I can simply include records that have a created date later than that of
the previous file, how do I monitor changes to older records? Is
'created' the original created date or is it updated when a change is
posted. A 'last update' date would be useful for sites which are slaving
data, you would check the 'last updated' date for a way centrally, and
then either download or use the local cache.
Lester Caine - G8HFL
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php
More information about the talk