Name: Culverts: fish passage barriers

Display Field: CLVT_FISH_PASS_GUID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The fish passage culverts layer stores locations and describes physical properties of these culverts on DNR roads in Washington State. Additionally, information is provide if the culvert has anadromous or resident fish presence. Fish barrier information is also provided. The culvert injunction status is also identified.Inspection of these culverts are entered into the fish passage inspection (ROPA.CULVERT_FISH_PASS_INSPEC) table.This layer is used for forest roads management supporting the following: - Culvert Infrastructure Planning and Maintenance - FP and RMAP Compliance Reporting - Road Maps - Forest Management - Timber Sales - Analysis for decision makers - Long-term documentation.

Service Item Id: 40fa20da40264315bb492c0152a4532b

Copyright Text: Washington State Department of Natural Resources (WADNR)

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1278260.9948076352
YMin: 768341.1154811436
XMax: 1364907.4092111636
YMax: 988135.7426074847
Spatial Reference: PROJCS["North_American_1983_Lambert_Conformal_Conic",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["false_easting",1640416.666666667],PARAMETER["false_northing",0.0],PARAMETER["central_meridian",-120.5],PARAMETER["standard_parallel_1",45.83333333333334],PARAMETER["standard_parallel_2",47.33333333333334],PARAMETER["latitude_of_origin",45.33333333333334],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CLVT_FISH_PASS_GUID ( type: esriFieldTypeString, alias: Culvert Guid, length: 38 )
• CLVT_NM ( type: esriFieldTypeString, alias: Culvert Name, length: 30 )
• CLVT_LOCATION_ID ( type: esriFieldTypeString, alias: Culvert Location ID, length: 12 )
• GIS_LONG_DD ( type: esriFieldTypeDouble, alias: Longitude )
• GIS_LAT_DD ( type: esriFieldTypeDouble, alias: Latitude )
• REGION_CD ( type: esriFieldTypeSmallInteger, alias: DNR Region , Coded Values: [100: Southeast Region] , [200: Olympic Region] , [400: Pacific Cascade Region] , ...4 more... )
• CLVT_SHAPE_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Shape , Coded Values: [10: 10: Round] , [20: 20: Box] , [30: 30: Pipe Arch] , ...5 more... )
• CLVT_MATERIAL_COAT_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Material and Coating , Coded Values: [10: 10: CMP - Corrugated Metal Pipe] , [11: 11: CMP - Corrugated Metal Pipe/Galvanized] , [12: 12: CMP - Corrugated Metal Pipe/Aluminized] , ...13 more... )
• CLVT_HEADWALL_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Headwall , Coded Values: [0: 0: None] , [10: 10: Rock] , [20: 20: Rock and Grout] , ...4 more... )
• CLVT_ATTACHMENT_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Attachment , Coded Values: [0: 0: None] , [10: 10: Round Downspout] , [20: 20: Half-Round Downspout] , ...7 more... )
• CLVT_SPAN ( type: esriFieldTypeSingle, alias: Culvert Span (ft) )
• CLVT_RISE ( type: esriFieldTypeSingle, alias: Culvert Rise (ft) )
• CLVT_LNG ( type: esriFieldTypeSingle, alias: Culvert Length (ft) )
• CLVT_GRD ( type: esriFieldTypeSingle, alias: Culvert Gradient (%) )
• CLVT_FILL_DPT ( type: esriFieldTypeSingle, alias: Culvert Fill Depth (ft) )
• CLVT_STREAMBED_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Streambed , Coded Values: [10: 10: No Bed Material in Culvert] , [20: 20: Bed Material Throughout Culvert Length] , [30: 30: Partial Bed Material in Culvert] , ...1 more... )
• CLVT_STORM_MONTITOR_FLG ( type: esriFieldTypeString, alias: Culvert Storm Monitor, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• CLVT_INSTALL_DT ( type: esriFieldTypeDate, alias: Culvert Install Date, length: 8 )
• CLVT_REPLACE_DT ( type: esriFieldTypeDate, alias: Culvert Replace Date, length: 8 )
• CLVT_PERMIT_NO ( type: esriFieldTypeString, alias: Culvert Permit Number, length: 15 )
• CLVT_ANADROMOUS_FLG ( type: esriFieldTypeString, alias: Anadromous Fish, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• CLVT_RESIDENT_FLG ( type: esriFieldTypeString, alias: Resident Fish, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• CLVT_CHANNEL_WD ( type: esriFieldTypeSingle, alias: Culvert Channel Width (ft) )
• CLVT_CHANNEL_DPT ( type: esriFieldTypeSingle, alias: Culvert Channel Depth (ft) )
• CLVT_SURVEY_DT ( type: esriFieldTypeDate, alias: Culvert Survey Date, length: 8 )
• CLVT_SURVEY_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Survey , Coded Values: [10: 10: Physical] , [20: 20: Biological] , [30: 30: Mapped] , ...4 more... )
• CLVT_OBSERVER_NM ( type: esriFieldTypeString, alias: Culvert Inspector Name, length: 20 )
• CLVT_BARRIER_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Barrier , Coded Values: [10: 10: Passable] , [20: 20: Mitigated] , [30: 30: Barrier] , ...6 more... )
• CLVT_PROBLEM_CD ( type: esriFieldTypeSmallInteger, alias: Culvert Barrier Problem , Coded Values: [10: 10: Hydraulic Drop] , [20: 20: Velocity] , [40: 40: Low Flow Depth] , ...6 more... )
• STRUCTURE_CONDITION_CD ( type: esriFieldTypeSmallInteger, alias: Structure Condition , Coded Values: [10: 10: Satisfactory (Bridges: DOT Rating 6-9)] , [20: 20: Unsatisfactory (Bridges: DOT Rating 4-5)] , [30: 30: Critical (Bridges: DOT Rating 0-3)] , ...1 more... )
• INJUNCTION_FLG ( type: esriFieldTypeString, alias: Injunction, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• CLVT_NOTE ( type: esriFieldTypeString, alias: Culvert Note, length: 999 )
• ROAD_CONTROL_CD ( type: esriFieldTypeSmallInteger, alias: Road Control , Coded Values: [10: 10: WA DNR - Department of Natural Resources] , [11: 11: WA DOT - Department of Transportation] , [12: 12: WA DFW - Department of Fish and Wildlife] , ...12 more... )
• ROAD_PROGRAM_CD ( type: esriFieldTypeSmallInteger, alias: Road Program , Coded Values: [1: 1: Forest Road] , [2: 2: Recreation Road] , [3: 3: NAP/NRCA Road] , ...6 more... )
• SYMBL_ROTATION ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation Angle )
• EDIT_NM ( type: esriFieldTypeString, alias: Editor Name, length: 25 )
• EDIT_DT ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata