View In:   ArcGIS Online Map Viewer

Name: Ambient Wells

Display Field: SiteName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Layer is associated with well sampling work orders in Cityworks. No features should be deleted from the dataset. The layer is updated on an annual basis in July.

Copyright Text: Mecklenburg County Groundwater & Wastewater Services

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: 1384251.250625
YMin: 460979.028750002
XMax: 1536997.25
YMax: 648987.581249997
Spatial Reference: 102719  (2264)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SiteStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  
• Value: Inactive
  Label: Inactive
  Description: N/A
  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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SiteStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: ObjectID )
• WellIdNumber ( type: esriFieldTypeString, alias: Well ID #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WellIdNumber )
• SiteName ( type: esriFieldTypeString, alias: Site Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SiteName )
• TaxParcelNumber ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TaxParcelNumber )
• SiteAddress ( type: esriFieldTypeString, alias: Site Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SiteAddress )
• SiteCity ( type: esriFieldTypeString, alias: Site City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SiteCity )
• SiteState ( type: esriFieldTypeString, alias: Site State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SiteState )
• SiteZip ( type: esriFieldTypeString, alias: Site Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SiteZip )
• WellUsedFor ( type: esriFieldTypeString, alias: Well Used For?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WellUsedFor )
• OwnerName ( type: esriFieldTypeString, alias: Owner Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerName )
• OwnerAddress ( type: esriFieldTypeString, alias: Owner Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerAddress )
• OwnerCity ( type: esriFieldTypeString, alias: Owner City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerCity )
• OwnerState ( type: esriFieldTypeString, alias: Owner State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: OwnerState )
• OwnerZip ( type: esriFieldTypeString, alias: Owner Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerZip )
• OwnerPhoneHome ( type: esriFieldTypeString, alias: Owner Phone (H), editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerPhoneHome )
• OwnerPhoneWork ( type: esriFieldTypeString, alias: Owner Phone (W), editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerPhoneWork )
• OwnerPhoneCell ( type: esriFieldTypeString, alias: Owner Phone (C), editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerPhoneCell )
• OwnerE_mail ( type: esriFieldTypeString, alias: Owner email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerE_mail )
• SiteStatus ( type: esriFieldTypeString, alias: Site Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SiteStatus , Coded Values: [Active: Active] , [Inactive: Inactive] , [No: No] )
• WellStatus ( type: esriFieldTypeString, alias: Well Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WellStatus , Coded Values: [Active: Active] , [Inactive: Inactive] , [No: No] )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• DateAbandoned ( type: esriFieldTypeDate, alias: Date Abandoned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateAbandoned )
• InstallerName ( type: esriFieldTypeString, alias: Installer Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InstallerName )
• Certification_ ( type: esriFieldTypeString, alias: Certification #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Certification_ )
• Registration_ ( type: esriFieldTypeString, alias: Registration #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Registration_ )
• WellDepth ( type: esriFieldTypeString, alias: Well Depth, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WellDepth )
• CasingDepth ( type: esriFieldTypeString, alias: Casing Depth, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CasingDepth )
• Diameter ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Diameter )
• GroutDepth ( type: esriFieldTypeString, alias: Grout Depth, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GroutDepth )
• Yield_GPM ( type: esriFieldTypeString, alias: Yield GPM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Yield_GPM )
• Yield_SC ( type: esriFieldTypeString, alias: Yield SC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Yield_SC )
• SWL ( type: esriFieldTypeString, alias: SWL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SWL )
• SWLDate ( type: esriFieldTypeDate, alias: SWL Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SWLDate )
• DateCollected ( type: esriFieldTypeDate, alias: DateCollected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCollected )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• ROCK_CLASS ( type: esriFieldTypeString, alias: Rock Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROCK_CLASS )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location )

Types:

ID: Active
Name: Active
Domains:
• SiteStatus:
  Inherited
• WellStatus:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  ROCK_CLASS: null
  Location: null
  WellIdNumber: null
  SiteName: null
  TaxParcelNumber: null
  SiteAddress: null
  SiteCity: null
  SiteState: null
  SiteZip: null
  WellUsedFor: null
  OwnerName: null
  OwnerAddress: null
  OwnerCity: null
  OwnerState: null
  OwnerZip: null
  OwnerPhoneHome: null
  OwnerPhoneWork: null
  OwnerPhoneCell: null
  OwnerE_mail: null
  SiteStatus: Active
  WellStatus: null
  InstallDate: null
  DateAbandoned: null
  InstallerName: null
  Certification_: null
  Registration_: null
  WellDepth: null
  CasingDepth: null
  Diameter: null
  GroutDepth: null
  Yield_GPM: null
  Yield_SC: null
  SWL: null
  SWLDate: null
  DateCollected: null
  FACILITYID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Inactive
Name: Inactive
Domains:
• SiteStatus:
  Inherited
• WellStatus:
  Inherited
Templates:
• Name: Inactive
  Description:
  Prototype:
  ROCK_CLASS: null
  Location: null
  WellIdNumber: null
  SiteName: null
  TaxParcelNumber: null
  SiteAddress: null
  SiteCity: null
  SiteState: null
  SiteZip: null
  WellUsedFor: null
  OwnerName: null
  OwnerAddress: null
  OwnerCity: null
  OwnerState: null
  OwnerZip: null
  OwnerPhoneHome: null
  OwnerPhoneWork: null
  OwnerPhoneCell: null
  OwnerE_mail: null
  SiteStatus: Inactive
  WellStatus: null
  InstallDate: null
  DateAbandoned: null
  InstallerName: null
  Certification_: null
  Registration_: null
  WellDepth: null
  CasingDepth: null
  Diameter: null
  GroutDepth: null
  Yield_GPM: null
  Yield_SC: null
  SWL: null
  SWLDate: null
  DateCollected: null
  FACILITYID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata