Currently a point is created for each observation record in whse_fish.fiss_fish_obsrvtn_events_sp, while whse_fish.fiss_falls_events_sp only includes distinct locations. This is fine for current use cases but standardizing would be valuable. It is probably best to go with what I've done for observations - use the events table for actual processing (no geoms), and use events_sp for visualizing. It is handy to have every input record easily queryable by the source id.
Currently a point is created for each observation record in
whse_fish.fiss_fish_obsrvtn_events_sp
, whilewhse_fish.fiss_falls_events_sp
only includes distinct locations. This is fine for current use cases but standardizing would be valuable. It is probably best to go with what I've done for observations - use theevents
table for actual processing (no geoms), and useevents_sp
for visualizing. It is handy to have every input record easily queryable by the source id.