Add site enl
From PTAGISWiki
Contents |
Procedure for adding a new site to the ALRS database
6/17/2009
Using the ALRS webapp for this site entry.
ENL Lower Entiat River Instream MUX at Entiat River rkm 2, immediately upstream of Entiat, WA. Instream Remote Detection System USFWS 47.66378 -120.24282 ENTIAR 17020010 2 2007 Current
Here are the tables and fields I needed to populate:
location (new)
- loc_id: 785
- location_name: Instream MUX at Entiat River rkm 2, immediately upstream of Entiat, WA.
- Lat: 47.66378
- Lon: -120.24282
- ElevationMsl: 0
- ycoord: 77
- xcoord: 183
river_segment (new)
- SegId: 364
- HUC: 17020010
- Name: ENL
- SegNbr: 1
- RKM: 778.002
- Description: Lower Entiat River
- ReachMin: 0
- ReachMax: 0
location_in_segment (new)
- site_id: ENL
- loc_id: 785 (from location table)
- seg_id: 364 (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: ENL
- site_id: ENL (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 2, immediately upstream of Entiat, WA.
- from_km: 0
- to_km: 0
- from_date: 2007-01-01 00:00:00 (from Data > Reports > Interactive > Interrogation sites)
- to_date:
