quanted / hms_kube

HMS kubernetes stack
0 stars 0 forks source link

Update HMS catchments database for waterbodies #13

Closed deronsmith closed 2 years ago

deronsmith commented 2 years ago

In the catchments database, add new field, WBComID, to PlusFlowlineVAA table which will be empty/null except where the catchment overlaps with a NHDPlus V2.1 Waterbody. Add a new table for NHDPlus V2.1 Waterbodies.

Add query to stream info which returns the ComID and WBComID for where ComID is in the list of comIDs for the network AND WBComID is not null/empty. Add new field in response WBComIDs: {COMID: WBComID}, add field to stream network table for WBComID, WB GNIS_Name (may be empty), FType and FCode.

All fields and tables can be found in the NHDPlus V2.1 dataset.