[OSM-talk] OSMDoc is awesome!

[Peter Körner]

Am 01.09.2010 15:15, schrieb Lars Francke:
> The database schema is pretty easy though so if anyone has data laying
> around this is what I would need:
>
> tag_keys: id integer, total_count integer, changeset_count integer,
> node_count integer, relation_count integer, way_count integer, name
> character varying(255), value_count integer
>
> tag_values: id integer, total_count integer, changeset_count integer,
> node_count integer, relation_count integer, way_count integer, name
> character varying(255), key_id integer

There's one thing I've been missing: the changeset_count. How do you 
calculate it? Is it the number of distinct changesets that have used 
this tag resp. tag/calue combination?

I'd then implement it using another two tables

changeset_keys: changeset integer, key_id integer
changeset_values: changeset integer, key_id integer, value_id integer

to check if a specific key / value is already used in a changeset and 
not incrementing changeset_count then.

Peter