Name: Impacted Streams Subbasin Project PINs

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This layer contains the streams impacted by the 10 year projects and the mitigation credits associated with each. The streams were selected using a 17.5 ft buffer and were then spatially joined to the project PINS and water mitigation credits data. That was then spatially joined to the USGS HUC 8 Subbasin layer with the subbasins for TN filtered out.

Copyright Text: Tennessee Department of Transportation, Long Range Planning, Data Visualization/ Tennessee Department of Transportation, Environmental, Enivronmental Mitigation Office/ United State Geological Survery

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 768465.109285146
YMin: 250138.711398378
XMax: 3025920.03695156
YMax: 838746.750715375
Spatial Reference: 102736 (2274)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[153,80,32,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GNIS_NAME (type: esriFieldTypeString, alias: Stream Name, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• ID_NUMBER (type: esriFieldTypeString, alias: ID Number, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NBR_TENN_C (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NBR_RT2 (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PIN (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• REGION (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeString, alias: Route Label, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PROJECT_D2 (type: esriFieldTypeString, alias: Termini, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PROJECT_T3 (type: esriFieldTypeString, alias: Scope of Work, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• BEG_LOG_MILE (type: esriFieldTypeDouble, alias: Beginning Log Mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• END_LOG_MILE (type: esriFieldTypeDouble, alias: End Log Mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COL_N (type: esriFieldTypeString, alias: Impact, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• VLLOKUP (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• REPORTED_PROJECT_LENGTH (type: esriFieldTypeDouble, alias: Reported Project Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATEWIDE_EQUATION_IMPACT (type: esriFieldTypeInteger, alias: Statewide Equation Impact, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVERAGE_CREDIT_MIN_RANGE (type: esriFieldTypeDouble, alias: Average Credit Minimum Range, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVERAGE_CREDIT_RANGE (type: esriFieldTypeDouble, alias: Average Credit Range, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAXIMUM_CREDIT_RANGE (type: esriFieldTypeDouble, alias: Maximum Credit Range, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CORRECTION_PERCENT (type: esriFieldTypeDouble, alias: Correction Percent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CORRECTION_MINIMUM (type: esriFieldTypeDouble, alias: Correction Minimum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CORRECTION_AVERAGE (type: esriFieldTypeDouble, alias: Correction Average, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CORRECTION_MAXIMUM (type: esriFieldTypeDouble, alias: Correction Maximum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HUC8 (type: esriFieldTypeString, alias: HUC8, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: Subbasin, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• YEAR (type: esriFieldTypeDate, alias: Year, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Impacted Streams Subbasin Project PINs
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/2/2025 12:17:24 AM

Schema Last Edit Date: 8/2/2025 12:17:24 AM

Data Last Edit Date: 8/2/2025 12:17:24 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat