areas

0 rows


Description

Individual polygons defined within a system. All hierarchies should be captured, e.g. both FAO 34.1 and FAO 34.1.11 are areas.

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
the official name.
E.g., Shrimp Fishing Area 14

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
the official name.
E.g., {es: Región de Arica y Parinacota}

code varchar 2147483647 null
system_owners.code Implied ConstraintR

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.
E.g., the Hake Quota Management Area (QMA) HAK1 in New Zealand has the code HAK1.

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.
E.g. for 34.1.11, would be 34.1

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
systems.id areas_system_id_fkeyR

Relationships