Parent Layer: Available Poles (Elligible for New Cell)

Name: Light Fixture

Display Field: LEDMODELNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 1000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.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: 6115510.951385334
YMin: 1885548.3689846396
XMax: 6215267.2021081
YMax: 1991158.2637355775
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LEDSTATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Non-LED
  Description: N/A
  Symbol:
  
• Value: 1
  Label: LED
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• CREATIONDATE ( nullable: true, length: 8, alias: Creation Date, type: esriFieldTypeDate )
• CREATOR ( nullable: true, length: 40, alias: Creator, type: esriFieldTypeString )
• PGEITEMCODEHISTORIC ( nullable: true, length: 20, alias: PGE Item Code Historic, type: esriFieldTypeString )
• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• FACILITYID ( nullable: true, length: 20, alias: Facility Identifier, type: esriFieldTypeString )
• INTID ( nullable: true, alias: Integer ID, type: esriFieldTypeInteger )
• BADGEID ( nullable: true, length: 20, alias: Pole Number, type: esriFieldTypeString )
• IMBADGE ( nullable: true, length: 20, alias: IM Pole Number, type: esriFieldTypeString )
• LIGHTLETTER ( nullable: true, length: 10, alias: Light Letter, type: esriFieldTypeString , Coded Values: [Z: Z] , [Y: Y] , [X: X] , ...23 more... )
• LOCDESC ( nullable: true, length: 255, alias: Location Description, type: esriFieldTypeString )
• LIGHTFIXTURETYPE ( nullable: true, length: 30, alias: Light Fixture Type, type: esriFieldTypeString , Coded Values: [AIRPORT: AIRPORT] , [BANNER LIGHT: BANNER LIGHT] , [CANE: CANE] , ...24 more... )
• LAMPTYPE ( nullable: true, length: 20, alias: Lamp Type, type: esriFieldTypeString , Coded Values: [10 Watt LPS: 10 Watt LPS] , [100 Watt HPS: 100 Watt HPS] , [100 Watt MH: 100 Watt MH] , ...19 more... )
• MOUNTTYPE ( nullable: true, length: 20, alias: Mount Type, type: esriFieldTypeString , Coded Values: [MAST ARM: MAST ARM] , [POST TOP: POST TOP] , [SOFFIT: SOFFIT] , ...3 more... )
• LIGHTSTATUS ( nullable: true, length: 15, alias: Light Status, type: esriFieldTypeString , Coded Values: [EXISTING: EXISTING] , [REMOVED: REMOVED] , [TURNED OFF: TURNED OFF] , ...2 more... )
• LUMINAIRECONTROLLER ( nullable: true, length: 40, alias: Luminaire Controller, type: esriFieldTypeString , Coded Values: [CABINET: CABINET] , [ITRON: ITRON] , [NETWORK ID: NETWORK ID] , ...9 more... )
• POLEUSE ( nullable: true, length: 50, alias: Pole Use, type: esriFieldTypeString , Coded Values: [ST LIGHT ONLY: ST LIGHT ONLY] , [TRAFFIC SIGNAL ONLY: TRAFFIC SIGNAL ONLY] , [PEDESTRIAN LIGHT: PEDESTRIAN LIGHT] , ...3 more... )
• VOLTAGE ( nullable: true, alias: Voltage, type: esriFieldTypeInteger , Coded Values: [120: 120] , [130: 130] , [208: 208] , ...4 more... )
• OWNERSHIP ( nullable: true, length: 50, alias: Ownership, type: esriFieldTypeString , Coded Values: [CALTRAN: CALTRAN] , [COUNTY: COUNTY] , [CSJ-AIR: CSJ-AIR] , ...8 more... )
• SECOID ( nullable: true, alias: SECO ID, type: esriFieldTypeInteger )
• ZIGBEEID ( nullable: true, length: 50, alias: ZIGBEE ID, type: esriFieldTypeString )
• LEDMANUFACTURER ( nullable: true, length: 50, alias: LED Manufacturer, type: esriFieldTypeString , Coded Values: [Cooper: Cooper] , [Cree: Cree] , [EIKO: EIKO] , ...15 more... )
• LEDMODELNAME ( nullable: true, length: 100, alias: LED Model Name, type: esriFieldTypeString , Coded Values: [AR13-48N-MV-NW-3-DB1-060-PCR7-CR-WL: AR13-48N-MV-NW-3-DB1-060-PCR7-CR-WL] , [AR13-48N-MV-NW-3-DB1-100-PCR7-CR-WL: AR13-48N-MV-NW-3-DB1-100-PCR7-CR-WL] , [AR13-48N-MV-NW-3-DB1-120-PCR7-CR-WL: AR13-48N-MV-NW-3-DB1-120-PCR7-CR-WL] , ...261 more... )
• LEDCOMMWATTAGE ( nullable: true, alias: LED Commisioned Wattage, type: esriFieldTypeDouble )
• LEDMAXWATTAGE ( nullable: true, alias: LED Max Wattage, type: esriFieldTypeDouble )
• LEDMODELID ( nullable: true, length: 10, alias: LED Model ID, type: esriFieldTypeString , Coded Values: [A: A] , [A1: A1] , [A3: A3] , ...83 more... )
• LEDINSTALDATE ( nullable: true, length: 8, alias: LED Install Date, type: esriFieldTypeDate )
• FIRSTCOMDATE ( nullable: true, length: 8, alias: First Communication Date, type: esriFieldTypeDate )
• LEDSTATUS ( nullable: true, alias: LED Status, type: esriFieldTypeInteger , Coded Values: [0: 0] , [1: 1] )
• LEDWARRANTYEXPIRATIONDATE ( nullable: true, length: 8, alias: LED warranty expiration date, type: esriFieldTypeDate )
• LEDCONVERSIONDATE ( nullable: true, length: 8, alias: LED conversion date, type: esriFieldTypeDate )
• PROJECT ( nullable: true, length: 100, alias: Project Name, type: esriFieldTypeString )
• GROUPING ( nullable: true, length: 50, alias: Grouping, type: esriFieldTypeString , Coded Values: [Collector: Collector] , [Collector High Ped: Collector High Ped] , [Collector Med Ped: Collector Med Ped] , ...14 more... )
• SLNOTES ( nullable: true, length: 255, alias: SL Program Notes, type: esriFieldTypeString )
• SHOPID ( nullable: true, length: 10, alias: Shop ID, type: esriFieldTypeString )
• PGEITEMCODE ( nullable: true, length: 20, alias: PGE Item Code, type: esriFieldTypeString , Coded Values: [HPS-Q: HPS-Q] , [LED: LED] , [S-H-100: S-H-100] , ...96 more... )
• PGESPID ( nullable: true, length: 20, alias: PGE SPID, type: esriFieldTypeString )
• PGESAID ( nullable: true, length: 15, alias: PGE SA ID, type: esriFieldTypeString )
• PGERATE ( nullable: true, length: 15, alias: PGE Rate, type: esriFieldTypeString , Coded Values: [LS1-A: LS1-A] , [LS1-E: LS1-E] , [LS1-F: LS1-F] , ...4 more... )
• ELESERVICE ( nullable: true, length: 20, alias: Electric Service, type: esriFieldTypeString , Coded Values: [OVERHEAD: OVERHEAD] , [UNDERGROUND: UNDERGROUND] , [OTHER: OTHER] , ...1 more... )
• COCOMMENT ( nullable: true, length: 255, alias: PW Connect Order Comment, type: esriFieldTypeString )
• CONUMBER ( nullable: true, length: 10, alias: PW Connect Order Number, type: esriFieldTypeString )
• COLOCATION ( nullable: true, length: 100, alias: PW Files Location, type: esriFieldTypeString )
• COHISTORY ( nullable: true, length: 255, alias: PW Connect Order History, type: esriFieldTypeString )
• LATITUDE ( nullable: true, alias: Latitude, type: esriFieldTypeDouble )
• LONGITUDE ( nullable: true, alias: Longitude, type: esriFieldTypeDouble )
• HYPERLINK ( nullable: true, length: 100, alias: Image, type: esriFieldTypeString )
• POLEJOINSTATUS ( nullable: true, length: 50, alias: Pole Join Status, type: esriFieldTypeString )
• POLEJOINDISTANCE ( nullable: true, alias: Pole Join Distance, type: esriFieldTypeDouble )
• ISDUPLICATE ( nullable: true, length: 5, alias: Is Duplicate, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• FMEDATE ( nullable: true, length: 8, alias: Date FME Last Run, type: esriFieldTypeDate )
• LASTUPDATE ( nullable: true, length: 8, alias: Last Update Date, type: esriFieldTypeDate )
• LASTEDITOR ( nullable: true, length: 40, alias: Last Editor, type: esriFieldTypeString )
• NOTES ( nullable: true, length: 255, alias: IM Notes, type: esriFieldTypeString )
• SHAPE ( nullable: true, alias: SHAPE, type: esriFieldTypeGeometry )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• ENTERPRISEID ( nullable: true, length: 20, alias: Enterprise ID, type: esriFieldTypeString )
• SHIELDDIRECTION ( nullable: true, length: 10, alias: Shield Direction, type: esriFieldTypeString , Coded Values: [Front: Front] , [Back: Back] , [Cul-de-sac: Cul-de-sac] , ...1 more... )
• ECOBRASTATUS ( nullable: true, length: 40, alias: ECobra Status, type: esriFieldTypeString , Coded Values: [Under Warranty: Under Warranty] , [Post Warranty: Post Warranty] , [Post Warranty - Replaced: Post Warranty - Replaced] , ...1 more... )
• LUMENS ( nullable: true, alias: Lumen Output, type: esriFieldTypeInteger )

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

  Iteminfo   Thumbnail   Metadata