matching stream observations > 100m from stream

[smnorris]

fish_observation_point_id = 466322 on Wardropper Creek (north side of Lake Cowichan) does not get matched to a stream.

The site is <100m from a stream but is ~125m from the non-waterbody portion of the stream. Presumably there is no match via the xref and linear_feature_id.

As we already have a ~98% match rate this may not be a priority but to fix, we could try:

• attempt to match sites 100-500m from a stream that do not have exact linear_feature_id matches via blue_line_key, watershed_code etc, and attributes like gazetted_name
• allow matching stream records to flow lines in waterbodies

[smnorris]

fish_observation_point_id = 466322 is actually a summary site, it doesn't get pulled into the _distinct table. I don't think there is an issue.