SchemaSpy Analysis of osm.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on jeu. janv. 13 02:29 CET 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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
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
geography_columns f_table_catalog name 2147483647  √  null
geography_columns f_table_name name 2147483647  √  null
geography_columns f_table_schema name 2147483647  √  null
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_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_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_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_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_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
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
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
geometry_columns coord_dimension int4 10
geometry_columns f_geometry_column varchar 256
geometry_columns f_table_catalog varchar 256
geometry_columns f_table_name varchar 256
geometry_columns f_table_schema varchar 256
planet_osm_nodes id int4 10
planet_osm_rels id int4 10
planet_osm_ways id int4 10
planet_osm_nodes lat int4 10
planet_osm_nodes lon int4 10
planet_osm_ways nodes _int4 10
planet_osm_rels pending bool 1
planet_osm_ways pending bool 1
geometry_columns srid int4 10
spatial_ref_sys srid int4 10
geometry_columns type varchar 30