Tables:

Table: CAW_GIS.CAW.FEATURE_LOCATE (17)

Name: CAW_GIS.CAW.FEATURE_LOCATE

Display Field: PRI_STREET

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• LOCATE_ID ( type: esriFieldTypeOID, alias: LOCATE_ID )
• PRI_STREET ( type: esriFieldTypeString, alias: PRI_STREET, length: 30 )
• DISTANCE1 ( type: esriFieldTypeDouble, alias: DISTANCE1 )
• DIRECTION1 ( type: esriFieldTypeString, alias: DIRECTION1, length: 5 )
• REFERENCE1 ( type: esriFieldTypeString, alias: REFERENCE1, length: 30 )
• INT_STREET ( type: esriFieldTypeString, alias: INT_STREET, length: 30 )
• DISTANCE2 ( type: esriFieldTypeDouble, alias: DISTANCE2 )
• DIRECTION2 ( type: esriFieldTypeString, alias: DIRECTION2, length: 5 )
• REFERENCE2 ( type: esriFieldTypeString, alias: REFERENCE2, length: 30 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• HYDT ( type: esriFieldTypeString, alias: HYDT, length: 7 )
• MAP_VA_NUM ( type: esriFieldTypeString, alias: MAP_VA_NUM, length: 12 )
• FEATURE_ID ( type: esriFieldTypeString, alias: FEATURE_ID, length: 15 )
• ObjectID ( type: esriFieldTypeInteger, alias: ObjectID )
• msrepl_tran_version ( type: esriFieldTypeGUID, alias: msrepl_tran_version, length: 38 )

Table: CAW_DATA.dbo.Meter_Loc_Acct_CayProd (18)

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


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 )