View In:   ArcGIS Online Map Viewer

Name: WaterServicePoint

Display Field: FilePathName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 550647.4229138047
YMin: 2833892.824270144
XMax: 569526.5393549651
YMax: 2855023.1858807206
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [122, 56, 175, 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:

• 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] , ...4 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: null, 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: [L: Lead] , [C: Copper] , [G: Galvanized] , ...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] , [GALVANIZED REQUIRING REPLACEMENT: GALVANIZED REQUIRING REPLACEMENT] , ...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 )
• CAMABuildingStyle ( type: esriFieldTypeString, alias: CAMA Building Style, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CAMABuildingStyle )
• FilePathName ( type: esriFieldTypeString, alias: FilePathName, editable: true, nullable: true, length: 200, defaultValue: null, modelName: FilePathName )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: CreationDate, required: true )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator, required: true )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: EditDate, required: true )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor, required: true )
• 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 )
• Main_PublicService_Installed ( type: esriFieldTypeString, alias: Main_PublicService_Installed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_PublicService_Installed , Coded Values: [Yes: Yes] , [No: No] )
• 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] , ...8 more... )
• Main_PrivateService_Installed ( type: esriFieldTypeString, alias: Main_PrivateService_Installed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_PrivateService_Installed , Coded Values: [Yes: Yes] , [No: No] )
• Main_PrivateServiceMaterial ( type: esriFieldTypeString, alias: Main_PrivateServiceMaterial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Main_PrivateServiceMaterial , Coded Values: [L: Lead] , [C: Copper] , [Galvanized: Galvanized] , ...8 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] )
• Active_Inactive ( type: esriFieldTypeString, alias: Active_Inactive, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Active_Inactive )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Status )
• 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_InspectionSelection ( type: esriFieldTypeSmallInteger, alias: Public_InspectionSelection, editable: true, nullable: true, defaultValue: null, modelName: Public_InspectionSelection )
• Private_InspectionSelection ( type: esriFieldTypeSmallInteger, alias: Private_InspectionSelection, editable: true, nullable: true, defaultValue: null, modelName: Private_InspectionSelection )
• PublicKnownPrivateUnknown ( type: esriFieldTypeString, alias: PublicKnownPrivateUnknown, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PublicKnownPrivateUnknown )
• PublicUnknownPrivateKnown ( type: esriFieldTypeString, alias: PublicUnknownPrivateKnown, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PublicUnknownPrivateKnown )
• BasementInspectionTarget ( type: esriFieldTypeString, alias: BasementInspectionTarget, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BasementInspectionTarget , Coded Values: [Yes: Yes] , [No: No] )
• BasementInspectionCompleted ( type: esriFieldTypeString, alias: BasementInspectionCompleted, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BasementInspectionCompleted , Coded Values: [Yes: Yes] , [No: No] )
• SewerOnly ( type: esriFieldTypeString, alias: SewerOnly, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SewerOnly )
• MailingAddress ( type: esriFieldTypeString, alias: MailingAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingAddress )
• MailingTown ( type: esriFieldTypeString, alias: MailingTown, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingTown )
• MailingZipCode ( type: esriFieldTypeString, alias: MailingZipCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingZipCode )
• OwnerName ( type: esriFieldTypeString, alias: OwnerName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnerName )
• LOC_ID ( type: esriFieldTypeString, alias: LOC_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOC_ID )
• MailingState ( type: esriFieldTypeString, alias: MailingState, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingState )
• EntireServiceLineRandom ( type: esriFieldTypeDouble, alias: EntireServiceLineRandom, editable: true, nullable: true, defaultValue: null, modelName: EntireServiceLineRandom )
• ESLInspectionSelection ( type: esriFieldTypeSmallInteger, alias: ESLInspectionSelection, editable: true, nullable: true, defaultValue: null, modelName: ESLInspectionSelection )
• Attachments ( type: esriFieldTypeInteger, alias: Attachments, editable: true, nullable: true, defaultValue: null, modelName: Attachments )
• VODALeadPercentages ( type: esriFieldTypeDouble, alias: VODALeadPercentages, editable: true, nullable: true, defaultValue: null, modelName: VODALeadPercentages )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: WaterServicePoint
  Description:
  Prototype:
  Attachments: null
  SiteID: null
  LocationalIdentifer: null
  LCRLocation: null
  ConnectorPresent: null
  CONNECTORMATERIAL: null
  CurrentPublicSLMaterial: null
  PublicSLPrevLead: null
  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
  VODALeadPercentages: null
  XCoordinate: null
  YCoordinate: null
  CAMAYearBuilt: null
  CAMABuildingStyle: null
  FilePathName: null
  CreationDate: null
  Creator: null
  EditDate: null
  Editor: null
  Public_Verification: null
  Private_Verification: null
  Main_YearInstalled: null
  Main_Material: null
  Main_PublicService_Installed: null
  Main_PublicServiceMaterial: null
  Main_PrivateService_Installed: null
  Main_PrivateServiceMaterial: null
  Main_New_Replaced: null
  Active_Inactive: null
  Status: null
  PublicRandom: null
  PrivateRandom: null
  Public_InspectionSelection: null
  Private_InspectionSelection: null
  PublicKnownPrivateUnknown: null
  PublicUnknownPrivateKnown: null
  BasementInspectionTarget: null
  BasementInspectionCompleted: null
  SewerOnly: null
  MailingAddress: null
  MailingTown: null
  MailingZipCode: null
  OwnerName: null
  LOC_ID: null
  MailingState: null
  EntireServiceLineRandom: null
  ESLInspectionSelection: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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