Add site madrvr
From PTAGISWiki
Contents |
Procedure for adding a new site to the ALRS database
3/26/2007
Using the ALRS webapp for this site entry.
Code Type: Release Site Proposed Code: MADRVR Proposed Description: Mad River, tributary to the Entiat River (rkm 778) is 17.1 river kilometers up the Entiat as measured from mid-point of the Columbia River up the Entiat to the confluence of the Mad River using USGS maps and MapTech tools. Release Site: Yes River Kilometers: 778.017 Point Release Site: No Reason for proposal: Beginning in 2005 and continuing into the foreseeable future juvenile salmonids are and have been tagged on the Mad River prior to emigration to evaluate life specific survival, growth rates, and migrational timing. The official StreamNet coordinates for this site are: 47.820855, -120.515435. Its LLID is: 1203622477359.
Here are the tables and fields I needed to populate:
location
- loc_id: 682 [ 0 makes a new ID ]
- location_name: Mad River (Entiat River watershed)
- lat_decimal: 47.820855 (publish 6 points of precision for point sites)
- lon_decimal: -120.515435 (publish 3 points of precision for reaches)
- lat_lon_source:
- lat_estimate: 47.820855
- lon_estimate: -120.515435
- est_lat_lon_source:
- elevations_msl: 0
- y_coord: 68
- x_coord: 173
river_segment
- SegId: 305
- HUC: 17020010
- Name: MADRVR
- SegNbr: 1 (check other river segments in HUC to get this value)
- RiverKm: 778.017
- Description: Mad River (Entiat River watershed)
- ReachMinKm: 0 (must enter)
- ReachMaxKm: 0 (must enter)
location_in_segment
- site_id: MADRVR
- loc_id: 682 (from location table)
- seg_id: 305 (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: MADRVR
- site_id: MADRVR (key to location-in-segment)
- activity_category: hands-on (hands-on, remote)
- activity_code: tagging, release, recapture (one record for each activity)
- activity_suffix: blank (con or non continuous flow)
- contact_id: -1
- activity_loc_description: Mad River (Entiat River watershed)
- from_km: 0
- to_km: 0
- from_date: 1/1/2005 (from Data > Reports > Interactive > Interrogation sites)
- to_date:
