From OSGeo Wiki
- 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
|