Good_segments

[pwoods25443]

Design a view or else implement a query that generates a new table to replace good_segs that can be used to filter positions to only include "clean" segments.

See the legacy version of good_segments

base this on the new and improved segment_info definition here:

#61

Looks like we need to capture min/max lat and lon also. Might need to generate this directly from position_messages...

[pwoods25443]

Should be able to make this now using the update segment_info table in #66

[pwoods25443]

Looks like we also need

• min_lat
• max_lat
• min_lon
• max_lon
• sat_pos_count

min/max lat and lon are fairly easy, but for sat_pos_count we will need to add 'receiver' to the normalized message schema and carry it through the segmenter. See https://github.com/GlobalFishingWatch/pipe-orbcomm/issues/46