LandcoverDB TIGER Detail

From OSGeo
Revision as of 12:12, 6 October 2007 by Martin (talk | contribs) (Add source detail)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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