Add site rou

From PTAGISWiki

Contents 1 Procedure for adding a new site to the ALRS database 1.1 location (new) 1.2 river_segment (new) 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.

ROU	Round Butte Dam	*	17070301	D	Dam	44.3061°	-121.2778°			259	144																																																																																																																																																																																																																																																				
																																																																																																																																																																																																																																																						

Here are the tables and fields I needed to populate:

location (new)

loc_id: [ 0 makes a new ID ]

location_name: Round Butte Dam

Lat: 44.3061

Lon: -121.2778

ElevationMsl: 0

ycoord: 259

xcoord: 144

river_segment (new)

SegId: 348

HUC: 17070301

Name: Upper Deschutes

SegNbr: 2

RKM: 328

Description: Upper Deschutes

ReachMin: 0

ReachMax: 0

location_in_segment (new)

site_id: ROU

loc_id: 744 (from location table)

seg_id: 348 (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