Difference between revisions of "LandcoverDB TIGER Detail"
Jump to navigation
Jump to search
(→New) |
(Add source detail) |
||
| Line 1: | Line 1: | ||
| − | ; tgr_waterbodies : | + | ; tgr_waterbodies:Flags: pip.module = poly2.module AND pip.polyid = poly2.polyid |
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
| Line 9: | Line 9: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| − | ; tgr_landmarks : | + | |
| + | ; tgr_landmarks: | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
| Line 21: | Line 21: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| − | ; tgr_major_roads : | + | |
| + | ; tgr_major_roads:Flags: substring(cfcc for 1) = 'A' OR substring(cfcc for 1) = 'P', cfcc_2 < 4 | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
| Line 33: | Line 33: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| − | ; tgr_minor_roads : | + | |
| + | ; tgr_minor_roads:Flags: substring(cfcc for 1) = 'A' OR substring(cfcc for 1) = 'P', cfcc_2 > 3 | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
| Line 45: | Line 45: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| − | ; tgr_railroads : | + | |
| + | ; tgr_railroads:Flags: substring(cfcc for 1) = 'B', cfcc_2 = 1 | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
| Line 57: | Line 57: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| − | ; tgr_waterways : | + | |
| + | ; tgr_waterways:Flags: substring(cfcc for 1) = 'H' AND (substring(cfcc from 2 for 1) = 1 OR substring(cfcc from 2 for 1) = 2) | ||
{|border="1" | {|border="1" | ||
!Attribute | !Attribute | ||
| Line 69: | Line 69: | ||
|- | |- | ||
|} | |} | ||
| − | |||
[[Category:Public Geospatial Data Committee]] | [[Category:Public Geospatial Data Committee]] | ||
Latest revision as of 12:12, 6 October 2007
- tgr_waterbodies
- Flags: pip.module = poly2.module AND pip.polyid = poly2.polyid
| Attribute | Type | Description |
|---|---|---|
| wkb_geometry | feature geometry; POLYGON |
- tgr_landmarks
| Attribute | Type | Description |
|---|---|---|
| wkb_geometry | feature geometry; POLYGON |
- tgr_major_roads
- Flags: substring(cfcc for 1) = 'A' OR substring(cfcc for 1) = 'P', cfcc_2 < 4
| Attribute | Type | Description |
|---|---|---|
| wkb_geometry | feature geometry; LINESTRING |
- tgr_minor_roads
- Flags: substring(cfcc for 1) = 'A' OR substring(cfcc for 1) = 'P', cfcc_2 > 3
| Attribute | Type | Description |
|---|---|---|
| wkb_geometry | feature geometry; LINESTRING |
- tgr_railroads
- Flags: substring(cfcc for 1) = 'B', cfcc_2 = 1
| Attribute | Type | Description |
|---|---|---|
| wkb_geometry | feature geometry; LINESTRING |
- tgr_waterways
- Flags: substring(cfcc for 1) = 'H' AND (substring(cfcc from 2 for 1) = 1 OR substring(cfcc from 2 for 1) = 2)
| Attribute | Type | Description |
|---|---|---|
| wkb_geometry | feature geometry; LINESTRING |