LandcoverDB VMap1 Detail

From OSGeo
Revision as of 10:33, 6 October 2007 by Martin (talk | contribs) (Add source detail)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
v1_landmass
'polbnda@bnd(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nm3 varchar Name


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


v1_coniferous
'treesa@veg(*)_area', veg=12
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_nipapalm
'treesa@veg(*)_area', veg=16
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_palm
'treesa@veg(*)_area', veg=17
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_mangrove
'treesa@veg(*)_area', veg=19
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_deciduous
'treesa@veg(*)_area', veg=24
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_eucalyptus
'treesa@veg(*)_area', veg=29
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v1_cypress
'treesa@veg(*)_area', veg=38
Attribute Type Description
wkb_geometry feature geometry; POLYGON


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


v1_road
'roadl@trans(*)_line', '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
'roadl@trans(*)_line', 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
'roadl@trans(*)_line', 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
'firebrkl@veg(*)_line', f_code=EC040
Attribute Type Description
wkb_geometry feature geometry; LINESTRING


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


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


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


v1_town
'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=19026"