View In:   ArcGIS Online Map Viewer

Name: Utility Side Customer Side

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: cc5f6bed4a344ea785aee206f05378da

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

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: utilstatus
Field 2: custstatus
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 255, 255, 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: 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: true
Supports Query With LOD Spatial Reference: true
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: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: utilstatus

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• accountid ( modelName: accountid, nullable: true, editable: true, defaultValue: null, length: 255, alias: Account ID, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• utilassetid ( modelName: utilassetid, nullable: true, editable: true, defaultValue: null, length: 255, alias: Utility Asset ID, type: esriFieldTypeString )
• utilmaterial ( modelName: utilmaterial, nullable: true, editable: true, defaultValue: null, alias: Utility Material, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [81: Asbestos Cement - AC] , [83: Cast Iron - CAS] , ...7 more... )
• utildiameter ( modelName: utildiameter, nullable: true, editable: true, defaultValue: null, alias: Utility Diameter, type: esriFieldTypeDouble , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• utilinstalldate ( modelName: utilinstalldate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Utility Install Date, type: esriFieldTypeDate )
• utilverified ( modelName: utilverified, nullable: true, editable: true, defaultValue: null, alias: Utility Side Verified, type: esriFieldTypeInteger , Coded Values: [1: Yes] , [2: No] )
• utilverifdate ( modelName: utilverifdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Utility Verification Date, type: esriFieldTypeDate )
• utilsource ( modelName: utilsource, nullable: true, editable: true, defaultValue: null, alias: Utility Source, type: esriFieldTypeSmallInteger , Coded Values: [1: Existing Records] , [2: Test Results] , [3: Visual Confirmation] , ...1 more... )
• utilstatus ( modelName: utilstatus, nullable: true, editable: true, defaultValue: null, alias: Utility Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• custassetid ( modelName: custassetid, nullable: true, editable: true, defaultValue: null, length: 255, alias: Customer Asset ID, type: esriFieldTypeString )
• custmaterial ( modelName: custmaterial, nullable: true, editable: true, defaultValue: null, alias: Customer Material, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [81: Asbestos Cement - AC] , [83: Cast Iron - CAS] , ...7 more... )
• custdiameter ( modelName: custdiameter, nullable: true, editable: true, defaultValue: null, alias: Customer Diameter, type: esriFieldTypeDouble , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• custinstalldate ( modelName: custinstalldate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Customer Install Date, type: esriFieldTypeDate )
• custverified ( modelName: custverified, nullable: true, editable: true, defaultValue: null, alias: Customer Side Verified, type: esriFieldTypeInteger , Coded Values: [1: Yes] , [2: No] )
• custverifdate ( modelName: custverifdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Customer Verification Date, type: esriFieldTypeDate )
• custsource ( modelName: custsource, nullable: true, editable: true, defaultValue: null, alias: Customer Source, type: esriFieldTypeSmallInteger , Coded Values: [1: Existing Records] , [2: Test Results] , [3: Visual Confirmation] , ...2 more... )
• custstatus ( modelName: custstatus, nullable: true, editable: true, defaultValue: null, alias: Customer Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• replacestatus ( modelName: replacestatus, nullable: true, editable: true, defaultValue: null, alias: Replacement Status, type: esriFieldTypeSmallInteger , Coded Values: [1: Doesn't Need Replacement] , [2: Needs Replacement] , [3: Scheduled Replacement] , ...1 more... )
• scheddate ( modelName: scheddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Scheduled Replacement Date, type: esriFieldTypeDate )
• replacereason ( modelName: replacereason, nullable: true, editable: true, defaultValue: null, alias: Reason for Replacement, type: esriFieldTypeInteger , Coded Values: [1: Lead] , [2: Other] )
• custnotified ( modelName: custnotified, nullable: true, editable: true, defaultValue: null, alias: Notified Customer, type: esriFieldTypeSmallInteger , Coded Values: [1: Yes] , [2: No] )
• notifydate ( modelName: notifydate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Notification Date, type: esriFieldTypeDate )
• yearstructbuilt ( modelName: yearstructbuilt, nullable: true, editable: true, defaultValue: null, alias: Year Structure Built, type: esriFieldTypeSmallInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 128, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 128, alias: Editor, type: esriFieldTypeString )
• esrignss_positionsourcetype ( modelName: esrignss_positionsourcetype, nullable: true, editable: true, defaultValue: null, alias: Position source type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• esrignss_receiver ( modelName: esrignss_receiver, nullable: true, editable: true, defaultValue: null, length: 50, alias: Receiver Name, type: esriFieldTypeString )
• esrignss_latitude ( modelName: esrignss_latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• esrignss_longitude ( modelName: esrignss_longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• esrignss_altitude ( modelName: esrignss_altitude, nullable: true, editable: true, defaultValue: null, alias: Altitude, type: esriFieldTypeDouble )
• esrignss_h_rms ( modelName: esrignss_h_rms, nullable: true, editable: true, defaultValue: null, alias: Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_v_rms ( modelName: esrignss_v_rms, nullable: true, editable: true, defaultValue: null, alias: Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_fixdatetime ( modelName: esrignss_fixdatetime, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fix Time, type: esriFieldTypeDate )
• esrignss_fixtype ( modelName: esrignss_fixtype, nullable: true, editable: true, defaultValue: null, alias: Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• esrignss_correctionage ( modelName: esrignss_correctionage, nullable: true, editable: true, defaultValue: null, alias: Correction Age, type: esriFieldTypeDouble )
• esrignss_stationid ( modelName: esrignss_stationid, nullable: true, editable: true, defaultValue: null, alias: Station ID, type: esriFieldTypeSmallInteger , Range: [0, 1023] )
• esrignss_numsats ( modelName: esrignss_numsats, nullable: true, editable: true, defaultValue: null, alias: Number of Satellites, type: esriFieldTypeSmallInteger , Range: [0, 99] )
• esrignss_pdop ( modelName: esrignss_pdop, nullable: true, editable: true, defaultValue: null, alias: PDOP, type: esriFieldTypeDouble )
• esrignss_hdop ( modelName: esrignss_hdop, nullable: true, editable: true, defaultValue: null, alias: HDOP, type: esriFieldTypeDouble )
• esrignss_vdop ( modelName: esrignss_vdop, nullable: true, editable: true, defaultValue: null, alias: VDOP, type: esriFieldTypeDouble )
• esrignss_direction ( modelName: esrignss_direction, nullable: true, editable: true, defaultValue: null, alias: Direction of travel (°), type: esriFieldTypeDouble )
• esrignss_speed ( modelName: esrignss_speed, nullable: true, editable: true, defaultValue: null, alias: Speed (km/h), type: esriFieldTypeDouble )
• esrisnsr_azimuth ( modelName: esrisnsr_azimuth, nullable: true, editable: true, defaultValue: null, alias: Compass reading (°), type: esriFieldTypeDouble )
• esrignss_avg_h_rms ( modelName: esrignss_avg_h_rms, nullable: true, editable: true, defaultValue: null, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_v_rms ( modelName: esrignss_avg_v_rms, nullable: true, editable: true, defaultValue: null, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_positions ( modelName: esrignss_avg_positions, nullable: true, editable: true, defaultValue: null, alias: Averaged Positions, type: esriFieldTypeSmallInteger )
• esrignss_h_stddev ( modelName: esrignss_h_stddev, nullable: true, editable: true, defaultValue: null, alias: Standard Deviation (m), type: esriFieldTypeDouble )

Types:

ID: 1
Name: Lead | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• esrignss_stationid:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• esrignss_numsats:
  Inherited
• custmaterial:
  Inherited
• esrignss_positionsourcetype:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
• esrignss_fixtype:
  Inherited
Templates:
• Name: Lead | Lead
  Description:
  Prototype:
  custstatus: 1
  utilstatus: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Galvanized Requiring Replacement
  Description:
  Prototype:
  custstatus: 3
  utilstatus: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Non-Lead
  Description:
  Prototype:
  custstatus: 2
  utilstatus: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Unknown
  Description:
  Prototype:
  custstatus: 0
  utilstatus: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Galvanized Requiring Replacement | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• esrignss_stationid:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• esrignss_numsats:
  Inherited
• custmaterial:
  Inherited
• esrignss_positionsourcetype:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
• esrignss_fixtype:
  Inherited
Templates:
• Name: Galvanized Requiring Replacement | Lead
  Description:
  Prototype:
  custstatus: 1
  utilstatus: 3
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Galvanized Requiring Replacement
  Description:
  Prototype:
  custstatus: 3
  utilstatus: 3
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Non-Lead
  Description:
  Prototype:
  custstatus: 2
  utilstatus: 3
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Unknown
  Description:
  Prototype:
  custstatus: 0
  utilstatus: 3
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Non-Lead | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• esrignss_stationid:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• esrignss_numsats:
  Inherited
• custmaterial:
  Inherited
• esrignss_positionsourcetype:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
• esrignss_fixtype:
  Inherited
Templates:
• Name: Non-Lead | Lead
  Description:
  Prototype:
  custstatus: 1
  utilstatus: 2
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Galvanized Requiring Replacement
  Description:
  Prototype:
  custstatus: 3
  utilstatus: 2
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Non-Lead
  Description:
  Prototype:
  custstatus: 2
  utilstatus: 2
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Unknown
  Description:
  Prototype:
  custstatus: 0
  utilstatus: 2
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Unknown | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• esrignss_stationid:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• esrignss_numsats:
  Inherited
• custmaterial:
  Inherited
• esrignss_positionsourcetype:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
• esrignss_fixtype:
  Inherited
Templates:
• Name: Unknown | Lead
  Description:
  Prototype:
  custstatus: 1
  utilstatus: 0
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Galvanized Requiring Replacement
  Description:
  Prototype:
  custstatus: 3
  utilstatus: 0
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Non-Lead
  Description:
  Prototype:
  custstatus: 2
  utilstatus: 0
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Unknown
  Description:
  Prototype:
  custstatus: 0
  utilstatus: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata