From PTAGISWiki
Procedure for adding a new site to the ALRS database
11/18/05
Need to determine what currently exists in ALRS tables (activity_location,
location, location_in_segment, and perhaps river_segment), to look up seg_id,
and loc_id.
Need to gather data from production RKM.
Need to ask Dave what kind of activity takes place at the site?
(tagging, recapture, release, interrogation, sbyc, mortality)
Need to create an entry in activity_location for each activity type at the
site.
Need to know site code, lat/lon, rkm.
Need to derive pixelx and pixely from lat/lon.
[rday@snapper rday]$ ssh pittag@blueback
Last login: Tue Mar 1 14:00:48 from snapper.psmfc.or
blueback:TH:pittag: > bash
bash-2.05$ source ~rday/.bash_profile
blueback:TH:pittag: > TERM_INGRES=vt100fx
blueback:TH:pittag: > export TERM_INGRES
blueback:TH:pittag: > qbf -mappend ptagis3 <table> -s
CHECK THE LEGACY DATA.
WFF
Can't check the old pittag.org site anymore since the web redirect to ptagis.
(http://www.pittag.org/cgi-bin/pittag/vld-tbl.cgi?DP=OS)
(http://www.pittag.org/cgi-bin/pittag/rkm.cgi)
WFF not in:
http://www.psmfc.org/pittag/Software_and_Documentation/cur_site_config.html
WFF not in:
http://www.psmfc.org/pittag/Software_and_Documentation/hist_site_config.html
This will be a new location since there are no other activities at this
location.
Coordinates are in blueback:/home/pittag/doc/Misc Stuff/Site Coordinates.xls
-122.618098, 45.352524
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:
