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
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk