Name: Street Lights

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Street Light Assets. The dataset contains locations and attributes of street lights provided by the District Department of Transportation (DDOT).

Copyright Text: District Department of Transportation

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: -8584588.347779084
YMin: 4693871.731278973
XMax: -8561521.078194968
YMax: 4721005.910089672
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• STREETLIGHTID ( type: esriFieldTypeString, alias: Streetlight Identifier, length: 12 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• ASSETSTATUS ( type: esriFieldTypeString, alias: Asset Status, length: 30 , Coded Values: [Active: Active] , [Inactive: Inactive] , [Removed: Removed] )
• WHYINACTIVE ( type: esriFieldTypeString, alias: Why Inactive, length: 50 )
• PEPCOLIGHTID ( type: esriFieldTypeString, alias: Pepco Light Identifier, length: 15 )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type , Coded Values: [1: Street Light] , [2: Alley Light] , [3: OHGS] , ...11 more... )
• OWNER ( type: esriFieldTypeSmallInteger, alias: Owner , Coded Values: [0: Unknown] , [1: DDOT] , [11: PEPCO] , ...4 more... )
• ISMETERED ( type: esriFieldTypeSmallInteger, alias: Is Metered , Coded Values: [0: Not Metered] , [1: Metered] )
• RMS ( type: esriFieldTypeSmallInteger, alias: RMS , Coded Values: [0: Not Controlled] , [1: Controlled] )
• SHIELD ( type: esriFieldTypeString, alias: Shield, length: 50 , Coded Values: [Internal 180: Internal 180] , [Internal 360: Internal 360] , [Internal 90: Internal 90] , ...10 more... )
• POLEHEIGHT ( type: esriFieldTypeString, alias: Pole Height, length: 10 , Coded Values: [10: 10 ft] , [100: 100 ft] , [13: 13 ft] , ...23 more... )
• NUMBERLIGHTS ( type: esriFieldTypeSmallInteger, alias: Number of Lights )
• FIXTURESTYLE ( type: esriFieldTypeSmallInteger, alias: Fixture Style , Coded Values: [1: Cobrahead Cutoff] , [2: Cobrahead Semi Cutoff] , [3: Posttop] , ...20 more... )
• TRAFFICCOMBO ( type: esriFieldTypeString, alias: Traffic Combo, length: 50 , Coded Values: [YES: YES] , [NO: NO] )
• LIGHTTYPE ( type: esriFieldTypeSmallInteger, alias: Light Type , Coded Values: [6: LED-Light Emitting Diode] , [1: HPS-High Pressure Sodium] , [3: INC-Incandescent] , ...3 more... )
• WATTAGE1 ( type: esriFieldTypeString, alias: Wattage 1, length: 4 , Coded Values: [10: 10] , [100: 100] , [1000: 1000] , ...33 more... )
• POLECOMPOSITION ( type: esriFieldTypeString, alias: Pole Composition, length: 15 , Coded Values: [Aluminum: Aluminum] , [Cast Iron: Cast Iron] , [Composite: Composite] , ...7 more... )
• POLETYPE ( type: esriFieldTypeString, alias: Pole Type, length: 20 , Coded Values: [16St Triple: 16St Triple] , [3A: 3A] , [3A-Ext: 3A-Ext] , ...25 more... )
• POWERFEED ( type: esriFieldTypeSmallInteger, alias: Power Feed , Coded Values: [1: Underground] , [2: Overhead] , [3: Solar] , ...1 more... )
• NUMBERARMS ( type: esriFieldTypeSmallInteger, alias: Number of Arms , Coded Values: [1: 1] , [2: 2] , [5: 5] , ...6 more... )
• ARMLENGTH1 ( type: esriFieldTypeSmallInteger, alias: Arm Length 1 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...9 more... )
• STREETNAME ( type: esriFieldTypeString, alias: Street Name, length: 40 )
• QUADRANT ( type: esriFieldTypeSmallInteger, alias: Quadrant , Coded Values: [1: NW] , [2: NE] , [3: SE] , ...3 more... )
• CROSSSTREET ( type: esriFieldTypeString, alias: Cross Street, length: 40 )
• WARD ( type: esriFieldTypeSmallInteger, alias: Ward , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...6 more... )
• HOUSENO ( type: esriFieldTypeString, alias: House Number, length: 12 )
• BLOCKKEY ( type: esriFieldTypeString, alias: Block Key, length: 100 )
• INOPERATION ( type: esriFieldTypeDate, alias: In Operation, length: 8 )
• LIGHTMANUFACTURER ( type: esriFieldTypeString, alias: Light Manufacturer, length: 25 , Coded Values: [Acuity: Acuity] , [Cree: Cree] , [General Electric: General Electric] , ...19 more... )
• TBASETYPE ( type: esriFieldTypeString, alias: T-Base Type, length: 25 , Coded Values: [Breakaway: Breakaway] , [DB: DB] , [Direct Anchored: Direct Anchored] , ...4 more... )
• LASTPAINTED ( type: esriFieldTypeDate, alias: Last Painted, length: 8 )
• LEDINOPERATION ( type: esriFieldTypeDate, alias: LED In Operation, length: 8 )
• POLECOLOR ( type: esriFieldTypeString, alias: Pole Color, length: 25 , Coded Values: [Black: Black] , [Gray: Gray] , [Red: Red] , ...2 more... )
• CCT ( type: esriFieldTypeString, alias: Common Color Temperature, length: 20 , Coded Values: [1000: 1000] , [2000: 2000] , [2500: 2500] , ...6 more... )
• WATTAGE2 ( type: esriFieldTypeString, alias: Wattage 2, length: 15 , Coded Values: [10: 10] , [100: 100] , [1000: 1000] , ...33 more... )
• FEEDMANHOLE ( type: esriFieldTypeString, alias: Feed Manhole, length: 25 , Coded Values: [N/A: N/A] , [DDOT: DDOT] , [PEPCO: PEPCO] )
• ARMSTYLE ( type: esriFieldTypeString, alias: Arm Style, length: 50 , Coded Values: [Decorated Straight: Decorated Straight] , [Decorated Truss Wrap: Decorated Truss Wrap] , [Decorated Wrap: Decorated Wrap] , ...16 more... )
• ARMLENGTH2 ( type: esriFieldTypeSmallInteger, alias: Arm Length 2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...9 more... )
• ROADCLASSIFICATION ( type: esriFieldTypeInteger, alias: Road Classification , Coded Values: [11: Interstate] , [12: Other Freeway and Expressway] , [14: Principal Arterial] , ...3 more... )
• ISMODIFIED ( type: esriFieldTypeString, alias: Is Modified, length: 25 , Coded Values: [YES: YES] , [NO: NO] )
• POLEMANUFACTURER ( type: esriFieldTypeString, alias: Pole Manufacturer, length: 50 , Coded Values: [Gray Bar: Gray Bar] , [Miller Metal: Miller Metal] , [Miller Metal/Traffic Systems Technologies: Miller Metal/Traffic Systems Technologies] , ...10 more... )
• FEEDMANHOLEID ( type: esriFieldTypeString, alias: Feed Manhole Identifier, length: 25 )
• SIDE ( type: esriFieldTypeString, alias: Side, length: 50 )
• LANDUSE ( type: esriFieldTypeString, alias: Land Use, length: 50 )
• AMIS_NETWORK_STATUS ( type: esriFieldTypeString, alias: AMIS Network Status, length: 255 , Coded Values: [EXISTING: Existing Network] , [IMPROVED: Improved Network] , [EXPANDED: Expanded Network] )
• ANCHORBOLTCOVERSRATING ( type: esriFieldTypeString, alias: Anchor Bolt Covers Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• ANCHORBOLTSRATING ( type: esriFieldTypeString, alias: Anchor Bolts Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• TBASERATING ( type: esriFieldTypeString, alias: T-Base Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• HANDHOLERATING ( type: esriFieldTypeString, alias: Hand Hole Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• FOUNDATIONRATING ( type: esriFieldTypeString, alias: Foundation Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• METALPOLERATING ( type: esriFieldTypeString, alias: Metal Pole Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• WOODPOLERATING ( type: esriFieldTypeString, alias: Wood Pole Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• BRACKETSANDARMSRATING ( type: esriFieldTypeString, alias: Brackets and Arms Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• LIGHTSRATING ( type: esriFieldTypeString, alias: Lights Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• GLARESHIELDRATING ( type: esriFieldTypeString, alias: Glare Shield Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• BRIDGEHWYSITE ( type: esriFieldTypeString, alias: Bridge/Highway Site, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• WRONGPOLETAGID ( type: esriFieldTypeString, alias: Wrong Pole Tag Identifier, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• MISSINGPOLE ( type: esriFieldTypeString, alias: Missing Pole, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• DAMAGEDSITE ( type: esriFieldTypeString, alias: Damaged Site, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• CONSTRUCTIONSITES ( type: esriFieldTypeString, alias: Construction Sites, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• LAT ( type: esriFieldTypeString, alias: Latitude, length: 255 )
• LON ( type: esriFieldTypeString, alias: Longitude, length: 255 )
• POLESHAFTRATING ( type: esriFieldTypeString, alias: Pole Shaft Rating, length: 255 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• POLETAG ( type: esriFieldTypeString, alias: Pole Tag, length: 255 )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition , Coded Values: [1: Need Immediate Replacement] , [2: Replace Within a Year] , [3: Need Inspection in 2 years] , ...1 more... )
• WARRANTY_DATE ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• LIGHT_MODEL ( type: esriFieldTypeString, alias: Light Model, length: 255 )
• MANUFACTURE_DATE ( type: esriFieldTypeDate, alias: Manufacture Date, length: 8 )
• CLIGHT_DIMMING_1 ( type: esriFieldTypeString, alias: C Light Dimming 1, length: 25 )
• SE_ANNO_CAD_DATA ( type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

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

  Iteminfo   Thumbnail   Metadata