Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Yakima Redd Survey 2002-2012
Short Name: Yakima Redd Survey 2002-2012
Status: Planned
Abstract:

Annual Yakima River Redd Survey GIS Data 2002 to 2012.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

Annual Yakima River Redd Survey GIS Data 2002 to 2012.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
gps_ NUMBER Unique ID number generated by GPS.
100
color VARCHAR2 Color of flagging used to mark redds.
100
channel VARCHAR2 River Channel surveyed.
100
comment VARCHAR2 An optional comment field.
100
Max_PDOP NUMBER Provides information on precision of verticle data point collection.
100
Max_HDOP NUMBER Provides information on horizontal precision of data point collection.
100
Corr_Type VARCHAR2 Data post processing correction type.
100
Rcvr_Type VARCHAR2 GPS Reciever used to collect data.
100
GPS_Date DATE Date of collection.
100
GPS_Time DATE Time of collection.
100
Feat_Name VARCHAR2 Feature collected.
100
Datafile VARCHAR2 Name of GPS data file.
100
Unfilt_Pos NUMBER Filtered Positions collected to generate data point.
100
Filt_Pos NUMBER Unfiltered Positions collected to generate data point.
100
Update_Sta VARCHAR2 GIS Generated column during postprocessing_no definition.
100
Std_Dev NUMBER Standard Deviation of Position collected to generate data point. Units for values are Meters.
100
GPS_Height NUMBER Altitude of GPS point. Units for values are Meters.
100
Horz_Prec NUMBER Horizonal precison of data point. Units for values are Meters.
100
Vert_Prec NUMBER Verticle precision of data point. Units for values are Meters.
100
Latitude NUMBER Latitude. Units for values are Decimal Degrees.
100
Longitude NUMBER Longitude. Units for values are Decimal Degrees.
100
Point_ID NUMBER Unique ID for calculated reach points.
100
Data_Dicti VARCHAR2 GPS Data Dictionary used for data collection.
100
redd_date DATE Date of the week the redd was flagged during the survey.
100
redd_id NUMBER Another Unique ID number.
100
river VARCHAR2 This denotes what river the data where collected on.
100
wk_samp NUMBER This denotes what sampling week the data were collected.
100
Measure NUMBER Distance from an arbitratary location chosen to establish river distance. Units for values are Meters.
100
SnpDist NUMBER This measure is the distance used to snap the the GPS point to a linear referenced River Shapefile. Units for values are Meters.
100
reachm VARCHAR2 Our user defined river reaches (these were created by us to break the river into sections.

Attribute Details

gps_

CC ID: 731015
Seq. Order: 1
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique ID number generated by GPS.

General Data Type: NUMBER

color

CC ID: 731016
Seq. Order: 2
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Color of flagging used to mark redds.

General Data Type: VARCHAR2

channel

CC ID: 731017
Seq. Order: 3
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

River Channel surveyed.

General Data Type: VARCHAR2

comment

CC ID: 731018
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

An optional comment field.

General Data Type: VARCHAR2

Max_PDOP

CC ID: 731019
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Provides information on precision of verticle data point collection.

General Data Type: NUMBER

Max_HDOP

CC ID: 731020
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Provides information on horizontal precision of data point collection.

General Data Type: NUMBER

Corr_Type

CC ID: 731021
Seq. Order: 7
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Data post processing correction type.

General Data Type: VARCHAR2

Rcvr_Type

CC ID: 731022
Seq. Order: 8
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

GPS Reciever used to collect data.

General Data Type: VARCHAR2

GPS_Date

CC ID: 731023
Seq. Order: 9
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date of collection.

General Data Type: DATE

GPS_Time

CC ID: 731024
Seq. Order: 10
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Time of collection.

General Data Type: DATE

Feat_Name

CC ID: 731025
Seq. Order: 11
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Feature collected.

General Data Type: VARCHAR2

Datafile

CC ID: 731026
Seq. Order: 12
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Name of GPS data file.

General Data Type: VARCHAR2

Unfilt_Pos

CC ID: 731027
Seq. Order: 13
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Filtered Positions collected to generate data point.

General Data Type: NUMBER

Filt_Pos

CC ID: 731028
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unfiltered Positions collected to generate data point.

General Data Type: NUMBER

Update_Sta

CC ID: 731029
Seq. Order: 15
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

GIS Generated column during postprocessing_no definition.

General Data Type: VARCHAR2

Std_Dev

CC ID: 731030
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Standard Deviation of Position collected to generate data point. Units for values are Meters.

General Data Type: NUMBER
Unit of Measure: Meters

GPS_Height

CC ID: 731031
Seq. Order: 17
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Altitude of GPS point. Units for values are Meters.

General Data Type: NUMBER
Unit of Measure: Meters

Horz_Prec

CC ID: 731032
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Horizonal precison of data point. Units for values are Meters.

General Data Type: NUMBER
Unit of Measure: Meters

Vert_Prec

CC ID: 731033
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Verticle precision of data point. Units for values are Meters.

General Data Type: NUMBER
Unit of Measure: Meters

Latitude

CC ID: 731034
Seq. Order: 20
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude. Units for values are Decimal Degrees.

General Data Type: NUMBER
Unit of Measure: Decimal Degrees

Longitude

CC ID: 731035
Seq. Order: 21
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude. Units for values are Decimal Degrees.

General Data Type: NUMBER
Unit of Measure: Decimal Degrees

Point_ID

CC ID: 731036
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique ID for calculated reach points.

General Data Type: NUMBER

Data_Dicti

CC ID: 731037
Seq. Order: 23
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

GPS Data Dictionary used for data collection.

General Data Type: VARCHAR2

redd_date

CC ID: 731038
Seq. Order: 24
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date of the week the redd was flagged during the survey.

General Data Type: DATE

redd_id

CC ID: 731039
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Another Unique ID number.

General Data Type: NUMBER

river

CC ID: 731040
Seq. Order: 26
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

This denotes what river the data where collected on.

General Data Type: VARCHAR2

wk_samp

CC ID: 731041
Seq. Order: 27
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

This denotes what sampling week the data were collected.

General Data Type: NUMBER

Measure

CC ID: 731042
Seq. Order: 28
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Distance from an arbitratary location chosen to establish river distance. Units for values are Meters.

General Data Type: NUMBER
Unit of Measure: Meters

SnpDist

CC ID: 731043
Seq. Order: 29
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

This measure is the distance used to snap the the GPS point to a linear referenced River Shapefile. Units for values are Meters.

General Data Type: NUMBER
Unit of Measure: Meters

reachm

CC ID: 731044
Seq. Order: 30
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Our user defined river reaches (these were created by us to break the river into sections.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36784
GUID: gov.noaa.nmfs.inport:36784
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-02-13 16:57+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28