View In:   ArcGIS Online Map Viewer

Name: Garrett_Water_Service_Line_Material_Survey_May2024

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ca68ec2a0985461186e84fb7f1f277eb

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

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: Garrett Water Service Line Material Survey May2024
Description: Survey Data Locations
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
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 ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• survey_note ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Garrett County and The Town of Oakland needs your help to complete an inventory of all water service line pipes connected to the public water system. This will assist us in applying for funding to replace lead lines, if they are found. Check your home for lead pipes, then complete our online survey to tell us what you find, no matter what type of pipes you find!, type: esriFieldTypeString )
• pocfirstname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: First Name, type: esriFieldTypeString )
• poclastname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Last Name, type: esriFieldTypeString )
• followupmethod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: How can we follow up with you if we have any questions?, type: esriFieldTypeString )
• pocphone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Phone Number, type: esriFieldTypeString )
• pocemail ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Email, type: esriFieldTypeString )
• service_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• utacm_account ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Utility Account Number, type: esriFieldTypeString )
• ownership_2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 21 Ownership 2nd Portion - Customer, type: esriFieldTypeString )
• mde_building_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Building Type, type: esriFieldTypeString , Coded Values: [Residential (Single-Family): Single Family Residential] , [Residential (Multi-Family): Multi Family Residential] , [Residential (School Dormitory): Residential (School Dormitory)] , ...17 more... )
• year_built ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Year Building Constructed, type: esriFieldTypeString )
• year_source ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Source of year constructed, type: esriFieldTypeString )
• year_original_plumming ( nullable: true, editable: true, defaultValue: null, length: 255, alias: When was the ORIGINAL plumbing material installed in building?, type: esriFieldTypeString , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [2024 and After: 2024 and After] , [1973 through 2023: 1973 through 2023] , ...4 more... )
• pointofentry ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is there any treatment of the water when enters the building?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_pointofusefaucet ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is there any treatment at the faucet(s)?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_interior_lead_pipes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Are there any pipes in the building that are lead (prior to 1972)?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• copperwithlead ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Are there copper pipes with Lead solder?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_field_materialtest2 ( nullable: true, editable: true, defaultValue: null, length: 500, alias: Material Tests Performed, type: esriFieldTypeString )
• mde_pipe_material2 ( nullable: true, editable: true, defaultValue: null, length: 500, alias: Water Line Material, type: esriFieldTypeString , Coded Values: [Lead: Lead] , [Galvanized (Iron or Steel): Galvanized (Iron or Steel)] , [Copper (No Lead Solder): Copper (No Lead Solder)] , ...2 more... )
• mde_material_source2 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: How did you determine this?, type: esriFieldTypeString , Coded Values: [1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...4 more... )
• mde_other_records2 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Other Records Used, type: esriFieldTypeString )
• mde_fieldverification2 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: 107 Exposed Service Line, type: esriFieldTypeString )
• mde_field_visual_2 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Visual Inspection Type, type: esriFieldTypeString )
• survey_comment ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Comment, type: esriFieldTypeString )
• status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status, type: esriFieldTypeString , Coded Values: [Submitted: Submitted] , [Received: Received] , [In Progress: In Progress] , ...1 more... )
• resolutiond ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Completed On, type: esriFieldTypeDate )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• wheretogo ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Locate Your Water Service Line Check the lowest level of your home—this could be the on the exterior, basement, a utility closet, or a crawl space. Look for a pipe entering through the floor or low on the wall., type: esriFieldTypeString )
• survey_header ( nullable: true, editable: true, defaultValue: null, length: 255, alias: survey_header, type: esriFieldTypeString )
• custstatus ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Custome Status, type: esriFieldTypeString , Coded Values: [1: Lead] , [2: Non-Lead] )
• custverified ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 140 Customer Side Verified, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Capabilities: Create,Editing,Sync,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query Attachments   Query Analytic   Query Top Features   Query Bins   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata