Difference between revisions of "LandcoverDB VMap0 Detail"

From OSGeo
Jump to navigation Jump to search
m
 
(Undo revision 34656 by Mspott (Talk))
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
soon to be filled; --[[User:Mspott|Mspott]] 23:22, 10 September 2007 (CEST)
+
; v0_landmass
 +
:Source: 'polbnda@bnd(*)_area'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|na2
 +
|character(2)
 +
|Two-character country code
 +
|-
 +
|na3
 +
|character(1)
 +
|Classification Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_floodland
 +
:Source: 'inwatera@hydro(*)_area' / Flags: f_code=BH090
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_sand
 +
:Source: 'grounda@phys(*)_area' / Flags: smc=88, swc=0
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_lava
 +
:Source: 'grounda@phys(*)_area' / Flags: smc=52
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_glacier
 +
:Source: 'landicea@phys(*)_area'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_packice
 +
:Source: 'seaicea@phys(*)_area' / Flags: f_code=BJ070
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_polarice
 +
:Source: 'seaicea@phys(*)_area' / Flags: f_code=BJ080
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_littoral
 +
:Source: 'grounda@phys(*)_area' / Flags: smc=88, swc=3
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_barrencover
 +
:Source: 'grounda@phys(*)_area' / Flags: smc=119
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_grasscover
 +
:Source: 'grassa@veg(*)_area' / Flags: f_code=EB010
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_scrubcover
 +
:Source: 'grassa@veg(*)_area' / Flags: f_code=EB020
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|dmb
 +
|numeric(5,0)
 +
|Density Measuure (Brush/Undergrowth)
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_marsh
 +
:Source: 'swampa@veg(*)_area' / Flags: f_code=BH095
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_bog
 +
:Source: 'swampa@veg(*)_area' / Flags: f_code=BH015
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_herbtundracover
 +
:Source: 'tundraa@veg(*)_area'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_mixedcroppasturecover
 +
:Source: 'cropa@veg(*)_area' / Flags: veg=0
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_drycroppasturecover
 +
:Source: 'cropa@veg(*)_area' / Flags: veg=1
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_irrcroppasturecover
 +
:Source: 'cropa@veg(*)_area' / Flags: veg=999
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_deciduousbroadcover
 +
:Source: 'treesa@veg(*)_area' / Flags: veg=24
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_evergreenbroadcover
 +
:Source: 'treesa@veg(*)_area' / Flags: veg=25
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_mixedforestcover
 +
:Source: 'treesa@veg(*)_area' / Flags: veg=50
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_lake
 +
:Source: 'inwatera@hydro(*)_area' / Flags: f_code=BH000, hyc=8
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_intermittentlake
 +
:Source: 'inwatera@hydro(*)_area' / Flags: f_code=BH000, hyc=6
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_urban
 +
:Source: 'builtupa@pop(*)_area'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POLYGON
 +
|-
 +
|geonameid
 +
|integer
 +
|GeoNames reference
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_stream
 +
:Source: 'watrcrsl@hydro(*)_line' / Flags: hyc=8
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_intermittentstream
 +
:Source: 'watrcrsl@hydro(*)_line' / Flags: hyc=6
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_canal
 +
:Source: 'aquecanl@hydro(*)_line' / Flags: exs=1, loc=8
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|loc
 +
|numeric(5,0)
 +
|Location Category
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_road
 +
:Source: 'roadl@trans(*)_line' / Flags: 'med!=1'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|med
 +
|numeric(5,0)
 +
|Median Category
 +
|-
 +
|rtt
 +
|numeric(5,0)
 +
|Route Intended Use
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_freeway
 +
:Source: 'roadl@trans(*)_line' / Flags: med=1
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|med
 +
|numeric(5,0)
 +
|Median Category
 +
|-
 +
|rtt
 +
|numeric(5,0)
 +
|Route Intended Use
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_railroad1
 +
:Source: 'railrdl@trans(*)_line' / Flags: 'fco!=2'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_railroad2
 +
:Source: 'railrdl@trans(*)_line' / Flags: fco=2
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_depthcontour
 +
:Source: 'depthl@bnd(*)_line'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|crv
 +
|numeric(5,0)
 +
|Depth Curve or Contour Value (meters)
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_elevcontour
 +
:Source: 'contourl@elev(*)_line'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; LINESTRING
 +
|-
 +
|zv2
 +
|numeric(5,0)
 +
|Highest Z-value (meters)
 +
|-
 +
|}
 +
 
 +
 
 +
; v0_town
 +
:Source: 'builtupp@pop(*)_point'
 +
{|border="1"
 +
!Attribute
 +
!Type
 +
!Description
 +
|-
 +
|wkb_geometry
 +
|feature geometry; POINT
 +
|-
 +
|geonameid
 +
|integer
 +
|GeoNames reference
 +
|-
 +
|nam
 +
|varchar
 +
|Name
 +
|-
 +
|}
 +
 
 +
 
 +
[[Category:Public Geospatial Data Committee]]

Latest revision as of 09:15, 26 January 2009

v0_landmass
Source: 'polbnda@bnd(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name
na2 character(2) Two-character country code
na3 character(1) Classification Name


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


v0_sand
Source: 'grounda@phys(*)_area' / Flags: smc=88, swc=0
Attribute Type Description
wkb_geometry feature geometry; POLYGON


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


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


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


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


v0_littoral
Source: 'grounda@phys(*)_area' / Flags: smc=88, swc=3
Attribute Type Description
wkb_geometry feature geometry; POLYGON


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


v0_grasscover
Source: 'grassa@veg(*)_area' / Flags: f_code=EB010
Attribute Type Description
wkb_geometry feature geometry; POLYGON


v0_scrubcover
Source: 'grassa@veg(*)_area' / Flags: f_code=EB020
Attribute Type Description
wkb_geometry feature geometry; POLYGON
dmb numeric(5,0) Density Measuure (Brush/Undergrowth)


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


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


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


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


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


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


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


v0_evergreenbroadcover
Source: 'treesa@veg(*)_area' / Flags: veg=25
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v0_mixedforestcover
Source: 'treesa@veg(*)_area' / Flags: veg=50
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v0_lake
Source: 'inwatera@hydro(*)_area' / Flags: f_code=BH000, hyc=8
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v0_intermittentlake
Source: 'inwatera@hydro(*)_area' / Flags: f_code=BH000, hyc=6
Attribute Type Description
wkb_geometry feature geometry; POLYGON
nam varchar Name


v0_urban
Source: 'builtupa@pop(*)_area'
Attribute Type Description
wkb_geometry feature geometry; POLYGON
geonameid integer GeoNames reference
nam varchar Name


v0_stream
Source: 'watrcrsl@hydro(*)_line' / Flags: hyc=8
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name


v0_intermittentstream
Source: 'watrcrsl@hydro(*)_line' / Flags: hyc=6
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name


v0_canal
Source: 'aquecanl@hydro(*)_line' / Flags: exs=1, loc=8
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
nam varchar Name
loc numeric(5,0) Location Category


v0_road
Source: 'roadl@trans(*)_line' / Flags: 'med!=1'
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
med numeric(5,0) Median Category
rtt numeric(5,0) Route Intended Use


v0_freeway
Source: 'roadl@trans(*)_line' / Flags: med=1
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
med numeric(5,0) Median Category
rtt numeric(5,0) Route Intended Use


v0_railroad1
Source: 'railrdl@trans(*)_line' / Flags: 'fco!=2'
Attribute Type Description
wkb_geometry feature geometry; LINESTRING


v0_railroad2
Source: 'railrdl@trans(*)_line' / Flags: fco=2
Attribute Type Description
wkb_geometry feature geometry; LINESTRING


v0_depthcontour
Source: 'depthl@bnd(*)_line'
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
crv numeric(5,0) Depth Curve or Contour Value (meters)


v0_elevcontour
Source: 'contourl@elev(*)_line'
Attribute Type Description
wkb_geometry feature geometry; LINESTRING
zv2 numeric(5,0) Highest Z-value (meters)


v0_town
Source: 'builtupp@pop(*)_point'
Attribute Type Description
wkb_geometry feature geometry; POINT
geonameid integer GeoNames reference
nam varchar Name