fwapg

fwapg extends British Columbia’s Freshwater Atlas (FWA) with PostgreSQL/PostGIS. fwapg provides additional tables, indexes and functions to:

• quickly translate arbitrary point locations (X,Y) to a linear reference positions (blue_line_key, measure) on the stream network

• enable speedy upstream/downstream queries throughout BC

• quickly and cleanly generate watershed boundaries upstream of arbitrary locations

• enable cross-boundary queries by combining FWA data with data from neighbouring jurisdictions

• enable querying of FWA features via spatial SQL

• provide gradient values for every FWA stream

• enable quickly serving FWA features as vector tiles (MVT) via pg_tileserv

• enable quickly serving FWA features and custom fwapg functions via pg_featureserv

Contents:

• Setup and data load
  • Create the database
  • Environment variables
  • Schema and data load
  • Updates
  • Data currency
• Usage
  • Upstream / downstream analysis
• Value added table/view reference
  • fwa_approx_borders
  • fwa_assessment_watersheds_lut
  • fwa_assessment_watersheds_streams_lut
  • fwa_basins_poly
  • fwa_bcboundary
  • fwa_named_streams
  • whse_basemapping.fwa_streams_vw
  • fwa_streams_watersheds_lut
  • fwa_waterbodies
  • fwa_waterbodies_upstream_area
  • fwa_watersheds_upstream_area
• Function reference
  • FWA_Downstream
  • FWA_IndexPoint
  • FWA_LocateAlong
  • FWA_LocateAlongInterval
  • FWA_StreamsAsMVT
  • FWA_Upstream
  • FWA_UpstreamTrace
  • FWA_WatershedAtMeasure