Impaired Fish Passage
<DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:7 0 7 0;"><SPAN STYLE="font-size:12pt">Applied definition query to Database Connections\r10_tnf_default_as_myself.sde\S_R10_TNF.WaterXing\S_R10_TNF.WaterXing. Query: PASSAGE= (Red OR Red_fx OR Red_inc) </SPAN></P><P STYLE="margin:7 0 7 0;"><SPAN STYLE="font-size:12pt">This data is frozen as of Feb 1 2023 for project record T:\FS\NFS\Tongass\Program\1900Planning\GIS\SO\2022_SASS_FM\MapProducts\SASSFM2022108\SASSFM2022108.gdb\RedPipes </SPAN></P><P STYLE="margin:7 0 7 0;"><SPAN STYLE="font-size:12pt">Opportunities are outputs from data analysis that show potential restoration activities. Opportunities are not a proposed action or implementation feature but can be used as starting off point for planning. Opportunities should be validated by program subject matter experts and/or by ground truthing. </SPAN></P><P STYLE="margin:7 0 7 0;"><SPAN STYLE="font-size:12pt">Tom Heutte 20230201 Metadata for corporate source layer follows.</SPAN></P><P><SPAN>This data represents information collected for water crossings on the Tongass NF. Shows where drainages cross roads on the Tongass National Forest. Used to determine which crossings are fish streams and which are non fish streams. Physical and biological data are included for fish crossings. Use for project planning and NEPA analysis. This is the updated layer as of 10/20/2021. This data includes a reduced set of attributes from the full version found in the WaterXing feature class. This copy of the data was downloaded from the hosted feature service on June 13, 2022.</SPAN></P></DIV></DIV></DIV>
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'xingid', 'type': 'esriFieldTypeString', 'alias': 'XingID', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'xingtype', 'type': 'esriFieldTypeString', 'alias': 'Crossing Type', 'sqlType': 'sqlTypeOther', 'length': 15, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'route_no', 'type': 'esriFieldTypeString', 'alias': 'Road Number', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'milepost', 'type': 'esriFieldTypeString', 'alias': 'Milepost', 'sqlType': 'sqlTypeOther', 'length': 20, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'date', 'type': 'esriFieldTypeDate', 'alias': 'Date', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'system', 'type': 'esriFieldTypeString', 'alias': 'Road System', 'sqlType': 'sqlTypeOther', 'length': 5, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_system', 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue', 'codedValues': [{'name': 'Yakutat', 'code': 'YAK'}, {'name': 'Sumez', 'code': 'SMZ'}, {'name': 'Long Is', 'code': 'LNG'}, {'name': 'Lancaster', 'code': 'LAN'}, {'name': 'Little Coal Bay', 'code': 'LCB'}, {'name': 'Prince of Wales', 'code': 'POW'}, {'name': 'Dall Is', 'code': 'DAL'}, {'name': 'Etolin', 'code': 'ETO'}, {'name': 'Wrangell', 'code': 'WRG'}, {'name': 'Zarembo', 'code': 'ZAR'}, {'name': 'Woronkofski', 'code': 'WOR'}, {'name': 'Frosty', 'code': 'FRO'}, {'name': 'Rynda', 'code': 'RYN'}, {'name': 'Anita', 'code': 'ANA'}, {'name': 'Bradfield', 'code': 'BRD'}, {'name': 'Bushy Is', 'code': 'BSH'}, {'name': 'King George', 'code': 'GEO'}, {'name': 'Shrubby', 'code': 'SHR'}, {'name': 'Sokolof', 'code': 'SOK'}, {'name': 'Cleveland', 'code': 'CLE'}, {'name': 'Kake', 'code': 'KAK'}, {'name': 'Kuiu', 'code': 'KUI'}, {'name': 'Thomas Bay', 'code': 'THB'}, {'name': 'Portage Bay', 'code': 'POR'}, {'name': 'Tonka', 'code': 'TON'}, {'name': 'Mitkof', 'code': 'MIT'}, {'name': 'Hassler', 'code': 'HAS'}, {'name': 'Shrimp Bay', 'code': 'SHB'}, {'name': 'Neets', 'code': 'NTS'}, {'name': 'Klu Bay', 'code': 'KLU'}, {'name': 'Carrol', 'code': 'CAR'}, {'name': 'Shelter Cove', 'code': 'SHE'}, {'name': 'Harriet Hunt', 'code': 'HAH'}, {'name': 'Shoal Cove', 'code': 'SHC'}, {'name': 'Quartz Hill', 'code': 'QTH'}, {'name': 'Annette', 'code': 'ANN'}, {'name': 'Valenar', 'code': 'VAL'}, {'name': 'Hyder', 'code': 'HYD'}, {'name': 'Margarita Bay', 'code': 'MGB'}, {'name': 'Fire Cove', 'code': 'FIC'}, {'name': 'Brown Mtn', 'code': 'BMT'}, {'name': 'Elf Pt', 'code': 'ELF'}, {'name': 'Revilla', 'code': 'REV'}, {'name': 'Southwest Neets', 'code': 'SWN'}, {'name': 'Marble Is', 'code': 'MAR'}, {'name': 'Tuxekan', 'code': 'TUX'}, {'name': 'Kosciusko', 'code': 'KOS'}, {'name': 'Orr Is', 'code': 'ORR'}, {'name': 'Heceta', 'code': 'HEC'}, {'name': 'Thorne Is', 'code': 'THI'}, {'name': 'Stevenson', 'code': 'STV'}, {'name': 'Calder', 'code': 'CAL'}, {'name': 'Juneau', 'code': 'JUN'}, {'name': 'Couverden', 'code': 'COV'}, {'name': 'Hobart Bay', 'code': 'HOB'}, {'name': 'Sitka', 'code': 'SIT'}, {'name': 'False Is', 'code': 'FSI'}, {'name': 'Indian River', 'code': 'INR'}, {'name': 'Rodman Bay', 'code': 'RDB'}, {'name': 'Tenakee Inlet', 'code': 'TKI'}, {'name': 'Appleton Cove', 'code': 'APC'}, {'name': 'Camp Coogan', 'code': 'COO'}, {'name': 'Hanus Bay', 'code': 'HAB'}, {'name': 'Kelp Bay', 'code': 'KLB'}, {'name': 'Inbetween', 'code': 'INB'}, {'name': 'Sitkoh Bay', 'code': 'SIB'}, {'name': 'Kizhuchia', 'code': 'KIZ'}, {'name': 'Corner Bay', 'code': 'COB'}, {'name': 'Lisa Cr', 'code': 'LIS'}, {'name': 'Fish Bay', 'code': 'FIS'}, {'name': 'Katlian', 'code': 'KAT'}, {'name': 'Noxon Cr', 'code': 'NOX'}, {'name': 'Eagle R Kruzof', 'code': 'EAG'}, {'name': 'St John the Baptist', 'code': 'STJ'}, {'name': 'Mud Bay Kruzof', 'code': 'KRU'}, {'name': 'Crab Bay', 'code': 'CRB'}, {'name': 'Saook Bay', 'code': 'SAB'}, {'name': 'Oly Creek', 'code': 'OLY'}, {'name': 'Hoonah', 'code': 'HOO'}, {'name': 'Whitestone', 'code': 'WHS'}, {'name': 'Eight Fathom', 'code': 'ETF'}, {'name': 'Kennel Creek', 'code': 'KNC'}, {'name': 'Freshwater Inlet', 'code': 'FWI'}, {'name': 'Salt Lake Bay', 'code': 'SLB'}, {'name': 'Seal Creek', 'code': 'SLC'}]}, 'defaultValue': None}, {'name': 'feature', 'type': 'esriFieldTypeString', 'alias': 'Feature Type', 'sqlType': 'sqlTypeOther', 'length': 3, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_feature', 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue', 'codedValues': [{'name': 'Abutments are present although bridge is not', 'code': 'AB'}, {'name': 'Blocking or closure device', 'code': 'BC'}, {'name': 'Foot Bridge', 'code': 'FB'}, {'name': 'Intersection', 'code': 'IS'}, {'name': 'J-hole', 'code': 'JH'}, {'name': 'landing', 'code': 'LD'}, {'name': 'quarry', 'code': 'QY'}, {'name': 'turnout', 'code': 'TO'}, {'name': 'x-section', 'code': 'XS'}, {'name': 'two closed bottomed multiplate pipes', 'code': 'AR2'}, {'name': 'three closed bottomed multiplate pipes', 'code': 'AR3'}, {'name': 'four closed bottomed multiplate pipes', 'code': 'AR4'}, {'name': 'two corrugated pipes', 'code': 'CP2'}, {'name': 'three corrugated pipes', 'code': 'CP3'}, {'name': 'two modular bridges', 'code': 'MB2'}, {'name': 'three modular bridges', 'code': 'MB3'}, {'name': 'two log bridges', 'code': 'LB2'}, {'name': 'three log culverts', 'code': 'LC3'}, {'name': 'two plastic pipes', 'code': 'PP2'}, {'name': 'site where structure is needed in future', 'code': 'MI'}, {'name': 'other', 'code': 'O'}, {'name': 'two corrugated metal pipe arches', 'code': 'PA2'}, {'name': 'three corrugated metal pipe arches', 'code': 'PA3'}, {'name': 'five corrugated metal pipe arches', 'code': 'PA5'}, {'name': 'waterbar', 'code': 'WB'}, {'name': 'removed', 'code': 'RM'}, {'name': 'CP', 'code': 'CP'}, {'name': 'FD', 'code': 'FD'}, {'name': 'AO', 'code': 'AO'}, {'name': 'AR', 'code': 'AR'}, {'name': 'CO', 'code': 'CO'}, {'name': 'CPB', 'code': 'CPB'}, {'name': 'PA', 'code': 'PA'}, {'name': 'PAB', 'code': 'PAB'}, {'name': 'PP', 'code': 'PP'}, {'name': 'LC', 'code': 'LC'}, {'name': 'WC', 'code': 'WC'}, {'name': 'LB', 'code': 'LB'}, {'name': 'MB', 'code': 'MB'}, {'name': 'PB', 'code': 'PB'}]}, 'defaultValue': None}, {'name': 'height', 'type': 'esriFieldTypeDouble', 'alias': 'Height of Culvert (in)', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'width', 'type': 'esriFieldTypeDouble', 'alias': 'Width of Culvert (in)', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'length', 'type': 'esriFieldTypeDouble', 'alias': 'Length of Culvert (ft)', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'strmclass_us', 'type': 'esriFieldTypeString', 'alias': 'Stream Class Upstream', 'sqlType': 'sqlTypeOther', 'length': 1, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_strmclass_us', 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue', 'codedValues': [{'name': 'Stream Class I', 'code': '1'}, {'name': 'Stream Class II', 'code': '2'}, {'name': 'Stream Class III', 'code': '3'}, {'name': 'Stream IV', 'code': '4'}, {'name': 'TLMP non-stream (Waterway)', 'code': '5'}, {'name': 'Not classified', 'code': 'N'}]}, 'defaultValue': None}, {'name': 'strmclass_ds', 'type': 'esriFieldTypeString', 'alias': 'Stream Class Downstream', 'sqlType': 'sqlTypeOther', 'length': 1, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_strmclass_ds', 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue', 'codedValues': [{'name': 'Stream Class I', 'code': '1'}, {'name': 'Stream Class II', 'code': '2'}, {'name': 'Stream Class III', 'code': '3'}, {'name': 'Stream IV', 'code': '4'}, {'name': 'TLMP non-stream (Waterway)', 'code': '5'}, {'name': 'Not classified', 'code': 'N'}]}, 'defaultValue': None}, {'name': 'fieldnote', 'type': 'esriFieldTypeString', 'alias': 'Field Note', 'sqlType': 'sqlTypeOther', 'length': 1150, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'passage', 'type': 'esriFieldTypeString', 'alias': 'Passage', 'sqlType': 'sqlTypeOther', 'length': 10, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'rmdtnscr', 'type': 'esriFieldTypeDouble', 'alias': 'Remediation score', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'GlobalID', 'type': 'esriFieldTypeGlobalID', 'alias': 'GlobalID', 'sqlType': 'sqlTypeOther', 'length': 38, 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__INTEGRAT__F4B70D853B17DD3A', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_4481.INTEGRATED_RESOURCE_MANAGEMENT_ON_THE_TONGASS_NATIONAL_FOREST_IMPAIRED_FISH_PASSAGE_Shape_sidx', 'fields': 'Shape', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Spatial'}, {'name': 'FDO_GlobalID', 'fields': 'GlobalID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}]
{'renderer': {'type': 'classBreaks', 'authoringInfo': {'type': 'classedSize', 'classificationMethod': 'esriClassifyQuantile'}, 'field': 'rmdtnscr', 'classificationMethod': 'esriClassifyQuantile', 'minValue': -0.43756954, 'classBreakInfos': [{'symbol': {'type': 'esriPMS', 'url': 'aeb9e502621162aa3cf930e368d39796', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABLUlEQVQ4jbXTP0tCYRTH8c8NZ0NQ7pBLCA33BfQagt6AQ3IXoaZ8B63NDYLQ0BIFQdGYY6uzU7QHmunSkCm3wSe4hRURneXAOZzv7/x5noI/WuE/ASVsYIT73wDW0aiwlVB6ZDpgMuQGhz8B1rG7Q5oSF4nmeCY7ITmjhuZ3gMYO6T7xGlEUghlRi/IK26fsobMMUKqwlYbiO7RD4gBVpMRd6sMvABsJpWJQbuN6oW6Ic6wSJcS3bKL3GTAaMZ3nAlnwleBnGDHF07IO7jF5IcuIDoJyJYyQ4XXhxnJn/bDEPjfHJC3K1dD2eycDsise+lzkaz5f4fCM2grbKfEq0SwoX/FwxGWOuxQAzVP2utQT4jDzOCifhxG+BUBnSCds+8kvn3Leej/k//4b3wBCYVY7hiZcwQAAAABJRU5ErkJggg==', 'contentType': 'image/png', 'width': 12, 'height': 12, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'classMaxValue': 17.40713165, 'label': 'Low'}, {'symbol': {'type': 'esriPMS', 'url': 'b7045781e63249a2c286808f88d26bee', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmklEQVQ4jdXTsUqbURQA4O8nKWiahFQbELRgSUvFaDAlaY1Lh/Y9XH2pjnXpAzg4uUg7hJpBayhNWrUpJIpiNQSJpEP+oYj+KLj0bBfu/Tjn3HPi7jHi/yU2gjFMII0LHKCF/l2wzBSVLItPySUY79L7zm6NDVTRuQ2Wec7bPMtzlOZIpomfMdih8ojiDqtt1q6CV7GRKSp5lt/xpkQqSxDHJXKMPmbpI0GbY6yjdxM29oTFl5TKpB4S1NDENOYJXpP8SWGPcnNYbusmbGKaXJ5klmAL77GFBaxglqBIss5Mk6koLB1jfJR4LMxoC7/xIDwXkCGWJoVEVM8uuvTOGFyGpS2E0CwmDWfihP45RziNwg5+sfuNyjNG5wlWwowm8QIdBtt0G+zjMAprfWUjQzHD0iuSswSFMKMOg8+cV6k12EQ7CuufUv3Cao/gB4UiyQyxE/rbdKvU6nz4wyf/jMV1GHTarLU53qNcZyZN6pyjBvsNNkPoVhsgvLjepBp+f8Kw2Ydhab3rHkUtes9whloRd26N3TnuFfsLWW99suqjIwwAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 14, 'height': 14, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'classMaxValue': 60.9423758, 'label': 'Medium'}, {'symbol': {'type': 'esriPMS', 'url': 'ca04894903ade3c5f04673ef694c59fe', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACZklEQVRIie3VT0uUURTH8c9T0+hMjn9qMykpYZAKIYq4GQhqEZrLXoIvwTfTpl0voE3Rn60iDGgGQdJCImhwJmimGMqZHKfFvUWS00hGi+hsnue5z7n3e8/53XNuyl+y1H/Q3wCdRgY5HKCK5p8E9WIYlzCWZgyNJq9QxluUsHcS0CDmz7N0kcI58jl6EtpVPpWp7LJe4wGKqP0OaHCAm3mWp5m7Rv9lUoPxZxnbjKwzXmSixF086QTrBOrFfJ7lWxQWyI6T9OBUdBjGJKmrDOUoPKZdoYI1fDkuaPg8S9PMLZC9QpLGPupxUgZ9AZbcJltlbo3FKjt4cxzQaVy6SOEa/eMRUscWniHBDKYjbIrkOgOvuVHlqXBAWt1AGYydI3+ZVE+MZAt3BMWbmMUKCsgGcOoRF14wGteodwPl0ozl6BkUNKnHSIo/zN6MY7Nx1SH0k06Tb3L2OKADNBLaPzolDldnGmfiexsNtDhIvr8etqNA1SavYp0YjjueibvfjJD5OJYRUlvGe/YbfIjcrqAmymUq24xMkuoThF8R0nUmQqbihM94yX4l8I7sEp2O99td1tcZv8rQJEmfIPxsdMjEZwPbtFf5uMtq+Dx+HZVqPCgykaNwm+wUSTYC2kK6PkfIfT49Z6PGwxjRT9YJtIdiibuPQ1+bu87ADKmhGEVZSNcqH5+z8Y572NChuf6q19XwpEJljcXX3HjEhX7SLQ7eR012WY2RbAhXx5HWrXvXsFZlp8rTF4ymySc04ukqCZqc+JogCPtGaCuZWIwtIYN7jhD+d0HfrCVUe72b40lBJ7J/D/QVHUfCmHyARBMAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 19, 'height': 19, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'classMaxValue': 421644.7256, 'label': 'High'}], 'legendOptions': {'order': 'ascendingValues'}}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': None}
[]
[{'name': 'Low', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'passage': None, 'rmdtnscr': 8.484781055000001, 'xingid': None, 'xingtype': None, 'route_no': None, 'milepost': None, 'date': None, 'system': None, 'feature': None, 'height': None, 'width': None, 'length': None, 'strmclass_us': None, 'strmclass_ds': None, 'fieldnote': None}}}, {'name': 'Medium', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'passage': None, 'rmdtnscr': 39.174753725, 'xingid': None, 'xingtype': None, 'route_no': None, 'milepost': None, 'date': None, 'system': None, 'feature': None, 'height': None, 'width': None, 'length': None, 'strmclass_us': None, 'strmclass_ds': None, 'fieldnote': None}}}, {'name': 'High', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'passage': None, 'rmdtnscr': 210852.8339879, 'xingid': None, 'xingtype': None, 'route_no': None, 'milepost': None, 'date': None, 'system': None, 'feature': None, 'height': None, 'width': None, 'length': None, 'strmclass_us': None, 'strmclass_ds': None, 'fieldnote': None}}}]