| Name | Type | Description |
|---|
| observation_key |
string |
Stable unique id, a hash of columns [source, species_code, observation_date, utm_zone, utm_easting, utm_northing, life_stage_code, activity_code] |
| fish_observation_point_id |
number |
Source observation primary key (unstable) |
| wbody_id |
number |
WBODY ID is a foreign key to WDIC_WATERBODIES. |
| species_code |
string |
BC fish species code, see https://raw.githubusercontent.com/smnorris/fishbc/master/data-raw/whse_fish_species_cd/whse_fish_species_cd.csv |
| agency_id |
number |
AGENCY ID is a foreign key to AGENCIES. |
| point_type_code |
string |
POINT TYPE CODE indicates if the row represents a direct Observation or a Summary of direct observations. |
| observation_date |
string |
The date on which the observation occurred. |
| agency_name |
string |
The name of the agency that made the observation. |
| source |
string |
The abbreviation, and if appropriate, the primary key, of the dataset(s) from which the data was obtained. For example: FDIS Database: fshclctn_id 66589 |
| source_ref |
string |
The concatenation of all biographical references for the source data. This may include citations to reports that published the observations, or the name of a project under which the observations were made. Some example values for SOURCE REF are: A RECONNAISSANCE SURVEY OF CULTUS LAKE, and Bonaparte Watershed Fish and Fish Habitat Inventory - 2000 |
| utm_zone |
number |
UTM ZONE is the 2 digit numeric code identifying the UTM Zone in which the UTM EASTING and UTM NORTHING lie. |
| utm_easting |
number |
UTM EASTING is the UTM Easting value within the specified UTM ZONE for this observation point. |
| utm_northing |
number |
UTM NORTHING is the UTM Northing value within the specified UTM ZONE for this observation point. |
| activity_code |
string |
ACTIVITY CODE contains the fish activity code from the source dataset, such as I for Incubating, or SPE for Spawning In Estuary. |
| activity |
string |
ACTIVITY is a full textual description of the activity the fish was engaged in when it was observed, such as SPAWNING. |
| life_stage_code |
string |
LIFE STAGE CODE is a short character code identiying the life stage of the fish species for this oberservation. Each source dataset of observations uses its own set of LIFE STAGE CODES. For example, in the FDIS dataset, U means Undetermined, NS means Not Specified, M means Mature, IM means Immature, and MT means Maturing. Descriptions for each LIFE STAGE CODE are given in the LIFE STAGE attribute. |
| life_stage |
string |
LIFE STAGE is the full textual description corresponding to the LIFE STAGE CODE |
| species_name |
string |
SPECIES NAME is the common name of the fish SPECIES that was observed. |
| waterbody_identifier |
string |
WATERBODY IDENTIFIER is a unique code identifying the waterbody in which the observation was made. It is a 5-digit seqnce number followed by a 4-character watershed group code. |
| waterbody_type |
string |
WATERBODY TYPE is a the type of waterbody in which the observation was made. For example, Stream or Lake. |
| gazetted_name |
string |
GAZETTED NAME is the gazetted name of the waterbody in which the observation was made. |
| new_watershed_code |
string |
NEW WATERSHED CODE is a watershed code, formatted with dashes, as assigned in the Watershed Atlas. For example: 900-569800-08600-00000-0000-0000-000-000-000-000-000-000. |
| trimmed_watershed_code |
string |
TRIMMED WATERSHED CODE is the NEW WATERSHED CODE, but with trailing zeros removed. For example, if the NEW WATERSHED CODE is 100-005200-43400-50000-0000-0000-000-000-000-000-000-000, then the TRIMMED WATERSHED CODE will be 100-005200-43400-50000. |
| acat_report_url |
string |
ACAT REPORT URL is a URL to the ACAT REPORT which provides additional information about the FISS FISH OBSRVTN PNT SP. |
| feature_code |
string |
FEATURE CODE contains a value based on the Canadian Council of Surveys and Mappings (CCSM) system for classification of geographic features. |
| linear_feature_id |
number |
See FWA documentation |
| wscode |
string |
Truncated FWA fwa_watershed_code |
| localcode |
string |
Truncated FWA local_watershed_code |
| blue_line_key |
number |
See FWA documentation |
| watershed_group_code |
string |
See FWA documentation |
| downstream_route_measure |
number |
See FWA documentation |
| match_type |
string |
Description of how the observation was matched to the stream |
| distance_to_stream |
number |
Distance (m) from source observation to output point |