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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SiteID ( type: esriFieldTypeString, alias: SITE ID, length: 255 )
• LocationalIdentifer ( type: esriFieldTypeString, alias: LOCATIONAL IDENTIFIER, length: 255 )
• LCRLocation ( type: esriFieldTypeString, alias: LCR SAMPLING LOCATION?, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• ConnectorPresent ( type: esriFieldTypeString, alias: CONNECTOR (GOOSENECK / PIGTAIL) CURRENTLY PRESENT?, length: 255 , 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, length: 255 , Coded Values: [L: Lead] , [C: Copper] , [B: Brass] , ...6 more... )
• CurrentPublicSLMaterial ( type: esriFieldTypeString, alias: CURRENT PUBLIC SERVICE LINE MATERIAL, length: 255 , Coded Values: [L: Lead] , [C: Copper] , [G: Galvanized] , ...9 more... )
• PublicSLPrevLead ( type: esriFieldTypeString, alias: WAS PUBLIC SERVICE LINE MATERIAL EVER PREVIOUSLY LEAD?, length: 255 , 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), length: 255 , 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), length: 255 )
• CurrentPrivateSLMaterial ( type: esriFieldTypeString, alias: CURRENT PRIVATE SERVICE LINE MATERIAL, length: 255 , Coded Values: [P: Plastic] , [DI: Ductile Iron] , [CI-L: Lined Cast Iron] , ...9 more... )
• PrivateSLSize ( type: esriFieldTypeString, alias: PRIVATE SERVICE LINE SIZE (inches), length: 255 , 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), length: 255 )
• EntireServiceLine ( type: esriFieldTypeString, alias: ENTIRE SERVICE LINE CLASSIFICATION, length: 255 , Coded Values: [LEAD: LEAD] , [NON-LEAD: NON-LEAD] , [LEAD STATUS UNKNOWN: LEAD STATUS UNKNOWN] , ...1 more... )
• VerificationMethod ( type: esriFieldTypeString, alias: VERIFICATION METHOD, length: 255 , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...3 more... )
• OtherMassDEPMethod ( type: esriFieldTypeString, alias: OTHER MASSDEP APPROVED VERIFICATION METHOD, length: 255 , Coded Values: )
• BuildingType ( type: esriFieldTypeString, alias: BUILDING TYPE, length: 255 , 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?, length: 255 , 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, length: 255 , Coded Values: [L: Lead] , [C: Copper] , [CLS: Copper w/ Lead Solder] , ...4 more... )
• BuildingPlumbingMaterial2 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 2, length: 255 , Coded Values: [L: Lead] , [C: Copper] , [CLS: Copper w/ Lead Solder] , ...4 more... )
• BuildingPlumbingInstallDate ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL INSTALL DATE (YYYY), length: 255 )
• SamplingPlanLocation ( type: esriFieldTypeString, alias: SAMPLING PLAN LOCATION, length: 255 , Coded Values: [R: Routine Site] , [A: Alternative Site] )
• tier ( type: esriFieldTypeString, alias: SAMPLING SITE TIER, length: 255 , 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), length: 255 , 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 , length: 255 , Coded Values: [C: Copper] , [P: Plastic] , [OTH: Other Material] )
• LSLReplacementDate ( type: esriFieldTypeString, alias: LSL REPLACEMENT DATE (MM/DD/YYYY), length: 255 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• XCoordinate ( type: esriFieldTypeDouble, alias: X Coordinate )
• YCoordinate ( type: esriFieldTypeDouble, alias: Y Coordinate )
• CAMAYearBuilt ( type: esriFieldTypeSmallInteger, alias: CAMA Year Built )
• CAMALUCode ( type: esriFieldTypeString, alias: CAMA Land Use Code, length: 50 )
• Public_Verification ( type: esriFieldTypeString, alias: Public_Verification, length: 255 , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...7 more... )
• Private_Verification ( type: esriFieldTypeString, alias: Private_Verification, length: 255 , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...7 more... )
• Main_YearInstalled ( type: esriFieldTypeString, alias: Main_YearInstalled, length: 255 )
• Main_Material ( type: esriFieldTypeString, alias: Main_Material, length: 255 , Coded Values: [L: Lead] , [C: Copper] , [G: Galvanized] , ...9 more... )
• Main_New_Replaced ( type: esriFieldTypeString, alias: Main_New_Replaced, length: 255 , Coded Values: [New: New] , [Replaced: Replaced] )
• Main_PublicService_Installed ( type: esriFieldTypeString, alias: Main_PublicServices_Installed, length: 255 , 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, length: 255 , Coded Values: [L: Lead] , [C: Copper] , [G: Galvanized] , ...9 more... )
• Main_PrivateService_Installed ( type: esriFieldTypeString, alias: Main_PrivateServices_Installe, length: 255 , 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, length: 255 , Coded Values: [P: Plastic] , [DI: Ductile Iron] , [CI-L: Lined Cast Iron] , ...9 more... )
• TIECardFileName ( type: esriFieldTypeString, alias: TIE Card File Name, length: 255 )
• TIECardFilePath ( type: esriFieldTypeString, alias: TIE Card File Path, length: 500 )
• Active_Inactive ( type: esriFieldTypeString, alias: Active or Inactive?, length: 15 , Coded Values: [Active: Active] , [Inactive: Inactive] )
• PublicRandom ( type: esriFieldTypeDouble, alias: PublicRandom )
• PrivateRandom ( type: esriFieldTypeDouble, alias: PrivateRandom )
• Public_InspectionTarget ( type: esriFieldTypeSmallInteger, alias: Public_InspectionTarget )
• Private_InspectionTarget ( type: esriFieldTypeSmallInteger, alias: Private_InspectionTaeget )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8, precision: 1 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8, precision: 1 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )
• LUDesc ( type: esriFieldTypeString, alias: LU Description, length: 1000 )
• OwnerName ( type: esriFieldTypeString, alias: OwnerName, length: 255 )
• MailingCity ( type: esriFieldTypeString, alias: MailingCity, length: 255 )
• MailingState ( type: esriFieldTypeString, alias: MailingState, length: 255 )
• MailingZipCode ( type: esriFieldTypeString, alias: MailingZipCode, length: 255 )
• MailingAddress ( type: esriFieldTypeString, alias: MailingAddress, length: 255 )
• PrivateVerificationDescriptio ( type: esriFieldTypeString, alias: PrivateVerificationDescriptio, length: 255 )
• PublicVerificationDescription ( type: esriFieldTypeString, alias: PublicVerificationDescription, length: 255 )
• FacilityID_FromPublic ( type: esriFieldTypeString, alias: FacilityID_FromPublic, length: 255 )
• FacilityID_FromPrivate ( type: esriFieldTypeString, alias: FacilityID_FromPrivate, length: 255 )
• MultipleLaterals ( type: esriFieldTypeString, alias: MultipleLaterals, length: 255 )
• FacilityID_FromUNKOwner ( type: esriFieldTypeString, alias: FacilityID_FromUNKOwner, length: 255 )
• ESL_RandomNumber ( type: esriFieldTypeDouble, alias: ESL_RandomNumber )
• ESL_InspectionSelection ( type: esriFieldTypeDouble, alias: ESL_InspectionSelection )
• ValidationPoolPrivateRandomNumb ( type: esriFieldTypeDouble, alias: Validation Pool Private Random Number )
• ValidationPoolPublicRandomNumbe ( type: esriFieldTypeDouble, alias: Validation Pool Public Random Number )
• ValidationInspectionPool ( type: esriFieldTypeInteger, alias: Validation Inspection Pool , 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, length: 256 , 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, length: 256 , 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... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata