Add site enm
From PTAGISWiki
Contents |
Procedure for adding a new site to the ALRS database
6/17/2009
Using the ALRS webapp for this site entry.
ENM Middle Entiat River Instream MUX at Entiat River rkm 26, below the McKenzie Diversion Dam Instream Remote Detection System USFWS 47.79705 -120.40307 ENTIAR 17020010 26 2008 Current
Here are the tables and fields I needed to populate:
location (new)
- loc_id: 786
- location_name: Instream MUX at Entiat River rkm 26, below the McKenzie Diversion Dam
- Lat: 47.79705
- Lon: -120.40307
- ElevationMsl: 0
- ycoord: 70
- xcoord: 177
river_segment (new)
- SegId: 365
- HUC: 17020010
- Name: ENM
- SegNbr: 1
- RKM: 778.026
- Description: Middle Entiat River
- ReachMin: 0
- ReachMax: 0
location_in_segment (new)
- site_id: ENM
- loc_id: 786 (from location table)
- seg_id: 365 (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: ENM
- site_id: ENM (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 Entiat River rkm 26, below the McKenzie Diversion Dam
- from_km: 0
- to_km: 0
- from_date: 2008-01-01 00:00:00 (from Data > Reports > Interactive > Interrogation sites)
- to_date:
