search

NOAA-OWP / hydrovis

Other
11 stars 8 forks source link

Create the Alaska HUC Hotspots - Feature ID Crosswalk table #814

Closed KatherinePowell-NOAA closed 3 days ago

KatherinePowell-NOAA commented 1 month ago

Created a table of Alaska domain HUC10 polygon geometry and add to the HydroVIS Visualization Postgres Database, to the "derived" schema:

derived.huc10_alaska

SEE https://github.com/NOAA-OWP/hydrovis/issues/762

However, there are statistical columns missing (total low order reach count, etc.), so this needs to be updated.

Additionally - we ALSO need to create a featureid_huc_crosswalk_ak in the "derived" schema in order to use the hotspot SQL

KatherinePowell-NOAA commented 1 month ago

The derived.huc10_alaska table has been updated and renamed to derived.huc10s_alaska.

The crosswalk table has also been created in TI:

derived.featureid_huc_crosswalk_ak

Next, both tables will be tested with ROF services for Alaska, creating the Hotspot layers. Once verified, the table will need to be moved to UAT, then Production with the accompanying ROF services.