IntermediateDB
The intermediate DB is more or less a SQL incarnation of an OSM file.
It comprise five tables. Their structure are straightforward.
Nodes, ways and relations table contain data of nodes etc. These three tables have several columns in common: First, they store data taken from osm file:
| id | primary key |
| osm_id | the osm id |
| tstamp | timestamp (last change date) |
| classcode | foreign key referencing a row in OHDM classification table |
| otherclasscodes | osm objects can be of more than one map feature |
| serializedtags | tags from osm file |
Secondly, each table has some flags which are used for the OHDM/OSM archive update.
| ohdm_geom_id | ohdm id of a geometry that was produced from this osm entity (can be null) |
| ohdm_geom_type | geometry type (point, linestring, polygon |
| ohdm_object_id | ohdm id of an object that was produced from this osm entity (can be null) |
| geom_changed | geometry has changed since last update |
| object_changed | object has changed since last update |
| deleted | osm entity was deleted since last update |
| object_new | osm entity is new |
| valid | osm entity is valid and unchanged since last update |