| SchemaSpy Analysis of osm.public | Generated by SchemaSpy |
| Generated by SchemaSpy on jeu. janv. 13 02:29 CET 2011 | |
| Database Type: PostgreSQL - 8.4.6 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| geography_columns | 7 | view | |||
| geometry_columns | 7 | 4 | |||
| planet_osm_line | 57 | 1 080 570 | |||
| planet_osm_nodes | 4 | 32 351 551 | |||
| planet_osm_point | 57 | 448 305 | |||
| planet_osm_polygon | 56 | 1 102 941 | |||
| planet_osm_polygon_view | 7 | view | |||
| planet_osm_rels | 7 | 108 468 | |||
| planet_osm_roads | 56 | 256 412 | |||
| planet_osm_ways | 4 | 2 157 334 | |||
| spatial_ref_sys | 5 | 3 749 | |||
| 9 Tables | 253 | 37 509 334 | |||
| 2 Views | 14 |