Name: Water Service Accounts

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2f9819d4520f4bfe8c0db4487c22579f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 736697.5796841383
YMin: 2970671.4608173072
XMax: 755296.9965534657
YMax: 2984158.5460478067
Spatial Reference: 102686  (2249)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: utilstatus
Field 2: custstatus
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Lead,Lead
  Label: Lead | Lead
  Description: N/A
  Symbol:
  
• Value: Lead,Unknown
  Label: Lead | Unknown
  Description: Lead,Unknown
  Symbol:
  
• Value: Lead,Non-Lead
  Label: Lead | Non-Lead
  Description: Lead,Non-Lead
  Symbol:
  
• Value: Non-Lead,Lead
  Label: Non-Lead | Lead
  Description: N/A
  Symbol:
  
• Value: Unknown,Galvanized Requiring Replacement
  Label: Unknown | Galvanized
  Description: Unknown,Galvanized Requiring Replacement
  Symbol:
  
• Value: Non-Lead,Galvanized Requiring Replacement
  Label: Non-Lead | Galvanized
  Description: Non-Lead,Galvanized Requiring Replacement
  Symbol:
  
• Value: Unknown,Unknown
  Label: Unknown | Unknown
  Description: Unknown,Unknown
  Symbol:
  
• Value: Non-Lead,Unknown
  Label: Non-Lead | Unknown
  Description: Non-Lead,Unknown
  Symbol:
  
• Value: Unknown,Non-Lead
  Label: Unknown | Non-Lead
  Description: Unknown,Non-Lead
  Symbol:
  
• Value: Non-Lead,Non-Lead
  Label: Non-Lead | Non-Lead
  Description: Non-Lead,Non-Lead
  Symbol:
  
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 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, length: 25 , Coded Values: [Commercial: Commercial] , [Fire: Fire] , [Industrial: Industrial] , ...3 more... )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, length: 25 )
• CAMA_ID ( type: esriFieldTypeString, alias: Assessor Parcel ID, length: 26 )
• LOC_ID ( type: esriFieldTypeString, alias: Parcel Location Identifier, length: 18 )
• addrptid ( type: esriFieldTypeString, alias: Building Address ID, length: 25 )
• siteaddid ( type: esriFieldTypeString, alias: Unit Address ID, length: 25 )
• AddrNum ( type: esriFieldTypeString, alias: Closest Address Number, length: 25 )
• RoadName ( type: esriFieldTypeString, alias: Closest Road Name, length: 75 , Coded Values: [ABERDEEN RD: ABERDEEN RD] , [ACADEMY ST: ACADEMY ST] , [ACORN PK: ACORN PK] , ...612 more... )
• AccountID ( type: esriFieldTypeInteger, alias: Water Account ID )
• sensitivepop ( type: esriFieldTypeString, alias: Sensitive Population, length: 15 )
• Connector ( type: esriFieldTypeString, alias: Connector Present (Y/N), length: 3 , Coded Values: [No: No] , [Yes: Yes] , [Unk: Unknown] )
• ConnectorMaterial ( type: esriFieldTypeString, alias: Connector Material, length: 25 , Coded Values: [Lead: Lead] , [Copper: Copper] , [Brass: Brass] , ...5 more... )
• EverLead ( type: esriFieldTypeString, alias: Was Public Service Line Ever Lead (Y/N), length: 3 , Coded Values: [No: No] , [Yes: Yes] , [Unk: Unknown] )
• utilmaterial ( type: esriFieldTypeString, alias: Utility Material, length: 10 , Coded Values: [UNK-LG: Unknown, may contain lead and/or galvanized] , [PVC: Plastic (PVC)] , [L: Lead] , ...8 more... )
• utildiameter ( type: esriFieldTypeDouble, alias: Utility Diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• utilinstalldate ( type: esriFieldTypeString, alias: Utility Install Date, length: 25 )
• utilsource ( type: esriFieldTypeString, alias: Utility Source, length: 50 , Coded Values: [Installation Record (Tie Card): Installation Record (Tie Card)] , [Meter Replacement (IDataCollect): Meter Replacement (IDataCollect)] , [Service Line Repair or Replacement Record: Service Line Repair or Replacement Record] , ...4 more... )
• utilverified ( type: esriFieldTypeString, alias: Utility Side Verified (Y/N), length: 3 , Coded Values: [No: No] , [Yes: Yes] , [Unk: Unknown] )
• utilverifmethod ( type: esriFieldTypeString, alias: Utility Verification Method, length: 5 , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...3 more... )
• utilverifdate ( type: esriFieldTypeString, alias: Utility Verification Date, length: 25 )
• utilstatus ( type: esriFieldTypeString, alias: Utility Status, length: 50 , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , ...1 more... )
• custmaterial ( type: esriFieldTypeString, alias: Customer Material, length: 10 , Coded Values: [UNK-LG: Unknown, may contain lead and/or galvanized] , [PVC: Plastic (PVC)] , [L: Lead] , ...8 more... )
• custdiameter ( type: esriFieldTypeDouble, alias: Customer Diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• custinstalldate ( type: esriFieldTypeString, alias: Customer Install Date, length: 25 )
• custsource ( type: esriFieldTypeString, alias: Customer Source , length: 50 , Coded Values: [Installation Record (Tie Card): Installation Record (Tie Card)] , [Meter Replacement (IDataCollect): Meter Replacement (IDataCollect)] , [Service Line Repair or Replacement Record: Service Line Repair or Replacement Record] , ...4 more... )
• custverified ( type: esriFieldTypeString, alias: Customer Side Verified (Y/N), length: 3 , Coded Values: [No: No] , [Yes: Yes] , [Unk: Unknown] )
• custverifmethod ( type: esriFieldTypeString, alias: Customer Verification Method, length: 5 , Coded Values: [F: Field Inspection by PWS] , [V: Records Review] , [A: Statistical Analysis] , ...3 more... )
• custverifdate ( type: esriFieldTypeString, alias: Customer Verification Date optional , length: 25 )
• custstatus ( type: esriFieldTypeString, alias: Customer Status, length: 50 , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , ...1 more... )
• bothsidesstatus ( type: esriFieldTypeString, alias: Entire Service Line Status, length: 50 , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , ...1 more... )
• otherverifmethod ( type: esriFieldTypeString, alias: Other MASSDEP Approved Verification Method, length: 50 )
• yearstructbuilt ( type: esriFieldTypeSmallInteger, alias: Year Structure Built )
• buildingtype ( type: esriFieldTypeString, alias: Structure Type, length: 50 , Coded Values: [SF: Single-Family] , [MF: Multi-Family] , [SCH/CC: School / Childcare] , ...4 more... )
• samplingsite ( type: esriFieldTypeString, alias: Current LCR Sampling Site (Y/N), length: 3 , Coded Values: [No: No] , [Yes: Yes] , [Unk: Unknown] )
• samplinglocation ( type: esriFieldTypeString, alias: Sampling Plan Location, length: 1 , Coded Values: [R: Routine Site] , [A: Alternative Site] )
• pointofentry ( type: esriFieldTypeString, alias: Point of Entry or Point of Use Filter (Y/N), length: 3 , Coded Values: [No: No] , [Yes: Yes] , [Unk: Unknown] )
• samplingtier ( type: esriFieldTypeString, alias: Sampling Site Tier, length: 10 , Coded Values: [TIER 1: TIER 1] , [TIER 2: TIER 2] , [TIER 3: TIER 3] , ...3 more... )
• PlumbingMaterial ( type: esriFieldTypeString, alias: Building Plumbing Material (Sampling Site), length: 25 , Coded Values: [L: Lead] , [C: Copper] , [CLS: Copper w/ Lead Solder] , ...4 more... )
• replacestatus ( type: esriFieldTypeString, alias: Lead Service Replacement Status, length: 10 , Coded Values: [Public: Yes, public side of LSL] , [Private: Yes, private side of LSL] , [Both: Yes, both public and private side of LSL] )
• utilreplacedate ( type: esriFieldTypeDate, alias: Utility Side Replacement Date, length: 8 )
• custreplacedate ( type: esriFieldTypeDate, alias: Customer Side Replacement Date, length: 8 )
• ReplaceMaterial ( type: esriFieldTypeString, alias: Lead Service Replacement Material, length: 10 , Coded Values: [Copper: Copper] , [Plastic: Plastic] , [Other: Other] )
• TieCardURL ( type: esriFieldTypeString, alias: Tie Card URL, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 50 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Edited By, length: 50 )
• last_edited_date ( type: esriFieldTypeDate, alias: Edited Date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

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

  Iteminfo   Thumbnail   Metadata