View In:   ArcGIS Online Map Viewer

Name: ServiceLine

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b8502d33d58c449ba76ef0b09c2a0acc

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -8916520.5629
YMin: 4288808.952799998
XMax: -8895448.929
YMax: 4312856.3445999995
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [153, 44, 114, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• accountid ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: accountid, alias: EPA ID )
• address ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: address, alias: Address )
• location ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: location, alias: Other Location Identifier )
• sensitivepop ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: sensitivepop, alias: Sensitive Population , Coded Values: [Yes - School: Yes - School] , [Yes - Day Care: Yes - Day Care] , [Yes - MF Home: Yes - Multifamily Home] , ...2 more... )
• disadvantaged ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: disadvantaged, alias: Disadvantaged Neighborhood , Coded Values: [Yes: Yes] , [No: No] )
• utilassetid ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: utilassetid, alias: Utility Asset ID )
• utilmaterial ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: utilmaterial, alias: Utility Material , Coded Values: [Lead: Lead] , [Lead-lined galvanized: Lead-lined galvanized] , [Galvanized: Galvanized] , ...6 more... )
• everlead ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: everlead, alias: Ever Lead? , Coded Values: [Yes: Yes] , [No: No] , [Don't know: Don't know] )
• utilinstalldate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: utilinstalldate, alias: Utility Install Date )
• utildiameter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: utildiameter, alias: Utility Diameter , Coded Values: [-1: Unknown] , [0.25: 1/4"] , [0.5: 1/2"] , ...24 more... )
• utilverified ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: utilverified, alias: Utility Side Verified , Coded Values: [Yes: Yes] , [No: No] )
• utilverifmethod ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: utilverifmethod, alias: Utility Verification Method , Coded Values: [Visual inspection at the meter pit: Visual inspection at the meter pit] , [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal] , [CCTV investigation at curb stop - external: CCTV investigation at curb stop - external] , ...4 more... )
• utilverifdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: utilverifdate, alias: Utility Verification Date )
• utilstatus ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: utilstatus, alias: Utility Service Line Lead Classification , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Unknown: Unknown] )
• utilnotes ( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: utilnotes, alias: Utility Side Notes )
• custassetid ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: custassetid, alias: Customer Asset ID )
• custmaterial ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: custmaterial, alias: Customer Material , Coded Values: [Lead: Lead] , [Lead-lined galvanized: Lead-lined galvanized] , [Galvanized: Galvanized] , ...6 more... )
• custinstalldate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: custinstalldate, alias: Customer Install Date )
• custdiameter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: custdiameter, alias: Customer Diameter , Coded Values: [-1: Unknown] , [0.25: 1/4"] , [0.5: 1/2"] , ...24 more... )
• custverified ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: custverified, alias: Customer Side Verified , Coded Values: [Yes: Yes] , [No: No] )
• custverifmethod ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: custverifmethod, alias: Customer Verification Method , Coded Values: [Visual inspection at the meter pit: Visual inspection at the meter pit] , [Customer self-identification: Customer self-identification] , [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal] , ...5 more... )
• custverifdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: custverifdate, alias: Customer Verification Date )
• custstatus ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: custstatus, alias: Customer Service Line Lead Classification , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...1 more... )
• custnotes ( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: custnotes, alias: Customer Side Notes )
• bothsidesstatus ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: bothsidesstatus, alias: Full Service Line Lead Classification , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , ...1 more... )
• leadsolder ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: leadsolder, alias: Lead Solder in Service Line , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• otherfittings ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: otherfittings, alias: Premise Other Fittings Containing Lead )
• buildingtype ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: buildingtype, alias: Building Type , Coded Values: [Single Family Residence: Single Family Residence] , [Multiple Family Residence: Multiple Family Residence] , [Building: Building] , ...1 more... )
• pointofentry ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: pointofentry, alias: Premise Point-of-Entry or Point-of-Use , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• copperwithlead ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: copperwithlead, alias: Premise Copper Pipes with Lead Solder Before Lead Ban , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• samplingsite ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: samplingsite, alias: Compliance Sampling Site , Coded Values: [Yes: Yes] , [No: No] )
• utilscheddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: utilscheddate, alias: Utility Side Scheduled Replacement Date )
• utilreplacedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: utilreplacedate, alias: Utility Side Replacement Date )
• custscheddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: custscheddate, alias: Customer Side Scheduled Replacement Date )
• custreplacedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: custreplacedate, alias: Customer Side Replacement Date )
• filter ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: filter, alias: Water Pitcher Filter , Coded Values: [Never Required: Never Required] , [Needs Filter: Needed After Replacement or Disturbance] )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• filterscheddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: filterscheddate, alias: Water Pitcher Filter Date Scheduled )
• filterprovidedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: filterprovidedate, alias: Water Pitcher Filter Date Provided )
• serviceuse ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: serviceuse, alias: Service Line Use , Coded Values: [Irrigation: Irrigation] , [Fire: Fire] , [Potable: Potable] , ...1 more... )
• utilpredmat ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: utilpredmat, alias: Utility Predicted Material )
• utilpredprob ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: utilpredprob, alias: Utility Predicted Material Probability )
• custpredmat ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: custpredmat, alias: Customer Predicted Material )
• custpredprob ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: custpredprob, alias: Customer Predicted Material Probability )
• servicestatus ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: servicestatus, alias: Service Line Working Status , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Abandoned/Disconnected: Abandoned/Disconnected] )
• lastmodeldate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: lastmodeldate, alias: Predictive Model Last Run Date )
• city ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: city, alias: City )
• state ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: state, alias: State )
• zip ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: zip, alias: Zip )
• connectorstatus ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: connectorstatus, alias: Connector Classification , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Unknown: Unknown] , ...1 more... )
• connectorscheddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: connectorscheddate, alias: Connector Scheduled Replacement Date )
• connectorreplacedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: connectorreplacedate, alias: Connector Replacement Date )
• utilreplacestatus ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: utilreplacestatus, alias: Utility Side Replacement Status , Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement] , [Needs Replacement: Needs Replacement] , [Scheduled Replacement: Scheduled Replacement] , ...3 more... )
• custreplacestatus ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: custreplacestatus, alias: Customer Side Replacement Status , Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement] , [Needs Replacement: Needs Replacement] , [Scheduled Replacement: Scheduled Replacement] , ...4 more... )
• custresponsetotal ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: custresponsetotal, alias: Customer Response to Replacement Requests , Coded Values: [Approved Replacement: Approved Replacement] , [Denied Replacement: Denied Replacement] , [Doesn't Need Replacement: Doesn't Need Replacement] , ...7 more... )
• custmaterialoriginal ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: custmaterialoriginal, alias: Customer Material Original , Coded Values: [Lead: Lead] , [Lead-lined galvanized: Lead-lined galvanized] , [Galvanized: Galvanized] , ...6 more... )
• utilmaterialoriginal ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: utilmaterialoriginal, alias: Utility Material Original , Coded Values: [Lead: Lead] , [Lead-lined galvanized: Lead-lined galvanized] , [Galvanized: Galvanized] , ...6 more... )
• tier ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: tier, alias: Tier , Coded Values: [Tier 1: Tier 1] , [Tier 2: Tier 2] , [Tier 3: Tier 3] , ...3 more... )
• utilmaterialreplaced ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: utilmaterialreplaced, alias: Utility Side Replaced Material , Coded Values: [Non-Lead - Copper: Non-Lead - Copper] , [Non-Lead - Plastic: Non-Lead - Plastic] , [Non-Lead - Other: Non-Lead - Other] )
• custmaterialreplaced ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: custmaterialreplaced, alias: Customer Side Replaced Material , Coded Values: [Non-Lead - Copper: Non-Lead - Copper] , [Non-Lead - Plastic: Non-Lead - Plastic] , [Non-Lead - Other: Non-Lead - Other] )
• replacestatus ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: replacestatus, alias: Full Line Replacement Status , Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement] , [Both Sides Need Replaced: Both Sides Need Replaced] , [Utility Side Needs Replaced: Utility Side Needs Replaced] , ...10 more... )
• custbasisclass ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: custbasisclass, alias: Customer Basis of Material Classification , Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Water sampling only with no records: Water sampling only with no records] , [Field inspection only with no records: Field inspection only with no records] , ...6 more... )
• utilbasisclass ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: utilbasisclass, alias: Utility Basis of Material Classification , Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Water sampling only with no records: Water sampling only with no records] , [Field inspection only with no records: Field inspection only with no records] , ...6 more... )
• replpriorityrank ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: replpriorityrank, alias: Replacement Priority Rank )
• schoolpriorityrank ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: schoolpriorityrank, alias: School Priority Rank )
• ccpriorityrank ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: ccpriorityrank, alias: Childcare Priority Rank )
• newcustomerdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: newcustomerdate, alias: newcustomerdate )

Templates:

• Name: ServiceLine
  Description:
  Prototype:
  samplingsite: null
  serviceuse: null
  utilreplacedate: null
  utilpredmat: null
  disadvantaged: null
  utilmaterial: null
  replpriorityrank: null
  servicestatus: null
  utilreplacestatus: null
  accountid: null
  filterscheddate: null
  utilpredprob: null
  utilassetid: null
  custreplacedate: null
  utilmaterialoriginal: null
  custbasisclass: null
  leadsolder: null
  bothsidesstatus: null
  custpredprob: null
  state: null
  custassetid: null
  zip: null
  custpredmat: null
  utilverified: null
  sensitivepop: null
  utilstatus: null
  utilscheddate: null
  utilverifmethod: null
  custscheddate: null
  everlead: null
  custdiameter: null
  otherfittings: null
  custresponsetotal: null
  schoolpriorityrank: null
  utilnotes: null
  replacestatus: null
  custreplacestatus: null
  filterprovidedate: null
  connectorstatus: null
  custverified: null
  city: null
  utilinstalldate: null
  lastmodeldate: null
  custinstalldate: null
  connectorscheddate: null
  newcustomerdate: null
  custnotes: null
  tier: null
  utilmaterialreplaced: null
  ccpriorityrank: null
  custverifmethod: null
  address: null
  utilbasisclass: null
  utildiameter: null
  utilverifdate: null
  connectorreplacedate: null
  buildingtype: null
  custstatus: null
  filter: null
  custmaterialreplaced: null
  custmaterial: null
  custmaterialoriginal: null
  location: null
  custverifdate: null
  pointofentry: null
  copperwithlead: null
  
  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: 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:

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