View In:   ArcGIS Online Map Viewer

Name: Utility Side | Customer Side

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500

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: -1.04501730699E7
YMin: 4393572.188199997
XMax: -1.04493427941E7
YMax: 4394606.767999999
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: utilstatus
Field 2: custstatus
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 12.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: Other
UniqueValueInfos:
• Value: 1,1
  Label: Lead | Lead
  Description: N/A
  Symbol:
  
• Value: 1,3
  Label: Lead | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 1,2
  Label: Lead | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 1,0
  Label: Lead | Unknown
  Description: N/A
  Symbol:
  
• Value: 3,1
  Label: Galvanized Requiring Replacement | Lead
  Description: N/A
  Symbol:
  
• Value: 3,3
  Label: Galvanized Requiring Replacement | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 3,2
  Label: Galvanized Requiring Replacement | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 3,0
  Label: Galvanized Requiring Replacement | Unknown
  Description: N/A
  Symbol:
  
• Value: 2,1
  Label: Non-Lead | Lead
  Description: N/A
  Symbol:
  
• Value: 2,3
  Label: Non-Lead | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 2,2
  Label: Non-Lead | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 2,0
  Label: Non-Lead | Unknown
  Description: N/A
  Symbol:
  
• Value: 0,1
  Label: Unknown | Lead
  Description: N/A
  Symbol:
  
• Value: 0,3
  Label: Unknown | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 0,2
  Label: Unknown | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 0,0
  Label: Unknown | Unknown
  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

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: utilstatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• accountid ( type: esriFieldTypeString, alias: Account ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: accountid )
• address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: address )
• utilassetid ( type: esriFieldTypeString, alias: Utility Asset ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilassetid )
• utilmaterial ( type: esriFieldTypeSmallInteger, alias: Utility Material, editable: true, nullable: true, defaultValue: null, modelName: utilmaterial , Coded Values: [0: Unknown] , [81: Asbestos Cement - AC] , [83: Cast Iron - CAS] , ...7 more... )
• utildiameter ( type: esriFieldTypeDouble, alias: Utility Diameter, editable: true, nullable: true, defaultValue: null, modelName: utildiameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• utilinstalldate ( type: esriFieldTypeDate, alias: Utility Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilinstalldate )
• utilverified ( type: esriFieldTypeInteger, alias: Utility Side Verified, editable: true, nullable: true, defaultValue: null, modelName: utilverified , Coded Values: [1: Yes] , [2: No] )
• utilverifdate ( type: esriFieldTypeDate, alias: Utility Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilverifdate )
• utilsource ( type: esriFieldTypeSmallInteger, alias: Utility Source, editable: true, nullable: true, defaultValue: null, modelName: utilsource , Coded Values: [1: Existing Records] , [2: Test Results] , [3: Visual Confirmation] , ...1 more... )
• utilstatus ( type: esriFieldTypeSmallInteger, alias: Utility Status, editable: true, nullable: true, defaultValue: null, modelName: utilstatus , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• custassetid ( type: esriFieldTypeString, alias: Customer Asset ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custassetid )
• custmaterial ( type: esriFieldTypeSmallInteger, alias: Customer Material, editable: true, nullable: true, defaultValue: null, modelName: custmaterial , Coded Values: [0: Unknown] , [81: Asbestos Cement - AC] , [83: Cast Iron - CAS] , ...7 more... )
• custdiameter ( type: esriFieldTypeDouble, alias: Customer Diameter, editable: true, nullable: true, defaultValue: null, modelName: custdiameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• custinstalldate ( type: esriFieldTypeDate, alias: Customer Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custinstalldate )
• custverified ( type: esriFieldTypeInteger, alias: Customer Side Verified, editable: true, nullable: true, defaultValue: null, modelName: custverified , Coded Values: [1: Yes] , [2: No] )
• custverifdate ( type: esriFieldTypeDate, alias: Customer Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custverifdate )
• custsource ( type: esriFieldTypeSmallInteger, alias: Customer Source, editable: true, nullable: true, defaultValue: null, modelName: custsource , Coded Values: [1: Existing Records] , [2: Test Results] , [3: Visual Confirmation] , ...2 more... )
• custstatus ( type: esriFieldTypeSmallInteger, alias: Customer Status, editable: true, nullable: true, defaultValue: null, modelName: custstatus , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• replacestatus ( type: esriFieldTypeSmallInteger, alias: Replacement Status, editable: true, nullable: true, defaultValue: null, modelName: replacestatus , Coded Values: [1: Doesn't Need Replacement] , [2: Needs Replacement] , [3: Scheduled Replacement] , ...1 more... )
• scheddate ( type: esriFieldTypeDate, alias: Scheduled Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: scheddate )
• replacereason ( type: esriFieldTypeInteger, alias: Reason for Replacement, editable: true, nullable: true, defaultValue: null, modelName: replacereason , Coded Values: [1: Lead] , [2: Other] )
• custnotified ( type: esriFieldTypeSmallInteger, alias: Notified Customer, editable: true, nullable: true, defaultValue: null, modelName: custnotified , Coded Values: [1: Yes] , [2: No] )
• notifydate ( type: esriFieldTypeDate, alias: Notification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: notifydate )
• yearstructbuilt ( type: esriFieldTypeSmallInteger, alias: Year Structure Built, editable: true, nullable: true, defaultValue: null, modelName: yearstructbuilt )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Editor )

Types:

ID: 1
Name: Lead | Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• custmaterial:
  Inherited
• custdiameter:
  Inherited
• custverified:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• replacestatus:
  Inherited
• replacereason:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Lead | Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 1
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 1
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Galvanized Requiring Replacement
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 1
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 3
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Non-Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 1
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 2
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Unknown
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 1
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 0
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Galvanized Requiring Replacement | Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• custmaterial:
  Inherited
• custdiameter:
  Inherited
• custverified:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• replacestatus:
  Inherited
• replacereason:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Galvanized Requiring Replacement | Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 3
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 1
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Galvanized Requiring Replacement
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 3
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 3
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Non-Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 3
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 2
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Unknown
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 3
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 0
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Non-Lead | Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• custmaterial:
  Inherited
• custdiameter:
  Inherited
• custverified:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• replacestatus:
  Inherited
• replacereason:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Non-Lead | Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 2
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 1
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Galvanized Requiring Replacement
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 2
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 3
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Non-Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 2
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 2
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Unknown
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 2
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 0
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Unknown | Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• custmaterial:
  Inherited
• custdiameter:
  Inherited
• custverified:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• replacestatus:
  Inherited
• replacereason:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Unknown | Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 0
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 1
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Galvanized Requiring Replacement
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 0
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 3
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Non-Lead
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 0
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 2
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Unknown
  Description:
  Prototype:
  utilsource: null
  custsource: null
  yearstructbuilt: null
  accountid: null
  address: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilverifdate: null
  utilstatus: 0
  custassetid: null
  custmaterial: null
  custdiameter: null
  custinstalldate: null
  custverified: null
  custverifdate: null
  custstatus: 0
  replacestatus: null
  scheddate: null
  replacereason: null
  custnotified: null
  notifydate: null
  
  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

Edit Fields Info:

• Creation Date Field: CreationDate
• Creator Field: Creator
• Edit Date Field: EditDate
• Editor Field: Editor

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: 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