Name: FlatSheetSigns

Display Field: COUNTY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset contains single points representing the flat sheet signs located on interstates, ramps, state routes, TDOT maintained state park roads, and locally owned NHS routes in Tennessee. This dataset can be queried by either location information, mounting type, sign orientation, sign type, visual condition, or MUTCD code. These records were derived from vehicle mounted LiDAR sensors and digitally captured photos. This information was collected by Cyclomedia Technology, Inc. under the direction of the Asset Management Division and the Long Range Planning Division. Questions on this dataset should be directed to TDOT.Maint.AssetManagement@tn.gov.

Copyright Text: Cyclomedia Technology, Inc.

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: 1618497.42726164
YMin: 456486.614974648
XMax: 1802111.68798514
YMax: 667806.303226814
Spatial Reference: 102736 (2274)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,211,127,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,211,127,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: false

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)
• REFERENCE_NUMBER (type: esriFieldTypeString, alias: Reference Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• COUNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ROUTE_NUMBER (type: esriFieldTypeString, alias: Route Number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SPECIAL_CASE (type: esriFieldTypeString, alias: Special Case, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• COUNTY_SEQUENCE (type: esriFieldTypeString, alias: County Sequence, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• EXIT_NUMBER (type: esriFieldTypeString, alias: Exit Number, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• RAMP_ID (type: esriFieldTypeString, alias: Ramp ID, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ROUTE_ID (type: esriFieldTypeString, alias: Route ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LOGMILE (type: esriFieldTypeDouble, alias: Log Mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MUTCD_CODE (type: esriFieldTypeString, alias: MUTCD Code, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FEATURE_DESCRIPTION (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SIGN_CONDITION (type: esriFieldTypeSmallInteger, alias: Sign Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_ORIENTATION (type: esriFieldTypeSmallInteger, alias: Sign Orientation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MILE_MARKER (type: esriFieldTypeDouble, alias: Marker, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_POST_REFERENCE_NUMBER (type: esriFieldTypeString, alias: Sign Post Reference Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• HEIGHT_FT (type: esriFieldTypeDouble, alias: Height (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH_FT (type: esriFieldTypeDouble, alias: Width (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREETSMART_URL (type: esriFieldTypeString, alias: StreetSmart URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FEATURE_SEQUENCE (type: esriFieldTypeSmallInteger, alias: Feature Sequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATE_COLLECTED (type: esriFieldTypeDate, alias: Date Collected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DELIVERY_DATE (type: esriFieldTypeString, alias: Delivery Date, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LATITUDE_DD (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE_DD (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ELEVATION_FT (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: FlatSheetSigns
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/6/2023 12:21:39 AM

Schema Last Edit Date: 2/6/2023 12:21:39 AM

Data Last Edit Date: 2/6/2023 12:21:39 AM

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