Name: CAW_DATA.dbo.Meter_Loc_Acct_CayProd
Display Field: CUSTOMER_NAME
Type: Table
Geometry Type: N/A
Description: null
Definition Expression: N/A
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 10000
Supported Query Formats: JSON, AMF
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
ID
(
type: esriFieldTypeString, alias: ID, length: 149
)
-
METER
(
type: esriFieldTypeString, alias: METER, length: 17
)
-
METER_NO
(
type: esriFieldTypeDouble, alias: METER_NO
)
-
InstallDate
(
type: esriFieldTypeString, alias: InstallDate, length: 10
)
-
CSERVICE
(
type: esriFieldTypeString, alias: CSERVICE, length: 83
)
-
METERLOCATION
(
type: esriFieldTypeString, alias: METERLOCATION, length: 2000
)
-
ROUTE
(
type: esriFieldTypeInteger, alias: ROUTE
)
-
SEQUENCE
(
type: esriFieldTypeInteger, alias: SEQUENCE
)
-
SERV_SEQ
(
type: esriFieldTypeSmallInteger, alias: SERV_SEQ
)
-
METER_BASE_ID
(
type: esriFieldTypeString, alias: METER_BASE_ID, length: 125
)
-
LOC_SERV
(
type: esriFieldTypeString, alias: LOC_SERV, length: 33
)
-
CONNECTION_NO
(
type: esriFieldTypeDouble, alias: CONNECTION_NO
)
-
PREMISE_NO
(
type: esriFieldTypeString, alias: PREMISE_NO, length: 15
)
-
ADDRESS
(
type: esriFieldTypeString, alias: ADDRESS, length: 105
)
-
UNIT
(
type: esriFieldTypeString, alias: UNIT, length: 18
)
-
UNIT_TYPE
(
type: esriFieldTypeString, alias: UNIT_TYPE, length: 5
)
-
CITY
(
type: esriFieldTypeString, alias: CITY, length: 30
)
-
ZIP_CODE
(
type: esriFieldTypeString, alias: ZIP_CODE, length: 13
)
-
BASIN
(
type: esriFieldTypeString, alias: BASIN, length: 100
)
-
SANIT_DISTRICT
(
type: esriFieldTypeString, alias: SANIT_DISTRICT, length: 15
)
-
SEWER_DISTRICT
(
type: esriFieldTypeString, alias: SEWER_DISTRICT, length: 15
)
-
SO_ZONE
(
type: esriFieldTypeString, alias: SO_ZONE, length: 5
)
-
TAX_DISTRICT
(
type: esriFieldTypeString, alias: TAX_DISTRICT, length: 15
)
-
WATER_DISTRICT
(
type: esriFieldTypeString, alias: WATER_DISTRICT, length: 15
)
-
ACTIVE_CD
(
type: esriFieldTypeString, alias: ACTIVE_CD, length: 5
)
-
CIS_NUMBER
(
type: esriFieldTypeDouble, alias: CIS_NUMBER
)
-
FINAL_BILL_DATE
(
type: esriFieldTypeString, alias: FINAL_BILL_DATE, length: 10
)
-
LAST_BILL_DATE
(
type: esriFieldTypeString, alias: LAST_BILL_DATE, length: 10
)
-
STATUS_CD
(
type: esriFieldTypeString, alias: STATUS_CD, length: 5
)
-
Main_Size
(
type: esriFieldTypeString, alias: Main_Size, length: 200
)
-
Pipe_Matl
(
type: esriFieldTypeString, alias: Pipe_Matl, length: 200
)
-
Pipe_Size
(
type: esriFieldTypeString, alias: Pipe_Size, length: 200
)
-
Service_Instal_Date
(
type: esriFieldTypeDate, alias: Service_Instal_Date, length: 8
)
-
SERVICE_TP
(
type: esriFieldTypeString, alias: SERVICE_TP, length: 5
)
-
Service_Type
(
type: esriFieldTypeString, alias: Service_Type, length: 200
)
-
ServiceLen
(
type: esriFieldTypeDouble, alias: ServiceLen
)
-
LOCATION_NO
(
type: esriFieldTypeDouble, alias: LOCATION_NO
)
-
METER_SEQ
(
type: esriFieldTypeSmallInteger, alias: METER_SEQ
)
-
LocationNo_MeterSEQ
(
type: esriFieldTypeString, alias: LocationNo_MeterSEQ, length: 82
)
Supported Operations:
Query
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata