ALRS use cases
From PTAGISWiki
Contents |
Add a new tagging, release, recapture site on a recognized river segment
WFF is an adult fish ladder (obs site type 7 in ptagis.obs_site_definitions. Here are the tables and fields I needed to populate: location loc_id: [ 0 makes a new ID ] location_name: Willamette Falls Fishway lat_decimal: lon_decimal: lat_lon_source: lat_estimate: 45.352524 lon_estimate: -122.618098 est_lat_lon_source: GoogleEarth elevations_msl: 0 y_coord: 202 x_coord: 93 lat_err: 0 lon_err: 0 est_piy: 0 est_pix: 0 y_err: 0 x_err: 0 modification_date: 11/18/05 modification_comment: location_in_segment site_id: WFF loc_id: 654 (from location table) seg_id: 272 (from river_segment table) site_type: Adult fish facility (Adult fish facility, dam, fish hatchery, highway bridge, diversion screens, fish trap, hybrid, island, riverbed, juvenile bypass) site_description: Constructed environment locality_radius: 100 general_locality_site: WFL km_in_reach: 043 km_total: 0 category: adult rkm_fixed_site_y_n: Y (A fixed location, such as a dam, bridge or trap, or a temporary release site in a river or stream?) fixed_site_y_n: Y marking_only_y_n: N entire_river_y_n: N release_act_suffix_y_n: N archaic_y_n: N activity_location site_code: WFF site_id: WFF (key to location-in-segment) activity_category: REMOTE (hands-on) activity_code: INTERROGATION (tagging, release, recapture) activity_suffix: NON (con or non continuous flow) contact_id: -1 activity_loc_description: Willamette Falls Fishway from_km: 0 to_km: 0 from_date: 12/28/2005 (from Data > Reports > Interactive > Interrogation sites) to_date:
Add a new river segment
No currently planned activity at this site.
Add a new trap on an existing river segment
Add a new dam
Existing location Ice Harbor Dam (loc_id 420) Here are the tables and fields I needed to populate: location no change or addition needed location_in_segment site_id: ICH loc_id: 420 seg_id: 228 site_type: HYBRID site_description: Constructed environment locality_radius: 200 general_locality_site: km_in_reach: 0 km_total: 538 category: adult rkm_fixed_site_y_n: blank fixed_site_y_n: blank marking_only_y_n: blank entire_river_y_n: N release_act_suffix_y_n: blank archaic_y_n: N activity_location site_code: ICH site_id: ICH activity_category: REMOTE activity_code: INTERROGATION activity_suffix: NON contact_id: -1 activity_loc_description: Dummy description from_km: 0 to_km: 0 from_date: 4/1/05 to_date:
