Add site fogdew
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: Tagging Site Proposed Code: FOGDEW Proposed Description: Foggy Dew Creek, Methow River Basin Release Site: Yes River Kilometers: 843.035.009 Point Release Site: No Reason for proposal: I would like to register Foggy Dew Creek a trib of Gold Creek in the Methow River Basin. We have an instream PIT-tag reader in Foggy Dew and multiple release locations that may be important to keep our release locations seperate from fish tagged in the mainstem gold creek near the same rkm. The official StreamNet coordinates for this river are: 48.172060, -120.273827. Its LLID is: 1201887482046.
Here are the tables and fields I needed to populate:
location
- loc_id: 684 [ 0 makes a new ID ]
- location_name: Foggy Dew Creek, Methow River Basin
- Lat: 48.172060
- Lon: -120.273827
- ycoord: 49
- xcoord: 182
river_segment
- SegId: 307
- HUC: 17020008
- Name: FOGDEW
- SegNbr: 1 (check other river segments in HUC to get this value)
- RiverKm: 843.035.009
- Description: Foggy Dew Creek, Methow River Basin
location_in_segment
- site_id: FOGDEW
- loc_id: 684 (from location table)
- seg_id: 307 (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
- 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: FOGDEW
- site_id: FOGDEW (key to location-in-segment)
- activity_category: hands-on (hands-on, remote)
- activity_code: tagging, release, recapture (one record for each activity)
- activity_suffix: non (con or non continuous flow)
- contact_id: -1
- activity_loc_description: Foggy Dew Creek, Methow River Basin
- from_km: 0
- to_km: 0
- from_date: 01/01/2006 (from Data > Reports > Interactive > Interrogation sites)
- to_date:
