Add site per

From PTAGISWiki

Contents 1 Procedure for adding a new site to the ALRS database 1.1 location (new) 1.2 river_segment (existing) 1.3 location_in_segment (new)

Procedure for adding a new site to the ALRS database

10/16/2008

Using the ALRS webapp for this site entry.

PER	Pelton Reregulating Dam	*	17070306	D	Dam	44.7240°	-121.2476°	743	76																																																																																																																																																																																																																																																						

Here are the tables and fields I needed to populate:

location (new)

loc_id: 743 [ 0 makes a new ID ]

location_name: Pelton Reregulating Dam

Lat: 44.7240

Lon: -121.2476

ElevationMsl: 0

ycoord: 236

xcoord: 145

river_segment (existing)

SegId: 76

HUC: 17060306

Name: Lower Deschutes River

SegNbr: 1

RKM:

Description:

ReachMin: 0

ReachMax: 0

location_in_segment (new)

site_id: PER

loc_id: 743 (from location table)

seg_id: 76 (from river_segment table)

site_type: dam (Adult fish facility, dam, fish hatchery, highway bridge, diversion screens, fish trap, hybrid, island, riverbed, juvenile bypass)

site_description: constructed environment

locality_radius: 500

general_locality_site:

km_in_reach: 0

km_total: 0