Name: dbo.MeterHistory_27

Display Field: code_type

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 2ef44fa5ca1e4339887a9927aad9294a

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• code_type ( type: esriFieldTypeString, alias: code_type, length: 12 )
• service_nbr ( type: esriFieldTypeInteger, alias: service_nbr )
• account_nbr ( type: esriFieldTypeInteger, alias: account_nbr )
• meter_tag ( type: esriFieldTypeInteger, alias: meter_tag )
• lat ( type: esriFieldTypeDouble, alias: lat )
• long ( type: esriFieldTypeDouble, alias: long )
• code ( type: esriFieldTypeSmallInteger, alias: code )
• date ( type: esriFieldTypeDate, alias: date, length: 8 )
• mtr_size_cd ( type: esriFieldTypeDouble, alias: mtr_size_cd )
• dtctr_mtr_size_cd ( type: esriFieldTypeSingle, alias: dtctr_mtr_size_cd )
• mtr_loc ( type: esriFieldTypeString, alias: mtr_loc, length: 1073741822 )
• make_code ( type: esriFieldTypeString, alias: make_code, length: 2 )
• route_nbr ( type: esriFieldTypeSmallInteger, alias: route_nbr )
• class_code ( type: esriFieldTypeSmallInteger, alias: class_code )
• srvc_addr ( type: esriFieldTypeString, alias: srvc_addr, length: 50 )
• type ( type: esriFieldTypeString, alias: type, length: 3 )
• remote_reg ( type: esriFieldTypeInteger, alias: remote_reg )
• mxu ( type: esriFieldTypeInteger, alias: mxu )
• meterNbr ( type: esriFieldTypeString, alias: meterNbr, length: 9 )
• bypass ( type: esriFieldTypeString, alias: bypass, length: 1 )
• read_date ( type: esriFieldTypeInteger, alias: read_date )
• reg_type ( type: esriFieldTypeString, alias: reg_type, length: 3 )
• url ( type: esriFieldTypeString, alias: url, length: 147 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata