Name: GRSM_ROAD_CULVERTS

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A culvert is a structure that allows water to flow under a road, railroad, trail, or similar obstruction from one side to the other side. Typically embedded so as to be surrounded by soil, a culvert may be made from a pipe, reinforced concrete or other material. In the United Kingdom the word can also be used for a longer artificially buried watercourse.[1] A structure that carries water above land is known as an aqueduct. Culverts are commonly used both as cross-drains for ditch relief and to pass water under a road at natural drainage and stream crossings. A culvert may be a bridge-like structure designed to allow vehicle or pedestrian traffic to cross over the waterway while allowing adequate passage for the water. Culverts come in many sizes and shapes including round, elliptical, flat-bottomed, pear-shaped, and box-like constructions. The culvert type and shape selection is based on a number of factors including requirements for hydraulic performance, limitation on upstream water surface elevation, and roadway embankment height

Copyright Text: Great Smoky Mountains National Park

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: -9351948.87659993
YMin: 4215923.55086471
XMax: -9244501.8213559
YMax: 4298133.88483248
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"5e6cb7d381ecb2b63c0263e1c08771ca","imageData":"iVBORw0KGgoAAAANSUhEUgAAACYAAAAICAYAAACVm43oAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAjElEQVQ4jc3OPQqDQBBA4Te4nsSbiJ2pzA3sPESOY2uXewRs0qb1BonCyBICSpZli13xdfNTfIaTZtxrNSDLMQTNQeYAmLZAA9qAfBKjOqAGLgEweuAKDGlxalE3oHRdHTB5f0EWlgqnG5Q8A2F/uAfoFFGVAYUP5YHtcJUdiNsI8vI9eGA/HPfIqKBWy8cmEsQQ1v8AAAAASUVORK5CYII=","contentType":"image/png","width":28,"height":6,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• POINT_TYPE (type: esriFieldTypeString, alias: POINT_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: General], [2: Culvert], [3: Structure Protection], ... 5 more ...)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Rebecca Biglow], [2: Andrew Breibart], [3: TJ Clifford], ... 19 more ...)
• DATE (type: esriFieldTypeDate, alias: DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PURPOSE (type: esriFieldTypeString, alias: PURPOSE, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CULVERTSIZE (type: esriFieldTypeSmallInteger, alias: CULVERTSIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [18: 18], [24: 24], [30: 30], ... 5 more ...)
• CULVERTMATERIAL (type: esriFieldTypeString, alias: CULVERTMATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Aluminum], [2: Concrete], [3: Corrugated Steel Pipe], ... 5 more ...)
• CULVERTCONDITION (type: esriFieldTypeString, alias: CULVERTCONDITION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [2: Fair ( some obstructions, culvert damaged, may need repair )], [3: Poor ( not functioning as intended, major obstructions, needs repair )], [4: Other], ... 2 more ...)
• CULVERTTYPE (type: esriFieldTypeString, alias: CULVERTTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Rock - Crossing with no culvert - Rock], [2: Culvert designed to transport ditch and/or surface water from one side of the road to the other.], [3: Culvert on class I, II, or III stream with no fish passage], ... 2 more ...)
• CULVERTRISK (type: esriFieldTypeString, alias: CULVERTRISK, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: High], [2: Moderate], [3: Low], ... 1 more ...)
• CULVERTDAMAGE (type: esriFieldTypeString, alias: CULVERTDAMAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Pre-Fire], [2: Post-Fire], [3: Other])
• ACTIVECHANNELWIDTH (type: esriFieldTypeString, alias: ACTIVECHANNELWIDTH, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RIPARIANVEG (type: esriFieldTypeString, alias: RIPARIANVEG, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Sand: Sand], [Loamy Sand: Loamy Sand], [Sandy Loam: Sandy Loam], ... 8 more ...)
• UPGRADE (type: esriFieldTypeString, alias: UPGRADE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [18: 18], [24: 24], [30: 30], ... 5 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FACILITYTYPE (type: esriFieldTypeInteger, alias: FACILITYTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1110: Paved], [1120: Unpaved], [1130: Both], ... 78 more ...)
• ASSETCODE (type: esriFieldTypeInteger, alias: ASSETCODE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Site/Area], [1100: Roads], [1300: Parking Area], ... 27 more ...)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LANDFORM (type: esriFieldTypeString, alias: LANDFORM, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• MANAGEMENTZONE (type: esriFieldTypeString, alias: MANAGEMENTZONE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MAPMETHOD (type: esriFieldTypeString, alias: MAPMETHOD, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [AGPS: Autonomous GPS], [DERV: Derived/Calculated], [DGPS: Differential GPS], ... 6 more ...)
• WATERSHED (type: esriFieldTypeString, alias: WATERSHED, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true, Coded Values: [Meadow Fork: Meadow Fork], [Pigeon River-English Creek: Pigeon River-English Creek], [Boyds Creek: Boyds Creek], ... 83 more ...)
• LON (type: esriFieldTypeDouble, alias: LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COORD_SYSTEM (type: esriFieldTypeString, alias: COORD_SYSTEM, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DATUM (type: esriFieldTypeString, alias: DATUM, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• UTM_ZONE (type: esriFieldTypeString, alias: UTM_ZONE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [NC: North Carolina], [TN: Tennessee])
• UNITCODE (type: esriFieldTypeString, alias: UNITCODE, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• QUADNAME (type: esriFieldTypeString, alias: QUADNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [BINFIELD: BINFIELD], [BLOCKHOUSE: BLOCKHOUSE], [BRYSON CITY: BRYSON CITY], ... 32 more ...)
• HERROR (type: esriFieldTypeString, alias: HERROR, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [<=15cm: <=15cm], [>10m: >10m], [>15cm <=1m: >15cm <=1m], ... 4 more ...)
• VERROR (type: esriFieldTypeString, alias: VERROR, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [<=15cm: <=15cm], [>10m: >10m], [>15cm <=1m: >15cm <=1m], ... 4 more ...)
• RESTRICTION (type: esriFieldTypeString, alias: RESTRICTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [UNR: Unrestricted], [RND: Restricted: No third party disclosure], [REX: Restricted: No release], ... 3 more ...)
• PARKDISTRICT (type: esriFieldTypeString, alias: PARKDISTRICT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Cades Cove District: Cades Cove District], [Little River District: Little River District], [Cosby District: Cosby District], ... 3 more ...)
• GEOMETRYID (type: esriFieldTypeGUID, alias: GEOMETRYID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• FMSS_LOC (type: esriFieldTypeString, alias: FMSS_LOC, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FMSS_ASSET (type: esriFieldTypeString, alias: FMSS_ASSET, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• LOC_NAME (type: esriFieldTypeString, alias: LOC_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ROAD (type: esriFieldTypeString, alias: ROAD, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FMSS_CULVERT_TYPE (type: esriFieldTypeString, alias: FMSS_CULVERT_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Stream Crossing: Stream Crossing], [Cross Drainage: Cross Drainage], [Other: Other])
• CULVERT_LOC_STATUS (type: esriFieldTypeString, alias: CULVERT_LOC_STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Field-Located: Field-Located], [Unable to Locate: Unable to Locate], [Removed from Service: Removed from Service])

Templates:

Name: PFMD.DBO.GRSM_ROAD_CULVERTS
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/12/2022 3:09:23 PM

Schema Last Edit Date: 12/12/2022 3:09:23 PM

Data Last Edit Date: 12/12/2022 3:09:23 PM

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