Name: Utilities_Water.dbo.vConsumption_GIS
Display Field: OVERIDEDT
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: fe991c69a9f44f0da5b97a0eead93cfc
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing 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: 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:
-
UniqIDs
(
type: esriFieldTypeOID, alias: UniqIDs
)
-
TRANSDATE
(
type: esriFieldTypeInteger, alias: TRANSDATE
)
-
ACTUALUSED
(
type: esriFieldTypeInteger, alias: ACTUALUSED
)
-
SERVDAYS
(
type: esriFieldTypeSmallInteger, alias: SERVDAYS
)
-
OVERIDEDT
(
type: esriFieldTypeString, alias: OVERIDEDT, length: 1
)
-
SERIALNBR
(
type: esriFieldTypeString, alias: SERIALNBR, length: 14
)
-
READING
(
type: esriFieldTypeInteger, alias: READING
)
-
ESTRECD
(
type: esriFieldTypeString, alias: ESTRECD, length: 2
)
-
DEMANDREAD
(
type: esriFieldTypeDouble, alias: DEMANDREAD
)
-
OFFPDEMDUS
(
type: esriFieldTypeDouble, alias: OFFPDEMDUS
)
-
CONSUMED
(
type: esriFieldTypeInteger, alias: CONSUMED
)
-
TRANSNBR
(
type: esriFieldTypeDouble, alias: TRANSNBR
)
-
ADKEY
(
type: esriFieldTypeInteger, alias: ADKEY
)
-
USAGEMONTH
(
type: esriFieldTypeInteger, alias: USAGEMONTH
)
-
READDATNUM
(
type: esriFieldTypeInteger, alias: READDATNUM
)
-
OFFPDEMDRD
(
type: esriFieldTypeDouble, alias: OFFPDEMDRD
)
-
READCODE
(
type: esriFieldTypeSmallInteger, alias: READCODE
)
-
CURRENTCUS
(
type: esriFieldTypeSmallInteger, alias: CURRENTCUS
)
-
CUSTNO
(
type: esriFieldTypeDouble, alias: CUSTNO
)
-
DEMANDUSED
(
type: esriFieldTypeDouble, alias: DEMANDUSED
)
-
RMOVED
(
type: esriFieldTypeString, alias: RMOVED, length: 1
)
-
WORS
(
type: esriFieldTypeString, alias: WORS, length: 1
)
-
BILLED
(
type: esriFieldTypeInteger, alias: BILLED
)
-
METERKY
(
type: esriFieldTypeInteger, alias: METERKY
)
-
MXCONSUMED
(
type: esriFieldTypeInteger, alias: MXCONSUMED
)
-
USGFLAG2
(
type: esriFieldTypeString, alias: USGFLAG2, length: 1
)
-
USGFLAG1
(
type: esriFieldTypeString, alias: USGFLAG1, length: 1
)
-
OLDMETERKY
(
type: esriFieldTypeInteger, alias: OLDMETERKY
)
-
MNCONSUMED
(
type: esriFieldTypeInteger, alias: MNCONSUMED
)
-
KWRDORIG
(
type: esriFieldTypeDouble, alias: KWRDORIG
)
-
KVRHREAD
(
type: esriFieldTypeInteger, alias: KVRHREAD
)
-
CALCPWRF
(
type: esriFieldTypeSingle, alias: CALCPWRF
)
-
KVRHUSED
(
type: esriFieldTypeInteger, alias: KVRHUSED
)
-
BILLEDKW
(
type: esriFieldTypeDouble, alias: BILLEDKW
)
-
KWUSED
(
type: esriFieldTypeDouble, alias: KWUSED
)
-
SONBR
(
type: esriFieldTypeInteger, alias: SONBR
)
-
STREETDIR
(
type: esriFieldTypeString, alias: STREETDIR, length: 2
)
-
STREETPREF
(
type: esriFieldTypeString, alias: STREETPREF, length: 2
)
-
STREETNBR
(
type: esriFieldTypeInteger, alias: STREETNBR
)
-
SUITE
(
type: esriFieldTypeString, alias: SUITE, length: 10
)
-
FRAHOUSE
(
type: esriFieldTypeString, alias: FRAHOUSE, length: 5
)
-
STREETTYPE
(
type: esriFieldTypeString, alias: STREETTYPE, length: 5
)
-
STREET
(
type: esriFieldTypeString, alias: STREET, length: 25
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata