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. |
||||
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). |
|||
code | varchar | 2147483647 | null |
|
|
Most commonly used abbreviation of the system name, even if not in English. If not defined by owner, should be created by user. |
||||
code_localized | jsonb | 2147483647 | null |
|
|
All official known abbreviations of the system code and respective locale. |
||||
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 |
|
|
|||||
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 |
|
|
|||||
id | serial | 10 | √ | nextval('systems_id_seq'::regclass) |
|
|
||||
system_type_id | int4 | 10 | √ | null |
|
|
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 |