Name: LightingInventory_10232023

Display Field: MAgencyName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: -87.451555555
YMin: 25.434502819
XMax: -80.11942469
YMax: 30.9971295550001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[255,170,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• LoadCenterID (type: esriFieldTypeGUID, alias: LoadCenterID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HLID (type: esriFieldTypeString, alias: Lighting ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LDistrict (type: esriFieldTypeSmallInteger, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [1: District 1], [2: District 2], ... 7 more ...)
• LCostCenter (type: esriFieldTypeSmallInteger, alias: Maintenance Unit/Cost Center, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [190: (190) Bartow], [191: (191) Heartland], ... 30 more ...)
• LCounty (type: esriFieldTypeSmallInteger, alias: County, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [1: (01) Charlotte], [2: (02) Citrus], ... 65 more ...)
• LSection (type: esriFieldTypeString, alias: Section, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• LSubsection (type: esriFieldTypeString, alias: Subsection, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• LRoadwayID (type: esriFieldTypeString, alias: Roadway ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LMilePost (type: esriFieldTypeDouble, alias: Mile Post, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOffset (type: esriFieldTypeSmallInteger, alias: Offset, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: Left], [2: Median], ... 1 more ...)
• LStateRoad (type: esriFieldTypeString, alias: State Road, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LCID (type: esriFieldTypeString, alias: Load Center ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LCLoadCenter (type: esriFieldTypeString, alias: Load Center Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LCMeter (type: esriFieldTypeString, alias: Meter Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAgencyType (type: esriFieldTypeSmallInteger, alias: Agency Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [1: FDOT/Contract], [2: Local Government: Highway Lighting Maintenance and Compensation Agreement], ... 3 more ...)
• MAgencyID (type: esriFieldTypeString, alias: Agency ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAgencyName (type: esriFieldTypeString, alias: Agency Name/Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LightingType (type: esriFieldTypeSmallInteger, alias: Lighting Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [1: Pole], [2: Underdeck], ... 2 more ...)
• DPoleID (type: esriFieldTypeString, alias: Pole ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DPoleType (type: esriFieldTypeSmallInteger, alias: Pole Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: Aluminum], [2: Bollard], ... 4 more ...)
• DStandard (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Standard, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes])
• DStainless (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Stainless, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes])
• DAnodized (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Anodized, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes])
• DPainted (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Painted, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes])
• DPowderCoat (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Powder Coat, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes])
• DDecorative (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Decorative/Special, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes])
• DOther (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Other, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes])
• DOtherNotes (type: esriFieldTypeString, alias: Pole Attribute: Other (Notes), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DPedestrian (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Pedestrian Light, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: Crosswalk Light], [2: Traffic Signal Mast Arm])
• DStructureID (type: esriFieldTypeString, alias: Bridge/Structure Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• DLuminaireID (type: esriFieldTypeString, alias: Luminaire ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DSignType (type: esriFieldTypeSmallInteger, alias: Sign Structure Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: Overlane], [2: Cantilever], ... 1 more ...)
• DHeight (type: esriFieldTypeSmallInteger, alias: Pole/Structure Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DLuminaireCount (type: esriFieldTypeSmallInteger, alias: Luminaire Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DInspectionDate (type: esriFieldTypeDate, alias: Lower Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DLightType (type: esriFieldTypeSmallInteger, alias: Light Bulb Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: High Pressure Sodium (HPS)], [2: Light Emitting Diode (LED)], [3: Metal Halide (OH)], ... 4 more ...)
• DLightNotes (type: esriFieldTypeString, alias: Light Bulb Type (Notes), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DLightCount (type: esriFieldTypeSmallInteger, alias: Light Bulb Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RecordStatus (type: esriFieldTypeSmallInteger, alias: Record Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Current], [3: Review], [2: Archive], ... 1 more ...)
• SurveyVersion (type: esriFieldTypeString, alias: Survey Version, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [N/A: N/A], [20201001-1600: 10/1/2020, 4:00 PM], [20210607-1400: 6/7/2021, 2:00 PM], ... 17 more ...)
• SurveyStart (type: esriFieldTypeDate, alias: Survey Start Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SurveyEnd (type: esriFieldTypeDate, alias: Survey End Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AdminCode (type: esriFieldTypeString, alias: Admin Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DMastArmMountHeight1 (type: esriFieldTypeSmallInteger, alias: Fixture Arm #1: Mounting Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DMastArmLength1 (type: esriFieldTypeSmallInteger, alias: Fixture Arm #1: Arm Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DMastArmMountHeight2 (type: esriFieldTypeSmallInteger, alias: Fixture Arm #2: Mounting Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DMastArmLength2 (type: esriFieldTypeSmallInteger, alias: Fixture Arm #2: Arm Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DPoleMountR (type: esriFieldTypeSmallInteger, alias: Pole Attribute: Pole Mount, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: No], [2: Yes (Deprecated)], ... 2 more ...)
• DFixtureArmR (type: esriFieldTypeSmallInteger, alias: Fixture Arm, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: N/A], [1: Single], [2: Double])

Templates:

Name: LightingInventory_10232023
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• DPoleMountR: -1
• DMastArmLength2: -1
• DFixtureArmR: -1
• HLID: New Record
• LDistrict: -1
• LCostCenter: -1
• LCounty: -1
• LSection: ###
• LSubsection: ###
• LRoadwayID: 00######
• LMilePost: -1
• LOffset: -1
• LStateRoad: ####
• LCID: Not Linked
• MAgencyType: -1
• MAgencyID: N/A
• MAgencyName: N/A
• LightingType: -1
• DPoleID: N/A
• DPoleType: -1
• DStandard: -1
• DStainless: -1
• DAnodized: -1
• DPainted: -1
• DPowderCoat: -1
• DDecorative: -1
• DOther: -1
• DOtherNotes: N/A
• DPedestrian: -1
• DStructureID: N/A
• DLuminaireID: N/A
• DSignType: -1
• DHeight: -1
• DLuminaireCount: -1
• DLightType: -1
• DLightNotes: N/A
• DLightCount: -1
• RecordStatus: 1
• SurveyVersion: Unknown
• AdminCode: Unknown
• DMastArmMountHeight1: -1
• DMastArmLength1: -1
• DMastArmMountHeight2: -1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/24/2023 4:46:49 PM

Schema Last Edit Date: 10/24/2023 4:46:49 PM

Data Last Edit Date: 10/24/2023 2:21:04 PM

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