View In:   ArcGIS Online Map Viewer

Parent Layer: Cave Creek Water

Name: wWell

Display Field: wellname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1ef21aa1ab6643ffbbf91948b770ca0a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.2476562075106662E7
YMin: 4002146.0050769225
XMax: -1.2460138530994812E7
YMax: 4010080.024985045
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: AssetID, type: esriFieldTypeString )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 200, alias: Location Description, type: esriFieldTypeString )
• rotation ( modelName: ROTATION, nullable: true, editable: true, defaultValue: null, alias: Rotation, type: esriFieldTypeDouble )
• wellname ( modelName: WELLNAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: Name, type: esriFieldTypeString )
• welltype ( modelName: WELLTYPE, nullable: true, editable: true, defaultValue: null, length: 25, alias: Type, type: esriFieldTypeString )
• opdate ( modelName: OPDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Operational Date, type: esriFieldTypeDate )
• staticpressure ( modelName: STATICPRESSURE, nullable: true, editable: true, defaultValue: null, alias: Static Pressure, type: esriFieldTypeInteger )
• capacity ( modelName: CAPACITY, nullable: true, editable: true, defaultValue: null, alias: Maximum Pumping Capacity, type: esriFieldTypeInteger )
• dailymaxallocationmgd ( modelName: DAILYMAXALLOCATIONMGD, nullable: true, editable: true, defaultValue: null, alias: Daily Max Allocation (MGD), type: esriFieldTypeInteger )
• elevation ( modelName: ELEVATION, nullable: true, editable: true, defaultValue: null, alias: Elevation, type: esriFieldTypeDouble )
• modelnum ( modelName: MODELNUM, nullable: true, editable: true, defaultValue: null, length: 20, alias: Model Number, type: esriFieldTypeString )
• serialnum ( modelName: SERIALNUM, nullable: true, editable: true, defaultValue: null, length: 20, alias: Serial Number, type: esriFieldTypeString )
• manufacturer ( modelName: MANUFACTURER, nullable: true, editable: true, defaultValue: null, length: 10, alias: Manufacturer, type: esriFieldTypeString )
• activeflag ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: Active, length: 20, alias: Status, type: esriFieldTypeString , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [Cancelled: Cancelled] , ...7 more... )
• lifecyclestatuschangedate ( modelName: LIFECYCLESTATUSCHANGEDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LifeCycleStatusChangeDate, type: esriFieldTypeDate )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Unknown] , [1: Cave Creek Utilities] , ...3 more... )
• operatingdistrict ( modelName: OPERATINGDISTRICT, nullable: true, editable: true, defaultValue: null, length: 32, alias: OperatingDistrict, type: esriFieldTypeString , Coded Values: [CC: Cave Creek] , [DH: Desert Hills] , [CS: Cahava Springs] , ...2 more... )
• system ( modelName: SYSTEM, nullable: true, editable: true, defaultValue: null, length: 20, alias: System, type: esriFieldTypeString )
• cathodicprotection ( modelName: CATHODICPROTECTION, nullable: true, editable: true, defaultValue: null, length: 3, alias: CathodicProtection, type: esriFieldTypeString )
• watertype ( modelName: WATERTYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Water Type, type: esriFieldTypeString , Coded Values: [Potable: Potable Water] , [Raw: Raw Water] , [Reclaimed: Reclaimed Water] , ...3 more... )
• legacyid1 ( modelName: LEGACYID1, nullable: true, editable: true, defaultValue: null, length: 20, alias: LEGACYID1, type: esriFieldTypeString )
• legacyid2 ( modelName: LEGACYID2, nullable: true, editable: true, defaultValue: null, length: 20, alias: LEGACYID2, type: esriFieldTypeString )
• address ( modelName: ADDRESS, nullable: true, editable: true, defaultValue: null, length: 100, alias: Address, type: esriFieldTypeString )
• condition ( modelName: CONDITION, nullable: true, editable: true, defaultValue: null, alias: Condition, type: esriFieldTypeDouble )
• conditiondate ( modelName: CONDITIONDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Condition Date, type: esriFieldTypeDate )
• warrantydate ( modelName: WARRANTYDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty Date, type: esriFieldTypeDate )
• safetyrequirements ( modelName: SAFETYREQUIREMENTS, nullable: true, editable: true, defaultValue: null, length: 30, alias: Safety Requirements, type: esriFieldTypeString )
• cof ( modelName: COF, nullable: true, editable: true, defaultValue: null, alias: Consequence of Failure, type: esriFieldTypeInteger )
• pof ( modelName: POF, nullable: true, editable: true, defaultValue: null, alias: Probability of Failure, type: esriFieldTypeInteger )
• bre ( modelName: BRE, nullable: true, editable: true, defaultValue: null, alias: Business Risk Exposure, type: esriFieldTypeInteger )
• gpscollectiontype ( modelName: GPSCOLLECTIONTYPE, nullable: true, editable: true, defaultValue: null, length: 25, alias: GPSCollectionType, type: esriFieldTypeString )
• gpsdate ( modelName: GPSDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GPSDate, type: esriFieldTypeDate )
• gpsestacc ( modelName: GPSESTACC, nullable: true, editable: true, defaultValue: null, alias: GPSEstAcc, type: esriFieldTypeDouble )
• gpsfieldnotes ( modelName: GPSFIELDNOTES, nullable: true, editable: true, defaultValue: null, length: 100, alias: GPSFieldNotes, type: esriFieldTypeString )
• qsec ( modelName: QSEC, nullable: true, editable: true, defaultValue: null, length: 20, alias: Quartersection, type: esriFieldTypeString )
• cipnumber ( modelName: CIPNUMBER, nullable: true, editable: true, defaultValue: null, length: 15, alias: CIP Number, type: esriFieldTypeString )
• statepermitnumber ( modelName: STATEPERMITNUMBER, nullable: true, editable: true, defaultValue: null, length: 20, alias: StatePermitNumber, type: esriFieldTypeString )
• datasourcetype ( modelName: DATASOURCETYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: DataSourceType, type: esriFieldTypeString , Coded Values: [Asbuilt: As-built Record Plan] , [Construction: Construction Plan] , [Conventional Survey: Conventional Survey] , ...16 more... )
• datasourcereference ( modelName: DATASOURCEREFERENCE, nullable: true, editable: true, defaultValue: null, length: 50, alias: DataSourceReference, type: esriFieldTypeString )
• createeditor ( modelName: CREATEEDITOR, nullable: true, editable: true, defaultValue: null, length: 20, alias: Creation User, type: esriFieldTypeString )
• createdate ( modelName: CREATEDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Created, type: esriFieldTypeDate )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• cadastral ( modelName: Cadastral, nullable: true, editable: true, defaultValue: null, length: 15, alias: Cadastral, type: esriFieldTypeString )
• adwr_number ( modelName: ADWR_Number, nullable: true, editable: true, defaultValue: null, length: 15, alias: ADWR_Number, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )

Templates:

• Name: wWell
  Description:
  Prototype:
  operatingdistrict: null
  datasourcetype: null
  facilityid: null
  installdate: null
  serialnum: null
  legacyid1: null
  staticpressure: null
  pof: null
  legacyid2: null
  createdate: null
  opdate: null
  manufacturer: null
  capacity: null
  gpscollectiontype: null
  bre: null
  safetyrequirements: null
  warrantydate: null
  watertype: null
  adwr_number: null
  gpsdate: null
  ownedby: 1
  dailymaxallocationmgd: null
  conditiondate: null
  elevation: null
  address: null
  lifecyclestatuschangedate: null
  rotation: null
  modelnum: null
  cathodicprotection: null
  cadastral: null
  wellname: null
  lasteditor: null
  activeflag: Active
  gpsfieldnotes: null
  condition: null
  system: null
  qsec: null
  createeditor: null
  cipnumber: null
  datasourcereference: null
  gpsestacc: null
  statepermitnumber: null
  location: null
  maintby: 1
  cof: null
  lastupdate: null
  welltype: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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