SchemaSpy Analysis of osm.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on jeu. janv. 13 02:29 CET 2011 |
| ||||||
|
osm.public contains 267 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
planet_osm_line | access | text | 2147483647 | √ | null | ||
planet_osm_point | access | text | 2147483647 | √ | null | ||
planet_osm_polygon | access | text | 2147483647 | √ | null | ||
planet_osm_roads | access | text | 2147483647 | √ | null | ||
planet_osm_line | addr:flats | text | 2147483647 | √ | null | ||
planet_osm_point | addr:flats | text | 2147483647 | √ | null | ||
planet_osm_polygon | addr:flats | text | 2147483647 | √ | null | ||
planet_osm_roads | addr:flats | text | 2147483647 | √ | null | ||
planet_osm_line | addr:housenumber | text | 2147483647 | √ | null | ||
planet_osm_point | addr:housenumber | text | 2147483647 | √ | null | ||
planet_osm_polygon | addr:housenumber | text | 2147483647 | √ | null | ||
planet_osm_roads | addr:housenumber | text | 2147483647 | √ | null | ||
planet_osm_line | addr:interpolation | text | 2147483647 | √ | null | ||
planet_osm_point | addr:interpolation | text | 2147483647 | √ | null | ||
planet_osm_polygon | addr:interpolation | text | 2147483647 | √ | null | ||
planet_osm_roads | addr:interpolation | text | 2147483647 | √ | null | ||
planet_osm_line | admin_level | text | 2147483647 | √ | null | ||
planet_osm_point | admin_level | text | 2147483647 | √ | null | ||
planet_osm_polygon | admin_level | text | 2147483647 | √ | null | ||
planet_osm_roads | admin_level | text | 2147483647 | √ | null | ||
planet_osm_line | aerialway | text | 2147483647 | √ | null | ||
planet_osm_point | aerialway | text | 2147483647 | √ | null | ||
planet_osm_polygon | aerialway | text | 2147483647 | √ | null | ||
planet_osm_roads | aerialway | text | 2147483647 | √ | null | ||
planet_osm_line | aeroway | text | 2147483647 | √ | null | ||
planet_osm_point | aeroway | text | 2147483647 | √ | null | ||
planet_osm_polygon | aeroway | text | 2147483647 | √ | null | ||
planet_osm_roads | aeroway | text | 2147483647 | √ | null | ||
planet_osm_line | amenity | text | 2147483647 | √ | null | ||
planet_osm_point | amenity | text | 2147483647 | √ | null | ||
planet_osm_polygon | amenity | text | 2147483647 | √ | null | ||
planet_osm_roads | amenity | text | 2147483647 | √ | null | ||
planet_osm_line | area | text | 2147483647 | √ | null | ||
planet_osm_point | area | text | 2147483647 | √ | null | ||
planet_osm_polygon | area | text | 2147483647 | √ | null | ||
planet_osm_roads | area | text | 2147483647 | √ | null | ||
spatial_ref_sys | auth_name | varchar | 256 | √ | null | ||
spatial_ref_sys | auth_srid | int4 | 10 | √ | null | ||
planet_osm_line | barrier | text | 2147483647 | √ | null | ||
planet_osm_point | barrier | text | 2147483647 | √ | null | ||
planet_osm_polygon | barrier | text | 2147483647 | √ | null | ||
planet_osm_roads | barrier | text | 2147483647 | √ | null | ||
planet_osm_line | bicycle | text | 2147483647 | √ | null | ||
planet_osm_point | bicycle | text | 2147483647 | √ | null | ||
planet_osm_polygon | bicycle | text | 2147483647 | √ | null | ||
planet_osm_roads | bicycle | text | 2147483647 | √ | null | ||
planet_osm_line | boundary | text | 2147483647 | √ | null | ||
planet_osm_point | boundary | text | 2147483647 | √ | null | ||
planet_osm_polygon | boundary | text | 2147483647 | √ | null | ||
planet_osm_roads | boundary | text | 2147483647 | √ | null | ||
planet_osm_line | bridge | text | 2147483647 | √ | null | ||
planet_osm_point | bridge | text | 2147483647 | √ | null | ||
planet_osm_polygon | bridge | text | 2147483647 | √ | null | ||
planet_osm_roads | bridge | text | 2147483647 | √ | null | ||
planet_osm_line | building | text | 2147483647 | √ | null | ||
planet_osm_point | building | text | 2147483647 | √ | null | ||
planet_osm_polygon | building | text | 2147483647 | √ | null | ||
planet_osm_roads | building | text | 2147483647 | √ | null | ||
planet_osm_point | capital | text | 2147483647 | √ | null | ||
planet_osm_line | construction | text | 2147483647 | √ | null | ||
planet_osm_point | construction | text | 2147483647 | √ | null | ||
planet_osm_polygon | construction | text | 2147483647 | √ | null | ||
planet_osm_roads | construction | text | 2147483647 | √ | null | ||
geography_columns | coord_dimension | int4 | 10 | √ | null | ||
geometry_columns | coord_dimension | int4 | 10 | ||||
planet_osm_line | cutting | text | 2147483647 | √ | null | ||
planet_osm_point | cutting | text | 2147483647 | √ | null | ||
planet_osm_polygon | cutting | text | 2147483647 | √ | null | ||
planet_osm_roads | cutting | text | 2147483647 | √ | null | ||
planet_osm_line | disused | text | 2147483647 | √ | null | ||
planet_osm_point | disused | text | 2147483647 | √ | null | ||
planet_osm_polygon | disused | text | 2147483647 | √ | null | ||
planet_osm_roads | disused | text | 2147483647 | √ | null | ||
planet_osm_point | ele | text | 2147483647 | √ | null | ||
planet_osm_line | embankment | text | 2147483647 | √ | null | ||
planet_osm_point | embankment | text | 2147483647 | √ | null | ||
planet_osm_polygon | embankment | text | 2147483647 | √ | null | ||
planet_osm_roads | embankment | text | 2147483647 | √ | null | ||
geography_columns | f_geography_column | name | 2147483647 | √ | null | ||
geometry_columns | f_geometry_column | varchar | 256 | ||||
geography_columns | f_table_catalog | name | 2147483647 | √ | null | ||
geometry_columns | f_table_catalog | varchar | 256 | ||||
geography_columns | f_table_name | name | 2147483647 | √ | null | ||
geometry_columns | f_table_name | varchar | 256 | ||||
geography_columns | f_table_schema | name | 2147483647 | √ | null | ||
geometry_columns | f_table_schema | varchar | 256 | ||||
planet_osm_line | foot | text | 2147483647 | √ | null | ||
planet_osm_point | foot | text | 2147483647 | √ | null | ||
planet_osm_polygon | foot | text | 2147483647 | √ | null | ||
planet_osm_roads | foot | text | 2147483647 | √ | null | ||
planet_osm_line | highway | text | 2147483647 | √ | null | ||
planet_osm_point | highway | text | 2147483647 | √ | null | ||
planet_osm_polygon | highway | text | 2147483647 | √ | null | ||
planet_osm_polygon_view | highway | text | 2147483647 | √ | null | ||
planet_osm_roads | highway | text | 2147483647 | √ | null | ||
planet_osm_line | historic | text | 2147483647 | √ | null | ||
planet_osm_point | historic | text | 2147483647 | √ | null | ||
planet_osm_polygon | historic | text | 2147483647 | √ | null | ||
planet_osm_roads | historic | text | 2147483647 | √ | null | ||
planet_osm_line | horse | text | 2147483647 | √ | null | ||
planet_osm_point | horse | text | 2147483647 | √ | null | ||
planet_osm_polygon | horse | text | 2147483647 | √ | null | ||
planet_osm_roads | horse | text | 2147483647 | √ | null | ||
planet_osm_nodes | id | int4 | 10 | ||||
planet_osm_rels | id | int4 | 10 | ||||
planet_osm_ways | id | int4 | 10 | ||||
planet_osm_line | junction | text | 2147483647 | √ | null | ||
planet_osm_point | junction | text | 2147483647 | √ | null | ||
planet_osm_polygon | junction | text | 2147483647 | √ | null | ||
planet_osm_roads | junction | text | 2147483647 | √ | null | ||
planet_osm_line | landuse | text | 2147483647 | √ | null | ||
planet_osm_point | landuse | text | 2147483647 | √ | null | ||
planet_osm_polygon | landuse | text | 2147483647 | √ | null | ||
planet_osm_polygon_view | landuse | text | 2147483647 | √ | null | ||
planet_osm_roads | landuse | text | 2147483647 | √ | null | ||
planet_osm_nodes | lat | int4 | 10 | ||||
planet_osm_line | layer | text | 2147483647 | √ | null | ||
planet_osm_point | layer | text | 2147483647 | √ | null | ||
planet_osm_polygon | layer | text | 2147483647 | √ | null | ||
planet_osm_roads | layer | text | 2147483647 | √ | null | ||
planet_osm_line | learning | text | 2147483647 | √ | null | ||
planet_osm_point | learning | text | 2147483647 | √ | null | ||
planet_osm_polygon | learning | text | 2147483647 | √ | null | ||
planet_osm_roads | learning | text | 2147483647 | √ | null | ||
planet_osm_line | leisure | text | 2147483647 | √ | null | ||
planet_osm_point | leisure | text | 2147483647 | √ | null | ||
planet_osm_polygon | leisure | text | 2147483647 | √ | null | ||
planet_osm_roads | leisure | text | 2147483647 | √ | null | ||
planet_osm_line | lock | text | 2147483647 | √ | null | ||
planet_osm_point | lock | text | 2147483647 | √ | null | ||
planet_osm_polygon | lock | text | 2147483647 | √ | null | ||
planet_osm_roads | lock | text | 2147483647 | √ | null | ||
planet_osm_nodes | lon | int4 | 10 | ||||
planet_osm_line | man_made | text | 2147483647 | √ | null | ||
planet_osm_point | man_made | text | 2147483647 | √ | null | ||
planet_osm_polygon | man_made | text | 2147483647 | √ | null | ||
planet_osm_roads | man_made | text | 2147483647 | √ | null | ||
planet_osm_rels | members | _text | 2147483647 | √ | null | ||
planet_osm_line | military | text | 2147483647 | √ | null | ||
planet_osm_point | military | text | 2147483647 | √ | null | ||
planet_osm_polygon | military | text | 2147483647 | √ | null | ||
planet_osm_roads | military | text | 2147483647 | √ | null | ||
planet_osm_line | motorcar | text | 2147483647 | √ | null | ||
planet_osm_point | motorcar | text | 2147483647 | √ | null | ||
planet_osm_polygon | motorcar | text | 2147483647 | √ | null | ||
planet_osm_roads | motorcar | text | 2147483647 | √ | null | ||
planet_osm_line | name | text | 2147483647 | √ | null | ||
planet_osm_point | name | text | 2147483647 | √ | null | ||
planet_osm_polygon | name | text | 2147483647 | √ | null | ||
planet_osm_polygon_view | name | text | 2147483647 | √ | null | ||
planet_osm_roads | name | text | 2147483647 | √ | null | ||
planet_osm_line | natural | text | 2147483647 | √ | null | ||
planet_osm_point | natural | text | 2147483647 | √ | null | ||
planet_osm_polygon | natural | text | 2147483647 | √ | null | ||
planet_osm_roads | natural | text | 2147483647 | √ | null | ||
planet_osm_polygon_view | nature | text | 2147483647 | √ | null | ||
planet_osm_ways | nodes | _int4 | 10 | ||||
planet_osm_line | oneway | text | 2147483647 | √ | null | ||
planet_osm_point | oneway | text | 2147483647 | √ | null | ||
planet_osm_polygon | oneway | text | 2147483647 | √ | null | ||
planet_osm_roads | oneway | text | 2147483647 | √ | null | ||
planet_osm_line | operator | text | 2147483647 | √ | null | ||
planet_osm_point | operator | text | 2147483647 | √ | null | ||
planet_osm_polygon | operator | text | 2147483647 | √ | null | ||
planet_osm_roads | operator | text | 2147483647 | √ | null | ||
planet_osm_line | osm_id | int4 | 10 | √ | null | ||
planet_osm_point | osm_id | int4 | 10 | √ | null | ||
planet_osm_polygon | osm_id | int4 | 10 | √ | null | ||
planet_osm_polygon_view | osm_id | int4 | 10 | √ | null | ||
planet_osm_roads | osm_id | int4 | 10 | √ | null | ||
planet_osm_rels | parts | _int4 | 10 | √ | null | ||
planet_osm_rels | pending | bool | 1 | ||||
planet_osm_ways | pending | bool | 1 | ||||
planet_osm_line | place | text | 2147483647 | √ | null | ||
planet_osm_point | place | text | 2147483647 | √ | null | ||
planet_osm_polygon | place | text | 2147483647 | √ | null | ||
planet_osm_roads | place | text | 2147483647 | √ | null | ||
planet_osm_point | poi | text | 2147483647 | √ | null | ||
planet_osm_line | power | text | 2147483647 | √ | null | ||
planet_osm_point | power | text | 2147483647 | √ | null | ||
planet_osm_polygon | power | text | 2147483647 | √ | null | ||
planet_osm_roads | power | text | 2147483647 | √ | null | ||
planet_osm_line | power_source | text | 2147483647 | √ | null | ||
planet_osm_point | power_source | text | 2147483647 | √ | null | ||
planet_osm_polygon | power_source | text | 2147483647 | √ | null | ||
planet_osm_roads | power_source | text | 2147483647 | √ | null | ||
planet_osm_line | priority | int4 | 10 | √ | null | ||
spatial_ref_sys | proj4text | varchar | 2048 | √ | null | ||
planet_osm_line | railway | text | 2147483647 | √ | null | ||
planet_osm_point | railway | text | 2147483647 | √ | null | ||
planet_osm_polygon | railway | text | 2147483647 | √ | null | ||
planet_osm_roads | railway | text | 2147483647 | √ | null | ||
planet_osm_line | ref | text | 2147483647 | √ | null | ||
planet_osm_point | ref | text | 2147483647 | √ | null | ||
planet_osm_polygon | ref | text | 2147483647 | √ | null | ||
planet_osm_roads | ref | text | 2147483647 | √ | null | ||
planet_osm_rels | rel_off | int2 | 5 | √ | null | ||
planet_osm_line | religion | text | 2147483647 | √ | null | ||
planet_osm_point | religion | text | 2147483647 | √ | null | ||
planet_osm_polygon | religion | text | 2147483647 | √ | null | ||
planet_osm_roads | religion | text | 2147483647 | √ | null | ||
planet_osm_line | residence | text | 2147483647 | √ | null | ||
planet_osm_point | residence | text | 2147483647 | √ | null | ||
planet_osm_polygon | residence | text | 2147483647 | √ | null | ||
planet_osm_roads | residence | text | 2147483647 | √ | null | ||
planet_osm_line | route | text | 2147483647 | √ | null | ||
planet_osm_point | route | text | 2147483647 | √ | null | ||
planet_osm_polygon | route | text | 2147483647 | √ | null | ||
planet_osm_roads | route | text | 2147483647 | √ | null | ||
planet_osm_line | service | text | 2147483647 | √ | null | ||
planet_osm_point | service | text | 2147483647 | √ | null | ||
planet_osm_polygon | service | text | 2147483647 | √ | null | ||
planet_osm_roads | service | text | 2147483647 | √ | null | ||
planet_osm_line | shop | text | 2147483647 | √ | null | ||
planet_osm_point | shop | text | 2147483647 | √ | null | ||
planet_osm_polygon | shop | text | 2147483647 | √ | null | ||
planet_osm_roads | shop | text | 2147483647 | √ | null | ||
planet_osm_line | sport | text | 2147483647 | √ | null | ||
planet_osm_point | sport | text | 2147483647 | √ | null | ||
planet_osm_polygon | sport | text | 2147483647 | √ | null | ||
planet_osm_roads | sport | text | 2147483647 | √ | null | ||
geography_columns | srid | int4 | 10 | √ | null | ||
geometry_columns | srid | int4 | 10 | ||||
spatial_ref_sys | srid | int4 | 10 | ||||
spatial_ref_sys | srtext | varchar | 2048 | √ | null | ||
planet_osm_nodes | tags | _text | 2147483647 | √ | null | ||
planet_osm_rels | tags | _text | 2147483647 | √ | null | ||
planet_osm_ways | tags | _text | 2147483647 | √ | null | ||
planet_osm_line | tourism | text | 2147483647 | √ | null | ||
planet_osm_point | tourism | text | 2147483647 | √ | null | ||
planet_osm_polygon | tourism | text | 2147483647 | √ | null | ||
planet_osm_roads | tourism | text | 2147483647 | √ | null | ||
planet_osm_line | tracktype | text | 2147483647 | √ | null | ||
planet_osm_polygon | tracktype | text | 2147483647 | √ | null | ||
planet_osm_roads | tracktype | text | 2147483647 | √ | null | ||
planet_osm_line | tunnel | text | 2147483647 | √ | null | ||
planet_osm_point | tunnel | text | 2147483647 | √ | null | ||
planet_osm_polygon | tunnel | text | 2147483647 | √ | null | ||
planet_osm_roads | tunnel | text | 2147483647 | √ | null | ||
geography_columns | type | text | 2147483647 | √ | null | ||
geometry_columns | type | varchar | 30 | ||||
planet_osm_line | waterway | text | 2147483647 | √ | null | ||
planet_osm_point | waterway | text | 2147483647 | √ | null | ||
planet_osm_polygon | waterway | text | 2147483647 | √ | null | ||
planet_osm_polygon_view | waterway | text | 2147483647 | √ | null | ||
planet_osm_roads | waterway | text | 2147483647 | √ | null | ||
planet_osm_line | way | geometry | 2147483647 | √ | null | ||
planet_osm_point | way | geometry | 2147483647 | √ | null | ||
planet_osm_polygon | way | geometry | 2147483647 | √ | null | ||
planet_osm_polygon_view | way | geometry | 2147483647 | √ | null | ||
planet_osm_roads | way | geometry | 2147483647 | √ | null | ||
planet_osm_line | way_area | float4 | 8,8 | √ | null | ||
planet_osm_polygon | way_area | float4 | 8,8 | √ | null | ||
planet_osm_roads | way_area | float4 | 8,8 | √ | null | ||
planet_osm_rels | way_off | int2 | 5 | √ | null | ||
planet_osm_line | width | text | 2147483647 | √ | null | ||
planet_osm_point | width | text | 2147483647 | √ | null | ||
planet_osm_polygon | width | text | 2147483647 | √ | null | ||
planet_osm_roads | width | text | 2147483647 | √ | null | ||
planet_osm_line | wood | text | 2147483647 | √ | null | ||
planet_osm_point | wood | text | 2147483647 | √ | null | ||
planet_osm_polygon | wood | text | 2147483647 | √ | null | ||
planet_osm_roads | wood | text | 2147483647 | √ | null | ||
planet_osm_line | z_order | int4 | 10 | √ | null | ||
planet_osm_point | z_order | int4 | 10 | √ | null | ||
planet_osm_polygon | z_order | int4 | 10 | √ | null | ||
planet_osm_roads | z_order | int4 | 10 | √ | null |