Skip to main content

Advertisement

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)