View In:   ArcGIS Online Map Viewer

Name: Water Lead Service Line Inventory

Display Field: TIECardFileName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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

Supports Datum Transformation: true

Extent:

XMin: 327845.7694366425
YMin: 2859500.7313875556
XMax: 360163.06339772046
YMax: 2886139.644645065
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [107, 77, 155, 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:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SiteID ( type: esriFieldTypeString, alias: SITE ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SiteID )
• LocationalIdentifer ( type: esriFieldTypeString, alias: LOCATIONAL IDENTIFIER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LocationalIdentifer )
• LCRLocation ( type: esriFieldTypeString, alias: LCR SAMPLING LOCATION?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LCRLocation , Coded Values: [YES: YES] , [NO: NO] )
• ConnectorPresent ( type: esriFieldTypeString, alias: CONNECTOR (GOOSENECK / PIGTAIL) CURRENTLY PRESENT?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ConnectorPresent , Coded Values: [YES: Yes, Known with Certainty] , [NO: No, Known with Certainty] , [UNK: Unknown, Not Known with Certainty] )
• CONNECTORMATERIAL ( type: esriFieldTypeString, alias: CONNECTOR (GOOSENECK /PIGTAIL) MATERIAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONNECTORMATERIAL , Coded Values: [L: Lead] , [C: Copper] , [B: Brass] , ...6 more... )
• CurrentPublicSLMaterial ( type: esriFieldTypeString, alias: CURRENT PUBLIC SERVICE LINE MATERIAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CurrentPublicSLMaterial , Coded Values: [L: Lead] , [C: Copper] , [G: Galvanized] , ...9 more... )
• PublicSLPrevLead ( type: esriFieldTypeString, alias: WAS PUBLIC SERVICE LINE MATERIAL EVER PREVIOUSLY LEAD?, editable: true, nullable: true, length: 255, defaultValue: UNK, modelName: PublicSLPrevLead , Coded Values: [YES: Yes, Known with Certainty] , [NO: No, Known with Certainty] , [UNK: Unknown, Not Known with Certainty] )
• PublicSLSize ( type: esriFieldTypeString, alias: PUBLIC SERVICE LINE SIZE (inches), editable: true, nullable: true, length: 255, defaultValue: null, modelName: PublicSLSize , Coded Values: [3/8": 3/8"] , [1/2": 1/2"] , [5/8": 5/8"] , ...15 more... )
• Public_SLInstallDate ( type: esriFieldTypeString, alias: PUBLIC SERVICE LINE INSTALL DATE (YYYY), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Public_SLInstallDate )
• CurrentPrivateSLMaterial ( type: esriFieldTypeString, alias: CURRENT PRIVATE SERVICE LINE MATERIAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CurrentPrivateSLMaterial , Coded Values: [P: Plastic] , [DI: Ductile Iron] , [CI-L: Lined Cast Iron] , ...9 more... )
• PrivateSLSize ( type: esriFieldTypeString, alias: PRIVATE SERVICE LINE SIZE (inches), editable: true, nullable: true, length: 255, defaultValue: null, modelName: PrivateSLSize , Coded Values: [3/8": 3/8"] , [1/2": 1/2"] , [5/8": 5/8"] , ...15 more... )
• Private_SLInstallDate ( type: esriFieldTypeString, alias: PRIVATE SERVICE LINE INSTALL DATE (YYYY), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Private_SLInstallDate )
• EntireServiceLine ( type: esriFieldTypeString, alias: ENTIRE SERVICE LINE CLASSIFICATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EntireServiceLine , Coded Values: [LEAD: LEAD] , [NON-LEAD: NON-LEAD] , [LEAD STATUS UNKNOWN: LEAD STATUS UNKNOWN] , ...1 more... )
• VerificationMethod ( type: esriFieldTypeString, alias: VERIFICATION METHOD, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VerificationMethod , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...3 more... )
• OtherMassDEPMethod ( type: esriFieldTypeString, alias: OTHER MASSDEP APPROVED VERIFICATION METHOD, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OtherMassDEPMethod , Coded Values: )
• BuildingType ( type: esriFieldTypeString, alias: BUILDING TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuildingType , Coded Values: [SF: Single-Family] , [MF: Multi-Family] , [SCH/CC: School/Childcare] , ...4 more... )
• POEPOUTreatment ( type: esriFieldTypeString, alias: POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: POEPOUTreatment , Coded Values: [YES: Yes, Known with Certainty] , [NO: No, Known with Certainty] , [UNK: Unknown, Not Known with Certainty] )
• BuildingPlumbingMaterial1 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuildingPlumbingMaterial1 , Coded Values: [L: Lead] , [C: Copper] , [CLS: Copper w/ Lead Solder] , ...4 more... )
• BuildingPlumbingMaterial2 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuildingPlumbingMaterial2 , Coded Values: [L: Lead] , [C: Copper] , [CLS: Copper w/ Lead Solder] , ...4 more... )
• BuildingPlumbingInstallDate ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL INSTALL DATE (YYYY), editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuildingPlumbingInstallDate )
• SamplingPlanLocation ( type: esriFieldTypeString, alias: SAMPLING PLAN LOCATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SamplingPlanLocation , Coded Values: [R: Routine Site] , [A: Alternative Site] )
• tier ( type: esriFieldTypeString, alias: SAMPLING SITE TIER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tier , Coded Values: [TIER 1: TIER 1] , [TIER 2: TIER 2] , [TIER 3: TIER 3] , ...3 more... )
• ReplacedSL ( type: esriFieldTypeString, alias: REPLACED LSL PUBLIC OR PRIVATE SIDE? (DURING OR AFTER 2024), editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReplacedSL , Coded Values: [PUBLIC: Yes, public side of LSL] , [PRIVATE: Yes, private side of LSL] , [BOTH: Yes, both public and private side of LSL] )
• ReplacedMaterial ( type: esriFieldTypeString, alias: NEW REPLACED SERVICE LINE MATERIAL , editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReplacedMaterial , Coded Values: [C: Copper] , [P: Plastic] , [OTH: Other Material] )
• LSLReplacementDate ( type: esriFieldTypeString, alias: LSL REPLACEMENT DATE (MM/DD/YYYY), editable: true, nullable: true, length: 255, defaultValue: null, modelName: LSLReplacementDate )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• XCoordinate ( type: esriFieldTypeDouble, alias: X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: XCoordinate )
• YCoordinate ( type: esriFieldTypeDouble, alias: Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: YCoordinate )
• CAMAYearBuilt ( type: esriFieldTypeSmallInteger, alias: CAMA Year Built, editable: true, nullable: true, defaultValue: null, modelName: CAMAYearBuilt )
• CAMALUCode ( type: esriFieldTypeString, alias: CAMA Land Use Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CAMALUCode )
• Public_Verification ( type: esriFieldTypeString, alias: Public_Verification, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Public_Verification , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...7 more... )
• Private_Verification ( type: esriFieldTypeString, alias: Private_Verification, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Private_Verification , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...7 more... )
• Main_YearInstalled ( type: esriFieldTypeString, alias: Main_YearInstalled, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_YearInstalled )
• Main_Material ( type: esriFieldTypeString, alias: Main_Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_Material , Coded Values: [L: Lead] , [C: Copper] , [G: Galvanized] , ...9 more... )
• Main_New_Replaced ( type: esriFieldTypeString, alias: Main_New_Replaced, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_New_Replaced , Coded Values: [New: New] , [Replaced: Replaced] )
• Main_PublicService_Installed ( type: esriFieldTypeString, alias: Main_PublicServices_Installed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_PublicService_Installed , Coded Values: [YES: Yes, Known with Certainty] , [NO: No, Known with Certainty] , [UNK: Unknown, Not Known with Certainty] )
• Main_PublicServiceMaterial ( type: esriFieldTypeString, alias: Main_PublicServiceMaterial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_PublicServiceMaterial , Coded Values: [L: Lead] , [C: Copper] , [G: Galvanized] , ...9 more... )
• Main_PrivateService_Installed ( type: esriFieldTypeString, alias: Main_PrivateServices_Installe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_PrivateService_Installed , Coded Values: [YES: Yes, Known with Certainty] , [NO: No, Known with Certainty] , [UNK: Unknown, Not Known with Certainty] )
• Main_PrivateServicesMaterial ( type: esriFieldTypeString, alias: Main_PrivateServicesMaterial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_PrivateServicesMaterial , Coded Values: [P: Plastic] , [DI: Ductile Iron] , [CI-L: Lined Cast Iron] , ...9 more... )
• TIECardFileName ( type: esriFieldTypeString, alias: TIE Card File Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TIECardFileName )
• TIECardFilePath ( type: esriFieldTypeString, alias: TIE Card File Path, editable: true, nullable: true, length: 500, defaultValue: null, modelName: TIECardFilePath )
• Active_Inactive ( type: esriFieldTypeString, alias: Active or Inactive?, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Active_Inactive , Coded Values: [Active: Active] , [Inactive: Inactive] )
• PublicRandom ( type: esriFieldTypeDouble, alias: PublicRandom, editable: true, nullable: true, defaultValue: null, modelName: PublicRandom )
• PrivateRandom ( type: esriFieldTypeDouble, alias: PrivateRandom, editable: true, nullable: true, defaultValue: null, modelName: PrivateRandom )
• Public_InspectionTarget ( type: esriFieldTypeSmallInteger, alias: Public_InspectionTarget, editable: true, nullable: true, defaultValue: null, modelName: Public_InspectionTarget )
• Private_InspectionTarget ( type: esriFieldTypeSmallInteger, alias: Private_InspectionTaeget, editable: true, nullable: true, defaultValue: null, modelName: Private_InspectionTarget )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• LUDesc ( type: esriFieldTypeString, alias: LU Description, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LUDesc )
• OwnerName ( type: esriFieldTypeString, alias: OwnerName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnerName )
• MailingCity ( type: esriFieldTypeString, alias: MailingCity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingCity )
• MailingState ( type: esriFieldTypeString, alias: MailingState, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingState )
• MailingZipCode ( type: esriFieldTypeString, alias: MailingZipCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingZipCode )
• MailingAddress ( type: esriFieldTypeString, alias: MailingAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingAddress )
• PrivateVerificationDescriptio ( type: esriFieldTypeString, alias: PrivateVerificationDescriptio, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PrivateVerificationDescriptio )
• PublicVerificationDescription ( type: esriFieldTypeString, alias: PublicVerificationDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PublicVerificationDescription )
• FacilityID_FromPublic ( type: esriFieldTypeString, alias: FacilityID_FromPublic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FacilityID_FromPublic )
• FacilityID_FromPrivate ( type: esriFieldTypeString, alias: FacilityID_FromPrivate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FacilityID_FromPrivate )
• MultipleLaterals ( type: esriFieldTypeString, alias: MultipleLaterals, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MultipleLaterals )
• FacilityID_FromUNKOwner ( type: esriFieldTypeString, alias: FacilityID_FromUNKOwner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FacilityID_FromUNKOwner )
• ESL_RandomNumber ( type: esriFieldTypeDouble, alias: ESL_RandomNumber, editable: true, nullable: true, defaultValue: null, modelName: ESL_RandomNumber )
• ESL_InspectionSelection ( type: esriFieldTypeDouble, alias: ESL_InspectionSelection, editable: true, nullable: true, defaultValue: null, modelName: ESL_InspectionSelection )
• ValidationPoolPrivateRandomNumb ( type: esriFieldTypeDouble, alias: Validation Pool Private Random Number, editable: true, nullable: true, defaultValue: null, modelName: ValidationPoolPrivateRandomNumb )
• ValidationPoolPublicRandomNumbe ( type: esriFieldTypeDouble, alias: Validation Pool Public Random Number, editable: true, nullable: true, defaultValue: null, modelName: ValidationPoolPublicRandomNumbe )
• ValidationInspectionPool ( type: esriFieldTypeInteger, alias: Validation Inspection Pool, editable: true, nullable: true, defaultValue: null, modelName: ValidationInspectionPool , Coded Values: [0: No Selection] , [1: Private Side Validation Inspection Pool] , [2: Public Side Validation Inspection Pool] , ...4 more... )
• ValidationPoolInspectionStatus ( type: esriFieldTypeString, alias: Validation Pool Inspection Status, editable: true, nullable: true, length: 256, defaultValue: null, modelName: ValidationPoolInspectionStatus , Coded Values: [Private Side Not Inspected: Private Side Not Inspected] , [Public Side Not Inspected: Public Side Not Inspected] , [Neither Side Inspected: Neither Side Inspected] , ...3 more... )
• ValidationPoolClassification ( type: esriFieldTypeString, alias: Validation Pool Classification, editable: true, nullable: true, length: 256, defaultValue: null, modelName: ValidationPoolClassification , Coded Values: [Private Side Verified Non-Lead: Private Side Verified Non-Lead] , [Public Side Verified Non-Lead: Public Side Verified Non-Lead] , [Both Sides Verified Non-Lead: Both Sides Verified Non-Lead] , ...3 more... )

Templates:

• Name: Water Lead Service Line Inventory
  Description:
  Prototype:
  ValidationPoolInspectionStatus: null
  ValidationInspectionPool: null
  SiteID: null
  LocationalIdentifer: null
  LCRLocation: null
  ConnectorPresent: null
  CONNECTORMATERIAL: null
  CurrentPublicSLMaterial: null
  PublicSLPrevLead: UNK
  PublicSLSize: null
  Public_SLInstallDate: null
  CurrentPrivateSLMaterial: null
  PrivateSLSize: null
  Private_SLInstallDate: null
  EntireServiceLine: null
  VerificationMethod: null
  OtherMassDEPMethod: null
  BuildingType: null
  POEPOUTreatment: null
  BuildingPlumbingMaterial1: null
  BuildingPlumbingMaterial2: null
  BuildingPlumbingInstallDate: null
  SamplingPlanLocation: null
  tier: null
  ReplacedSL: null
  ReplacedMaterial: null
  LSLReplacementDate: null
  COMMENTS: null
  ValidationPoolClassification: null
  XCoordinate: null
  YCoordinate: null
  CAMAYearBuilt: null
  CAMALUCode: null
  Public_Verification: null
  Private_Verification: null
  Main_YearInstalled: null
  Main_Material: null
  Main_New_Replaced: null
  Main_PublicService_Installed: null
  Main_PublicServiceMaterial: null
  Main_PrivateService_Installed: null
  Main_PrivateServicesMaterial: null
  TIECardFileName: null
  TIECardFilePath: null
  Active_Inactive: null
  PublicRandom: null
  PrivateRandom: null
  Public_InspectionTarget: null
  Private_InspectionTarget: null
  CreationDate: null
  Creator: null
  EditDate: null
  Editor: null
  LUDesc: null
  OwnerName: null
  MailingCity: null
  MailingState: null
  MailingZipCode: null
  MailingAddress: null
  PrivateVerificationDescriptio: null
  PublicVerificationDescription: null
  FacilityID_FromPublic: null
  FacilityID_FromPrivate: null
  MultipleLaterals: null
  FacilityID_FromUNKOwner: null
  ESL_RandomNumber: null
  ESL_InspectionSelection: null
  ValidationPoolPrivateRandomNumb: null
  ValidationPoolPublicRandomNumbe: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata