Name: WDFW_FishPassageSite

Display Field: StreamName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This map shows information on the location, type, and fish passage barrier status of road-based stream crossing structures, dams, and miscellaneous instream structures in Washington State. It is a subset of data extracted from the Washington Department of Fish and Wildlife's (WDFW) Fish Passage and Diversion Screening Inventory (FPDSI) database. It includes data compiled from several WDFW and non-WDFW fish passage barrier inventory efforts. The data are statewide in scope but do not represent a comprehensive or complete inventory of fish passage barriers. The data set is updated continually as inventory efforts are ongoing. The data are used to identify, locate, and prioritize correction of man-made fish passage barriers. Identifying and correcting fish passage barriers is a key component of salmon recovery. The data may be used by any group interested in salmon and habitat recovery. The data are also used to track where inventory efforts have occurred. The Washington Department of Fish and Wildlife (WDFW) makes no guarantee concerning the data's content, accuracy, completeness, or the results obtained from queries or use of these data. WDFW makes no warranty of fitness for a particular purpose, no representation as to the quality of any data, and assumes no liability for the data represented here. These data do not represent exhaustive inventories, but are compilations of existing knowledge from field biologists that are updated periodically as knowledge improves. This data should be used cautiously because they are not exhaustive, and are subject to change. When conducting projects or planning for fish and wildlife, please consider using additional information gathered from field investigations and consultations with WDFW or other professional biologists.

Copyright Text: WDFW Habitat Program

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -124.769698931558
YMin: 45.5021016770277
XMax: -116.7792341594
YMax: 49.0348623270582
Spatial Reference: 4269 (4269)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[42,137,90,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SiteRecordID (type: esriFieldTypeDouble, alias: SiteRecordID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SiteId (type: esriFieldTypeString, alias: Site ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SiteLatitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SiteLongitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FishPassageFeatureTypeCode (type: esriFieldTypeSmallInteger, alias: Feature Type Code, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Culvert], [2: Non-Culvert Xing], [3: Dam], ... 2 more ...)
• FeatureType (type: esriFieldTypeString, alias: Feature Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StreamName (type: esriFieldTypeString, alias: Stream Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TributaryToName (type: esriFieldTypeString, alias: Tributary to Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FishUseCode (type: esriFieldTypeSmallInteger, alias: Fish Use, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Missing], [10: Yes], [20: No], ... 1 more ...)
• FishUseCriteriaCode (type: esriFieldTypeSmallInteger, alias: Fish Use Criteria, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [10: Other], [11: Biological], [12: Physical], ... 1 more ...)
• RoadName (type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• RoadMilePostMeasurement (type: esriFieldTypeDouble, alias: Mile Post, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FishPassageBarrierStatusCode (type: esriFieldTypeSmallInteger, alias: Fish Passage Barrier, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [10: Yes], [20: No], ... 1 more ...)
• FishPassageBarrierReasonCode (type: esriFieldTypeSmallInteger, alias: Barrier Reason, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: WS Drop], [11: Slope], ... 16 more ...)
• PercentFishPassableCode (type: esriFieldTypeSmallInteger, alias: Percent Passable, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: 0], [20: 33], ... 3 more ...)
• SignificantReachCode (type: esriFieldTypeSmallInteger, alias: Significant Reach, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [10: Yes], [20: No], ... 1 more ...)
• OwnerTypeCode (type: esriFieldTypeSmallInteger, alias: Owner Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: City], [2: County], [3: Federal], ... 9 more ...)
• DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SurveyDate (type: esriFieldTypeString, alias: Survey Date, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• LinealGainMeasurement (type: esriFieldTypeInteger, alias: Potential Habitat Gain, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PriorityIndexTotalQuantity (type: esriFieldTypeDouble, alias: PI Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PotentialSpecies (type: esriFieldTypeString, alias: Potential Species, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• BarrierCorrectionTypeCode (type: esriFieldTypeSmallInteger, alias: Barrier Correction Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: Tidegate removed], [1: Culvert removed crossing abandoned], [2: Culvert replaced with bridge], ... 6 more ...)
• BarrierCorrectionYearsText (type: esriFieldTypeString, alias: Barrier Correction Years, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CaseAreaFlag (type: esriFieldTypeSmallInteger, alias: CaseArea Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• FormLinkURL (type: esriFieldTypeString, alias: FormLinkURL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• WRIANumber (type: esriFieldTypeSmallInteger, alias: WRIA Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CountyName (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• IncorporatedCityName (type: esriFieldTypeString, alias: Incorporated City Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• HUC12Name (type: esriFieldTypeString, alias: HUC12 Name, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ProjectName (type: esriFieldTypeString, alias: ProjectName, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)

Templates:

Name: WDFW_FishPassageSite
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• SiteRecordID: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/8/2024 5:57:38 PM

Schema Last Edit Date: 5/8/2024 5:57:38 PM

Data Last Edit Date: 5/8/2024 5:55:50 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat