Name: SWSBU.dbo.AllActiveServicesView
Display Field: arcs_name1
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 15b63f0a0a7d4e278246404478393d00
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:
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:
-
utsvm_serv_code
(
type: esriFieldTypeString, alias: utsvm_serv_code, length: 6
)
-
utsvm_serv_status
(
type: esriFieldTypeString, alias: utsvm_serv_status, length: 1
)
-
utsvm_stop_date
(
type: esriFieldTypeDate, alias: utsvm_stop_date, length: 8
)
-
utsvm_utacd_key
(
type: esriFieldTypeInteger, alias: utsvm_utacd_key
)
-
utsvm_start_date
(
type: esriFieldTypeDate, alias: utsvm_start_date, length: 8
)
-
utacd_account
(
type: esriFieldTypeString, alias: utacd_account, length: 30
)
-
utacd_cid
(
type: esriFieldTypeInteger, alias: utacd_cid
)
-
utacm_parcel
(
type: esriFieldTypeString, alias: utacm_parcel, length: 30
)
-
Parcel
(
type: esriFieldTypeDouble, alias: Parcel
)
-
arcs_name1
(
type: esriFieldTypeString, alias: arcs_name1, length: 40
)
-
arcs_name2
(
type: esriFieldTypeString, alias: arcs_name2, length: 40
)
-
arcs_addr1
(
type: esriFieldTypeString, alias: arcs_addr1, length: 40
)
-
arcs_addr2
(
type: esriFieldTypeString, alias: arcs_addr2, length: 40
)
-
arcs_city
(
type: esriFieldTypeString, alias: arcs_city, length: 20
)
-
arcs_state
(
type: esriFieldTypeString, alias: arcs_state, length: 2
)
-
arcs_zip
(
type: esriFieldTypeString, alias: arcs_zip, length: 10
)
-
utsvm_rate_code
(
type: esriFieldTypeString, alias: utsvm_rate_code, length: 4
)
-
utsvm_route_book
(
type: esriFieldTypeString, alias: utsvm_route_book, length: 6
)
-
pipu_alt_parcel
(
type: esriFieldTypeString, alias: pipu_alt_parcel, length: 30
)
-
pipu_imperv
(
type: esriFieldTypeInteger, alias: pipu_imperv
)
-
utacm_loc_no
(
type: esriFieldTypeInteger, alias: utacm_loc_no
)
-
utacm_loc_pre_dir
(
type: esriFieldTypeString, alias: utacm_loc_pre_dir, length: 4
)
-
utacm_loc_street
(
type: esriFieldTypeString, alias: utacm_loc_street, length: 25
)
-
utacm_loc_str_typ
(
type: esriFieldTypeString, alias: utacm_loc_str_typ, length: 10
)
-
utacm_loc_unit_typ
(
type: esriFieldTypeString, alias: utacm_loc_unit_typ, length: 10
)
-
utacm_loc_apt
(
type: esriFieldTypeString, alias: utacm_loc_apt, length: 5
)
-
ServiceID
(
type: esriFieldTypeInteger, alias: ServiceID
)
-
upsize_ts
(
type: esriFieldTypeBlob, alias: upsize_ts
)
-
MonthlyRate
(
type: esriFieldTypeDouble, alias: MonthlyRate
)
-
AnnualRate
(
type: esriFieldTypeDouble, alias: AnnualRate
)
-
BillMonth
(
type: esriFieldTypeString, alias: BillMonth, length: 20
)
-
DelayedBillMonth
(
type: esriFieldTypeString, alias: DelayedBillMonth, length: 2147483647
)
-
FullAN
(
type: esriFieldTypeString, alias: FullAN, length: 12
)
-
ServiceLocation
(
type: esriFieldTypeString, alias: ServiceLocation, length: 1073741822
)
-
utsvm_factor
(
type: esriFieldTypeDouble, alias: utsvm_factor
)
-
utacd_stop_date
(
type: esriFieldTypeDate, alias: utacd_stop_date, length: 8
)
-
TierERU
(
type: esriFieldTypeDouble, alias: TierERU
)
-
LastUpdated
(
type: esriFieldTypeDate, alias: LastUpdated, length: 8
)
-
ESRI_OID
(
type: esriFieldTypeOID, alias: ESRI_OID
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata