Name: wTankHistoryBasinLevel

Display Field: facname

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 2ebffe02d8af46e7a2c434817f1de6d5

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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: false
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: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata