Table 5 Field names and definitions for data collected through the systematic map process
From: Assessing the global distribution of river fisheries harvest: a systematic map protocol
Field name | Field definition | Field type |
|---|---|---|
Ref_ID | DOI or assigned reference number | VARCHAR(25) |
RIVERID | (Metadata) artificial sequence number, linked to metadata table. RIVERID is derived from on NaturalEarth Rivers Database | NUMBER(6) |
RIVER_NAME | River name | VARCHAR2(150) |
RIVER_ZONE_ID | Segment ID from the river zones. these zones were defined in a separate modeling analysis based on a k-mean plus cluster algorithm where cluster were derived based on six different bio-physical parameters of the rivers. A separate manuscript regarding this modeling effort is under preparation | NUMBER(15) |
FISHCATCH_ID | Fish_Catch_record sequence number (unique) | NUMBER(6) |
BEG_DATE | Beginning date of fish data. Format: month/year example: 06/2016 | DATE |
END_DATE | End date of fish data. Format: month/year example: 06/2016 | DATE |
EST_DATE | Is the date estimated? (1 = yes, 2 = no) | NUMBER(1) |
FISH_CATCH_LAT | Latitude coordinate of fish catch in decimal degree | NUMBER(15, 2) |
FISH_CATCH_LONG | Longitude coordinate of fish catch in decimal degree | NUMBER(15, 2) |
FISH_CATCH_LOCATION | Original coordinate or location data from the reference | VARCHAR2(150) |
LOCATION_MAP | Is there a map showing the location of data collection? (1 = yes, 2 = no) | NUMBER(1) |
FISH_CATCH_SPECIES | Species full Latin name. Enter “Mixed Catch” if specific species names are not provided. Example: Schizodon fasciatus | NUMBER(8) |
FISH_CATCH_COUNT | Number of individual fish caught. Enter N/A if number is not available | NUMBER(8) |
FISH_SPECIES_TYPE | Select type of species (1 = native, 2 = non-native, 3 = article does not specify). If a report combines multiple fisheries, catch from each fishery will be recorded as separate entries | NUMBER(1) |
FISH_SPECIES_INTRO_YR | If introduced species then the year this species introduced in this river system, as determined by fishbase.org | NUMBER(4) |
FISH_CATCH_TYPE | Select the reason for fish capture (1 = artisanal, 2 = commercial, 3 = recreational, 4 = scientific study, 5 = subsistence, 6 = aquaculture, 7 = others) | NUMBER(1) |
FISH_CATCH_WT | The numeric value for the weight of the fish catch. The unit of weight is recorded in the field FISH_CATCH_UNIT | NUMBER(15,2) |
FISH_CATCH_UNIT | Select the weight unit reported by the article | VARCHAR2(5) |
FISH_CATCH_KG | Fish biomass, in kg. Calculated from field “FISH_CATCH_WT” | NUMBER(15,2) |
SAMPLED_AREA | What area was sampled (include units) | NUMBER(8,2) |
FISH_CATCH_BY_AREA | Fish biomass, in kg/ha or X unit | NUMBER(15,2) |
TOTAL_BIOMASS | The numeric value for the total biomass captured (including fish and other species). Enter N/A if not available | NUMBER(15,2) |
TOTAL_BIOMASS_UNIT | Select the weight unit reported by the article | VARCHAR2(5) |
TOTAL_BIOMASS_KG | Total biomass captured in the haul in KG (including fish and other species). Enter N/A if not available | NUMBER(15,2) |
GEAR_TYPE | Select the type of gear used to capture the fish species (1 = trawl, 2 = net, 3 = traps, 4 = line, 5 = electrofishing, 6 = other) | VARCHAR2(150) |
GEAR_SIZE | Numerical value for the gear size | NUMBER(8,2) |
GEAR_SIZE_UNIT | Select the gear size unit reported by the article | VARCHAR2(150) |
GEAR_SIZE_cm | Mesh size or gear size in centimeters | NUMBER(8,2) |
FISHING_EFFORT_UNIT | Number of boats or gears used for the survey | NUMBER(8) |
FISHING_EFFORT_DURATION | Number of hours or days spend in fishing (days as 24 h) | NUMBER(8) |