Name: Street Lights
Display Field: TYPE_FIXTURES
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: This point-based GIS layer provides comprehensive information about street lighting assets across Allen, TX. Each feature includes attributes such as:Ownership: Identifies the entity responsible for the street light (e.g., City of Allen, Oncor, CoServ, GCEC, HOA).Location Description: Provides descriptive information about the feature's location.Maintenance Responsibility: Indicates who is responsible for maintenance activities.Fixture Type: Specifies the type of light fixture installed.Pole Type: Describes the type of pole supporting the light fixture.Installation Date: Records when the street light was installed.Condition: Assesses the current state (e.g., Excellent, Good, Fair, Poor).The dataset is accessible through the City of Allen's GIS Open Data Hub and is compatible with standard GIS applications for advanced querying and analysis.This feature class contains points representing street lights in Allen Tx. It is maintained by Scotty Stewart (Traffic Signal Foreman) in the Engineering department through the Street Light and Street Sign Field Data Collection web map .Metadata updated: 05/2025
Service Item Id: 58bad2c00ab54fa88edd92044ad16e08
Copyright Text: Allen Tx
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.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: 2505549.8231514394
YMin: 7078017.557899833
XMax: 2547243.0932062566
YMax: 7108897.050536588
Spatial Reference: 102738
(2276)
VCSWkid(115702)
LatestVCSWkid(115702)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: OWNERSHIP
Field 2: PROVIDER
Field 3: LAMP_TYPE
Field Delimiter: ,
Default Symbol:
Default Label: Unknown
UniqueValueInfos:
-
Value: COA,COSERV,HPS
Label: COA - COSERV
Description: N/A
Symbol:
-
Value: COA,COSERV,LEDFixture
Label: COA - COSERV (LED Fixture)
Description: N/A
Symbol:
-
Value: COA,COSERV,LEDBulb
Label: COA - COSERV (LED Bulb)
Description: N/A
Symbol:
-
Value: COA,GCEC,HPS
Label: COA - GCEC
Description: N/A
Symbol:
-
Value: COA,GCEC,LEDBulb
Label: COA - GCEC (LED Bulb)
Description: N/A
Symbol:
-
Value: COA,ONCOR,HPS
Label: COA - ONCOR
Description: N/A
Symbol:
-
Value: COA,ONCOR,LEDFixture
Label: COA - ONCOR (LED Fixture)
Description: N/A
Symbol:
-
Value: COA,ONCOR,LEDBulb
Label: COA - ONCOR (LED Bulb)
Description: N/A
Symbol:
-
Value: P_R,ONCOR,HPS
Label: Parks and Recreation - ONCOR
Description: N/A
Symbol:
-
Value: AISD,ONCOR,HPS
Label: AISD - ONCOR
Description: N/A
Symbol:
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:
-
Engineering_StreetLightDbase
(
type: esriFieldTypeInteger, alias: Engineering ID
)
-
NO_FIXTURES
(
type: esriFieldTypeSmallInteger, alias: # of Fixtures
, Coded Values:
[0: Retire]
, [1: Single Fixture]
, [2: Double Fixture]
, ...2 more...
)
-
TYPE_FIXTURES
(
type: esriFieldTypeString, alias: Type of Fixture, length: 30
, Coded Values:
[CH-A: Cobra Head TYPE-A]
, [CH-B: Cobra Head TYPE-B]
, [CH-C: Cobra Head TYPE-C]
, ...7 more...
)
-
OWNERSHIP
(
type: esriFieldTypeString, alias: Street Light Ownership, length: 40
, Coded Values:
[AISD: Allen Independent School District]
, [COA: City of Allen]
, [COSERV: Coserv]
, ...19 more...
)
-
PROVIDER
(
type: esriFieldTypeString, alias: Service Provider, length: 40
, Coded Values:
[AISD: Allen Independent School District]
, [COA: City of Allen]
, [COSERV: Coserv]
, ...8 more...
)
-
LAMP_TYPE
(
type: esriFieldTypeString, alias: Lamp Type, length: 40
, Coded Values:
[MV: Mercury Vapor]
, [HPS: High Pressure Sodium]
, [MH: Metal Halide]
, ...3 more...
)
-
YR_INSTALLED
(
type: esriFieldTypeSmallInteger, alias: Year Light Installed
, Range: [1800, 2500]
)
-
LAMP_SIZE
(
type: esriFieldTypeSmallInteger, alias: Lamp Size (Watts)
, Coded Values:
[100: 100]
, [150: 150]
, [175: 175]
, ...10 more...
)
-
TYPICAL_APPLICATION
(
type: esriFieldTypeString, alias: Typical Application, length: 30
, Coded Values:
[01: RESIDENTIAL/COMMERCIAL/ROADWAY]
, [02: RESIDENTIAL]
, [03: COMMERCIAL/ROADWAY]
, ...4 more...
)
-
COMMENTS
(
type: esriFieldTypeString, alias: Comments, length: 75
)
-
location
(
type: esriFieldTypeString, alias: Location on Ground, length: 41
)
-
Subdivisio
(
type: esriFieldTypeString, alias: Subdivision, length: 50
)
-
Thorough_1
(
type: esriFieldTypeString, alias: Street, length: 50
)
-
Locations
(
type: esriFieldTypeInteger, alias: Location ID
)
-
Type
(
type: esriFieldTypeInteger, alias: Type
)
-
Contractor
(
type: esriFieldTypeString, alias: Contractor, length: 50
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 50
, Coded Values:
[E: Existing]
, [P: Proposed/Future]
, [U: Underconstruction]
, ...2 more...
)
-
Qty
(
type: esriFieldTypeSmallInteger, alias: Qty
)
-
GRID
(
type: esriFieldTypeString, alias: GRID, length: 2
)
-
LIGHTID_1
(
type: esriFieldTypeInteger, alias: LIGHTID_1
)
-
SUBGRID
(
type: esriFieldTypeString, alias: SUBGRID, length: 5
)
-
AS_CODE
(
type: esriFieldTypeDouble, alias: AS_CODE
)
-
InspectedBy
(
type: esriFieldTypeString, alias: Inspected By
, length: 50
, Coded Values:
[City of Allen: City of Allen]
, [Contractor: Contractor]
)
-
InspectionDate
(
type: esriFieldTypeDate, alias: Inspection Date, length: 8
)
-
KNockdownBy
(
type: esriFieldTypeString, alias: Knockdown By, length: 50
, Coded Values:
[City of Allen: City of Allen]
, [Contractor: Contractor]
)
-
RepairBy
(
type: esriFieldTypeString, alias: Repaired By, length: 50
, Coded Values:
[City of Allen: City of Allen]
, [Contractor: Contractor]
)
-
RepairDate
(
type: esriFieldTypeDate, alias: Repair Date, length: 8
)
-
CWID
(
type: esriFieldTypeString, alias: CWID, length: 20
)
-
CONTACTS
(
type: esriFieldTypeString, alias: CONTACTS, length: 100
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
ConvertedYear
(
type: esriFieldTypeString, alias: Converted Year, length: 4
)
-
PhotoCell
(
type: esriFieldTypeString, alias: Photo Cell, length: 4
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
UBCell
(
type: esriFieldTypeString, alias: UB Cell, length: 4
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
TypeofPoleBase
(
type: esriFieldTypeString, alias: Type of Pole Base, length: 25
, Coded Values:
[Standard Square: Standard Square]
, [Standard Tube: Standard Tube]
, [Specialty: Specialty]
)
-
SmallCellNode
(
type: esriFieldTypeString, alias: Small Cell Node, length: 4
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
METER
(
type: esriFieldTypeString, alias: METER OR UNMETER, length: 15
, Coded Values:
[Y: Meter]
, [N: No Meter]
, [UNK: Unknown]
)
-
SUPP_STRCTRE
(
type: esriFieldTypeString, alias: SUPPORT STRUCTURE, length: 20
, Coded Values:
[AB: Anchor Base]
, [BLK: Black]
, [BRZ: Bronze]
, ...12 more...
)
-
OBJECTID_1
(
type: esriFieldTypeInteger, alias: OBJECTID_1
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata