{ "currentVersion": 10.51, "id": 39, "name": "Salmon, Chinook (Lower Columbia River ESU)", "type": "Feature Layer", "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\".", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "copyrightText": "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.", "parentLayer": { "id": 37, "name": "Salmon, Chinook (Lower Columbia River ESU)" }, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "DPS_ID", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 167, 127, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 0 ], "width": 0.4 } }, "value": "CKLCR", "label": "ESU area", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 205, 170, 102, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 0 ], "width": 0.4 } }, "value": "CKLCR_Out", "label": "Outside ESU area", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.3883610217799999E7, "ymin": 5031215.1635000035, "xmax": -1.25789336898E7, "ymax": 6556933.022200003, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "DPS", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID_12", "type": "esriFieldTypeOID", "alias": "OBJECTID_12", "domain": null }, { "name": "hydrologic_Shape", "type": "esriFieldTypeGeometry", "alias": "hydrologic_Shape", "domain": null }, { "name": "link_FEATURE_ID", "type": "esriFieldTypeInteger", "alias": "FEATURE_ID", "domain": null }, { "name": "link_FEATURE_ACCESS", "type": "esriFieldTypeString", "alias": "FEATURE_ACCESS", "length": 255, "domain": { "type": "codedValue", "name": "Feature_Access", "codedValues": [ { "name": "Accessible", "code": "AC" }, { "name": "Trap and Haul", "code": "TH" }, { "name": "Artificial", "code": "AR" }, { "name": "Naturally Blocked", "code": "NB" }, { "name": "Anthropogenically Blocked", "code": "AB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "hydrologic_FEATURE_NOTES", "type": "esriFieldTypeString", "alias": "FEATURE_NOTES", "length": 500, "domain": null }, { "name": "hydrologic_HUC_12", "type": "esriFieldTypeString", "alias": "HUC_12", "length": 12, "domain": null }, { "name": "hydrologic_HU_12_Name", "type": "esriFieldTypeString", "alias": "HU_12_Name", "length": 120, "domain": null }, { "name": "hydrologic_HU_SPLIT", "type": "esriFieldTypeString", "alias": "HU_SPLIT", "length": 5, "domain": null }, { "name": "DPS_ID", "type": "esriFieldTypeString", "alias": "DPS_ID", "length": 10, "domain": null }, { "name": "DPS", "type": "esriFieldTypeString", "alias": "DPS", "length": 100, "domain": null }, { "name": "link_DPS_NOTES", "type": "esriFieldTypeString", "alias": "DPS_NOTES", "length": 255, "domain": null }, { "name": "MIDLEVEL_GROUP", "type": "esriFieldTypeString", "alias": "GROUP", "length": 100, "domain": { "type": "codedValue", "name": "MidLevel Group", "codedValues": [ { "name": "Strait of Georgia", "code": "700" }, { "name": "Strait of Juan de Fuca", "code": "701" }, { "name": "Hood Canal", "code": "702" }, { "name": "Whidbey Basin", "code": "703" }, { "name": "Central/South Sound", "code": "704" }, { "name": "North Coast", "code": "705" }, { "name": "Mid-Coast", "code": "706" }, { "name": "Lakes", "code": "707" }, { "name": "Umpqua", "code": "708" }, { "name": "Mid-South Coast", "code": "709" }, { "name": "Kettle/Colville", "code": "711" }, { "name": "Spokane", "code": "712" }, { "name": "Northern Cascades", "code": "713" }, { "name": "Central and South Puget Sound", "code": "714" }, { "name": "Hood Canal and Strait of Juan de Fuca", "code": "715" }, { "name": "Cascades Eastern Slope Tributaries", "code": "716" }, { "name": "Hells Canyon", "code": "725" }, { "name": "Payette/Boise", "code": "726" }, { "name": "Malheur/Owyhee", "code": "727" }, { "name": "Bruneau and Salmon Falls", "code": "728" }, { "name": "John Day", "code": "717" }, { "name": "Walla Walla and Umatilla", "code": "718" }, { "name": "Yakima", "code": "719" }, { "name": "Lower Snake", "code": "720" }, { "name": "Clearwater", "code": "721" }, { "name": "Grande Ronde", "code": "722" }, { "name": "Salmon", "code": "723" }, { "name": "Imnaha", "code": "724" }, { "name": "Dry Clearwater", "code": "729" }, { "name": "Wet Clearwater", "code": "730" }, { "name": "Grande Ronde/Imnaha", "code": "731" }, { "name": "South Fork Salmon", "code": "732" }, { "name": "Middle Fork Salmon", "code": "733" }, { "name": "Upper Salmon", "code": "734" }, { "name": "Middle Snake", "code": "735" }, { "name": "Malheur", "code": "736" }, { "name": "Owyhee", "code": "737" }, { "name": "Upper Snake", "code": "738" }, { "name": "Coast", "code": "739" }, { "name": "Cascade", "code": "740" }, { "name": "Gorge", "code": "741" }, { "name": "Cascade spring", "code": "742" }, { "name": "Gorge spring", "code": "743" }, { "name": "Coast fall", "code": "744" }, { "name": "Cascade fall", "code": "745" }, { "name": "Gorge fall", "code": "746" }, { "name": "Cascade late fall", "code": "747" }, { "name": "Cascade summer", "code": "748" }, { "name": "Cascade winter", "code": "749" }, { "name": "Gorge summer", "code": "750" }, { "name": "Gorge winter", "code": "751" }, { "name": "North Cascades", "code": "710" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WCR_POP_ID", "type": "esriFieldTypeString", "alias": "WCR_POP_ID", "length": 255, "domain": null }, { "name": "POPULATION", "type": "esriFieldTypeString", "alias": "POPULATION", "length": 255, "domain": null }, { "name": "RUN_TIMING", "type": "esriFieldTypeString", "alias": "RUN_TIMING", "length": 255, "domain": { "type": "codedValue", "name": "Run Timing", "codedValues": [ { "name": "winter", "code": "wi" }, { "name": "spring", "code": "sp" }, { "name": "spring/summer", "code": "ss" }, { "name": "summer", "code": "su" }, { "name": "summer and winter", "code": "sw" }, { "name": "fall", "code": "fa" }, { "name": "late fall", "code": "lf" }, { "name": "early", "code": "er" }, { "name": "late", "code": "lt" }, { "name": "early and late", "code": "el" }, { "name": "unknown", "code": "xx" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 255, "domain": { "type": "codedValue", "name": "Type", "codedValues": [ { "name": "Independent", "code": "IN" }, { "name": "Functionally Independent", "code": "FI" }, { "name": "Potentially Independent", "code": "PI" }, { "name": "Dependent", "code": "DP" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 255, "domain": { "type": "codedValue", "name": "Status", "codedValues": [ { "name": "Extant", "code": "EX" }, { "name": "Extirpated", "code": "ET" }, { "name": "Functionally Extirpated", "code": "FE" }, { "name": "Reintroduced", "code": "RE" }, { "name": "Reintroduced - 10(j) Designation", "code": "RJ" }, { "name": "Recolonized", "code": "RC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "link_POP_NOTES", "type": "esriFieldTypeString", "alias": "POP_NOTES", "length": 255, "domain": null }, { "name": "NWFSC_POP_ID", "type": "esriFieldTypeInteger", "alias": "NWFSC_POP_ID", "domain": null }, { "name": "TRT", "type": "esriFieldTypeString", "alias": "TRT", "length": 100, "domain": { "type": "codedValue", "name": "TRT", "codedValues": [ { "name": "Willamette-Lower Columbia Technical Recovery Team", "code": "WLC TRT" }, { "name": "Puget Sound Technical Recovery Team", "code": "PS TRT" }, { "name": "Puget Sound Steelhead Technical Recovery Team", "code": "PSS TRT" }, { "name": "Interior Columbia Technical Recovery Team", "code": "IC TRT" }, { "name": "Oregon and Northern California Coast Technical Recovery Team", "code": "ONCC TRT" }, { "name": "North-Central California Coast Technical Recovery Team", "code": "NCCC TRT" }, { "name": "Central Valley Technical Recovery Team", "code": "CV TRT" }, { "name": "South-Central and Southern California Coast Technical Recovery Team", "code": "SCSCC TRT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TRT_POP_ID", "type": "esriFieldTypeString", "alias": "TRT_POP_ID", "length": 255, "domain": null }, { "name": "LISTING_STATUS", "type": "esriFieldTypeString", "alias": "LISTING_STATUS", "length": 50, "domain": { "type": "codedValue", "name": "Listing Status", "codedValues": [ { "name": "Endangered", "code": "E" }, { "name": "Threatened", "code": "T" }, { "name": "Species of Concern", "code": "S" }, { "name": "Not Warranted", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SPECIES", "type": "esriFieldTypeString", "alias": "SPECIES", "length": 50, "domain": { "type": "codedValue", "name": "Species", "codedValues": [ { "name": "Oncorhynchus tshawytscha", "code": "CK" }, { "name": "Oncorhynchus nerka", "code": "SO" }, { "name": "Oncorhynchus kisutch", "code": "CO" }, { "name": "Oncorhynchus keta", "code": "CM" }, { "name": "Oncorhynchus mykiss", "code": "ST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FRN", "type": "esriFieldTypeString", "alias": "FRN", "length": 40, "domain": null } ], "indexes": [ { "name": "FDO_hydrologic_Shape", "fields": "hydrologic_Shape", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "supportsDatumTransformation": true }