All Layers and Tables (ServiceLine

Layers:

Layer: ServiceLine (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"a8cef56248793243183de2dbdefd61d1","imageData":"iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABqklEQVRIic2W642DMBCE50eagDY2ZQBlQBlwZdhlnNPGloFp4zTGRhyCEB463UgoiWP7s9e7Yx74Iz3+IygHIPHJAFgAeieojo9MxDyH955t1BCh3VmQxMFFmlxEoKooigLGGAzDwN9Z0zSt9579KgD+CKgE8B1oIui6LkxONU0zdcqyLLT3fc92sdb27BJ3uAuSBKnrOqz8ExljUJYlHxPPTvdA3VFIEnfHcdZaF5NnE8QDLlK4zsgYE85NVTlB9w4UIIz/WRlj8Hw+iy1QqBNmVzr4i5I4p1+CQp0wbJcJIqnWZBN0JWRLmPd+mmwOCo1cyR3yPmwkXwOxyGrnHNq2vQUGwK2BQoHRYq5qGK3pV9syvWmQrIFLSaEjhHPpFojha6uqCv51djfdWOxT2NZAwa2ZljTPoxZEEaLjlpo9r6PV99aOBnwE9nq96HP8+rX8bw3k42oMB3EwYe/cYojhmkHcJyDMrmnHoqP9U/xMF988u2bhWoXs3bAaCy7dssIao7hyzjvLLrc8kyOgpGT36eWEDpKralr5R4V35C2IZ7f6PnA36JJ+AHSvxusH7xvDAAAAAElFTkSuQmCC","contentType":"image/png","width":19,"height":19,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
location (type: esriFieldTypeString, alias: Other Location Identifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sensitivepop (type: esriFieldTypeString, alias: Sensitive Population, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes - School: Yes - School], [Yes - Day Care: Yes - Day Care], [Yes - Other: Yes - Other], ... 1 more ...)
disadvantaged (type: esriFieldTypeString, alias: Disadvantaged Neighborhood, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
utilassetid (type: esriFieldTypeString, alias: Utility Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
utilmaterial (type: esriFieldTypeString, alias: Utility Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], [Non-Lead - Other: Non-Lead - Other], ... 7 more ...)
everlead (type: esriFieldTypeString, alias: Ever Lead?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
utilinstalldate (type: esriFieldTypeDate, alias: Utility Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utildiameter (type: esriFieldTypeDouble, alias: Utility Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 13 more ...)
utilsource (type: esriFieldTypeString, alias: Utility Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, 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 ...)
utilverified (type: esriFieldTypeString, alias: Utility Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
utilverifmethod (type: esriFieldTypeString, alias: Utility Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Mechanical Excavation at 1 location: Mechanical Excavation at 1 location], [Mechanical Excavation at multiple locations: Mechanical Excavation at multiple locations], [Visual inspection at meter pit: Visual inspection at meter pit], ... 1 more ...)
utilverifdate (type: esriFieldTypeDate, alias: Utility Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utilstatus (type: esriFieldTypeString, alias: Utility Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Lead: Lead], [Non-Lead: Non-Lead], ... 1 more ...)
utilnotes (type: esriFieldTypeString, alias: Utility Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
custassetid (type: esriFieldTypeString, alias: Customer Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
custmaterial (type: esriFieldTypeString, alias: Customer Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], [Non-Lead - Other: Non-Lead - Other], ... 7 more ...)
custinstalldate (type: esriFieldTypeDate, alias: Customer Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custdiameter (type: esriFieldTypeDouble, alias: Customer Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 13 more ...)
custsource (type: esriFieldTypeString, alias: Customer Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, 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 ...)
custverified (type: esriFieldTypeString, alias: Customer Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
custverifmethod (type: esriFieldTypeString, alias: Customer Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Mechanical Excavation at 1 location: Mechanical Excavation at 1 location], [Mechanical Excavation at multiple locations: Mechanical Excavation at multiple locations], [Visual inspection at meter pit: Visual inspection at meter pit], ... 1 more ...)
custverifdate (type: esriFieldTypeDate, alias: Customer Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custstatus (type: esriFieldTypeString, alias: Customer Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Lead: Lead], [Non-Lead: Non-Lead], ... 1 more ...)
custnotes (type: esriFieldTypeString, alias: Customer Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
bothsidesstatus (type: esriFieldTypeString, alias: Entire Service Line Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Lead: Lead], [Non-Lead: Non-Lead], ... 1 more ...)
leadconnector (type: esriFieldTypeString, alias: Lead Connector, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
leadsolder (type: esriFieldTypeString, alias: Lead Solder, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
otherfittings (type: esriFieldTypeString, alias: Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
buildingtype (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Single Family Residence: Single Family Residence], [Multiple Family Residence: Multiple Family Residence], [Building: Building], ... 1 more ...)
pointofentry (type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
copperwithlead (type: esriFieldTypeString, alias: Copper Pipes with Lead Solder Before Lead Ban, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
samplingsite (type: esriFieldTypeString, alias: Sampling Site, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
replacestatus (type: esriFieldTypeString, alias: Replacement Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Needs Replacement: Needs Replacement], [Scheduled Replacement: Scheduled Replacement], ... 1 more ...)
utilscheddate (type: esriFieldTypeDate, alias: Utility Side Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utilreplacedate (type: esriFieldTypeDate, alias: Utility Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custscheddate (type: esriFieldTypeDate, alias: Customer Side Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custreplacedate (type: esriFieldTypeDate, alias: Customer Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
filter (type: esriFieldTypeString, alias: Water Filter, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
yearstructbuilt (type: esriFieldTypeSmallInteger, alias: Year Structure Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
samplingtier (type: esriFieldTypeString, alias: samplingtier, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
rejectsite (type: esriFieldTypeString, alias: rejectsite, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
rejectreason (type: esriFieldTypeString, alias: rejectreason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Above Ground Obstruction: Above Ground Obstruction], [Pavement or Concrete Above Dig Site: Pavement or Concrete Above Dig Site], [Owner Prevented Dig: Owner Prevented Dig], ... 3 more ...)
QCStatus (type: esriFieldTypeString, alias: QC Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
samplestatus (type: esriFieldTypeString, alias: Sampling Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [1: Tier 1], [2: Tier 2], [3: Tier 3], ... 5 more ...)
rejectnote (type: esriFieldTypeString, alias: Reject Note, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
utilityexcavationmethod (type: esriFieldTypeString, alias: Utility Excavation Method, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Hand Dig: Hand Dig], [Vac Truck: Vac Truck])
custexcavationmethod (type: esriFieldTypeString, alias: Customer Excavation Method, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Hand Dig: Hand Dig], [Vac Truck: Vac Truck])
EvalSite (type: esriFieldTypeString, alias: Evaluation Site, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Relationships:

Sampling (0) -- Related To: Sampling (4)
Notifications (1) -- Related To: Notifications (3)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

Notifications (3)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
reason (type: esriFieldTypeString, alias: Reason for Notification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Action Level Exceedance: Action Level Exceedance], [Service Line Replacement: Service Line Replacement], [Tap Sampling: Tap Sampling], ... 4 more ...)
phone (type: esriFieldTypeString, alias: By Phone?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
phonedate (type: esriFieldTypeDate, alias: Phone Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
email (type: esriFieldTypeString, alias: By Email?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
emaildate (type: esriFieldTypeDate, alias: Email Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
mail (type: esriFieldTypeString, alias: By Mail?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
maildate (type: esriFieldTypeDate, alias: Mail Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
sitevisit (type: esriFieldTypeString, alias: By Site Visit?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
sitevisitdate (type: esriFieldTypeDate, alias: Site Visit Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
assetguid (type: esriFieldTypeGUID, alias: Asset Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Sampling (4)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tier (type: esriFieldTypeString, alias: Tier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Tier 1: Tier 1], [Tier 2: Tier 2], [Tier 3: Tier 3], ... 1 more ...)
sampledby (type: esriFieldTypeString, alias: Sampled By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Homeowner: Homeowner], [Utility: Utility], [Other: Other])
sampledate (type: esriFieldTypeDate, alias: Sampling Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
resultdate (type: esriFieldTypeDate, alias: Result Received Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
leadfirstliter (type: esriFieldTypeDouble, alias: Lead - 1st Liter (mg/l), SQL Type: sqlTypeOther, nullable: true, editable: true)
leadfifthliter (type: esriFieldTypeDouble, alias: Lead - 5th Liter (mg/l), SQL Type: sqlTypeOther, nullable: true, editable: true)
copperfirstliter (type: esriFieldTypeDouble, alias: Copper - 1st Liter (mg/l), SQL Type: sqlTypeOther, nullable: true, editable: true)
copperfifthliter (type: esriFieldTypeDouble, alias: Copper- 5th Liter (mg/l), SQL Type: sqlTypeOther, nullable: true, editable: true)
labsampleidfirst (type: esriFieldTypeString, alias: Lab Sample ID - 1st Liter, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
labsampleidfifth (type: esriFieldTypeString, alias: Lab Sample ID - 5th Liter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
assetguid (type: esriFieldTypeGUID, alias: Asset Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
highresultlead (type: esriFieldTypeDouble, alias: Lead - Higher Result, SQL Type: sqlTypeOther, nullable: true, editable: true)
highresultcopper (type: esriFieldTypeDouble, alias: Copper - Higher Result, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: