Description
Waterbodies include dams, streams, and rivers.
| Column Name | Data Type | Data UDT Type | Nullable | Description | Include |
|---|---|---|---|---|---|
| geom | geometry | geometry | YES | The spatial component or definition of the geographic feature. | x |
| created_at | timestamp without time zone | timestamp | YES | The created date of the record. | x |
| updated_at | timestamp without time zone | timestamp | YES | The last modification date of the record. | x |
| feature_area_sqm | double precision | float8 | YES | The surface area of the feature measured in square metres. | x |
| feature_length_m | double precision | float8 | YES | The perimeter of the feature measured in metres. | x |
| country_id | integer | int4 | NO | The identifier of the national administrative division. | x |
| country | character varying | varchar | YES | The official country name specified in English. | x |
| ison | integer | int4 | YES | The iso country number defined in ISO 3166-1. | x |
| iso3 | character varying | varchar | YES | The three-letter country code defined in ISO 3166-1. | x |
| iso2 | character varying | varchar | YES | The two-letter country code defined in ISO 3166-1. | x |
| adminarea_l1_id | integer | int4 | YES | The identifier of the first-level administrative area. | x |
| adminarea_l1_type | character varying | varchar | YES | The type of the first-level administrative area. | x |
| adminarea_l1_name | character varying | varchar | YES | The name of the first-level administrative area. | x |
| adminarea_l1_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the first-level administrative area. | x |
| adminarea_l2_id | integer | int4 | YES | The identifier of the second-level administrative area. | x |
| adminarea_l2_type | character varying | varchar | YES | The type of the second-level administrative area. | x |
| adminarea_l2_name | character varying | varchar | YES | The name of the second-level administrative area. | x |
| adminarea_l2_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the second-level administrative area. | x |
| adminarea_l2_variantname | character varying | varchar | YES | An alternative and/or former name of the second-level administrative area. | x |
| adminarea_l3_id | integer | int4 | YES | The identifier of the third-level administrative area. | x |
| adminarea_l3_type | character varying | varchar | YES | The type of the third-level administrative area. | x |
| adminarea_l3_name | character varying | varchar | YES | The name of the third-level administrative area. | x |
| adminarea_l3_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the third-level administrative area. | x |
| adminarea_l3_variantname | character varying | varchar | YES | An alternative and/or former name of the third-level administrative area. | x |
| locality_id | integer | int4 | YES | The identifier of the locality. | x |
| locality_type | character varying | varchar | YES | The type of the locality. | x |
| locality_name | character varying | varchar | YES | The name of the locality. | x |
| water_id | integer | int4 | NO | The water body identifier. | x |
| water_name | character varying | varchar | YES | The name of the water body. | x |
| water_type | character varying | varchar | YES | The type of the water body. | x |
| map_sheet | character varying | varchar | YES | The mapseries name. | x |
| map_label1 | character varying | varchar | YES | A proposed expression for map labelling purposes. | x |
| label | geometry | geometry | YES | The spatial component or definition of the recommended label location. | x |
| mbr | geometry | geometry | YES | The spatial component or definition of the minimum boundary rectangle. | x |
| vbr | geometry | geometry | YES | The spatial component or definition of the viewport boundary rectangle. | x |