Name: WaterCons20_23

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 57baa80ad74d4ba39a8a0e1bce30b9c6

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ACCOUNTID ( type: esriFieldTypeString, alias: ACCOUNTID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCOUNTID )
• SERVICETYPE ( type: esriFieldTypeString, alias: SERVICETYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETYPE )
• JAN20 ( type: esriFieldTypeDouble, alias: JAN20, editable: true, nullable: true, defaultValue: null, modelName: JAN20 )
• FEB20 ( type: esriFieldTypeDouble, alias: FEB20, editable: true, nullable: true, defaultValue: null, modelName: FEB20 )
• MAR20 ( type: esriFieldTypeDouble, alias: MAR20, editable: true, nullable: true, defaultValue: null, modelName: MAR20 )
• APR20 ( type: esriFieldTypeDouble, alias: APR20, editable: true, nullable: true, defaultValue: null, modelName: APR20 )
• MAY20 ( type: esriFieldTypeDouble, alias: MAY20, editable: true, nullable: true, defaultValue: null, modelName: MAY20 )
• JUN20 ( type: esriFieldTypeDouble, alias: JUN20, editable: true, nullable: true, defaultValue: null, modelName: JUN20 )
• JUL20 ( type: esriFieldTypeDouble, alias: JUL20, editable: true, nullable: true, defaultValue: null, modelName: JUL20 )
• AUG20 ( type: esriFieldTypeDouble, alias: AUG20, editable: true, nullable: true, defaultValue: null, modelName: AUG20 )
• SEP20 ( type: esriFieldTypeDouble, alias: SEP20, editable: true, nullable: true, defaultValue: null, modelName: SEP20 )
• OCT20 ( type: esriFieldTypeDouble, alias: OCT20, editable: true, nullable: true, defaultValue: null, modelName: OCT20 )
• NOV20 ( type: esriFieldTypeDouble, alias: NOV20, editable: true, nullable: true, defaultValue: null, modelName: NOV20 )
• DEC20 ( type: esriFieldTypeDouble, alias: DEC20, editable: true, nullable: true, defaultValue: null, modelName: DEC20 )
• JAN21 ( type: esriFieldTypeDouble, alias: JAN21, editable: true, nullable: true, defaultValue: null, modelName: JAN21 )
• FEB21 ( type: esriFieldTypeDouble, alias: FEB21, editable: true, nullable: true, defaultValue: null, modelName: FEB21 )
• MAR21 ( type: esriFieldTypeDouble, alias: MAR21, editable: true, nullable: true, defaultValue: null, modelName: MAR21 )
• APR21 ( type: esriFieldTypeDouble, alias: APR21, editable: true, nullable: true, defaultValue: null, modelName: APR21 )
• MAY21 ( type: esriFieldTypeDouble, alias: MAY21, editable: true, nullable: true, defaultValue: null, modelName: MAY21 )
• JUN21 ( type: esriFieldTypeDouble, alias: JUN21, editable: true, nullable: true, defaultValue: null, modelName: JUN21 )
• JUL21 ( type: esriFieldTypeDouble, alias: JUL21, editable: true, nullable: true, defaultValue: null, modelName: JUL21 )
• AUG21 ( type: esriFieldTypeDouble, alias: AUG21, editable: true, nullable: true, defaultValue: null, modelName: AUG21 )
• SEP21 ( type: esriFieldTypeDouble, alias: SEP21, editable: true, nullable: true, defaultValue: null, modelName: SEP21 )
• OCT21 ( type: esriFieldTypeDouble, alias: OCT21, editable: true, nullable: true, defaultValue: null, modelName: OCT21 )
• NOV21 ( type: esriFieldTypeDouble, alias: NOV21, editable: true, nullable: true, defaultValue: null, modelName: NOV21 )
• DEC21 ( type: esriFieldTypeDouble, alias: DEC21, editable: true, nullable: true, defaultValue: null, modelName: DEC21 )
• JAN22 ( type: esriFieldTypeDouble, alias: JAN22, editable: true, nullable: true, defaultValue: null, modelName: JAN22 )
• FEB22 ( type: esriFieldTypeDouble, alias: FEB22, editable: true, nullable: true, defaultValue: null, modelName: FEB22 )
• MAR22 ( type: esriFieldTypeDouble, alias: MAR22, editable: true, nullable: true, defaultValue: null, modelName: MAR22 )
• APR22 ( type: esriFieldTypeDouble, alias: APR22, editable: true, nullable: true, defaultValue: null, modelName: APR22 )
• MAY22 ( type: esriFieldTypeDouble, alias: MAY22, editable: true, nullable: true, defaultValue: null, modelName: MAY22 )
• JUN22 ( type: esriFieldTypeDouble, alias: JUN22, editable: true, nullable: true, defaultValue: null, modelName: JUN22 )
• JUL22 ( type: esriFieldTypeDouble, alias: JUL22, editable: true, nullable: true, defaultValue: null, modelName: JUL22 )
• AUG22 ( type: esriFieldTypeDouble, alias: AUG22, editable: true, nullable: true, defaultValue: null, modelName: AUG22 )
• SEP22 ( type: esriFieldTypeDouble, alias: SEP22, editable: true, nullable: true, defaultValue: null, modelName: SEP22 )
• OCT22 ( type: esriFieldTypeDouble, alias: OCT22, editable: true, nullable: true, defaultValue: null, modelName: OCT22 )
• NOV22 ( type: esriFieldTypeDouble, alias: NOV22, editable: true, nullable: true, defaultValue: null, modelName: NOV22 )
• DEC22 ( type: esriFieldTypeDouble, alias: DEC22, editable: true, nullable: true, defaultValue: null, modelName: DEC22 )
• JAN23 ( type: esriFieldTypeDouble, alias: JAN23, editable: true, nullable: true, defaultValue: null, modelName: JAN23 )
• TOT23 ( type: esriFieldTypeDouble, alias: TOT23, editable: true, nullable: true, defaultValue: null, modelName: TOT23 )
• TOT20 ( type: esriFieldTypeDouble, alias: TOT20, editable: true, nullable: true, defaultValue: null, modelName: TOT20 )
• TOT21 ( type: esriFieldTypeDouble, alias: TOT21, editable: true, nullable: true, defaultValue: null, modelName: TOT21 )
• TOT22 ( type: esriFieldTypeDouble, alias: TOT22, editable: true, nullable: true, defaultValue: null, modelName: TOT22 )
• FEB23 ( type: esriFieldTypeDouble, alias: FEB23, editable: true, nullable: true, defaultValue: null, modelName: FEB23 )
• MAR23 ( type: esriFieldTypeDouble, alias: MAR23, editable: true, nullable: true, defaultValue: null, modelName: MAR23 )
• APR23 ( type: esriFieldTypeDouble, alias: APR23, editable: true, nullable: true, defaultValue: null, modelName: APR23 )
• MAY23 ( type: esriFieldTypeDouble, alias: MAY23, editable: true, nullable: true, defaultValue: null, modelName: MAY23 )
• JUN23 ( type: esriFieldTypeDouble, alias: JUN23, editable: true, nullable: true, defaultValue: null, modelName: JUN23 )
• AUG23 ( type: esriFieldTypeDouble, alias: AUG23, editable: true, nullable: true, defaultValue: null, modelName: AUG23 )
• JUL23 ( type: esriFieldTypeDouble, alias: JUL23, editable: true, nullable: true, defaultValue: null, modelName: JUL23 )
• SEP23 ( type: esriFieldTypeDouble, alias: SEP23, editable: true, nullable: true, defaultValue: null, modelName: SEP23 )
• OCT23 ( type: esriFieldTypeDouble, alias: OCT23, editable: true, nullable: true, defaultValue: null, modelName: OCT23 )
• NOV23 ( type: esriFieldTypeDouble, alias: NOV23, editable: true, nullable: true, defaultValue: null, modelName: NOV23 )
• DEC23 ( type: esriFieldTypeDouble, alias: DEC23, editable: true, nullable: true, defaultValue: null, modelName: DEC23 )

Templates:

• Name: WaterCons20_23
  Description:
  Prototype:
  NOV23: null
  DEC23: null
  FACILITYID: null
  ACCOUNTID: null
  SERVICETYPE: null
  JAN20: null
  FEB20: null
  MAR20: null
  APR20: null
  MAY20: null
  JUN20: null
  JUL20: null
  AUG20: null
  SEP20: null
  OCT20: null
  NOV20: null
  DEC20: null
  JAN21: null
  FEB21: null
  MAR21: null
  APR21: null
  MAY21: null
  JUN21: null
  JUL21: null
  AUG21: null
  SEP21: null
  OCT21: null
  NOV21: null
  DEC21: null
  JAN22: null
  FEB22: null
  MAR22: null
  APR22: null
  MAY22: null
  JUN22: null
  JUL22: null
  AUG22: null
  SEP22: null
  OCT22: null
  NOV22: null
  DEC22: null
  JAN23: null
  TOT23: null
  TOT20: null
  TOT21: null
  TOT22: null
  FEB23: null
  MAR23: null
  APR23: null
  MAY23: null
  JUN23: null
  AUG23: null
  JUL23: null
  SEP23: null
  OCT23: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

Child Resources:   Field Groups   Contingent Values

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