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 14: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