View In:
ArcGIS Online Map Viewer
Name: Street Light
Display Field: LuminaireID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: feb709353e384fa3acb2afa0217c862e
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: 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:
Default Label:
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:
-
Value: Maquoketa Valley
Label: Maquoketa Valley
Description: N/A
Symbol:
-
Value: Other
Label: Other
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: 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
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
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: null
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
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: STL
Metered: Yes
LightDistributionType: Type 3
Shielding: No
LuminaireManufacturer: PHILLIPS ROADVIEW: RFM-160W48LED4KT-R3M-UNIV-DING-RCD-SP2-GY3-PH9.
Wattage: 160
FixtureType: Cobra Head
LocationOn: CLARKE DR
FootCandle: null
CircuitNumber: null
MastarmID: null
SharedPole: No
ControlType: PHT
PhotoEye: No
BillingPremiseNo: null
Owner: City of Dubuque
Status: Active
LampType: LED
MountingHeight: 30
DedicatedPole: No
InstallDate: 1533081600000
LocationAt: W LOCUST ST
Note: null
LuminaireID: null
LightControllerID: 8808
MeterID: 8412
Lumens: 17700
OperatingVoltage: null
NominalVoltage: null
SymbolRotation: null
PInstallRating: null
Drawing Tool: esriFeatureEditToolPoint
-
Name: STERNBERG LUMINAIRE
Description:
Prototype:
PoleID: null
LightControllerID: null
SymbolRotation: null
PInstallRating: null
PhaseDesignation: null
LuminaireID: null
Role: STL
Metered: Yes
Lumens: 23660
LightDistributionType: Type 3
Shielding: No
LuminaireManufacturer: STERNBERG LIGHTING
Wattage: 112
FixtureType: Pendant
LocationOn: E 17TH ST
FootCandle: null
CircuitNumber: 1
MastarmID: null
SharedPole: No
ControlType: PHT
PhotoEye: No
OperatingVoltage: null
NominalVoltage: null
BillingPremiseNo: null
MeterID: null
Owner: City of Dubuque
Status: Active
LampType: LED
MountingHeight: 27
DedicatedPole: No
InstallDate: 1546300800000
LocationAt: null
Note: null
Drawing Tool: esriFeatureEditToolPoint
-
Name: 94 WATT ELM
Description:
Prototype:
PoleID: 24696
LightControllerID: null
SymbolRotation: 75
PInstallRating: null
PhaseDesignation: null
LuminaireID: 5105
Role: STL
Metered: Yes
Lumens: 11520
LightDistributionType: Type 3
Shielding: No
LuminaireManufacturer: STERNBERG
Wattage: 94
FixtureType: Pendant
LocationOn: ELM ST
FootCandle: null
CircuitNumber: null
MastarmID: null
SharedPole: No
ControlType: null
PhotoEye: null
OperatingVoltage: null
NominalVoltage: 100
BillingPremiseNo: null
MeterID: null
Owner: City of Dubuque
Status: Active
LampType: LED
MountingHeight: 18
DedicatedPole: No
InstallDate: 1356998400000
LocationAt: E 9TH ST
Note: null
Drawing Tool: esriFeatureEditToolPoint
-
Name: Rustic Point Light
Description:
Prototype:
PInstallRating: null
Note: null
LuminaireID: null
PoleID: null
LightControllerID: 9209
MastarmID: null
MeterID: 8812
BillingPremiseNo: null
Metered: Yes
LocationOn: SICKLE LN
LocationAt: null
Status: Active
Owner: City of Dubuque
LampType: LED
ControlType: PHT
MountingHeight: 20
Shielding: No
Role: STL
LuminaireManufacturer: null
DedicatedPole: Yes
SharedPole: No
PhotoEye: No
FixtureType: Post Top Subdivision
LightDistributionType: Type 3
Lumens: null
FootCandle: null
Wattage: 55
OperatingVoltage: null
NominalVoltage: null
PhaseDesignation: null
CircuitNumber: null
InstallDate: 1504224000000
SymbolRotation: 180
Drawing Tool: esriFeatureEditToolPoint
ID: Combination Ownership
Name: Combination Ownership
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: Combination Ownership
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: Combination Ownership
LampType: null
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: Maquoketa Valley
Name: Maquoketa Valley
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: Maquoketa Valley
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: Maquoketa Valley
LampType: null
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: Other
Name: Other
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: Other
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: Other
LampType: null
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
Relationships:
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
Query Related Records
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata