Name: fish Populations - Steelhead

Display Field: hydrologic_HU_12_Name

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".

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: false

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: -1.38836102493E7
YMin: 5702167.272
XMax: -1.29970322914E7
YMax: 6298189.4978
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LISTING_STATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: E
  Label: E
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [255, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 1
• Value: T
  Label: T
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [230, 230, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 168, 0, 255]
  Width: 0
• Value:
  Label:
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [158, 215, 194, 255]
  Outline:
  Style: esriSLSSolid
  Color: [68, 137, 112, 255]
  Width: 0
Transparency: 50
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

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 )
• SaSIStockID ( type: esriFieldTypeSmallInteger, alias: SaSI ID )
• NWFSC_POP_ID ( type: esriFieldTypeInteger, alias: NWFSC Population ID )
• DPS ( type: esriFieldTypeString, alias: DPS or ESU Name, length: 100 )
• SpeciesText ( type: esriFieldTypeString, alias: Species Text, length: 25 )
• RUN_TIMING ( type: esriFieldTypeString, alias: Population Run Time, length: 255 )
• DPS_ID ( type: esriFieldTypeString, alias: DPS or ESU ID, length: 10 )
• SPECIES ( type: esriFieldTypeString, alias: Species Name, length: 50 )
• WCR_POP_ID ( type: esriFieldTypeString, alias: WCR Population ID, length: 255 )
• hydrologic_HU_12_Name ( type: esriFieldTypeString, alias: HUC12 Name, length: 120 )
• hydrologic_FEATURE_NOTES ( type: esriFieldTypeString, alias: Feature Notes, length: 500 )
• link_FEATURE_ACCESS ( type: esriFieldTypeString, alias: Fish Accessibility, length: 255 )
• link_POP_NOTES ( type: esriFieldTypeString, alias: Population Notes, length: 255 )
• link_DPS_NOTES ( type: esriFieldTypeString, alias: DPS Notes, length: 255 )
• FRN ( type: esriFieldTypeString, alias: Fed Reg Notice, length: 40 )
• LISTING_DESCRIPTION ( type: esriFieldTypeString, alias: Listing Description, length: 2000 )
• LISTING_STATUS ( type: esriFieldTypeString, alias: Listing Status, length: 50 )
• TRT ( type: esriFieldTypeString, alias: TRT Name, length: 100 )
• TRT_POP_ID ( type: esriFieldTypeString, alias: TRT Population ID, length: 255 )
• POPULATION ( type: esriFieldTypeString, alias: Population Name, length: 255 )
• TYPE ( type: esriFieldTypeString, alias: TRT Population Type, length: 255 )
• STATUS ( type: esriFieldTypeString, alias: WCR Status, length: 255 )
• EXTINCTION_RISK ( type: esriFieldTypeString, alias: Extinction Risk, length: 255 )
• MIDLEVEL_GROUP ( type: esriFieldTypeString, alias: Population Group Name, length: 100 )

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

  Iteminfo   Thumbnail   Metadata