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.