Parent Layer: Steelhead (Puget Sound DPS)

Name: Steelhead (Puget Sound DPS) - populations

Display Field: POPULATION

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: The base geospatial information is the Watershed Boundary Dataset (WBD), which was queried by two 2-digit "regions" HU 17 (Pacific Northwest) and HU 18 (California), and downloaded in June 2012. The WBD HU 17 "region" included transboundary hydrologic data, or HUs that cross the U.S.-Canadian border. The WBD data were merged with "Assessment Watersheds" for the Slocan River drainage in British Columbia, north of the transboundary HUs, to represent areas historically occupied by fish.There are 5 objects stored in this geodatabase:hydrologic (feature class)link (table)DPS (table)population (table)fish (feature class)The hydrologic feature class is the base geospatial data from the Watershed Boundary Dataset and British Columbia Assessment Watersheds. Some of the hydrologic polygon features have been split to better represent fish populations. No overlapping polygons.The link table contains the relationships between spatial and tabular data.The DPS table contains information on Distinct Population Segments, which are the listed entities under the Endangered Species Act. A DPS can be further refined to an entity called an Evolutionarily Significant Unit (ESU) for salmon. An ESU can also be a listed entity under the Endangered Species Act. For purposes of this database, DPSs and ESUs are included in this single table.The population table contains fish units smaller than the steelhead DPSs and salmon ESUs. The fish feature class is the end product to be used for visualisation of fish data. It was generated in 4 steps. Step 1: used the Make Query Table tool (ArcToolbox 10.2.2 -> Data Management Tools -> Layers and Table Views -> Make Query Table) to combine the hydrologic feature class with the link table (query is based on unique FEATURE_ID). Step 2: joined the DPS table (join is based on unique DPS_ID). Step 3: joined the population table (join is based on unique WCR_POP_ID). Step 4: exported the result to make a permanent fish feature class in the geodatabase because joins are temporary. The fish feature class has overlapping polygons for species located in the same geographic areas and for species with multiple run timings.Coded value domains are utilized in this geodataase for numerous fields. In order to export any geodatabase tables with the values (not the codes), use the Table to Excel tool (ArcToolbox 10.2.2 -> Conversion Tools -> Excel -> Table to Excel). In the tool options, check the box for "Use domain and subtype description".

Service Item Id: 9359d044da434b34b564f7d581130edf

Copyright Text: Geodatabase version 1.0 was designed and populated by Shanna Dunn, completed December 2015. The information reviewed during the data assessment and used to compile this geodatabase came from a variety of sources. Credits go to the participants of Biological Review Teams and Technical Recovery Teams, recovery planning teams, staff from the West Coast Region, Northwest Fisheries Science Center, and Southwest Fisheries Science Center, external partners, and especially the states and tribes for collecting groundtruthed fish distribution data. The StreamNet 2012 data was used extensively during processing. Credit also goes to the United States Geological Survey and the Natural Resources Conservation Service for producing and maintaining the Watershed Boundary Dataset and National Hydrography Dataset, which together make it possible to consistently map fish geography.

Default Visibility: true

MaxRecordCount: 1000000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -1.3883610217799999E7
YMin: 5031215.1635000035
XMax: -1.25789336898E7
YMax: 6556933.022200003
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: WCR_POP_ID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: STPUGwiDHT
  Label: Drayton Harbor Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 38, 115, 255]
  Outline:
  N/A
• Value: STPUGwiNKS
  Label: Nooksack River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 77, 168, 255]
  Outline:
  N/A
• Value: STPUGwiSBT
  Label: Samish River and Bellingham Bay Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 92, 230, 255]
  Outline:
  N/A
• Value: STPUGsuSFN
  Label: South Fork Nooksack River (summer)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 169, 230, 255]
  Outline:
  N/A
• Value: STPUGswBKR
  Label: Baker River (summer and winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 178, 255, 255]
  Outline:
  N/A
• Value: STPUGswSKG
  Label: Skagit River (summer and winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [102, 153, 205, 255]
  Outline:
  N/A
• Value: STPUGwiNKC
  Label: Nookachamps Creek (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [190, 210, 255, 255]
  Outline:
  N/A
• Value: STPUGsuDER
  Label: Deer Creek (summer)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [190, 255, 232, 255]
  Outline:
  N/A
• Value: STPUGwiSTL
  Label: Stillaguamish River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 255, 223, 255]
  Outline:
  N/A
• Value: STPUGsuCAN
  Label: Canyon Creek (summer)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [163, 255, 115, 255]
  Outline:
  N/A
• Value: STPUGswSAK
  Label: Sauk River (summer and winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [122, 245, 202, 255]
  Outline:
  N/A
• Value: STPUGwiPLC
  Label: Pilchuck River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 230, 169, 255]
  Outline:
  N/A
• Value: STPUGwiSKY
  Label: Snohomish/Skykomish Rivers (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [102, 205, 171, 255]
  Outline:
  N/A
• Value: STPUGsuNSY
  Label: North Fork Skykomish River (summer)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [137, 205, 102, 255]
  Outline:
  N/A
• Value: STPUGsuTLT
  Label: Tolt River (summer)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [68, 137, 112, 255]
  Outline:
  N/A
• Value: STPUGwiSNQ
  Label: Snoqualmie River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 115, 76, 255]
  Outline:
  N/A
• Value: STPUGwiNLW
  Label: North Lake Washington and Lake Sammamish (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 76, 0, 255]
  Outline:
  N/A
• Value: STPUGwiCDR
  Label: Cedar River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [168, 112, 0, 255]
  Outline:
  N/A
• Value: STPUGwiGRN
  Label: Green River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [230, 152, 0, 255]
  Outline:
  N/A
• Value: STPUGwiWHT
  Label: White River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [214, 189, 0, 255]
  Outline:
  N/A
• Value: STPUGwiPUY
  Label: Puyallup River/Carbon River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [205, 170, 102, 255]
  Outline:
  N/A
• Value: STPUGwiNSQ
  Label: Nisqually River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 211, 127, 255]
  Outline:
  N/A
• Value: STPUGwiSSD
  Label: South Puget Sound Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 215, 158, 255]
  Outline:
  N/A
• Value: STPUGwiEKP
  Label: East Kitsap Peninsula Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 235, 190, 255]
  Outline:
  N/A
• Value: STPUGwiSHC
  Label: South Hood Canal Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [135, 0, 32, 255]
  Outline:
  N/A
• Value: STPUGwiEHC
  Label: East Hood Canal Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [137, 68, 101, 255]
  Outline:
  N/A
• Value: STPUGwiSKO
  Label: Skokomish River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [168, 0, 132, 255]
  Outline:
  N/A
• Value: STPUGwiWHC
  Label: West Hood Canal Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [205, 102, 153, 255]
  Outline:
  N/A
• Value: STPUGwiSDT
  Label: Sequim/Discovery Bays Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [205, 102, 102, 255]
  Outline:
  N/A
• Value: STPUGswDNG
  Label: Dungeness River (summer and winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [245, 162, 122, 255]
  Outline:
  N/A
• Value: STPUGwiSJF
  Label: Strait of Juan de Fuca Tributaries (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [245, 122, 182, 255]
  Outline:
  N/A
• Value: STPUGwiELW
  Label: Elwha River (winter)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 190, 232, 255]
  Outline:
  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_12 ( type: esriFieldTypeOID, alias: OBJECTID_12 )
• hydrologic_Shape ( type: esriFieldTypeGeometry, alias: hydrologic_Shape )
• link_FEATURE_ID ( type: esriFieldTypeInteger, alias: FEATURE_ID )
• link_FEATURE_ACCESS ( type: esriFieldTypeString, alias: FEATURE_ACCESS, length: 255 , Coded Values: [AC: Accessible] , [TH: Trap and Haul] , [AR: Artificial] , ...2 more... )
• hydrologic_FEATURE_NOTES ( type: esriFieldTypeString, alias: FEATURE_NOTES, length: 500 )
• hydrologic_HUC_12 ( type: esriFieldTypeString, alias: HUC_12, length: 12 )
• hydrologic_HU_12_Name ( type: esriFieldTypeString, alias: HU_12_Name, length: 120 )
• hydrologic_HU_SPLIT ( type: esriFieldTypeString, alias: HU_SPLIT, length: 5 )
• DPS_ID ( type: esriFieldTypeString, alias: DPS_ID, length: 10 )
• DPS ( type: esriFieldTypeString, alias: DPS, length: 100 )
• link_DPS_NOTES ( type: esriFieldTypeString, alias: DPS_NOTES, length: 255 )
• MIDLEVEL_GROUP ( type: esriFieldTypeString, alias: GROUP, length: 100 , Coded Values: [700: Strait of Georgia] , [701: Strait of Juan de Fuca] , [702: Hood Canal] , ...49 more... )
• WCR_POP_ID ( type: esriFieldTypeString, alias: WCR_POP_ID, length: 255 )
• POPULATION ( type: esriFieldTypeString, alias: POPULATION, length: 255 )
• RUN_TIMING ( type: esriFieldTypeString, alias: RUN_TIMING, length: 255 , Coded Values: [wi: winter] , [sp: spring] , [ss: spring/summer] , ...8 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 , Coded Values: [IN: Independent] , [FI: Functionally Independent] , [PI: Potentially Independent] , ...2 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 255 , Coded Values: [EX: Extant] , [ET: Extirpated] , [FE: Functionally Extirpated] , ...3 more... )
• link_POP_NOTES ( type: esriFieldTypeString, alias: POP_NOTES, length: 255 )
• NWFSC_POP_ID ( type: esriFieldTypeInteger, alias: NWFSC_POP_ID )
• TRT ( type: esriFieldTypeString, alias: TRT, length: 100 , Coded Values: [WLC TRT: Willamette-Lower Columbia Technical Recovery Team] , [PS TRT: Puget Sound Technical Recovery Team] , [PSS TRT: Puget Sound Steelhead Technical Recovery Team] , ...5 more... )
• TRT_POP_ID ( type: esriFieldTypeString, alias: TRT_POP_ID, length: 255 )

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

  Iteminfo   Thumbnail   Metadata