systems

0 rows


Description

Area or multiple areas defined, published and upkept by an Owner as a single set. Areas within a single system will be non-overlapping except for hierarchies, e.g. FAO 34.1.11 is a subset of FAO 34.1.
Examples: FAO fishing areas; IOTC area; DFO shrimp fishing areas.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
name_english varchar 2147483647 null

Official or directly translated English name of the system, generally in the plural, as defined by the owner. Country, species or owner name should be included only if in the official name.

name_localized jsonb 2147483647 null

Official name(s) and respective locale(s) of the system, generally in the plural, 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: Áreas de manejo}

additional_descriptor varchar 2147483647 null

Where necessary, additional descriptor of the system that differentiates the system from similar systems that share similar name and code (i.e. when name is not enough).
E.g., Lake Erie Yellow Perch Management Unit

code varchar 2147483647 null
system_owners.code Implied ConstraintR

Most commonly used abbreviation of the system name, even if not in English. If not defined by owner, should be created by user.
E.g., FMA

code_localized jsonb 2147483647 null

All official known abbreviations of the system code and respective locale.
E.g., {en: FMA, id: KKP}

code_official bool 1 null
code_disambiguation varchar 2147483647 null

Additional code necessary when System.Code, System_owner.Country, Owner.Code and System_type.Code are identical, i.e. not enough to disambiguate different systems, e.g. Canadian Shrimp Fishing Areas and Scallop Fishing Areas are both System_code: SFA, System_owner.Country: CAN, Owner.Code: DFO so will need to enter e.g. ‘shp’ and ‘sca’ here respectively, to differentiate.

multispecies bool 1 true

Binary flag for whether the system is directed at multiple species (true), or management of a single species (false). Defaults to 1.

multispecies_comment text 2147483647 null

Text description of the species the system manages. If text description is copied and pasted, cite the source. Generally used for multispecies areas where species managed can be summarised in a description. For example, “Tuna and tuna-like species and other species of fish taken by vessels fishing for tunas and tuna-like species. (copied from https://www.iattc.org/getattachment/593fe044-9e3c-440b-8acf-e676d16b6618/Antigua%20Convention%20-%20text).”

source varchar 2147483647 null

Citation of the source of the system and its areas. This should be the mandatory citation if provided, otherwise use APA style citation, also noting date retrieved. I.e. for a website: Author Surname or name of organisation, Author Firstname. (Date published or last revised). Title of webpage. Title of Website. Retrieved Date Retrieved from: website (e.g.: Ministry for Primary Industries (MPI). (10 Jan 2020). Quota Management Areas. Data.gov.nz. Retrieved 30 June 2022: https://mpi.maps.arcgis.com/home/item.html?id=83b5785c0f0b4da1a2c99dadeebdff0a)

source_date date 13 null

Date that the source was published or last updated (whichever is most recent). If date resolution only goes down to month then select 1st of month. If date resolution only goes down to year then select 1st of year. If no specific source date is known, use website date if available or retrieval date otherwise.

license_id int4 10 null
licenses.id systems_license_terms_fkeyR
lineage text 2147483647 null

Describes the history of the spatial data, including descriptions of the source material from which the data were derived, and the methods of derivation. It also contains the dates of the source material, and all transformations involved in producing the final digital files or map products. This includes whether the area was georeferenced from an image in the source, and any other layers and steps that may have been used in the creation (such as clipping to Natural Earth Admin - 0, 1:10 m land boundaries). If downloaded then imported with no additional manipulations then note ‘Downloaded and imported from SOURCE on DATE’.

comment text 2147483647 null

Additional comments, notes, or considerations on the system by the database user. Could include known issues or uncertainties with the system.

category _int4 10 null
system_owner_code varchar 2147483647 null
system_owners.code systems_system_owner_code_fkeyR
id serial 10 nextval('systems_id_seq'::regclass)
areas.system_id areas_system_id_fkeyR
system_type_id int4 10 null
system_types.id systems_system_type_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
systems_pkey Primary key Asc id
code_code_disambiguation_index Must be unique Asc/Asc code + code_disambiguation

Relationships