View In:   ArcGIS Online Map Viewer

Name: Street Light

Display Field: LuminaireID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 04164541760d4b7b9e15e084ffbaf162

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Owner
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: Alliant Energy
  Label: Alliant Energy
  Description: N/A
  Symbol:
  
• Value: City of Dubuque
  Label: City of Dubuque
  Description: N/A
  Symbol:
  
• Value: Combination Ownership
  Label: Combination Ownership
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [184, 184, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Maquoketa Valley
  Label: Maquoketa Valley
  Description: N/A
  Symbol:
  
• Value: Other
  Label: Other
  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 TrueCurve: false
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 )
• 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... )
• 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... )
• 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... )
• 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 )
• SymbolRotation ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: SymbolRotation )
• Note ( type: esriFieldTypeString, alias: Note, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Note )
• 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
Domains:
• Metered:
  Inherited
• Status:
  Inherited
• Owner:
  Inherited
• LampType:
  Inherited
• FixtureType:
  Inherited
• LocationOn:
  Inherited
• ControlType:
  Inherited
• Shielding:
  Inherited
• Role:
  Inherited
• DedicatedPole:
  Inherited
• SharedPole:
  Inherited
• PhotoEye:
  Inherited
• LightDistributionType:
  Inherited
• PhaseDesignation:
  Inherited
Templates:
• Name: Alliant Energy
  Description:
  Prototype:
  SymbolRotation: null
  Note: null
  LuminaireID: null
  Metered: null
  Status: null
  Owner: Alliant Energy
  LampType: null
  FixtureType: null
  Wattage: null
  OperatingVoltage: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: City of Dubuque
Name: City of Dubuque
Domains:
• Metered:
  Inherited
• Status:
  Inherited
• Owner:
  Inherited
• LampType:
  Inherited
• FixtureType:
  Inherited
• LocationOn:
  Inherited
• ControlType:
  Inherited
• Shielding:
  Inherited
• Role:
  Inherited
• DedicatedPole:
  Inherited
• SharedPole:
  Inherited
• PhotoEye:
  Inherited
• LightDistributionType:
  Inherited
• PhaseDesignation:
  Inherited
Templates:
• Name: Luminaire
  Description:
  Prototype:
  OperatingVoltage: null
  Note: null
  Owner: City of Dubuque
  SymbolRotation: null
  Status: Active
  LampType: LED
  FixtureType: Cobra Head
  Wattage: 160
  LuminaireID: null
  Metered: Yes
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: STERNBERG LUMINAIRE
  Description:
  Prototype:
  Metered: Yes
  OperatingVoltage: null
  FixtureType: Pendant
  SymbolRotation: null
  Status: Active
  Owner: City of Dubuque
  LampType: LED
  Note: null
  Wattage: 112
  LuminaireID: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: 94 WATT ELM
  Description:
  Prototype:
  Metered: Yes
  OperatingVoltage: null
  FixtureType: Pendant
  SymbolRotation: 75
  Status: Active
  Owner: City of Dubuque
  LampType: LED
  Note: null
  Wattage: 94
  LuminaireID: 5105
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Rustic Point Light
  Description:
  Prototype:
  Metered: Yes
  Note: null
  Owner: City of Dubuque
  OperatingVoltage: null
  LampType: LED
  Status: Active
  Wattage: 55
  LuminaireID: null
  SymbolRotation: 180
  FixtureType: Post Top Subdivision
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Combination Ownership
Name: Combination Ownership
Domains:
• Metered:
  Inherited
• Status:
  Inherited
• Owner:
  Inherited
• LampType:
  Inherited
• FixtureType:
  Inherited
• LocationOn:
  Inherited
• ControlType:
  Inherited
• Shielding:
  Inherited
• Role:
  Inherited
• DedicatedPole:
  Inherited
• SharedPole:
  Inherited
• PhotoEye:
  Inherited
• LightDistributionType:
  Inherited
• PhaseDesignation:
  Inherited
Templates:
• Name: Combination Ownership
  Description:
  Prototype:
  SymbolRotation: null
  Note: null
  LuminaireID: null
  Metered: null
  Status: null
  Owner: Combination Ownership
  LampType: null
  FixtureType: null
  Wattage: null
  OperatingVoltage: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Maquoketa Valley
Name: Maquoketa Valley
Domains:
• Metered:
  Inherited
• Status:
  Inherited
• Owner:
  Inherited
• LampType:
  Inherited
• FixtureType:
  Inherited
• LocationOn:
  Inherited
• ControlType:
  Inherited
• Shielding:
  Inherited
• Role:
  Inherited
• DedicatedPole:
  Inherited
• SharedPole:
  Inherited
• PhotoEye:
  Inherited
• LightDistributionType:
  Inherited
• PhaseDesignation:
  Inherited
Templates:
• Name: Maquoketa Valley
  Description:
  Prototype:
  SymbolRotation: null
  Note: null
  LuminaireID: null
  Metered: null
  Status: null
  Owner: Maquoketa Valley
  LampType: null
  FixtureType: null
  Wattage: null
  OperatingVoltage: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Other
Name: Other
Domains:
• Metered:
  Inherited
• Status:
  Inherited
• Owner:
  Inherited
• LampType:
  Inherited
• FixtureType:
  Inherited
• LocationOn:
  Inherited
• ControlType:
  Inherited
• Shielding:
  Inherited
• Role:
  Inherited
• DedicatedPole:
  Inherited
• SharedPole:
  Inherited
• PhotoEye:
  Inherited
• LightDistributionType:
  Inherited
• PhaseDesignation:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  SymbolRotation: null
  Note: null
  LuminaireID: null
  Metered: null
  Status: null
  Owner: Other
  LampType: null
  FixtureType: null
  Wattage: null
  OperatingVoltage: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Lighting Controller (6) -- Related To: Lighting Controller (7)
• Electric Meter (4) -- Related To: Electric Meter (6)
• Pole (7) -- Related To: Poles (11)

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:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata