Add site mrb
From PTAGISWiki
Contents |
Procedure for adding a new site to the ALRS database
3/27/2007
Using the ALRS webapp for this site entry.
Code Type: Interrogation Site Proposed Code: MRB Proposed Description: Instream detections in the Methow River Basin, Washington Interrogation Type: Instream Interrogation Coil Assignments: A1-A6; B1-B6; C1-C6; D1-D6; E1-E6 Reason for proposal: 17km radius about 42 km up Methow River from mouth. HUC 17020008. Approximate lat/lon midpoint 48.2908°(N), -120.0797(W). Start date: September 15, 2004. Monitors and antenna IDs: Beaver Creek, rkm 13.5 (FS-2001) -- A2 Beaver Creek (Stokes), rkm 4.6 (MUX) -- B1-B6 Beaver Creek, rkm 4.5 (FS-2001) -- A4 Beaver Creek, rkm 1.5 (FS-2001) -- A6 Libby Creek, rkm 2.4 (FS-2001) -- C2 Libby Creek, rkm 0.3 (FS-2001) -- C4 Gold Creek, rkm 8.7 (FS-2001) -- D2 Foggy Dew Creek, rkm 0.1 (FS-2001) -- D4 South Fork Gold Creek, rkm 3.8 (FS-2001) -- D6 Gold Creek, rkm 0.1 (MUX) -- E1-E6
Here are the tables and fields I needed to populate:
location
Used pre-existing location record.
- loc_id: 139 [ 0 makes a new ID ]
- location_name: Methow River
river_segment
Used existing river_segment record
- SegId: 151
- HUC: 17020008
- Name: METHR
- SegNbr: 1 (check other river segments in HUC to get this value)
- RiverKm: 843
- Description: Methow River
location_in_segment
- site_id: MRB
- loc_id: 139 (from location table)
- seg_id: 151 (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: 17000
- general_locality_site:
- km_in_reach: 0
- km_total: 0
- category: juvenile (hybrid, adult, juvenile, tag)
- rkm_fixed_site_y_n: N (A fixed location, such as a dam, bridge or trap, or a temporary release site in a river or stream?)
- fixed_site_y_n: N
- marking_only_y_n: N
- entire_river_y_n: Y
- release_act_suffix_y_n: Y
- archaic_y_n: N
activity_location
- site_code: MRB
- site_id: MRB (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: Methow River Basin, Washington
- from_km: 0
- to_km: 0
- from_date: 9/15/2004 (from Data > Reports > Interactive > Interrogation sites)
- to_date:
