Name: Panel_Sign_Damage_Report

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description: <p><font color="#2f4f4f" size="3"><span style="background-color:rgb(255, 255, 255); font-family:Arial;"><span style="font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; word-spacing:0px;">This feature layer represents the </span></span><span style="font-family:Arial;"><strong>locations of reported damaged panel signs</strong></span><span style="background-color:rgb(255, 255, 255); font-family:Arial;"><span style="font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; word-spacing:0px;"> on </span></span><span style="font-family:Arial;"><strong>freeways and expressways</strong></span><span style="background-color:rgb(255, 255, 255); font-family:Arial;"><span style="font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; word-spacing:0px;"> across Kentucky. Panel signs play a crucial role in </span></span><span style="font-family:Arial;"><strong>guiding motorists, highlighting destinations, and providing information about services and attractions</strong></span><span style="background-color:rgb(255, 255, 255); font-family:Arial;"><span style="font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; word-spacing:0px;"> throughout the state. This dataset helps the Kentucky Transportation Cabinet (KYTC) monitor and maintain clear and effective roadway signage, ensuring compliance with AASHTO and FHWA standards. It supports transportation planning, roadway safety, and infrastructure management by identifying areas where signage needs repair or replacement.</span></span></font></p>

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Panel Sign Damage Report","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: true

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• ReportDate (type: esriFieldTypeDate, alias: Date Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReportTime (type: esriFieldTypeString, alias: Time Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReporterFirstName (type: esriFieldTypeString, alias: Reporter First Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ReporterLastName (type: esriFieldTypeString, alias: Reporter Last Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• NeedsRepair (type: esriFieldTypeString, alias: Needs Repair, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CurrentDamage (type: esriFieldTypeString, alias: Current Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DamageComment (type: esriFieldTypeString, alias: Damage Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeSingle, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 9 more ...)
• CNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• CO_NUMBER (type: esriFieldTypeSmallInteger, alias: County Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D_DISTRICT (type: esriFieldTypeString, alias: District Description, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• MP_Initial (type: esriFieldTypeDouble, alias: Initial Milepoint, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MP_Current (type: esriFieldTypeDouble, alias: Current Milepoint, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RD_NAME (type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
• RT_PREFIX (type: esriFieldTypeString, alias: Route Prefix, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RT_SUFFIX (type: esriFieldTypeString, alias: Route Suffix, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RT_NUMBER (type: esriFieldTypeSmallInteger, alias: Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROUTE_TYPE (type: esriFieldTypeString, alias: Route Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• ROUTE_LBL (type: esriFieldTypeString, alias: Route Label, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• INITIAL_LAT (type: esriFieldTypeDouble, alias: Initial Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INITIAL_LONG (type: esriFieldTypeDouble, alias: Initial Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRICT_ITEM_NUM (type: esriFieldTypeString, alias: District Item Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• RT_UNIQUE_Initial (type: esriFieldTypeString, alias: RT Unique Initial, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• RT_UNIQUE_Current (type: esriFieldTypeString, alias: RT Unique Initial, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• RT_UNIQUE_DateInitial (type: esriFieldTypeDate, alias: RT Unique Initial Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RT_UNIQUE_DateCurrent (type: esriFieldTypeDate, alias: RT Unique Current Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DateOfDeath (type: esriFieldTypeDate, alias: Date of Death, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GUID_Str (type: esriFieldTypeString, alias: GUID String, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ValidationComments (type: esriFieldTypeString, alias: Validiation Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UpdateIndicator (type: esriFieldTypeSmallInteger, alias: Update Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ETLDate (type: esriFieldTypeDate, alias: ETL Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SignType (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [GREEN_PID: Green PID], [PULL_THRU: Pull Thru], [2_MILE: 2 Mile], ... 38 more ...)
• SignMessage (type: esriFieldTypeString, alias: Sign Message, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Supports (type: esriFieldTypeString, alias: Supports, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [TYPE_A_FIXED: Type A Fixed], [TYPE_B: Type B], [TYPE_C: Type C], ... 9 more ...)
• OtherComment (type: esriFieldTypeString, alias: Comments & Other Descriptions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Width (type: esriFieldTypeDouble, alias: Width (Ft.), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height (type: esriFieldTypeDouble, alias: Height (Ft.), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PENDING: Pending], [COMPLETE: Complete], [DAMAGED: Damaged], ... 2 more ...)
• CompleteDate (type: esriFieldTypeDate, alias: Complete Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WorkOrderNumber (type: esriFieldTypeString, alias: Work Order Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• WorkOrderDescription (type: esriFieldTypeString, alias: Work Order Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D_SignType (type: esriFieldTypeString, alias: Sign Type - Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• D_Supports (type: esriFieldTypeString, alias: Supports - Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MS_BEAMS_OFF_BASE (type: esriFieldTypeSmallInteger, alias: Beam(s) Off Base, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_BEAMS_DAMAGED (type: esriFieldTypeSmallInteger, alias: Beam(s) Damaged, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_BEAMS_MISSING (type: esriFieldTypeSmallInteger, alias: Beam(S) Missing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_BASE_DAMAGES (type: esriFieldTypeSmallInteger, alias: Base Damaged, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_SIGN_DOWN (type: esriFieldTypeSmallInteger, alias: Sign Down, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_SIGN_LETTERS_DAMAGED (type: esriFieldTypeSmallInteger, alias: Sign Letters Loose/Missing/Damaged, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_SIGN_PANELS_DAMAGED (type: esriFieldTypeSmallInteger, alias: Sign Panels Loose/Missing/Bent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_SIGN_MISSING (type: esriFieldTypeSmallInteger, alias: Sign Missing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_SIGN_FADED (type: esriFieldTypeSmallInteger, alias: Sign Faded - Retroflectivity Issue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_SIGN_HARDWARE_LOOSE (type: esriFieldTypeSmallInteger, alias: Sign Hardware Loose/Missing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_GRAFFITI (type: esriFieldTypeSmallInteger, alias: Graffiti (G), SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_FUNGUS (type: esriFieldTypeSmallInteger, alias: Fungus (FUN), SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_CANTILEVER_STRUCTURAL_DAMAGE (type: esriFieldTypeSmallInteger, alias: Cantilever Structural Damage/Deterioration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_MUTCD_OPERTIONAL (type: esriFieldTypeSmallInteger, alias: MUTCD / Opertional Issues, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MS_OTHER (type: esriFieldTypeSmallInteger, alias: Other - See Comments, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• Panel_Sign_Damage_Report_ReferencePoint (1) -- Related To: ReferencePoint (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2025 7:00:33 PM

Schema Last Edit Date: 7/23/2025 6:57:13 PM

Data Last Edit Date: 7/23/2025 7:00:33 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat