Table osm.public.planet_osm_polygon Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
osm_id int4 10  √  null
access text 2147483647  √  null
addr:flats text 2147483647  √  null
addr:housenumber text 2147483647  √  null
addr:interpolation text 2147483647  √  null
admin_level text 2147483647  √  null
aerialway text 2147483647  √  null
aeroway text 2147483647  √  null
amenity text 2147483647  √  null
area text 2147483647  √  null
barrier text 2147483647  √  null
bicycle text 2147483647  √  null
bridge text 2147483647  √  null
boundary text 2147483647  √  null
building text 2147483647  √  null
construction text 2147483647  √  null
cutting text 2147483647  √  null
disused text 2147483647  √  null
embankment text 2147483647  √  null
foot text 2147483647  √  null
highway text 2147483647  √  null
historic text 2147483647  √  null
horse text 2147483647  √  null
junction text 2147483647  √  null
landuse text 2147483647  √  null
layer text 2147483647  √  null
learning text 2147483647  √  null
leisure text 2147483647  √  null
lock text 2147483647  √  null
man_made text 2147483647  √  null
military text 2147483647  √  null
motorcar text 2147483647  √  null
name text 2147483647  √  null
natural text 2147483647  √  null
oneway text 2147483647  √  null
operator text 2147483647  √  null
power text 2147483647  √  null
power_source text 2147483647  √  null
place text 2147483647  √  null
railway text 2147483647  √  null
ref text 2147483647  √  null
religion text 2147483647  √  null
residence text 2147483647  √  null
route text 2147483647  √  null
service text 2147483647  √  null
shop text 2147483647  √  null
sport text 2147483647  √  null
tourism text 2147483647  √  null
tracktype text 2147483647  √  null
tunnel text 2147483647  √  null
waterway text 2147483647  √  null
width text 2147483647  √  null
wood text 2147483647  √  null
z_order int4 10  √  null
way_area float4 8,8  √  null
way geometry 2147483647  √  null

Table contained 1 102 941 rows at jeu. janv. 13 02:29 CET 2011

Indexes:
Column(s) Type Sort Constraint Name
aeroway Performance Asc planet_osm_polygon_aeroway_idx
amenity Performance Asc planet_osm_polygon_amenity_idx
building Performance Asc planet_osm_polygon_building_idx
way Performance Asc planet_osm_polygon_index
landuse Performance Asc planet_osm_polygon_landuse_idx
leisure Performance Asc planet_osm_polygon_leisure_idx
Performance planet_osm_polygon_natural_idx
osm_id Performance Asc planet_osm_polygon_pkey
waterway Performance Asc planet_osm_polygon_waterway_idx