View In:   ArcGIS Online Map Viewer

Name: Luminaire

Display Field: LuminaireID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 00ac1ff55886438681c0a33cf6030d02

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 5654369.629351214
YMin: 3625032.155789137
XMax: 5692037.84699364
YMax: 3676906.977236137
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Owner
Field 2: LampType
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Alliant Energy,HPS
  Label: Alliant Energy, HPS
  Description: N/A
  Symbol:
  
• Value: Alliant Energy,LED
  Label: Alliant Energy, LED
  Description: N/A
  Symbol:
  
• Value: City of Dubuque,HPS
  Label: City of Dubuque, HPS
  Description: N/A
  Symbol:
  
• Value: City of Dubuque,Incandescent
  Label: City of Dubuque, Incandescent
  Description: N/A
  Symbol:
  
• Value: City of Dubuque,LED
  Label: City of Dubuque, LED
  Description: N/A
  Symbol:
  
• Value: City of Dubuque,MH
  Label: City of Dubuque, MH
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [Wattage]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: 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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Owner

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LuminaireID ( type: esriFieldTypeString, alias: Luminaire ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LuminaireID )
• PoleID ( type: esriFieldTypeString, alias: Pole ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PoleID )
• LightControllerID ( type: esriFieldTypeString, alias: Light Controller ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LightControllerID )
• MastarmID ( type: esriFieldTypeString, alias: Mastarm ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MastarmID )
• MeterID ( type: esriFieldTypeString, alias: Meter ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MeterID )
• BillingPremiseNo ( type: esriFieldTypeString, alias: Billing Premise Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BillingPremiseNo )
• Metered ( type: esriFieldTypeString, alias: Metered?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Metered , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• LocationOn ( type: esriFieldTypeString, alias: Location On, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationOn , Coded Values: [ABACA CT: ABACA CT] , [ABBEY WOOD CT: ABBEY WOOD CT] , [ABBOTT ST: ABBOTT ST] , ...1213 more... )
• LocationAt ( type: esriFieldTypeString, alias: Location At, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationAt )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Abandoned: Abandoned in Place] , [Active: Active] , [Inactive: Inactive] , ...4 more... )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner , Coded Values: [City of Dubuque: City of Dubuque] , [Alliant Energy: Alliant Energy] , [Maquoketa Valley: Maquoketa Valley] , ...2 more... )
• LampType ( type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LampType , Coded Values: [HPS: HPS] , [MH: MH] , [LED: LED] , ...4 more... )
• ControlType ( type: esriFieldTypeString, alias: Control Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ControlType , Coded Values: [PHT: Photocell] , [TMR: TImer] , [OTH: Other] )
• MountingHeight ( type: esriFieldTypeSmallInteger, alias: Mounting Height from Surface, editable: true, nullable: true, defaultValue: null, modelName: MountingHeight )
• Shielding ( type: esriFieldTypeString, alias: Shielding?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Shielding , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• Role ( type: esriFieldTypeString, alias: Luminaire Role, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Role , Coded Values: [FLD: Flood Light] , [SEC: Security Light] , [STL: Street Light] , ...4 more... )
• LuminaireManufacturer ( type: esriFieldTypeString, alias: Luminaire Manufacturer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LuminaireManufacturer )
• DedicatedPole ( type: esriFieldTypeString, alias: Located on Dedicated Pole?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DedicatedPole , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• SharedPole ( type: esriFieldTypeString, alias: Located on Shared Pole?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SharedPole , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• PhotoEye ( type: esriFieldTypeString, alias: Photo Eye?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PhotoEye , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• FixtureType ( type: esriFieldTypeString, alias: Fixture Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FixtureType , Coded Values: [Accent: Accent] , [Area/Site: Area/Site] , [Bollard: Bollard] , ...9 more... )
• LightDistributionType ( type: esriFieldTypeString, alias: Light Distribution Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LightDistributionType , Coded Values: [Type 1: Type 1] , [Type 2: Type 2] , [Type 3: Type 3] , ...2 more... )
• Lumens ( type: esriFieldTypeInteger, alias: Lumens, editable: true, nullable: true, defaultValue: null, modelName: Lumens )
• FootCandle ( type: esriFieldTypeDouble, alias: Foot Candle (FC) Reading, editable: true, nullable: true, defaultValue: null, modelName: FootCandle )
• Wattage ( type: esriFieldTypeDouble, alias: Wattage, editable: true, nullable: true, defaultValue: null, modelName: Wattage )
• OperatingVoltage ( type: esriFieldTypeDouble, alias: Operating Voltage, editable: true, nullable: true, defaultValue: null, modelName: OperatingVoltage )
• NominalVoltage ( type: esriFieldTypeDouble, alias: Nominal Voltage, editable: true, nullable: true, defaultValue: null, modelName: NominalVoltage )
• PhaseDesignation ( type: esriFieldTypeInteger, alias: Phase Designation, editable: true, nullable: true, defaultValue: null, modelName: PhaseDesignation , Coded Values: [4: A] , [6: AB] , [5: AC] , ...4 more... )
• CircuitNumber ( type: esriFieldTypeDouble, alias: Circuit Number, editable: true, nullable: true, defaultValue: null, modelName: CircuitNumber )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• SymbolRotation ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: SymbolRotation )
• PInstallRating ( type: esriFieldTypeSmallInteger, alias: Proposed Install Rating, editable: true, nullable: true, defaultValue: null, modelName: PInstallRating )
• Note ( type: esriFieldTypeString, alias: Note, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Note )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Alliant Energy
Name: Alliant Energy, HPS
Domains:
• Metered:
  Inherited
• LocationOn:
  Inherited
• Status:
  Inherited
• Owner:
  Inherited
• LampType:
  Inherited
• ControlType:
  Inherited
• Shielding:
  Inherited
• Role:
  Inherited
• DedicatedPole:
  Inherited
• SharedPole:
  Inherited
• PhotoEye:
  Inherited
• FixtureType:
  Inherited
• LightDistributionType:
  Inherited
• PhaseDesignation:
  Inherited
Templates:
• Name: Alliant Energy, HPS
  Description:
  Prototype:
  PInstallRating: null
  Note: null
  LuminaireID: null
  PoleID: null
  LightControllerID: null
  MastarmID: null
  MeterID: null
  BillingPremiseNo: null
  Metered: null
  LocationOn: null
  LocationAt: null
  Status: null
  Owner: Alliant Energy
  LampType: HPS
  ControlType: null
  MountingHeight: null
  Shielding: null
  Role: null
  LuminaireManufacturer: null
  DedicatedPole: null
  SharedPole: null
  PhotoEye: null
  FixtureType: null
  LightDistributionType: null
  Lumens: null
  FootCandle: null
  Wattage: null
  OperatingVoltage: null
  NominalVoltage: null
  PhaseDesignation: null
  CircuitNumber: null
  InstallDate: null
  SymbolRotation: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Alliant Energy, LED
  Description:
  Prototype:
  PInstallRating: null
  Note: null
  LuminaireID: null
  PoleID: null
  LightControllerID: null
  MastarmID: null
  MeterID: null
  BillingPremiseNo: null
  Metered: null
  LocationOn: null
  LocationAt: null
  Status: null
  Owner: Alliant Energy
  LampType: LED
  ControlType: null
  MountingHeight: null
  Shielding: null
  Role: null
  LuminaireManufacturer: null
  DedicatedPole: null
  SharedPole: null
  PhotoEye: null
  FixtureType: null
  LightDistributionType: null
  Lumens: null
  FootCandle: null
  Wattage: null
  OperatingVoltage: null
  NominalVoltage: null
  PhaseDesignation: null
  CircuitNumber: null
  InstallDate: null
  SymbolRotation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: City of Dubuque
Name: City of Dubuque, HPS
Domains:
• Metered:
  Inherited
• LocationOn:
  Inherited
• Status:
  Inherited
• Owner:
  Inherited
• LampType:
  Inherited
• ControlType:
  Inherited
• Shielding:
  Inherited
• Role:
  Inherited
• DedicatedPole:
  Inherited
• SharedPole:
  Inherited
• PhotoEye:
  Inherited
• FixtureType:
  Inherited
• LightDistributionType:
  Inherited
• PhaseDesignation:
  Inherited
Templates:
• Name: Luminaire
  Description:
  Prototype:
  PoleID: null
  PhaseDesignation: null
  Role: TRL
  Metered: Yes
  LightDistributionType: Type 3
  Shielding: No
  LuminaireManufacturer: STERNBERG LIGHTING BOULEVARD D650SRLED/4ARC45T3.
  Wattage: 64
  FixtureType: Post Top Historical
  LocationOn: null
  FootCandle: null
  CircuitNumber: 3
  MastarmID: null
  SharedPole: No
  ControlType: PHT
  PhotoEye: No
  BillingPremiseNo: null
  Owner: City of Dubuque
  Status: Active
  LampType: LED
  MountingHeight: 14
  DedicatedPole: No
  InstallDate: 1491004800000
  LocationAt: BEE BRANCH TRAIL
  Note: null
  LuminaireID: null
  LightControllerID: 1603
  MeterID: 1602
  Lumens: 5955
  OperatingVoltage: 120
  NominalVoltage: null
  SymbolRotation: 215
  PInstallRating: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: City of Dubuque, HPS
  Description:
  Prototype:
  PInstallRating: null
  Note: null
  LuminaireID: null
  PoleID: null
  LightControllerID: null
  MastarmID: null
  MeterID: null
  BillingPremiseNo: null
  Metered: null
  LocationOn: null
  LocationAt: null
  Status: null
  Owner: City of Dubuque
  LampType: HPS
  ControlType: null
  MountingHeight: null
  Shielding: null
  Role: null
  LuminaireManufacturer: null
  DedicatedPole: null
  SharedPole: null
  PhotoEye: null
  FixtureType: null
  LightDistributionType: null
  Lumens: null
  FootCandle: null
  Wattage: null
  OperatingVoltage: null
  NominalVoltage: null
  PhaseDesignation: null
  CircuitNumber: null
  InstallDate: null
  SymbolRotation: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: City of Dubuque, Incandescent
  Description:
  Prototype:
  PInstallRating: null
  Note: null
  LuminaireID: null
  PoleID: null
  LightControllerID: null
  MastarmID: null
  MeterID: null
  BillingPremiseNo: null
  Metered: null
  LocationOn: null
  LocationAt: null
  Status: null
  Owner: City of Dubuque
  LampType: Incandescent
  ControlType: null
  MountingHeight: null
  Shielding: null
  Role: null
  LuminaireManufacturer: null
  DedicatedPole: null
  SharedPole: null
  PhotoEye: null
  FixtureType: null
  LightDistributionType: null
  Lumens: null
  FootCandle: null
  Wattage: null
  OperatingVoltage: null
  NominalVoltage: null
  PhaseDesignation: null
  CircuitNumber: null
  InstallDate: null
  SymbolRotation: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: City of Dubuque, MH
  Description:
  Prototype:
  PInstallRating: null
  Note: null
  LuminaireID: null
  PoleID: null
  LightControllerID: null
  MastarmID: null
  MeterID: null
  BillingPremiseNo: null
  Metered: null
  LocationOn: null
  LocationAt: null
  Status: null
  Owner: City of Dubuque
  LampType: MH
  ControlType: null
  MountingHeight: null
  Shielding: null
  Role: null
  LuminaireManufacturer: null
  DedicatedPole: null
  SharedPole: null
  PhotoEye: null
  FixtureType: null
  LightDistributionType: null
  Lumens: null
  FootCandle: null
  Wattage: null
  OperatingVoltage: null
  NominalVoltage: null
  PhaseDesignation: null
  CircuitNumber: null
  InstallDate: null
  SymbolRotation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata