View In:   ArcGIS Online Map Viewer

Name: Street Lights

Display Field: CMMSID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: 6171501.558340222
YMin: 2054548.3600521386
XMax: 6215447.920906633
YMax: 2091216.459944144
Spatial Reference: 103005  (6420)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PoleType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Traffic Signal
  Label: Traffic Signal
  Description: N/A
  Symbol:
  
• Value: Ornamental
  Label: Ornamental
  Description: N/A
  Symbol:
  
• Value: Power Pole
  Label: Power Pole with Street Light
  Description: N/A
  Symbol:
  
• Value: Street Light
  Label: Street Light
  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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: PoleType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeInteger, alias: Asset ID, editable: true, nullable: true, defaultValue: null, modelName: AssetID )
• CMMSID ( type: esriFieldTypeString, alias: CMMS ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: CMMSID )
• GeneralLedgerKey ( type: esriFieldTypeDouble, alias: General Ledger Key, editable: true, nullable: true, defaultValue: null, modelName: GeneralLedgerKey )
• PGEBadgeNumber ( type: esriFieldTypeString, alias: PGE Badge Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PGEBadgeNumber )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 18, defaultValue: null, modelName: AssetType )
• PoleType ( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 14, defaultValue: null, modelName: PoleSubType , Coded Values: [Ornamental: Ornamental] , [Other: Other] , [Power Pole: Power Pole with Street Light] , ...3 more... )
• PoleMaterial ( type: esriFieldTypeString, alias: Pole Material, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PoleMaterial , Coded Values: [Aluminum: Aluminum] , [Cast Iron: Cast Iron] , [Concrete: Concrete] , ...3 more... )
• PoleHeight ( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PoleHeight , Coded Values: [12-15 Ft: 12-15 Ft] , [16-19 Ft: 16-19 Ft] , [20-24 Ft: 20-24 Ft] , ...5 more... )
• PoleColor ( type: esriFieldTypeString, alias: Pole Color, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PoleColor , Coded Values: [Black: Black] , [Green: Green] , [Grey: Grey] , ...1 more... )
• MastArmLength ( type: esriFieldTypeString, alias: Mast Arm Length, editable: true, nullable: true, length: 16, defaultValue: null, modelName: MastArmLength , Coded Values: [2-1/2 Ft: 2-1/2 Ft] , [4 Ft: 4 Ft] , [6 Ft: 6 Ft] , ...7 more... )
• MastArmType ( type: esriFieldTypeString, alias: Mast Arm Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MastArmType , Coded Values: [A-Frame With Guy: A-Frame With Guy] , [Bracket-Cantilever: Bracket-Cantilever] , [Bracket-Double Guy: Bracket-Double Guy] , ...1 more... )
• NumberOfBulbs ( type: esriFieldTypeSmallInteger, alias: Number of Bulbs, editable: true, nullable: true, defaultValue: null, modelName: NumberOfLumins , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• Circuit ( type: esriFieldTypeString, alias: Circuit, editable: true, nullable: true, length: 18, defaultValue: null, modelName: Circuit , Coded Values: [120 Volt: 120 Volt] , [240 Volt: 240 Volt] , [240V-High Pressure: 240V-High Pressure] , ...6 more... )
• BulbBrightness ( type: esriFieldTypeInteger, alias: Bulb Brightness, editable: true, nullable: true, defaultValue: null, modelName: BulbBrightness , Coded Values: [5500: 5500] , [5800: 5800] , [9500: 9500] , ...5 more... )
• BulbWattage ( type: esriFieldTypeSmallInteger, alias: Bulb Wattage, editable: true, nullable: true, defaultValue: null, modelName: Wattage , Coded Values: [25: 25] , [27: 27] , [49: 49] , ...10 more... )
• BulbType ( type: esriFieldTypeString, alias: Bulb Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LuminType , Coded Values: [Cobra Head: Cobra Head] , [Cut-off Optics: Cut-off Optics] , [Drop Prism: Drop Prism] , ...4 more... )
• BulbManufacturer ( type: esriFieldTypeString, alias: Bulb Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BulbManufacturer , Coded Values: [American Electric: American Electric] , [General Electric: General Electric] , [Joslyn: Joslyn] , ...4 more... )
• BulbModel ( type: esriFieldTypeString, alias: Bulb Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BulbModel , Coded Values: [GC1-30F: GC1-30F] , [J Series: J Series] , [Other: Other] )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 9, defaultValue: null, modelName: Condition , Coded Values: [New: New] , [Good: Good] , [Damaged: Damaged] , ...1 more... )
• PublicPrivate ( type: esriFieldTypeString, alias: Public or Private?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PubPvt , Coded Values: [PUB: Public] , [PVT: Private] )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Owner , Coded Values: [Alameda County: Alameda County] , [CalTrans: CalTrans] , [City of Livermore: City of Livermore] , ...3 more... )
• TractNumber ( type: esriFieldTypeString, alias: Tract Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TractNumber )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 80, defaultValue: null, modelName: Location )
• UsefulLife ( type: esriFieldTypeSmallInteger, alias: Useful Life, editable: true, nullable: true, defaultValue: null, modelName: UsefulLife )
• DateInstalled ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• InstallationCost ( type: esriFieldTypeDouble, alias: Installation Cost, editable: true, nullable: true, defaultValue: null, modelName: InstallationCost )
• ReplacementCost ( type: esriFieldTypeDouble, alias: Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• ConsequenceOfFailure ( type: esriFieldTypeSmallInteger, alias: Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• RiskOfFailure ( type: esriFieldTypeSmallInteger, alias: Risk of Failure, editable: true, nullable: true, defaultValue: null, modelName: RiskOfFailure )
• Risk ( type: esriFieldTypeSmallInteger, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• RehabilitationFrequency ( type: esriFieldTypeSmallInteger, alias: Rehab Frequency, editable: true, nullable: true, defaultValue: null, modelName: RehabilitationFrequency )
• RehabilitationCost ( type: esriFieldTypeDouble, alias: Rehab Cost, editable: true, nullable: true, defaultValue: null, modelName: RehabilitationCost )
• NextYearOfRehabilitation ( type: esriFieldTypeSmallInteger, alias: Next Year of Rehab, editable: true, nullable: true, defaultValue: null, modelName: NextYearOfRehabilitation )
• DateServiced ( type: esriFieldTypeDate, alias: DateServiced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateServiced )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Retired: Retired] , [Proposed: Proposed] )
• SymbolRotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: 0, modelName: SymRotation )
• CreateDate ( type: esriFieldTypeDate, alias: Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateBy ( type: esriFieldTypeString, alias: Create By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreateBy )
• RevDate ( type: esriFieldTypeDate, alias: Rev Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: RevDate )
• RevBy ( type: esriFieldTypeString, alias: Rev By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: RevBy )
• RevComments ( type: esriFieldTypeString, alias: Rev Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MaintenanceArea ( type: esriFieldTypeSmallInteger, alias: Maintenance Area, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceGrid , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...11 more... )

Types:

ID: Traffic Signal
Name: Traffic Signal
Domains:
• PoleType:
  Inherited
• PoleMaterial:
  Inherited
• PoleHeight:
  Inherited
• PoleColor:
  Inherited
• MastArmLength:
  Inherited
• MastArmType:
  Inherited
• NumberOfBulbs:
  Inherited
• Circuit:
  Inherited
• BulbBrightness:
  Inherited
• BulbWattage:
  Inherited
• BulbType:
  Inherited
• BulbManufacturer:
  Inherited
• BulbModel:
  Inherited
• Condition:
  Inherited
• PublicPrivate:
  Inherited
• Owner:
  Inherited
• Status:
  Inherited
• MaintenanceArea:
  Inherited
Templates:
• Name: Traffic Signal
  Description:
  Prototype:
  AssetType: null
  Status: null
  MaintenanceArea: null
  AssetID: null
  CMMSID: null
  GeneralLedgerKey: null
  PGEBadgeNumber: null
  PoleType: Traffic Signal
  PoleMaterial: null
  PoleHeight: null
  PoleColor: null
  MastArmLength: null
  MastArmType: null
  NumberOfBulbs: null
  Circuit: null
  BulbBrightness: null
  BulbWattage: null
  BulbType: null
  BulbManufacturer: null
  BulbModel: null
  Condition: null
  PublicPrivate: null
  Owner: null
  TractNumber: null
  Location: null
  UsefulLife: null
  DateInstalled: null
  InstallationCost: null
  ReplacementCost: null
  ConsequenceOfFailure: null
  RiskOfFailure: null
  Risk: null
  RehabilitationFrequency: null
  RehabilitationCost: null
  NextYearOfRehabilitation: null
  DateServiced: null
  SymbolRotation: 0
  RevComments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Ornamental
Name: Ornamental
Domains:
• PoleType:
  Inherited
• PoleMaterial:
  Inherited
• PoleHeight:
  Inherited
• PoleColor:
  Inherited
• MastArmLength:
  Inherited
• MastArmType:
  Inherited
• NumberOfBulbs:
  Inherited
• Circuit:
  Inherited
• BulbBrightness:
  Inherited
• BulbWattage:
  Inherited
• BulbType:
  Inherited
• BulbManufacturer:
  Inherited
• BulbModel:
  Inherited
• Condition:
  Inherited
• PublicPrivate:
  Inherited
• Owner:
  Inherited
• Status:
  Inherited
• MaintenanceArea:
  Inherited
Templates:
• Name: Ornamental
  Description:
  Prototype:
  AssetType: null
  Status: null
  MaintenanceArea: null
  AssetID: null
  CMMSID: null
  GeneralLedgerKey: null
  PGEBadgeNumber: null
  PoleType: Ornamental
  PoleMaterial: null
  PoleHeight: null
  PoleColor: null
  MastArmLength: null
  MastArmType: null
  NumberOfBulbs: null
  Circuit: null
  BulbBrightness: null
  BulbWattage: null
  BulbType: null
  BulbManufacturer: null
  BulbModel: null
  Condition: null
  PublicPrivate: null
  Owner: null
  TractNumber: null
  Location: null
  UsefulLife: null
  DateInstalled: null
  InstallationCost: null
  ReplacementCost: null
  ConsequenceOfFailure: null
  RiskOfFailure: null
  Risk: null
  RehabilitationFrequency: null
  RehabilitationCost: null
  NextYearOfRehabilitation: null
  DateServiced: null
  SymbolRotation: 0
  RevComments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Power Pole
Name: Power Pole with Street Light
Domains:
• PoleType:
  Inherited
• PoleMaterial:
  Inherited
• PoleHeight:
  Inherited
• PoleColor:
  Inherited
• MastArmLength:
  Inherited
• MastArmType:
  Inherited
• NumberOfBulbs:
  Inherited
• Circuit:
  Inherited
• BulbBrightness:
  Inherited
• BulbWattage:
  Inherited
• BulbType:
  Inherited
• BulbManufacturer:
  Inherited
• BulbModel:
  Inherited
• Condition:
  Inherited
• PublicPrivate:
  Inherited
• Owner:
  Inherited
• Status:
  Inherited
• MaintenanceArea:
  Inherited
Templates:
• Name: Power Pole with Street Light
  Description:
  Prototype:
  AssetType: null
  Status: null
  MaintenanceArea: null
  AssetID: null
  CMMSID: null
  GeneralLedgerKey: null
  PGEBadgeNumber: null
  PoleType: Power Pole
  PoleMaterial: null
  PoleHeight: null
  PoleColor: null
  MastArmLength: null
  MastArmType: null
  NumberOfBulbs: null
  Circuit: null
  BulbBrightness: null
  BulbWattage: null
  BulbType: null
  BulbManufacturer: null
  BulbModel: null
  Condition: null
  PublicPrivate: null
  Owner: null
  TractNumber: null
  Location: null
  UsefulLife: null
  DateInstalled: null
  InstallationCost: null
  ReplacementCost: null
  ConsequenceOfFailure: null
  RiskOfFailure: null
  Risk: null
  RehabilitationFrequency: null
  RehabilitationCost: null
  NextYearOfRehabilitation: null
  DateServiced: null
  SymbolRotation: 0
  RevComments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Street Light
Name: Street Light
Domains:
• PoleType:
  Inherited
• PoleMaterial:
  Inherited
• PoleHeight:
  Inherited
• PoleColor:
  Inherited
• MastArmLength:
  Inherited
• MastArmType:
  Inherited
• NumberOfBulbs:
  Inherited
• Circuit:
  Inherited
• BulbBrightness:
  Inherited
• BulbWattage:
  Inherited
• BulbType:
  Inherited
• BulbManufacturer:
  Inherited
• BulbModel:
  Inherited
• Condition:
  Inherited
• PublicPrivate:
  Inherited
• Owner:
  Inherited
• Status:
  Inherited
• MaintenanceArea:
  Inherited
Templates:
• Name: Street Light
  Description:
  Prototype:
  AssetType: null
  Status: null
  MaintenanceArea: null
  AssetID: null
  CMMSID: null
  GeneralLedgerKey: null
  PGEBadgeNumber: null
  PoleType: Street Light
  PoleMaterial: null
  PoleHeight: null
  PoleColor: null
  MastArmLength: null
  MastArmType: null
  NumberOfBulbs: null
  Circuit: null
  BulbBrightness: null
  BulbWattage: null
  BulbType: null
  BulbManufacturer: null
  BulbModel: null
  Condition: null
  PublicPrivate: null
  Owner: null
  TractNumber: null
  Location: null
  UsefulLife: null
  DateInstalled: null
  InstallationCost: null
  ReplacementCost: null
  ConsequenceOfFailure: null
  RiskOfFailure: null
  Risk: null
  RehabilitationFrequency: null
  RehabilitationCost: null
  NextYearOfRehabilitation: null
  DateServiced: null
  SymbolRotation: 0
  RevComments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Other
Name: Other
Domains:
• PoleType:
  Inherited
• PoleMaterial:
  Inherited
• PoleHeight:
  Inherited
• PoleColor:
  Inherited
• MastArmLength:
  Inherited
• MastArmType:
  Inherited
• NumberOfBulbs:
  Inherited
• Circuit:
  Inherited
• BulbBrightness:
  Inherited
• BulbWattage:
  Inherited
• BulbType:
  Inherited
• BulbManufacturer:
  Inherited
• BulbModel:
  Inherited
• Condition:
  Inherited
• PublicPrivate:
  Inherited
• Owner:
  Inherited
• Status:
  Inherited
• MaintenanceArea:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  AssetType: null
  Status: null
  MaintenanceArea: null
  AssetID: null
  CMMSID: null
  GeneralLedgerKey: null
  PGEBadgeNumber: null
  PoleType: Other
  PoleMaterial: null
  PoleHeight: null
  PoleColor: null
  MastArmLength: null
  MastArmType: null
  NumberOfBulbs: null
  Circuit: null
  BulbBrightness: null
  BulbWattage: null
  BulbType: null
  BulbManufacturer: null
  BulbModel: null
  Condition: null
  PublicPrivate: null
  Owner: null
  TractNumber: null
  Location: null
  UsefulLife: null
  DateInstalled: null
  InstallationCost: null
  ReplacementCost: null
  ConsequenceOfFailure: null
  RiskOfFailure: null
  Risk: null
  RehabilitationFrequency: null
  RehabilitationCost: null
  NextYearOfRehabilitation: null
  DateServiced: null
  SymbolRotation: 0
  RevComments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreateBy
• Edit Date Field: RevDate
• Editor Field: RevBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata