View In:   ArcGIS Map Viewer by SR

Name: geodata.DBO.STREET_LIGHTS_EVARI

Display Field: BADGENUM

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 1000000

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: 6128123.436262727
YMin: 2088826.1059984714
XMax: 6164993.432528883
YMax: 2114111.861550331
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STREETLIGHT_STATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Op
  Label: Operational
  Description:
  Symbol:
  
• Value: PGE_Op
  Label: PGE Operational
  Description:
  Symbol:
  
• Value: In_Prog
  Label: In Progress
  Description:
  Symbol:
  
• Value: Non_Op
  Label: Non-Operational
  Description:
  Symbol:
  
• Value: Missing
  Label: Missing
  Description:
  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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: STREETLIGHT_STATUS

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• BADGENUM ( type: esriFieldTypeString, alias: BADGENUM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BADGENUM )
• Obs_Item_Code ( type: esriFieldTypeString, alias: Obs_Item_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Obs_Item_Code )
• RATE_SCHED ( type: esriFieldTypeString, alias: RATE_SCHED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RATE_SCHED )
• Obs_Pole_Height ( type: esriFieldTypeString, alias: Obs_Pole_Height, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Obs_Pole_Height )
• Obs_Pole_Material ( type: esriFieldTypeString, alias: Obs_Pole_Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Obs_Pole_Material )
• Obs_Mast_Arm_Type ( type: esriFieldTypeString, alias: Obs_Mast_Arm_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Obs_Mast_Arm_Type )
• Obs_Fixture_Model ( type: esriFieldTypeString, alias: Obs_Fixture_Model, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Obs_Fixture_Model )
• Final_Address ( type: esriFieldTypeString, alias: Final_Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Final_Address )
• FAppliance ( type: esriFieldTypeString, alias: FAppliance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FAppliance )
• FAppliance2 ( type: esriFieldTypeString, alias: FAppliance2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FAppliance2 )
• FAppliance3 ( type: esriFieldTypeString, alias: FAppliance3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FAppliance3 )
• FAppliance4 ( type: esriFieldTypeString, alias: FAppliance4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FAppliance4 )
• FAppliance5 ( type: esriFieldTypeString, alias: FAppliance5, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FAppliance5 )
• ACCTNUM ( type: esriFieldTypeString, alias: ACCTNUM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ACCTNUM )
• BADGENUM_1 ( type: esriFieldTypeString, alias: BADGENUM_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BADGENUM_1 )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SP_ID )
• SA_ID ( type: esriFieldTypeString, alias: SA_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SA_ID )
• PREM_ID ( type: esriFieldTypeString, alias: PREM_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PREM_ID )
• UNIQUESPID ( type: esriFieldTypeString, alias: UNIQUESPID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UNIQUESPID )
• STREETLIGHT_STATUS ( type: esriFieldTypeString, alias: STREETLIGHT_STATUS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREETLIGHT_STATUS , Coded Values: [Op: Operational] , [PGE_Op: PGE Operational] , [In_Prog: In Progress] , ...3 more... )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NOTES )
• BILLINGCODE ( type: esriFieldTypeString, alias: BILLINGCODE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BILLINGCODE , Coded Values: [PVT: Privately owned] , [LS1: LS1 PG&E] , [LS1-A: LS1-A PG&E] , ...6 more... )

Types:

ID: Op
Name: Op
Domains:
• STREETLIGHT_STATUS:
  Inherited
• BILLINGCODE:
  Inherited
Templates:
• Name: Op
  Description:
  Prototype:
  NOTES: null
  BILLINGCODE: null
  Latitude: null
  Longitude: null
  BADGENUM: null
  Obs_Item_Code: null
  RATE_SCHED: null
  Obs_Pole_Height: null
  Obs_Pole_Material: null
  Obs_Mast_Arm_Type: null
  Obs_Fixture_Model: null
  Final_Address: null
  FAppliance: null
  FAppliance2: null
  FAppliance3: null
  FAppliance4: null
  FAppliance5: null
  ACCTNUM: null
  BADGENUM_1: null
  SP_ID: null
  SA_ID: null
  PREM_ID: null
  UNIQUESPID: null
  STREETLIGHT_STATUS: Op
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: PGE_Op
Name: PGE_Op
Domains:
• STREETLIGHT_STATUS:
  Inherited
• BILLINGCODE:
  Inherited
Templates:
• Name: PGE_Op
  Description:
  Prototype:
  NOTES: null
  BILLINGCODE: null
  Latitude: null
  Longitude: null
  BADGENUM: null
  Obs_Item_Code: null
  RATE_SCHED: null
  Obs_Pole_Height: null
  Obs_Pole_Material: null
  Obs_Mast_Arm_Type: null
  Obs_Fixture_Model: null
  Final_Address: null
  FAppliance: null
  FAppliance2: null
  FAppliance3: null
  FAppliance4: null
  FAppliance5: null
  ACCTNUM: null
  BADGENUM_1: null
  SP_ID: null
  SA_ID: null
  PREM_ID: null
  UNIQUESPID: null
  STREETLIGHT_STATUS: PGE_Op
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: In_Prog
Name: In_Prog
Domains:
• STREETLIGHT_STATUS:
  Inherited
• BILLINGCODE:
  Inherited
Templates:
• Name: In_Prog
  Description:
  Prototype:
  NOTES: null
  BILLINGCODE: null
  Latitude: null
  Longitude: null
  BADGENUM: null
  Obs_Item_Code: null
  RATE_SCHED: null
  Obs_Pole_Height: null
  Obs_Pole_Material: null
  Obs_Mast_Arm_Type: null
  Obs_Fixture_Model: null
  Final_Address: null
  FAppliance: null
  FAppliance2: null
  FAppliance3: null
  FAppliance4: null
  FAppliance5: null
  ACCTNUM: null
  BADGENUM_1: null
  SP_ID: null
  SA_ID: null
  PREM_ID: null
  UNIQUESPID: null
  STREETLIGHT_STATUS: In_Prog
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Non_Op
Name: Non_Op
Domains:
• STREETLIGHT_STATUS:
  Inherited
• BILLINGCODE:
  Inherited
Templates:
• Name: Non_Op
  Description:
  Prototype:
  NOTES: null
  BILLINGCODE: null
  Latitude: null
  Longitude: null
  BADGENUM: null
  Obs_Item_Code: null
  RATE_SCHED: null
  Obs_Pole_Height: null
  Obs_Pole_Material: null
  Obs_Mast_Arm_Type: null
  Obs_Fixture_Model: null
  Final_Address: null
  FAppliance: null
  FAppliance2: null
  FAppliance3: null
  FAppliance4: null
  FAppliance5: null
  ACCTNUM: null
  BADGENUM_1: null
  SP_ID: null
  SA_ID: null
  PREM_ID: null
  UNIQUESPID: null
  STREETLIGHT_STATUS: Non_Op
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Missing
Name: Missing
Domains:
• STREETLIGHT_STATUS:
  Inherited
• BILLINGCODE:
  Inherited
Templates:
• Name: Missing
  Description:
  Prototype:
  NOTES: null
  BILLINGCODE: null
  Latitude: null
  Longitude: null
  BADGENUM: null
  Obs_Item_Code: null
  RATE_SCHED: null
  Obs_Pole_Height: null
  Obs_Pole_Material: null
  Obs_Mast_Arm_Type: null
  Obs_Fixture_Model: null
  Final_Address: null
  FAppliance: null
  FAppliance2: null
  FAppliance3: null
  FAppliance4: null
  FAppliance5: null
  ACCTNUM: null
  BADGENUM_1: null
  SP_ID: null
  SA_ID: null
  PREM_ID: null
  UNIQUESPID: null
  STREETLIGHT_STATUS: Missing
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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