View In:
ArcGIS Online Map Viewer
Name: fish_web_dice_vertices1000
Display Field: hydrologic_hu_12_name
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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.</SPAN></P><P><SPAN>There are 5 objects stored in this geodatabase:</SPAN></P><P><SPAN STYLE="font-weight:bold;">hydrologic (feature class)</SPAN></P><P><SPAN STYLE="font-weight:bold;">link (table)</SPAN></P><P><SPAN STYLE="font-weight:bold;">DPS (table)</SPAN></P><P><SPAN STYLE="font-weight:bold;">population (table)</SPAN></P><P><SPAN STYLE="font-weight:bold;">fish (feature class)</SPAN></P><P><SPAN>The </SPAN><SPAN STYLE="font-weight:bold;">hydrologic feature class </SPAN><SPAN>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.</SPAN></P><P><SPAN>The </SPAN><SPAN STYLE="font-weight:bold;">link table </SPAN><SPAN>contains the relationships between spatial and tabular data.</SPAN></P><P><SPAN>The </SPAN><SPAN STYLE="font-weight:bold;">DPS table </SPAN><SPAN>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.</SPAN></P><P><SPAN>The </SPAN><SPAN STYLE="font-weight:bold;">population table </SPAN><SPAN>contains fish units smaller than the steelhead DPSs and salmon ESUs. </SPAN></P><P><SPAN>The </SPAN><SPAN STYLE="font-weight:bold;">fish feature class </SPAN><SPAN>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.</SPAN></P><P><SPAN>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".</SPAN></P></DIV></DIV></DIV>
Service Item Id: b3077f8e48cf4b9e804becea2a8f3cf6
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: 0
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
XMin: -1.3883610217799999E7
YMin: 5260893.309799999
XMax: -1.25789336898E7
YMax: 6376144.7434
Spatial Reference: 102100
(3857)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSFSSolid
Color: [179, 246, 252, 0]
Outline:
Style: esriSLSSolid
Color: [52, 52, 52, 255]
Width: 1
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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
objectid_12
(
nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID_12
)
-
hydrologic_hu_area_sqkm
(
modelName: Area_SqKm, nullable: true, editable: true, defaultValue: null, alias: HU_Area_SqKm, type: esriFieldTypeDouble
)
-
hydrologic_hu_states
(
modelName: States, nullable: true, editable: true, defaultValue: null, length: 50, alias: HU_States, type: esriFieldTypeString
)
-
hydrologic_hu_loaddate
(
modelName: LoadDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: HU_LoadDate, type: esriFieldTypeDate
)
-
hydrologic_huc_12
(
modelName: HUC_12, nullable: true, editable: true, defaultValue: null, length: 12, alias: HUC_12, type: esriFieldTypeString
)
-
hydrologic_hu_12_name
(
modelName: HU_12_Name, nullable: true, editable: true, defaultValue: null, length: 120, alias: HU_12_Name, type: esriFieldTypeString
)
-
hydrologic_hu_12_type
(
modelName: HU_12_Type, nullable: true, editable: true, defaultValue: null, length: 254, alias: HU_12_Type, type: esriFieldTypeString
)
-
hydrologic_hu_12_mod
(
modelName: HU_12_Mod, nullable: true, editable: true, defaultValue: null, length: 50, alias: HU_12_Mod, type: esriFieldTypeString
)
-
hydrologic_c_gnis_name
(
modelName: GNIS_NAME_, nullable: true, editable: true, defaultValue: null, length: 80, alias: C_GNIS_NAME, type: esriFieldTypeString
)
-
hydrologic_c_fwa_id
(
modelName: FWA_WATERS, nullable: true, editable: true, defaultValue: null, length: 143, alias: C_FWA_ID, type: esriFieldTypeString
)
-
hydrologic_c_local_id
(
modelName: LOCAL_WATE, nullable: true, editable: true, defaultValue: null, length: 143, alias: C_LOCAL_ID, type: esriFieldTypeString
)
-
hydrologic_c_area_ha
(
modelName: AREA_HA, nullable: true, editable: true, defaultValue: null, alias: C_AREA_HA, type: esriFieldTypeDouble
)
-
hydrologic_hu_split
(
modelName: HU_SPLIT, nullable: true, editable: true, defaultValue: null, length: 5, alias: HU_SPLIT, type: esriFieldTypeString
)
-
hydrologic_feature_id
(
modelName: Feature_ID_v3, nullable: true, editable: true, defaultValue: null, alias: FEATURE_ID, type: esriFieldTypeInteger
)
-
hydrologic_feature_notes
(
modelName: FEATURE_NOTES, nullable: true, editable: true, defaultValue: null, length: 500, alias: hydrologic_FEATURE_NOTES, type: esriFieldTypeString
)
-
link_objectid
(
modelName: OBJECTID, nullable: true, editable: true, defaultValue: null, alias: link_OBJECTID, type: esriFieldTypeInteger
)
-
link_feature_id
(
modelName: FEATURE_ID, nullable: true, editable: true, defaultValue: null, alias: FEATURE_ID, type: esriFieldTypeInteger
)
-
link_wcr_pop_id
(
modelName: WCR_POP_ID, nullable: true, editable: true, defaultValue: null, length: 255, alias: WCR_POP_ID, type: esriFieldTypeString
)
-
link_feature_access
(
modelName: FEATURE_ACCESS, nullable: true, editable: true, defaultValue: null, length: 255, alias: FEATURE_ACCESS, type: esriFieldTypeString
, Coded Values:
[AC: Accessible]
, [TH: Trap and Haul]
, [AR: Artificial]
, ...2 more...
)
-
link_pop_notes
(
modelName: POP_NOTES, nullable: true, editable: true, defaultValue: null, length: 255, alias: POP_NOTES, type: esriFieldTypeString
)
-
link_dps_id
(
modelName: DPS_ID, nullable: true, editable: true, defaultValue: null, length: 255, alias: DPS_ID, type: esriFieldTypeString
)
-
link_dps_notes
(
modelName: DPS_NOTES, nullable: true, editable: true, defaultValue: null, length: 255, alias: DPS_NOTES, type: esriFieldTypeString
)
-
objectid
(
modelName: OBJECTID, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger
)
-
dps
(
modelName: ESU_DPS, nullable: true, editable: true, defaultValue: null, length: 100, alias: DPS, type: esriFieldTypeString
)
-
dps_id
(
modelName: ESU_DPS_CODE, nullable: true, editable: true, defaultValue: null, length: 10, alias: DPS_ID, type: esriFieldTypeString
)
-
frn
(
modelName: FRN, nullable: true, editable: true, defaultValue: null, length: 40, alias: FRN, type: esriFieldTypeString
)
-
listing_description
(
modelName: LISTING_DESCRIPTION, nullable: true, editable: true, defaultValue: null, length: 2000, alias: LISTING_DESCRIPTION, type: esriFieldTypeString
)
-
listing_status
(
modelName: LISTING_STATUS, nullable: true, editable: true, defaultValue: null, length: 50, alias: LISTING_STATUS, type: esriFieldTypeString
, Coded Values:
[E: Endangered]
, [T: Threatened]
, [S: Species of Concern]
, ...1 more...
)
-
species
(
modelName: SPECIES, nullable: true, editable: true, defaultValue: null, length: 50, alias: SPECIES, type: esriFieldTypeString
, Coded Values:
[CK: Oncorhynchus tshawytscha]
, [SO: Oncorhynchus nerka]
, [CO: Oncorhynchus kisutch]
, ...2 more...
)
-
trt
(
modelName: TRT, nullable: true, editable: true, defaultValue: null, length: 100, alias: TRT, type: esriFieldTypeString
, 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...
)
-
objectid_1
(
modelName: OBJECTID, nullable: true, editable: true, defaultValue: null, alias: OBJECTID_1, type: esriFieldTypeInteger
)
-
wcr_pop_id
(
modelName: WCR_POP_ID, nullable: true, editable: true, defaultValue: null, length: 255, alias: WCR_POP_ID, type: esriFieldTypeString
)
-
trt_pop_id
(
modelName: TRT_POP_ID, nullable: true, editable: true, defaultValue: null, length: 255, alias: TRT_POP_ID, type: esriFieldTypeString
)
-
nwfsc_pop_id
(
modelName: NWFSC_POP_ID, nullable: true, editable: true, defaultValue: null, alias: NWFSC_POP_ID, type: esriFieldTypeInteger
)
-
population
(
modelName: POPULATION, nullable: true, editable: true, defaultValue: null, length: 255, alias: POPULATION, type: esriFieldTypeString
)
-
type
(
modelName: TYPE, nullable: true, editable: true, defaultValue: null, length: 255, alias: TYPE, type: esriFieldTypeString
, Coded Values:
[IN: Independent]
, [FI: Functionally Independent]
, [PI: Potentially Independent]
, ...2 more...
)
-
status
(
modelName: STATUS, nullable: true, editable: true, defaultValue: null, length: 255, alias: STATUS, type: esriFieldTypeString
, Coded Values:
[EX: Extant]
, [ET: Extirpated]
, [FE: Functionally Extirpated]
, ...3 more...
)
-
run_timing
(
modelName: RUN_TIMING, nullable: true, editable: true, defaultValue: null, length: 255, alias: RUN_TIMING, type: esriFieldTypeString
, Coded Values:
[wi: winter]
, [sp: spring]
, [ss: spring/summer]
, ...8 more...
)
-
extinction_risk
(
modelName: EXTINCTION_RISK, nullable: true, editable: true, defaultValue: null, length: 255, alias: EXTINCTION_RISK, type: esriFieldTypeString
, Coded Values:
[HR: High Risk]
, [MR: Moderate Risk]
, [LR: Low Risk]
, ...4 more...
)
-
midlevel_group
(
modelName: MIDLEVEL_GROUP, nullable: true, editable: true, defaultValue: null, length: 100, alias: MIDLEVEL_GROUP, type: esriFieldTypeString
, Coded Values:
[700: Strait of Georgia]
, [701: Strait of Juan de Fuca]
, [702: Hood Canal]
, ...49 more...
)
-
SHAPE__Length
(
virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble
)
-
SHAPE__Area
(
virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble
)
Templates:
-
Name: fish_web_dice_vertices1000
Description:
Prototype:
hydrologic_c_gnis_name: null
listing_description: null
hydrologic_c_fwa_id: null
link_dps_id: null
type: null
hydrologic_c_area_ha: null
hydrologic_hu_12_type: null
link_feature_id: null
link_wcr_pop_id: null
listing_status: null
extinction_risk: null
trt_pop_id: null
link_objectid: null
hydrologic_hu_12_mod: null
hydrologic_c_local_id: null
link_dps_notes: null
link_feature_access: null
frn: null
nwfsc_pop_id: null
dps: null
run_timing: null
link_pop_notes: null
hydrologic_hu_loaddate: null
hydrologic_huc_12: null
hydrologic_hu_12_name: null
objectid_1: null
hydrologic_feature_notes: null
population: null
hydrologic_hu_split: null
hydrologic_hu_area_sqkm: null
species: null
dps_id: null
trt: null
midlevel_group: null
wcr_pop_id: null
hydrologic_hu_states: null
objectid: null
hydrologic_feature_id: null
status: null
Drawing Tool: esriFeatureEditToolPolygon
Capabilities: Query
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Supports ApplyEdits By Upload Id: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata