Difference between revisions of "LandcoverDB VMap0 Detail"
m (/* prepare for automagically adding attribute descriptions/) |
m (→add type) |
||
Line 2: | Line 2: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 8: | Line 9: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
|na2 | |na2 | ||
+ | |character(2) | ||
|Country | |Country | ||
|- | |- | ||
|na3 | |na3 | ||
+ | |character(1) | ||
|Continent | |Continent | ||
|- | |- | ||
Line 22: | Line 26: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 28: | Line 33: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 36: | Line 42: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 47: | Line 54: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 58: | Line 66: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 69: | Line 78: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 75: | Line 85: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 83: | Line 94: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 89: | Line 101: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 97: | Line 110: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 108: | Line 122: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 119: | Line 134: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 130: | Line 146: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 136: | Line 153: | ||
|- | |- | ||
|dmb | |dmb | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
Line 144: | Line 162: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 155: | Line 174: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 166: | Line 186: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 177: | Line 198: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 188: | Line 210: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 199: | Line 222: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 210: | Line 234: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 216: | Line 241: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 224: | Line 250: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 230: | Line 257: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 238: | Line 266: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 244: | Line 273: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 252: | Line 282: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 258: | Line 289: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 266: | Line 298: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 272: | Line 305: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 280: | Line 314: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 286: | Line 321: | ||
|- | |- | ||
|geonameid | |geonameid | ||
+ | |integer | ||
|GeoNames reference | |GeoNames reference | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 297: | Line 334: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 303: | Line 341: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 311: | Line 350: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 317: | Line 357: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
Line 325: | Line 366: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 331: | Line 373: | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- | ||
|loc | |loc | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
Line 342: | Line 386: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 348: | Line 393: | ||
|- | |- | ||
|med | |med | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
|rtt | |rtt | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
Line 359: | Line 406: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 365: | Line 413: | ||
|- | |- | ||
|med | |med | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
|rtt | |rtt | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
Line 376: | Line 426: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 387: | Line 438: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 398: | Line 450: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 404: | Line 457: | ||
|- | |- | ||
|crv | |crv | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
Line 412: | Line 466: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 418: | Line 473: | ||
|- | |- | ||
|zv2 | |zv2 | ||
+ | |numeric(5,0) | ||
| | | | ||
|- | |- | ||
Line 426: | Line 482: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
+ | !Type | ||
!Description | !Description | ||
|- | |- | ||
Line 432: | Line 489: | ||
|- | |- | ||
|geonameid | |geonameid | ||
+ | |integer | ||
|GeoNames reference | |GeoNames reference | ||
|- | |- | ||
|nam | |nam | ||
+ | |varchar | ||
|Name | |Name | ||
|- | |- |
Revision as of 15:30, 12 September 2007
- v0_landmass
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
na2 | character(2) | Country |
na3 | character(1) | Continent |
Spatial Reference System: EPSG:4326
- v0_floodland
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_sand
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_lava
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_glacier
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_packice
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_polarice
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_littoral
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_barrencover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_grasscover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_scrubcover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
dmb | numeric(5,0) |
Spatial Reference System: EPSG:4326
- v0_marsh
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_bog
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_herbtundracover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_mixedcroppasturecover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_drycroppasturecover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_irrcroppasturecover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON |
Spatial Reference System: EPSG:4326
- v0_deciduousbroadcover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_evergreenbroadcover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_mixedforestcover
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_lake
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_intermittentlake
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_urban
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POLYGON | |
geonameid | integer | GeoNames reference |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_stream
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_intermittentstream
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING | |
nam | varchar | Name |
Spatial Reference System: EPSG:4326
- v0_canal
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING | |
nam | varchar | Name |
loc | numeric(5,0) |
Spatial Reference System: EPSG:4326
- v0_road
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING | |
med | numeric(5,0) | |
rtt | numeric(5,0) |
Spatial Reference System: EPSG:4326
- v0_freeway
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING | |
med | numeric(5,0) | |
rtt | numeric(5,0) |
Spatial Reference System: EPSG:4326
- v0_railroad1
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING |
Spatial Reference System: EPSG:4326
- v0_railroad2
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING |
Spatial Reference System: EPSG:4326
- v0_depthcontour
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING | |
crv | numeric(5,0) |
Spatial Reference System: EPSG:4326
- v0_elevcontour
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; LINESTRING | |
zv2 | numeric(5,0) |
Spatial Reference System: EPSG:4326
- v0_town
Attribute | Type | Description |
---|---|---|
wkb_geometry | feature geometry; POINT | |
geonameid | integer | GeoNames reference |
nam | varchar | Name |
Spatial Reference System: EPSG:4326