Database tables - Githubissues

dhardestylewis / terrain_aggregator

Workflow to aggregate terrain imagery at scale to a single seamless image dataset

Other

10 stars 4 forks source link

Database tables #19

Open dhardestylewis opened 2 years ago

dhardestylewis commented 2 years ago

✅ Original TNRIS Lidar tile database by project

Retiling products tile-by-tile

Retiling products as a whole (single row)

dhardestylewis commented 2 years ago

These are the current DB tables maintained:

terrain_aggregator source DEM tiles, from a variety of sources
- currently including:
  - TNRIS Lidar DEM collections
- and slated to include:
  - USGS seamless DEM collections
  - Fathom 3m DEMs
  - NOAA Digital Coast Lidar DEM collections (future version)
terrain_aggregator DEM collections derived from tiles
WBD HUC 12
WBD HUC 8
RFPGs
Texas state boundary

DB tables that will be produced:

single_seamless_elevation dataset
NHDPlus flowlines

The main purposes of these DBs are:

document TNRIS source DEM tiles
enable terrain_aggregator workflow approach + performance improvements as described in https://github.com/dhardestylewis/terrain_aggregator/issues/41 & https://github.com/dhardestylewis/terrain_aggregator/issues/44
enable web portal for visual feedback, selection, and download as described in https://github.com/dhardestylewis/terrain_aggregator/issues/59
QAQC for downhill monotonic flow as describied in https://github.com/dhardestylewis/terrain_aggregator/issues/73#issue-1323329494

dhardestylewis commented 2 years ago

[ ] document specific relevant attributes each DB table will provide