View In:   ArcGIS.com Map

Name: Wells

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Municipal water wells are connected directly into a storage system where the water is then distributed. Why is it important: Unlike private wells, municipal wells are providing a water supply to entire communities or operational facilities so the quantity and quality of the water is of the utmost importance.</SPAN></P></DIV></DIV></DIV>

Copyright Text: Created and maintained by the City of Battle Creek DPW Records Division since 2005.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

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: -9489772.15383703
YMin: 5204988.875256362
XMax: -9476898.554582573
YMax: 5213979.833507408
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Supply
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Purge
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Abandoned
  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: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• BUILDING ( type: esriFieldTypeSmallInteger, alias: Building, editable: true, nullable: true, defaultValue: null, modelName: BUILDING )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• CAPACITY ( type: esriFieldTypeInteger, alias: Capacity, editable: true, nullable: true, defaultValue: null, modelName: CAPACITY , Coded Values: [300: 300 GPM] , [500: 500 GPM] , [750: 750 GPM] , ...2 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Sub Type, editable: true, nullable: true, defaultValue: 1, modelName: SUBTYPE , Coded Values: [1: Supply] , [2: Purge] )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• LAST_REBLT ( type: esriFieldTypeDate, alias: Last Rebuilt, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_REBLT )
• CAPACITY_MGD ( type: esriFieldTypeDouble, alias: Well Capacity MGD, editable: true, nullable: true, defaultValue: null, modelName: CAPACITY_MGD )
• PUMP_DEPTH ( type: esriFieldTypeDouble, alias: Pump Depth (ft), editable: true, nullable: true, defaultValue: null, modelName: PUMP_DEPTH )
• MOTOR_SIZE ( type: esriFieldTypeInteger, alias: Motor Size, editable: true, nullable: true, defaultValue: null, modelName: MOTOR_SIZE )
• CASING_SIZE ( type: esriFieldTypeInteger, alias: Casing Size (in), editable: true, nullable: true, defaultValue: null, modelName: CASING_SIZE )
• COLMN_PIPESIZE ( type: esriFieldTypeInteger, alias: Column Pipe Size (in), editable: true, nullable: true, defaultValue: null, modelName: COLMN_PIPESIZE )
• LONG_SEC_CP ( type: esriFieldTypeString, alias: Long Sec. CP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONG_SEC_CP )
• SHORT_SEC_CP ( type: esriFieldTypeString, alias: Short Sec. CP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SHORT_SEC_CP )
• SUCTION_PIPE ( type: esriFieldTypeString, alias: Suction Pipe, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SUCTION_PIPE )
• WELL_SCREEN ( type: esriFieldTypeString, alias: Well Screen, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WELL_SCREEN )
• PUMP_BRAND ( type: esriFieldTypeString, alias: Pump Brand, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMP_BRAND )
• PUMP_MODEL ( type: esriFieldTypeString, alias: Pump Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMP_MODEL )
• PUMP_SIZE ( type: esriFieldTypeInteger, alias: Pump Size (in), editable: true, nullable: true, defaultValue: null, modelName: PUMP_SIZE )
• PUMP_STAGES ( type: esriFieldTypeInteger, alias: Pump Stages, editable: true, nullable: true, defaultValue: null, modelName: PUMP_STAGES )
• SHAFT_SIZE ( type: esriFieldTypeInteger, alias: Shaft Size (in), editable: true, nullable: true, defaultValue: null, modelName: SHAFT_SIZE )
• SHAFT_MATERIAL ( type: esriFieldTypeString, alias: Shaft Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SHAFT_MATERIAL )
• DATE_MONTH_RUNHRS ( type: esriFieldTypeDate, alias: Date Monthly Run Hrs., editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_MONTH_RUNHRS )
• MONTHLY_RUNHRS ( type: esriFieldTypeInteger, alias: Monthly Run Hrs., editable: true, nullable: true, defaultValue: null, modelName: MONTHLY_RUNHRS )
• HRS_SINCE_REBUILD ( type: esriFieldTypeInteger, alias: Hrs. Since Rebuild, editable: true, nullable: true, defaultValue: null, modelName: HRS_SINCE_REBUILD )
• MONTHLY_MGD ( type: esriFieldTypeDouble, alias: MOnthly MGD, editable: true, nullable: true, defaultValue: null, modelName: MONTHLY_MGD )
• MGD_SINCE_REBUILD ( type: esriFieldTypeDouble, alias: MGD Since Rebuild, editable: true, nullable: true, defaultValue: null, modelName: MGD_SINCE_REBUILD )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: false, nullable: true, length: 150, defaultValue: null, modelName: CreatedBy )
• CreatedByDate ( type: esriFieldTypeDate, alias: Created By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedByDate )
• EditedBy ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 150, defaultValue: null, modelName: EditedBy )
• EditedByDate ( type: esriFieldTypeDate, alias: Edited By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditedByDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Latitude ( type: esriFieldTypeDouble, alias: Lattitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )

Types:

ID: 1
Name: Supply
Domains:
• CAPACITY:
  Inherited
• Enabled:
  Inherited
• SUBTYPE:
  Inherited
Templates:
• Name: Supply
  Description:
  Prototype:
  Enabled: 1
  Latitude: null
  FACILITYID: null
  BUILDING: null
  LOCATION: null
  CAPACITY: null
  COMMENTS: null
  SUBTYPE: 1
  ADDRESS: null
  LAST_REBLT: null
  CAPACITY_MGD: null
  PUMP_DEPTH: null
  MOTOR_SIZE: null
  CASING_SIZE: null
  COLMN_PIPESIZE: null
  LONG_SEC_CP: null
  SHORT_SEC_CP: null
  SUCTION_PIPE: null
  WELL_SCREEN: null
  PUMP_BRAND: null
  PUMP_MODEL: null
  PUMP_SIZE: null
  PUMP_STAGES: null
  SHAFT_SIZE: null
  SHAFT_MATERIAL: null
  DATE_MONTH_RUNHRS: null
  MONTHLY_RUNHRS: null
  HRS_SINCE_REBUILD: null
  MONTHLY_MGD: null
  MGD_SINCE_REBUILD: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Purge
Domains:
• CAPACITY:
  Inherited
• Enabled:
  Inherited
• SUBTYPE:
  Inherited
Templates:
• Name: Purge
  Description:
  Prototype:
  Enabled: 1
  Latitude: null
  FACILITYID: null
  BUILDING: null
  LOCATION: null
  CAPACITY: null
  COMMENTS: null
  SUBTYPE: 2
  ADDRESS: null
  LAST_REBLT: null
  CAPACITY_MGD: null
  PUMP_DEPTH: null
  MOTOR_SIZE: null
  CASING_SIZE: null
  COLMN_PIPESIZE: null
  LONG_SEC_CP: null
  SHORT_SEC_CP: null
  SUCTION_PIPE: null
  WELL_SCREEN: null
  PUMP_BRAND: null
  PUMP_MODEL: null
  PUMP_SIZE: null
  PUMP_STAGES: null
  SHAFT_SIZE: null
  SHAFT_MATERIAL: null
  DATE_MONTH_RUNHRS: null
  MONTHLY_RUNHRS: null
  HRS_SINCE_REBUILD: null
  MONTHLY_MGD: null
  MGD_SINCE_REBUILD: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Abandoned
Domains:
• CAPACITY:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Abandoned
  Description:
  Prototype:
  Enabled: 1
  Latitude: null
  FACILITYID: null
  BUILDING: null
  LOCATION: null
  CAPACITY: null
  COMMENTS: null
  SUBTYPE: 3
  ADDRESS: null
  LAST_REBLT: null
  CAPACITY_MGD: null
  PUMP_DEPTH: null
  MOTOR_SIZE: null
  CASING_SIZE: null
  COLMN_PIPESIZE: null
  LONG_SEC_CP: null
  SHORT_SEC_CP: null
  SUCTION_PIPE: null
  WELL_SCREEN: null
  PUMP_BRAND: null
  PUMP_MODEL: null
  PUMP_SIZE: null
  PUMP_STAGES: null
  SHAFT_SIZE: null
  SHAFT_MATERIAL: null
  DATE_MONTH_RUNHRS: null
  MONTHLY_RUNHRS: null
  HRS_SINCE_REBUILD: null
  MONTHLY_MGD: null
  MGD_SINCE_REBUILD: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedByDate
• Creator Field: CreatedBy
• Edit Date Field: EditedByDate
• Editor Field: EditedBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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