Parent Layer: Transportation

Name: Street Lights

Display Field: LightPoleStyle

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset contains street lights for the City of McKinney, Texas. It's updated with data collected in the field for street lights maintained by the City of McKinney and also with data provided by CoServ, GCEC and Oncor. Oncor didn't provide their data for 2021 so any Oncor data in this layer is not current.Contact information:GCEC: Vic McTeeGrayson Collin Electric Cooperative903.482.7130vmctee@gcec.netCoServ:Donna Wood, CKAECOMMUNITY SUPPORT SPECIALIST| Community EngagementO (940) 270-6816 | M (469) 261-9944 7701 S Stemmons, Corinth, TX 76210dwood@coserv.comOncor:Paul Hernandez Area Manager OncorPaul.Hernandez@oncor.comLast updated: 5/5/2021Update frequency: As needed

Copyright Text: Created and maintained by the City of McKinney Public Works Department, Streets Division.

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2498373.0207000226
YMin: 7098719.0630774945
XMax: 2568104.264732957
YMax: 7153405.342872426
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [66, 145, 144, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LightPoleStyle ( type: esriFieldTypeString, alias: Light Pole Style, length: 50 , Coded Values: [1: Cobra Head] , [2: Decorative] , [3: McKinney Standard] , ...2 more... )
• LightPoleMaterial ( type: esriFieldTypeString, alias: Light Pole Material, length: 20 , Coded Values: [1: Decorative] , [2: Galvanized Steel] , [3: Wood] , ...1 more... )
• BulbType ( type: esriFieldTypeString, alias: Bulb Type, length: 50 , Coded Values: [1: High-Pressure Sodium (HPS)] , [2: Hetal-Halide (MH)] , [3: Mercury-Vapor (MV)] , ...1 more... )
• LightPoleVoltage ( type: esriFieldTypeString, alias: Light Pole Voltage, length: 50 , Coded Values: [1: 120/240] , [2: 480] )
• BulbWattage ( type: esriFieldTypeInteger, alias: Bulb Wattage )
• NumberOfFixtures ( type: esriFieldTypeString, alias: Number of Fixtures, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• InstallationDate ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• ElectricProvider ( type: esriFieldTypeString, alias: Electric Provider, length: 50 , Coded Values: [1: CoServ] , [2: GCEC] , [3: Oncor] , ...1 more... )
• MaintenanceResponsibility ( type: esriFieldTypeString, alias: Maintenance Responsibility, length: 30 , Coded Values: [1: CoServ] , [2: GCEC] , [3: Oncor] , ...2 more... )
• FixtureType ( type: esriFieldTypeString, alias: Fixture Type, length: 50 )
• ColorTemperature ( type: esriFieldTypeString, alias: Color Temperature, length: 50 , Coded Values: [1: 3000K] , [2: 4000K] , [3: 5000K] )
• PoleColor ( type: esriFieldTypeString, alias: Pole Color, length: 50 , Coded Values: [1: Black] , [2: Bronze/Brown] , [3: Green] , ...1 more... )
• PoleHeight ( type: esriFieldTypeString, alias: Pole Height (ft), length: 50 )
• Verified ( type: esriFieldTypeString, alias: Verified, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• created_user ( type: esriFieldTypeString, alias: Point Creator, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Point Creation Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Point Editor, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Point Edit Date, length: 8 )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 50 )
• LifeCycle ( type: esriFieldTypeString, alias: Light Pole Status, length: 50 , Coded Values: [Active: Active] , [Abandoned: Abandoned] , [Removed: Removed] , ...1 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• AssociatedMeter ( type: esriFieldTypeString, alias: Associated Meter, length: 255 )
• AdditionalNotes ( type: esriFieldTypeString, alias: Additional Notes, length: 60 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• PoleTagCode ( type: esriFieldTypeString, alias: PoleTagCode, length: 255 , Coded Values: [AirportDr: ARPT] , [AlmaRd: ALMA] , [BloomdaleRd: BLMD] , ...64 more... )
• PoleTagNumber ( type: esriFieldTypeSmallInteger, alias: PoleTagNumber )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata