smnorris / bcfishobs

Reference BC Known Fish Observations to the Freshwater Atlas stream network
Apache License 2.0
6 stars 2 forks source link

improve matching of observations to streams based on watershed code #1

Closed smnorris closed 6 years ago

smnorris commented 6 years ago

On submission and load to BCGW, fish observations are snapped to 1:20k streams when loaded to the warehouse. However, observations may occur on unmapped streams and older observations may not have been snapped to 1:50k streams (or not snapped to a stream at all).

Modify the logic for matching observations (to streams, not waterbodies) to use watershed codes when distance from stream is greater than a small threshold. Review logic of matching streams to waterbodies to see if using the watershed code will improve the match.

smnorris commented 6 years ago

Note that I did not attempt to improve/QA the join via wbody_id with the join via new_wateshed_code