Name: wTankHistoryWellSounding

Display Field: facname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 22855a28835547818ad834cd8a2875f1

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, editable: true, nullable: true, length: 20, defaultValue: null, modelName: assetkey )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workorderid )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1, editable: true, nullable: true, defaultValue: null, modelName: attachmentid1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2, editable: true, nullable: true, defaultValue: null, modelName: attachmentid2 )
• workby ( type: esriFieldTypeString, alias: WorkBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workby , Coded Values: [Carlos Solis: Carlos Solis] , [Ed Cazares: Ed Cazares] , [Emanuel Cardoso: Emanuel Cardoso] , ...6 more... )
• worktype ( type: esriFieldTypeString, alias: worktype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: worktype , Coded Values: [Well Production: Well Production] , [Well Inspection: Well Inspection] , [Well Sounding: Well Sounding] , ...3 more... )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• facname ( type: esriFieldTypeString, alias: facname, editable: true, nullable: true, length: 50, defaultValue: null, modelName: facname )
• storagetype ( type: esriFieldTypeString, alias: storagetype, editable: true, nullable: true, length: 30, defaultValue: null, modelName: storagetype , Coded Values: [Hydropillar: Hydropillar] , [Standpipe: Standpipe] , [Reservoir: Reservoir] , ...3 more... )
• pressurezone ( type: esriFieldTypeString, alias: pressurezone, editable: true, nullable: true, length: 30, defaultValue: null, modelName: pressurezone , Coded Values: [1023 Zone: 1023 Zone] , [590 Zone: 590 Zone] , [715 Zone: 715 Zone] , ...4 more... )
• material ( type: esriFieldTypeString, alias: material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: material , Coded Values: [Concrete: Concrete] , [Steel: Steel] , [Glass Infused Steel: Glass Infused Steel] , ...2 more... )
• capacity ( type: esriFieldTypeDouble, alias: capacity, editable: true, nullable: true, defaultValue: null, modelName: capacity )
• topelevtrigger ( type: esriFieldTypeDouble, alias: topelevtrigger, editable: true, nullable: true, defaultValue: null, modelName: topelevtrigger )
• lowelevtrigger ( type: esriFieldTypeDouble, alias: lowelevtrigger, editable: true, nullable: true, defaultValue: null, modelName: lowelevtrigger )
• waterlevel ( type: esriFieldTypeDouble, alias: waterlevel, editable: true, nullable: true, defaultValue: null, modelName: waterlevel )
• gpm ( type: esriFieldTypeDouble, alias: gpm, editable: true, nullable: true, defaultValue: null, modelName: gpm )
• flowccf ( type: esriFieldTypeDouble, alias: flowccf, editable: true, nullable: true, defaultValue: null, modelName: flowccf )
• flowccf_last ( type: esriFieldTypeDouble, alias: flowccf_last, editable: true, nullable: true, defaultValue: null, modelName: flowccf_last )
• flow ( type: esriFieldTypeDouble, alias: flow, editable: true, nullable: true, defaultValue: null, modelName: flow )
• hourmeter ( type: esriFieldTypeDouble, alias: hourmeter, editable: true, nullable: true, defaultValue: null, modelName: hourmeter )
• hourmeter_last ( type: esriFieldTypeDouble, alias: hourmeter_last, editable: true, nullable: true, defaultValue: null, modelName: hourmeter_last )
• runtime ( type: esriFieldTypeDouble, alias: runtime, editable: true, nullable: true, defaultValue: null, modelName: runtime )
• kwhmeter ( type: esriFieldTypeDouble, alias: kwhmeter, editable: true, nullable: true, defaultValue: null, modelName: kwhmeter )
• kwhmeter_last ( type: esriFieldTypeDouble, alias: kwhmeter_last, editable: true, nullable: true, defaultValue: null, modelName: kwhmeter_last )
• kwhmeter_diff ( type: esriFieldTypeDouble, alias: kwhmeter_diff, editable: true, nullable: true, defaultValue: null, modelName: kwhmeter_diff )
• kwhused ( type: esriFieldTypeDouble, alias: kwhused, editable: true, nullable: true, defaultValue: null, modelName: kwhused )
• kwhperccf ( type: esriFieldTypeDouble, alias: kwhperccf, editable: true, nullable: true, defaultValue: null, modelName: kwhperccf )
• kwhperhr ( type: esriFieldTypeDouble, alias: kwhperhr, editable: true, nullable: true, defaultValue: null, modelName: kwhperhr )
• demand_last ( type: esriFieldTypeDouble, alias: demand_last, editable: true, nullable: true, defaultValue: null, modelName: demand_last )
• flowaf ( type: esriFieldTypeDouble, alias: flowaf, editable: true, nullable: true, defaultValue: null, modelName: flowaf )
• flowaf_last ( type: esriFieldTypeDouble, alias: flowaf_last, editable: true, nullable: true, defaultValue: null, modelName: flowaf_last )
• sewermeter_diff ( type: esriFieldTypeDouble, alias: sewermeter_diff, editable: true, nullable: true, defaultValue: null, modelName: sewermeter_diff )
• swl ( type: esriFieldTypeDouble, alias: swl, editable: true, nullable: true, defaultValue: null, modelName: swl )
• pwl ( type: esriFieldTypeDouble, alias: pwl, editable: true, nullable: true, defaultValue: null, modelName: pwl )
• wellstatus ( type: esriFieldTypeString, alias: wellstatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wellstatus , Coded Values: [On: On] , [Off: Off] , [Out of Service: Out of Service] )
• wellfield ( type: esriFieldTypeString, alias: wellfield, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wellfield , Coded Values: [Hand: Hand] , [Off: Off] , [Auto: Auto] )
• dischargepsi ( type: esriFieldTypeDouble, alias: dischargepsi, editable: true, nullable: true, defaultValue: null, modelName: dischargepsi )
• localcntrlswtch ( type: esriFieldTypeString, alias: localcntrlswtch, editable: true, nullable: true, length: 50, defaultValue: null, modelName: localcntrlswtch , Coded Values: [Hand: Hand] , [Off: Off] , [Time Clock: Time Clock] )
• timeclockon ( type: esriFieldTypeDouble, alias: timeclockon, editable: true, nullable: true, defaultValue: null, modelName: timeclockon )
• timeclockoff ( type: esriFieldTypeDouble, alias: timeclockoff, editable: true, nullable: true, defaultValue: null, modelName: timeclockoff )
• demandkw ( type: esriFieldTypeDouble, alias: demandkw, editable: true, nullable: true, defaultValue: null, modelName: demandkw )
• sightoiler ( type: esriFieldTypeDouble, alias: sightoiler, editable: true, nullable: true, defaultValue: null, modelName: sightoiler )
• operationalcntrl ( type: esriFieldTypeString, alias: operationalcntrl, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operationalcntrl , Coded Values: [Local / Manual: Local / Manual] , [Remote / Auto: Remote / Auto] )
• waterlevelrunning ( type: esriFieldTypeDouble, alias: waterlevelrunning, editable: true, nullable: true, defaultValue: null, modelName: waterlevelrunning )
• cl2pump ( type: esriFieldTypeSmallInteger, alias: cl2pump, editable: true, nullable: true, defaultValue: null, modelName: cl2pump )
• cl2pumpspeed ( type: esriFieldTypeSmallInteger, alias: cl2pumpspeed, editable: true, nullable: true, defaultValue: null, modelName: cl2pumpspeed )
• cl2residual ( type: esriFieldTypeDouble, alias: cl2residual, editable: true, nullable: true, defaultValue: null, modelName: cl2residual )
• starttime ( type: esriFieldTypeDate, alias: starttime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: starttime )
• initials ( type: esriFieldTypeString, alias: initials, editable: true, nullable: true, length: 30, defaultValue: null, modelName: initials , Coded Values: [amartinez: amartinez] , [csolis: csolis] , [ecazares: ecazares] , ...6 more... )
• productiontotal_ccf ( type: esriFieldTypeDouble, alias: productiontotal_ccf, editable: true, nullable: true, defaultValue: null, modelName: productiontotal_ccf )
• productiontotal_mg ( type: esriFieldTypeDouble, alias: productiontotal_mg, editable: true, nullable: true, defaultValue: null, modelName: productiontotal_mg )
• productiontotal_af ( type: esriFieldTypeDouble, alias: productiontotal_af, editable: true, nullable: true, defaultValue: null, modelName: productiontotal_af )
• motorheat ( type: esriFieldTypeString, alias: motorheat, editable: true, nullable: true, length: 50, defaultValue: null, modelName: motorheat , Coded Values: [Okay: Okay] , [N/A: N/A] , [Issue: Issue] )
• pumpvibration ( type: esriFieldTypeString, alias: pumpvibration, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pumpvibration , Coded Values: [Okay: Okay] , [N/A: N/A] , [Issue: Issue] )
• bearinghouse ( type: esriFieldTypeString, alias: bearinghouse, editable: true, nullable: true, length: 50, defaultValue: null, modelName: bearinghouse , Coded Values: [Okay: Okay] , [N/A: N/A] , [Issue: Issue] )
• oillevel ( type: esriFieldTypeString, alias: oillevel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: oillevel , Coded Values: [Okay: Okay] , [N/A: N/A] , [Issue: Issue] )
• totalkwh ( type: esriFieldTypeDouble, alias: totalkwh, editable: true, nullable: true, defaultValue: null, modelName: totalkwh )
• diversionaf ( type: esriFieldTypeDouble, alias: diversionaf, editable: true, nullable: true, defaultValue: null, modelName: diversionaf )
• diversionaf_last ( type: esriFieldTypeDouble, alias: diversionaf_last, editable: true, nullable: true, defaultValue: null, modelName: diversionaf_last )
• diversionaf_diff ( type: esriFieldTypeDouble, alias: diversionaf_diff, editable: true, nullable: true, defaultValue: null, modelName: diversionaf_diff )
• c9flow ( type: esriFieldTypeDouble, alias: c9flow, editable: true, nullable: true, defaultValue: null, modelName: c9flow )
• c9flow_last ( type: esriFieldTypeDouble, alias: c9flow_last, editable: true, nullable: true, defaultValue: null, modelName: c9flow_last )
• c9flow_diff ( type: esriFieldTypeDouble, alias: c9flow_diff, editable: true, nullable: true, defaultValue: null, modelName: c9flow_diff )
• watersource ( type: esriFieldTypeString, alias: watersource, editable: true, nullable: true, length: 25, defaultValue: null, modelName: watersource , Coded Values: [Conduit: Conduit] , [River: River] , [Off: Off] , ...2 more... )
• wtpinfluentaf ( type: esriFieldTypeDouble, alias: wtpinfluentaf, editable: true, nullable: true, defaultValue: null, modelName: wtpinfluentaf )
• wtpinfluentaf_last ( type: esriFieldTypeDouble, alias: wtpinfluentaf_last, editable: true, nullable: true, defaultValue: null, modelName: wtpinfluentaf_last )
• wtpinfluentaf_diff ( type: esriFieldTypeDouble, alias: wtpinfluentaf_diff, editable: true, nullable: true, defaultValue: null, modelName: wtpinfluentaf_diff )
• allocationaf ( type: esriFieldTypeDouble, alias: allocationaf, editable: true, nullable: true, defaultValue: null, modelName: allocationaf )
• spreadwateraf ( type: esriFieldTypeDouble, alias: spreadwateraf, editable: true, nullable: true, defaultValue: null, modelName: spreadwateraf )
• multiplier ( type: esriFieldTypeDouble, alias: multiplier, editable: true, nullable: true, defaultValue: null, modelName: multiplier )
• sounding_date_time ( type: esriFieldTypeDate, alias: soundingdatetime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sounding_date_time )
• well_running_static ( type: esriFieldTypeString, alias: well_running_static, editable: true, nullable: true, length: 50, defaultValue: null, modelName: well_running_static , Coded Values: [Running: Running] , [Static: Static] )
• sounding_method ( type: esriFieldTypeString, alias: sounding_method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sounding_method , Coded Values: [Tape: Tape] , [Automated Pressure Transducer: Automated Pressure Transducer] , [Other: Other] )
• productiontotal_gal ( type: esriFieldTypeDouble, alias: productiontotal_gal, editable: true, nullable: true, defaultValue: null, modelName: productiontotal_gal )
• wocreatedby ( type: esriFieldTypeString, alias: wocreatedby, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wocreatedby )
• wocreateddate ( type: esriFieldTypeDate, alias: wocreateddate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: wocreateddate )
• wodescription ( type: esriFieldTypeString, alias: wodescription, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: wodescription )
• wonotes ( type: esriFieldTypeString, alias: wonotes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: wonotes )
• woaddress ( type: esriFieldTypeString, alias: woaddress, editable: true, nullable: true, length: 100, defaultValue: null, modelName: woaddress )
• wocustomer ( type: esriFieldTypeString, alias: wocustomer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wocustomer )
• WorkDate2 ( type: esriFieldTypeDate, alias: WorkDate2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkDate2 )
• workdate ( type: esriFieldTypeDate, alias: workdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: workdate )

Templates:

• Name: wTankHistoryWellSounding
  Description:
  Prototype:
  WorkDate2: null
  workdate: null
  assetkey: null
  workorderid: null
  attachmentid1: null
  attachmentid2: null
  workby: null
  worktype: null
  comments: null
  facname: null
  storagetype: null
  pressurezone: null
  material: null
  capacity: null
  topelevtrigger: null
  lowelevtrigger: null
  waterlevel: null
  gpm: null
  flowccf: null
  flowccf_last: null
  flow: null
  hourmeter: null
  hourmeter_last: null
  runtime: null
  kwhmeter: null
  kwhmeter_last: null
  kwhmeter_diff: null
  kwhused: null
  kwhperccf: null
  kwhperhr: null
  demand_last: null
  flowaf: null
  flowaf_last: null
  sewermeter_diff: null
  swl: null
  pwl: null
  wellstatus: null
  wellfield: null
  dischargepsi: null
  localcntrlswtch: null
  timeclockon: null
  timeclockoff: null
  demandkw: null
  sightoiler: null
  operationalcntrl: null
  waterlevelrunning: null
  cl2pump: null
  cl2pumpspeed: null
  cl2residual: null
  starttime: null
  initials: null
  productiontotal_ccf: null
  productiontotal_mg: null
  productiontotal_af: null
  motorheat: null
  pumpvibration: null
  bearinghouse: null
  oillevel: null
  totalkwh: null
  diversionaf: null
  diversionaf_last: null
  diversionaf_diff: null
  c9flow: null
  c9flow_last: null
  c9flow_diff: null
  watersource: null
  wtpinfluentaf: null
  wtpinfluentaf_last: null
  wtpinfluentaf_diff: null
  allocationaf: null
  spreadwateraf: null
  multiplier: null
  sounding_date_time: null
  well_running_static: null
  sounding_method: null
  productiontotal_gal: null
  wocreatedby: null
  wocreateddate: null
  wodescription: null
  wonotes: null
  woaddress: null
  wocustomer: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GISPROD.DBO.wWaterSources (2) -- Related To: wWaterSources (0)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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