LandcoverDB VMap1 Detail

From OSGeo
Revision as of 10:17, 6 October 2007 by Martin (talk | contribs) (Better formatting)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
v1_landmass
Source: 'polbnda@bnd(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nm3 varchar Name


v1_floodland
Source: 'inunda@hydro(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_lava
Source: 'grounda@phys(*)_area' / Flags: mcc=52
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_sand
Source: 'grounda@phys(*)_area' / Flags: mcc=88
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_glacier
Source: 'landicea@phys(*)_area' / Flags: f_code=BJ030
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_snowfield
Source: 'landicea@phys(*)_area' / Flags: f_code=BJ100, sic=1
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_icefield
Source: 'landicea@phys(*)_area' / Flags: f_code=BJ100, 'sic!=1'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_iceshelf
Source: 'seaicea@phys(*)_area' / Flags: f_code=BJ065
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_packice
Source: 'seaicea@phys(*)_area' / Flags: f_code=BJ070
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_polarice
Source: 'seaicea@phys(*)_area' / Flags: f_code=BJ080
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_boulder
Source: 'grounda@phys(*)_area' / Flags: mcc=8
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_barrencover
Source: 'grounda@phys(*)_area' / Flags: mcc=119
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_mixedcover
Source: 'grounda@phys(*)_area' / Flags: 'mcc!=8', 'mcc!=52', 'mcc!=88', 'mcc!=119'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_park
Source: 'landmrka@pop(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v1_harbour
Source: 'harbora@trans(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_railyard
Source: 'rryarda@trans(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_powerplant
Source: 'powera@util(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name
ppc numeric(5,0) Power Plant Category


v1_grasscover
Source: 'grassa@veg(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_bog
Source: 'swampa@veg(*)_area' / Flags: f_code=BH015
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_marsh
Source: 'swampa@veg(*)_area' / Flags: f_code=BH095
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_ricefield
Source: 'cropa@veg(*)_area' / Flags: f_code=BH135
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_cropland
Source: 'cropa@veg(*)_area' / Flags: f_code=EA010
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_herbtundracover
Source: 'tundraa@veg(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_orchard
Source: 'orcharda@veg(*)_area' / Flags: f_code=EA040
Attribute Type Description
wkb_geometry feature geometry; POLYGON
pro numeric(5,0) Product Category


v1_vineyard
Source: 'orcharda@veg(*)_area' / Flags: f_code=EA050
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_coniferous
Source: 'treesa@veg(*)_area' / Flags: veg=12
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_nipapalm
Source: 'treesa@veg(*)_area' / Flags: veg=16
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_palm
Source: 'treesa@veg(*)_area' / Flags: veg=17
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_mangrove
Source: 'treesa@veg(*)_area' / Flags: veg=19
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_deciduous
Source: 'treesa@veg(*)_area' / Flags: veg=24
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_eucalyptus
Source: 'treesa@veg(*)_area' / Flags: veg=29
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_cypress
Source: 'treesa@veg(*)_area' / Flags: veg=38
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_mixedforest
Source: 'treesa@veg(*)_area' / Flags: 'veg!=12', 'veg!=16', 'veg!=17', 'veg!=19', 'veg!=24', 'veg!=29', 'veg!=38'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_drylake
Source: 'lakeresa@hydro(*)_area' / Flags: f_code=BH080, 'scc!=10', hyc=3
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v1_intermittentlake
Source: 'lakeresa@hydro(*)_area' / Flags: f_code=BH080, 'scc!=10', hyc=6, 'scc!=10'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v1_lake
Source: 'lakeresa@hydro(*)_area' / Flags: f_code=BH080, 'scc!=10', hyc=8, 'scc!=10'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v1_misclake
Source: 'lakeresa@hydro(*)_area' / Flags: f_code=BH080, 'scc!=10', 'hyc!=3', 'hyc!=6', 'hyc!=8'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v1_saltlake
Source: 'lakeresa@hydro(*)_area' / Flags: f_code=BH080, scc=10
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v1_reservoir
Source: 'lakeresa@hydro(*)_area' / Flags: f_code=BH130
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v1_disposal
Source: 'disposea@ind(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
pro numeric(5,0) Product Category


v1_extraction
Source: 'extracta@ind(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
min numeric(5,0) Mining Category


v1_processing
Source: 'processa@ind(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name
pro numeric(5,0) Product Category


v1_treatment
Source: 'treata@ind(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_asphaltlake
Source: 'asphalta@phys(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_building
Source: 'builda@pop(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_urban
Source: 'builtupa@pop(*)_area' / Flags: 'exs!=7'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
geonameid integer GeoNames reference
nam varchar Name


v1_settlement
Source: 'mispopa@pop(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_ruin
Source: 'ruinsa@pop(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_ditch
Source: 'watrcrsl@hydro(*)_line' / Flags: f_code=BH030
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
wid numeric(5,0) Width (meters)


v1_intermittentstream
Source: 'watrcrsl@hydro(*)_line' / Flags: f_code=BH140, hyc=6
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
wid numeric(5,0) Width (meters)


v1_stream
Source: 'watrcrsl@hydro(*)_line' / Flags: f_code=BH140, hyc=8
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
wid numeric(5,0) Width (meters)


v1_canal
Source: 'watrcrsl@hydro(*)_line' / Flags: f_code=BH020
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
wid numeric(5,0) Width (meters)


v1_siderail
Source: 'railrdl@trans(*)_line' / Flags: f_code=AN050
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name


v1_railroad1
Source: 'railrdl@trans(*)_line' / Flags: f_code=AN010, fco=3
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name


v1_railroad2
Source: 'railrdl@trans(*)_line' / Flags: f_code=AN010, fco=11
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name


v1_miscrailroad
Source: 'railrdl@trans(*)_line' / Flags: f_code=AN010, fco=2
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name


v1_road
Source: 'roadl@trans(*)_line' / Flags: 'med!=1'
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
med numeric(5,0) Median Category
rst numeric(5,0) Road/Runway Surface Type
rtt numeric(5,0) Route Intended Use
wd1 numeric(5,0) Minimum Travel Way Width (decimeters)


v1_freeway
Source: 'roadl@trans(*)_line' / Flags: med=1, 'rtt!=15'
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
med numeric(5,0) Median Category
rst numeric(5,0) Road/Runway Surface Type
rtt numeric(5,0) Route Intended Use
wd1 numeric(5,0) Minimum Travel Way Width (decimeters)


v1_motorway
Source: 'roadl@trans(*)_line' / Flags: med=1, rtt=15
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
med numeric(5,0) Median Category
rst numeric(5,0) Road/Runway Surface Type
rtt numeric(5,0) Route Intended Use
wd1 numeric(5,0) Minimum Travel Way Width (decimeters)


v1_firebreak
Source: 'firebrkl@veg(*)_line' / Flags: f_code=EC040
Attribute Type Description
wkb_geometry feature geometry; LINESTRING


v1_pipeline
Source: 'pipel@util(*)_line' / Flags: f_code=AQ113
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
pro numeric(5,0) Product Category


v1_powerline
Source: 'powerl@util(*)_line' / Flags: f_code=AQ113
Attribute Type Description
wkb_geometry feature geometry; LINESTRING


v1_waterintake
Source: 'miscp@hydro(*)_point' / Flags: f_code=BI050
Attribute Type Description
wkb_geometry feature geometry; POINT


v1_town
Source: 'builtupp@pop(*)_point'
Attribute Type Description
wkb_geometry feature geometry; POINT
geonameid integer GeoNames reference
nam varchar Name
Retrieved from "http://wiki.osgeo.org/w/index.php?title=LandcoverDB_VMap1_Detail&oldid=19028"