Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| name_english | varchar | 2147483647 | null |
|
|
Full official or directly translated name of the area in English, as defined by the owner. Country, species or owner name should be included only if in |
||||
| name_localized | jsonb | 2147483647 | √ | null |
|
|
Official name(s) and respective locale(s) of the area, as defined by the owner in local language. Country, species or owner name should be included only if in |
|||
| code | varchar | 2147483647 | null |
|
|
Abbreviated code of the area. This should be unique within the system. If the area is only referred to by a full name (i.e. Area_name_English or Area_name_localized) and does not have a unique code then a code should be created and the Area_code_official field set to 0. |
||||
| code_official | bool | 1 | null |
|
|
Binary flag for whether code is defined by System owner or not. |
||||
| parent_area | varchar | 2147483647 | √ | null |
|
|
Code of area immediately above current area if a hierarchy is defined and area is not at top level. |
|||
| geom | geometry | 2147483647 | null |
|
|
Polygon or multipolygon of the area in EPSG:4326. A single area is a single polygon (or multi-polygon) with a single (homogenous) area name, of a single system, of a single management authority/owner. |
||||
| comment | text | 2147483647 | √ | null |
|
|
Additional comments, notes, or considerations on the area by the database user. Could include known issues or uncertainties with the area. |
|||
| created_by | varchar | 2147483647 | √ | null |
|
|
Name of the organization that created the record |
|||
| created_on | date | 13 | CURRENT_DATE |
|
|
|||||
| system_id | int4 | 10 | null |
|
|