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 |
|
|