Layers:

Layer: ServiceLine (0)

Name: ServiceLine

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: ServiceLine

Service Item Id: 10d4385e791748bcb6bf243bc5cdc894

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 577791.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.562899996
YMin: 4288808.952800006
XMax: -8895448.929
YMax: 4312856.3445999995
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [58, 63, 130, 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: true

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

Relationships:

• (0) -- Related To: Sampling (3)
• (1) -- Related To: Notifications (1)
• (2) -- Related To: School_Childcare_Sampling (5)

Tables:

Table: Notifications (1)

Name: Notifications

Display Field: notes

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 10d4385e791748bcb6bf243bc5cdc894

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• notes ( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: notes, alias: Notes )
• assetguid ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: assetguid, alias: Asset Guid )
• creationdate ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: creationdate, alias: CreationDate )
• creator ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: creator, alias: Creator )
• editdate ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: editdate, alias: EditDate )
• editor ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: editor, alias: Editor )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• notifreason ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: notifreason, alias: Reason for Notification , Coded Values: [Material Requires Notification: Material Requires Notification] , [Service Line Replacement: Service Line Replacement] , [Service Line Disturbance: Service Line Disturbance] , ...3 more... )
• notifmethod ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: notifmethod, alias: Notification Method , Coded Values: [Phone: Phone] , [Mail: Mail] , [Email: Email] , ...3 more... )
• notifdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: notifdate, alias: Notification Date )
• custresponse ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: custresponse, alias: Customer Response to Notification , Coded Values: [Approved Replacement: Approved Replacement] , [Denied Replacement: Denied Replacement] , [Approved Sampling: Approved Sampling] , ...1 more... )
• nonresponsive ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: nonresponsive, alias: Non-Responsive for 30 Days , Coded Values: [Yes: Yes] , [Not Yet: Not Yet] , [Customer Responded: Customer Responded] )
• custresponsedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: custresponsedate, alias: Customer Response Date )
• address ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: address, alias: Address )
Templates:
• Name: Notifications
  Description:
  Prototype:
  custresponsedate: null
  notes: null
  address: null
  assetguid: null
  notifdate: null
  nonresponsive: null
  notifmethod: null
  custresponse: null
  notifreason: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• (1) -- Related To: ServiceLine (0)

Table: Sampling (3)

Name: Sampling

Display Field: labsampleidfirst

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 10d4385e791748bcb6bf243bc5cdc894

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• leadfirstliter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadfirstliter, alias: Lead - 1st Liter (mg/L) )
• leadfifthliter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadfifthliter, alias: Lead - 5th Liter (mg/L) )
• copperfirstliter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: copperfirstliter, alias: Copper - 1st Liter (mg/L) )
• labsampleidfirst ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: labsampleidfirst, alias: Lab Sample ID - 1st Liter )
• labsampleidfifth ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labsampleidfifth, alias: Lab Sample ID - 5th Liter )
• notes ( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: notes, alias: Notes )
• assetguid ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: assetguid, alias: Asset Guid )
• 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 )
• highresultlead ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: highresultlead, alias: Lead - Higher Result )
• resultdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: resultdate, alias: Result Received Date )
• samplingreason ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: samplingreason, alias: Reason for Sampling , Coded Values: [Compliance for 90th Percentile: Compliance for 90th Percentile] , [Voluntary: Voluntary] , [Post Replacement: Post Replacement] )
• sampledby ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: sampledby, alias: Sampled By , Coded Values: [Homeowner: Homeowner] , [Utility: Utility] , [Other: Other] )
• sampledate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: sampledate, alias: Sampling Date )
• resultnotifieddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: resultnotifieddate, alias: Sample Result Notification Date )
• sampledeliverdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: sampledeliverdate, alias: Sample Kit Delivered Date )
• address ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: address, alias: Address )
• replacestatus ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: replacestatus, alias: Full Line Replacement Status )
• tier ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: tier, alias: Tier )
• postreplacementsampling ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: postreplacementsampling, alias: Date to Start Post Replacement Sampling Activities )
• samplingsite ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: samplingsite, alias: Compliance Sampling Site )
• samplingperiod ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: samplingperiod, alias: Sampling Period Year )
Templates:
• Name: Sampling
  Description:
  Prototype:
  samplingsite: null
  notes: null
  address: null
  resultnotifieddate: null
  samplingperiod: null
  samplingreason: null
  labsampleidfirst: null
  sampledby: null
  leadfifthliter: null
  leadfirstliter: null
  tier: null
  sampledeliverdate: null
  postreplacementsampling: null
  highresultlead: null
  assetguid: null
  sampledate: null
  replacestatus: null
  resultdate: null
  copperfirstliter: null
  labsampleidfifth: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• (0) -- Related To: ServiceLine (0)

Table: School_Childcare_Sampling (5)

Name: School_Childcare_Sampling

Display Field: facilitytype

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 10d4385e791748bcb6bf243bc5cdc894

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• facilitytype ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: facilitytype, alias: Facility Type , Coded Values: [School: School] , [Childcare: Childcare] , [Both School and Childcare: Both School and Childcare] )
• sampledby ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: sampledby, alias: Sampled By , Coded Values: [School Childcare Staff: School Childcare Staff] , [Utility: Utility] , [Other: Other] )
• sampledate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: sampledate, alias: Sampling Date )
• resultdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: resultdate, alias: Result Received Date )
• leadssite1 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite1, alias: Lead - School Site 1 (mg/L) )
• leadssite2 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite2, alias: Lead - School Site 2 (mg/L) )
• leadssite3 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite3, alias: Lead - School Site 3 (mg/L) )
• leadssite4 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite4, alias: Lead - School Site 4 (mg/L) )
• leadssite5 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite5, alias: Lead - School Site 5 (mg/L) )
• labids1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids1, alias: Lab Sample ID - School Site 1 )
• labids2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids2, alias: Lab Sample ID - School Site 2 )
• labids3 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids3, alias: Lab Sample ID - School Site 3 )
• labids4 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids4, alias: Lab Sample ID - School Site 4 )
• labids5 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids5, alias: Lab Sample ID - School Site 5 )
• ssite1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite1, alias: School Site 1 Description )
• ssite2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite2, alias: School Site 2 Description )
• ssite3 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite3, alias: School Site 3 Description )
• ssite4 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite4, alias: School Site 4 Description )
• ssite5 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite5, alias: School Site 5 Description )
• leadccsite1 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadccsite1, alias: Lead - CC Site 1 (mg/L) )
• leadccsite2 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadccsite2, alias: Lead - CC Site 2 (mg/L) )
• labidcc1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labidcc1, alias: Lab Sample ID - CC Site 1 )
• labidcc2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labidcc2, alias: Lab Sample ID - CC Site 2 )
• ccsite1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ccsite1, alias: CC Site 1 Description )
• ccsite2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ccsite2, alias: CC Site 2 Description )
• notes ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: notes, alias: Notes )
• assetguid ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: assetguid, alias: Asset Guid )
• 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 )
• waiver ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: waiver, alias: Waiver Granted for Previous Sampling , Coded Values: [Yes: Yes] , [No: No] )
• resultnotifieddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: resultnotifieddate, alias: Sample Result Notification Date )
• sampledeliverdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: sampledeliverdate, alias: Sample Kit Delivered Date )
• scheduledate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: scheduledate, alias: Sample Schedule Date )
• address ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: address, alias: Address )
• 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 )
• location ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: location, alias: Other Location Identifier )
Templates:
• Name: School_Childcare_Sampling
  Description:
  Prototype:
  notes: null
  labidcc1: null
  sampledby: null
  labidcc2: null
  scheduledate: null
  leadssite1: null
  leadssite2: null
  ccsite1: null
  leadssite3: null
  ccsite2: null
  leadssite4: null
  sampledate: null
  leadssite5: null
  assetguid: null
  leadccsite2: null
  leadccsite1: null
  ccpriorityrank: null
  address: null
  resultnotifieddate: null
  schoolpriorityrank: null
  labids4: null
  ssite1: null
  sampledeliverdate: null
  labids3: null
  labids5: null
  ssite5: null
  ssite4: null
  resultdate: null
  labids2: null
  ssite3: null
  location: null
  facilitytype: null
  labids1: null
  ssite2: null
  waiver: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• (2) -- Related To: ServiceLine (0)