Add site lwn
From PTAGISWiki
Contents |
Procedure for adding a new site to the ALRS database
6/17/2009
Using the ALRS webapp for this site entry.
LWN Little Wenatchee River Instream MUX at Little Wenatchee River rkm 4, at the old fish weir site Instream Remote Detection System WDFW 47.83420 -120.83888 LWENAT 17020011 4 Current Current
Here are the tables and fields I needed to populate:
location (new)
- loc_id: 787
- location_name: Instream MUX at Little Wenatchee River rkm 4, at the old fish weir site
- Lat: 47.83420
- Lon: -120.83888
- ElevationMsl: 0
- ycoord: 68
- xcoord: 161
river_segment (new)
- seg_id: 366
- HUC: 17020011
- Name: LWN
- SegNbr: 1
- RKM: 754.090.008.004
- Description: Little Wenatchee River
- ReachMin: 0
- ReachMax: 0
location_in_segment (new)
- site_id: LWN
- loc_id: 787 (from location table)
- seg_id: 366 (from river_segment table)
- site_type: riverbed (Adult fish facility, dam, fish hatchery, highway bridge, diversion screens, fish trap, hybrid, island, riverbed, juvenile bypass)
- site_description: natural environment
- locality_radius: 500
- general_locality_site:
- km_in_reach: 0
- km_total: 0
activity_location (new)
- site_code: LWN
- site_id: LWN (key to location-in-segment)
- activity_category: remote (hands-on, remote)
- activity_code: interrogation (one record for each activity)
- activity_suffix: non (con or non continuous flow)
- contact_id: -1
- activity_loc_description: Instream MUX at Little Wenatchee River rkm 4, at the old fish weir site
- from_km: 0
- to_km: 0
- from_date: 2009-01-01 00:00:00 (from Data > Reports > Interactive > Interrogation sites)
- to_date:
