Layers:

Layer: Days Past Due (8)

Name: Days Past Due

Display Field: arbh_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU.dbo.AllSWBillsOneYearView2024

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -1.2184155719092585E8
YMin: -9.365862200518383E7
XMax: 1.2584155719615918E8
YMax: 5.991355664156069E7
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Class Breaks Renderer:
Field: DaysOver
Min. Value: -18.0
ClassBreakInfos:
• Class Maximum Value: 21
  Label: Not Past Due
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [165, 255, 117, 255]
  Size: 2.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Class Maximum Value: 42
  Label: 22 - 42
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 117, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Class Maximum Value: 124
  Label: More than 42
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 25
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• argls_type ( type: esriFieldTypeOID, alias: argls_type )
• arbh_ar_cat ( type: esriFieldTypeSmallInteger, alias: arbh_ar_cat )
• arbd_chg_def ( type: esriFieldTypeString, alias: arbd_chg_def, length: 6 )
• arbh_name ( type: esriFieldTypeString, alias: arbh_name, length: 40 )
• arbh_loc_no ( type: esriFieldTypeInteger, alias: arbh_loc_no )
• arbh_loc_street ( type: esriFieldTypeString, alias: arbh_loc_street, length: 25 )
• arbh_prop_cd ( type: esriFieldTypeString, alias: arbh_prop_cd, length: 30 )
• BillNum ( type: esriFieldTypeInteger, alias: BillNum )
• arbh_acct ( type: esriFieldTypeInteger, alias: arbh_acct )
• arbh_ud_bal ( type: esriFieldTypeDouble, alias: arbh_ud_bal )
• BillYear ( type: esriFieldTypeSmallInteger, alias: BillYear )
• FullAn ( type: esriFieldTypeInteger, alias: FullAn )
• DueAmt ( type: esriFieldTypeDouble, alias: DueAmt )
• DaysOver ( type: esriFieldTypeInteger, alias: DaysOver )
• BillDate ( type: esriFieldTypeDate, alias: BillDate, length: 8 )
• OrgAmt ( type: esriFieldTypeDouble, alias: OrgAmt )
• AddPtNum ( type: esriFieldTypeInteger, alias: AddPtNum )
• APID ( type: esriFieldTypeInteger, alias: APID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )

Layer: WaterDistricts (28)

Name: WaterDistricts

Display Field: AMR_Dist

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1992982.6250150055
YMin: 768855.9290154278
XMax: 2089147.1502052546
YMax: 869969.8140575886
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: AMR_Dist
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [130, 130, 130, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: 02
  Label: 02
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [38, 145, 88, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 03
  Label: 03
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [102, 31, 143, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 05
  Label: 05
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [138, 46, 30, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 06
  Label: 06
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [34, 101, 143, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 07
  Label: 07
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [156, 176, 42, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 08
  Label: 08
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [171, 39, 103, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 09
  Label: 09
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [140, 112, 69, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 10
  Label: 10
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [75, 173, 173, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 11
  Label: 11
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [70, 176, 56, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 13
  Label: 13
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [31, 62, 148, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 14
  Label: 14
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [135, 68, 72, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 15
  Label: 15
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [117, 138, 61, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 16
  Label: 16
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [133, 66, 127, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 17
  Label: 17
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [171, 72, 176, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 18
  Label: 18
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [176, 39, 59, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 21
  Label: 21
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [173, 103, 42, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 40
Labeling Info:
Label Placement: esriServerPolygonPlacementAlwaysHorizontal
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• AMR_Dist ( type: esriFieldTypeString, alias: AMR_Dist, length: 2 )
• District ( type: esriFieldTypeString, alias: District, length: 2 )
• Shape_Length ( type: esriFieldTypeDouble, alias: Shape_Length )
• Shape_Area ( type: esriFieldTypeDouble, alias: Shape_Area )

Layer: Customer Inquiries - FY 2020 (3)

Name: Customer Inquiries - FY 2020

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU."DURHAM_DOMAIN\CHRISTYWE".CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: HOA
  Label: HOA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 255, 223, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [115, 255, 223, 255] Width: 0
• Value: Non-Residential
  Label: Non-Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [197, 0, 255, 255] Width: 0
• Value: Residential
  Label: Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Customer Inquiries - FY 2021 (4)

Name: Customer Inquiries - FY 2021

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU."DURHAM_DOMAIN\CHRISTYWE".CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: HOA
  Label: HOA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 255, 223, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [115, 255, 223, 255] Width: 0
• Value: Non-Residential
  Label: Non-Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [197, 0, 255, 255] Width: 0
• Value: Residential
  Label: Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Customer Inquiries - FY 2022 (2)

Name: Customer Inquiries - FY 2022

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU."DURHAM_DOMAIN\CHRISTYWE".CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: HOA
  Label: HOA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 255, 223, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [115, 255, 223, 255] Width: 0
• Value: Non-Residential
  Label: Non-Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [197, 0, 255, 255] Width: 0
• Value: Residential
  Label: Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Customer Inquiries - FY 2023 (1)

Name: Customer Inquiries - FY 2023

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU."DURHAM_DOMAIN\CHRISTYWE".CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: HOA
  Label: HOA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 255, 223, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [115, 255, 223, 255] Width: 0
• Value: Non-Residential
  Label: Non-Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [197, 0, 255, 255] Width: 0
• Value: Residential
  Label: Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Customer Inquiries - FY 2024 (0)

Name: Customer Inquiries - FY 2024

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU."DURHAM_DOMAIN\CHRISTYWE".CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: HOA
  Label: HOA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 255, 223, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [115, 255, 223, 255] Width: 0
• Value: Non-Residential
  Label: Non-Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [197, 0, 255, 255] Width: 0
• Value: Residential
  Label: Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Customer Inquiries - Last 7 Days (5)

Name: Customer Inquiries - Last 7 Days

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU."DURHAM_DOMAIN\CHRISTYWE".CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[130, 130, 130, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: HOA
  Label: HOA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 255, 223, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [115, 255, 223, 255] Width: 0
• Value: Non-Residential
  Label: Non-Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [197, 0, 255, 255] Width: 0
• Value: Residential
  Label: Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Customer Inquiries - Last 30 Days (6)

Name: Customer Inquiries - Last 30 Days

Display Field: RESHOANONRES

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU."DURHAM_DOMAIN\CHRISTYWE".CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[130, 130, 130, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: HOA
  Label: HOA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 255, 223, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [115, 255, 223, 255] Width: 0
• Value: Non-Residential
  Label: Non-Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [197, 0, 255, 255] Width: 0
• Value: Residential
  Label: Residential
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: All Customer Inquiries (7)

Name: All Customer Inquiries

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU.dbo.CustomerInquiriesXY

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1998917.1767941415
YMin: 770408.0200713128
XMax: 2069668.497561559
YMax: 904816.2099158168
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [38, 115, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[38, 115, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )
• APID ( type: esriFieldTypeInteger, alias: APID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Stormwater Accounts Billed Year (13)

Name: Stormwater Accounts Billed Year

Display Field: arbh_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SWSBU.dbo.AllSWBillsOneYearView

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1999058.8366158009
YMin: 770397.1546074748
XMax: 2033701.667264387
YMax: 824033.806520313
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [122, 182, 245, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[122, 182, 245, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• argls_type ( type: esriFieldTypeSmallInteger, alias: argls_type )
• arbh_ar_cat ( type: esriFieldTypeSmallInteger, alias: arbh_ar_cat )
• arbd_chg_def ( type: esriFieldTypeString, alias: arbd_chg_def, length: 6 )
• arbh_name ( type: esriFieldTypeString, alias: arbh_name, length: 40 )
• arbh_loc_no ( type: esriFieldTypeInteger, alias: arbh_loc_no )
• arbh_loc_street ( type: esriFieldTypeString, alias: arbh_loc_street, length: 25 )
• arbh_prop_cd ( type: esriFieldTypeString, alias: arbh_prop_cd, length: 30 )
• BillNum ( type: esriFieldTypeOID, alias: BillNum )
• arbh_acct ( type: esriFieldTypeInteger, alias: arbh_acct )
• arbh_ud_bal ( type: esriFieldTypeDouble, alias: arbh_ud_bal )
• FullAn ( type: esriFieldTypeInteger, alias: FullAn )
• DueAmt ( type: esriFieldTypeDouble, alias: DueAmt )
• DaysOver ( type: esriFieldTypeInteger, alias: DaysOver )
• AddPtNum ( type: esriFieldTypeInteger, alias: AddPtNum )
• BillDate ( type: esriFieldTypeDate, alias: BillDate, length: 8 )
• OrgAmt ( type: esriFieldTypeDouble, alias: OrgAmt )
• APID ( type: esriFieldTypeInteger, alias: APID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )

Layer: City Council Wards (9)

Name: City Council Wards

Display Field: LOCALGOV

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Polygon feature class representing the City of Durham Council Wards. Adopted November 2022 for required 2020 Census redistricting. No voting precincts are split by ward boundariesThis feature class represents the City Council Wards current as of the latest adopted annexation case for each Quarter.

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text: City of Durham - Technology Solutions Department GIS Services

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1997768.135461986
YMin: 770284.1400000006
XMax: 2074381.1817119867
YMax: 868814.5
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Ward
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [130, 130, 130, 0]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: Ward 1
  Label: Ward 1
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [179, 233, 252, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Ward 2
  Label: Ward 2
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 190, 232, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Ward 3
  Label: Ward 3
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [202, 122, 245, 255]
  Outline:
  Style: esriSLSSolid
  Color: [202, 122, 245, 255]
  Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LOCALGOV ( type: esriFieldTypeString, alias: LOCALGOV, length: 30 )
• Ward ( type: esriFieldTypeString, alias: Ward, length: 10 )
• DisField ( type: esriFieldTypeString, alias: DisField, length: 50 )
• WardRep ( type: esriFieldTypeString, alias: WardRep, length: 254 )
• AtLargeRep ( type: esriFieldTypeString, alias: AtLargeRep, length: 254 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Layer: Durham City Limits (11)

Name: Durham City Limits

Display Field: LOCALGOV

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This feature class represent the City limits current as of the latest adopted annexation case for each Quarter.This Feature Class is used for preparing the official Published Corporate Limits Map of the City of Durham.This Feature Class should not be used in place of the official published Corporate Limits Map of the City of Durham.This Feature Class is intended for internal use only

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text: City of Durham, NC

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1997768.135461986
YMin: 770284.1400000006
XMax: 2074381.1817119867
YMax: 868814.5
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 255, 190, 255]
Outline:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LOCALGOV ( type: esriFieldTypeString, alias: LOCALGOV, length: 30 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Tables:

Table: SWSBU.dbo.CUSTOMERINQUIRIESviewQL (12)

Name: SWSBU.dbo.CUSTOMERINQUIRIESviewQL

Display Field: CUSTOMERNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• CONTACTDATE ( type: esriFieldTypeDate, alias: CONTACTDATE, length: 8 )
• HANDLEDBY ( type: esriFieldTypeString, alias: HANDLEDBY, length: 255 )
• CALLER ( type: esriFieldTypeString, alias: CALLER, length: 255 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 255 )
• ACCOUNT ( type: esriFieldTypeInteger, alias: ACCOUNT )
• SITEADDRESS ( type: esriFieldTypeString, alias: SITEADDRESS, length: 255 )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID )
• CUSTOMERCONCERN ( type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255 )
• ACCOUNTADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT )
• REVENUEADJUSTMENT ( type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• DATEOFCONTACT ( type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8 )
• ADDRESSPOINT ( type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6 )
• Revenue_Adjustment ( type: esriFieldTypeDouble, alias: Revenue_Adjustment )
• RESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: RESIDENTIAL )
• NONRESIDENTIAL ( type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL )
• PARCELID ( type: esriFieldTypeInteger, alias: PARCELID )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255 )
• RESHOANONRES ( type: esriFieldTypeString, alias: RESHOANONRES, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, length: 255 )
• upsize_ts ( type: esriFieldTypeBlob, alias: upsize_ts )
• MapSent ( type: esriFieldTypeDate, alias: MapSent, length: 8 )

Table: SWSBU.dbo.CustomerContactPerMonth2QL (14)

Name: SWSBU.dbo.CustomerContactPerMonth2QL

Display Field: ContactYear

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• ContactYear ( type: esriFieldTypeInteger, alias: ContactYear )
• ContactMonth ( type: esriFieldTypeInteger, alias: ContactMonth )
• ContactCount ( type: esriFieldTypeInteger, alias: ContactCount )

Table: SWSBU.dbo.AllActiveSWServicesViewQL (15)

Name: SWSBU.dbo.AllActiveSWServicesViewQL

Display Field: arcs_name1

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


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: esriFieldTypeOID, 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 )

Table: SWSBU.dbo.GLMasterPositiveNumberViewQL (16)

Name: SWSBU.dbo.GLMasterPositiveNumberViewQL

Display Field: a_account_type

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• a_account_type ( type: esriFieldTypeString, alias: a_account_type, length: 1 )
• a_fund_seg1 ( type: esriFieldTypeString, alias: a_fund_seg1, length: 10 )
• a_remaining_orgseg ( type: esriFieldTypeString, alias: a_remaining_orgseg, length: 30 )
• a_object ( type: esriFieldTypeString, alias: a_object, length: 6 )
• a_project ( type: esriFieldTypeString, alias: a_project, length: 10 )
• a_org ( type: esriFieldTypeString, alias: a_org, length: 8 )
• a_entity_code ( type: esriFieldTypeString, alias: a_entity_code, length: 1 )
• a_account_desc ( type: esriFieldTypeString, alias: a_account_desc, length: 30 )
• a_account_desc_sh ( type: esriFieldTypeString, alias: a_account_desc_sh, length: 10 )
• a_bal_sheet_type ( type: esriFieldTypeString, alias: a_bal_sheet_type, length: 1 )
• a_account_status ( type: esriFieldTypeString, alias: a_account_status, length: 1 )
• d_encumb_bud_y_n ( type: esriFieldTypeString, alias: d_encumb_bud_y_n, length: 1 )
• a_budgetary_y_n ( type: esriFieldTypeString, alias: a_budgetary_y_n, length: 1 )
• a_grant_org ( type: esriFieldTypeString, alias: a_grant_org, length: 8 )
• a_grant_object ( type: esriFieldTypeString, alias: a_grant_object, length: 6 )
• a_grant_project ( type: esriFieldTypeString, alias: a_grant_project, length: 5 )
• a_last_update ( type: esriFieldTypeDate, alias: a_last_update, length: 8 )
• a_bal_sheet_sign ( type: esriFieldTypeString, alias: a_bal_sheet_sign, length: 1 )
• a_segment_2 ( type: esriFieldTypeString, alias: a_segment_2, length: 10 )
• a_segment_3 ( type: esriFieldTypeString, alias: a_segment_3, length: 10 )
• a_segment_4 ( type: esriFieldTypeString, alias: a_segment_4, length: 10 )
• a_segment_5 ( type: esriFieldTypeString, alias: a_segment_5, length: 10 )
• a_segment_6 ( type: esriFieldTypeString, alias: a_segment_6, length: 10 )
• a_segment_7 ( type: esriFieldTypeString, alias: a_segment_7, length: 10 )
• a_segment_8 ( type: esriFieldTypeString, alias: a_segment_8, length: 10 )
• a_bud_yr ( type: esriFieldTypeSmallInteger, alias: a_bud_yr )
• b_incept_bal ( type: esriFieldTypeDouble, alias: b_incept_bal )
• d_bud_in_5years ( type: esriFieldTypeDouble, alias: d_bud_in_5years )
• d_ny5_statistics ( type: esriFieldTypeDouble, alias: d_ny5_statistics )
• d_bud_in_4years ( type: esriFieldTypeDouble, alias: d_bud_in_4years )
• d_ny4_statistics ( type: esriFieldTypeDouble, alias: d_ny4_statistics )
• d_bud_in_3years ( type: esriFieldTypeDouble, alias: d_bud_in_3years )
• d_ny3_statistics ( type: esriFieldTypeDouble, alias: d_ny3_statistics )
• d_bud_in_2years ( type: esriFieldTypeDouble, alias: d_bud_in_2years )
• d_ny2_statistics ( type: esriFieldTypeDouble, alias: d_ny2_statistics )
• d_bud_ny_level1 ( type: esriFieldTypeDouble, alias: d_bud_ny_level1 )
• d_bud_ny_level2 ( type: esriFieldTypeDouble, alias: d_bud_ny_level2 )
• d_bud_ny_level3 ( type: esriFieldTypeDouble, alias: d_bud_ny_level3 )
• d_bud_ny_level4 ( type: esriFieldTypeDouble, alias: d_bud_ny_level4 )
• d_bud_ny_level5 ( type: esriFieldTypeDouble, alias: d_bud_ny_level5 )
• d_ny_stat_level1 ( type: esriFieldTypeDouble, alias: d_ny_stat_level1 )
• d_ny_stat_level2 ( type: esriFieldTypeDouble, alias: d_ny_stat_level2 )
• d_ny_stat_level3 ( type: esriFieldTypeDouble, alias: d_ny_stat_level3 )
• d_ny_stat_level4 ( type: esriFieldTypeDouble, alias: d_ny_stat_level4 )
• d_ny_stat_level5 ( type: esriFieldTypeDouble, alias: d_ny_stat_level5 )
• d_bud_cy_level1 ( type: esriFieldTypeDouble, alias: d_bud_cy_level1 )
• d_bud_cy_level2 ( type: esriFieldTypeDouble, alias: d_bud_cy_level2 )
• d_bud_cy_level3 ( type: esriFieldTypeDouble, alias: d_bud_cy_level3 )
• d_bud_cy_level4 ( type: esriFieldTypeDouble, alias: d_bud_cy_level4 )
• d_bud_cy_level5 ( type: esriFieldTypeDouble, alias: d_bud_cy_level5 )
• d_cy_orig_bud ( type: esriFieldTypeDouble, alias: d_cy_orig_bud )
• d_cy_xfr_bud_in ( type: esriFieldTypeDouble, alias: d_cy_xfr_bud_in )
• d_cy_xfr_bud_out ( type: esriFieldTypeDouble, alias: d_cy_xfr_bud_out )
• d_carry_fwrd_cy ( type: esriFieldTypeDouble, alias: d_carry_fwrd_cy )
• d_cary_fwrd_cy_xfr ( type: esriFieldTypeDouble, alias: d_cary_fwrd_cy_xfr )
• d_cy_revised_bud ( type: esriFieldTypeDouble, alias: d_cy_revised_bud )
• b_cy_memo_bal ( type: esriFieldTypeDouble, alias: b_cy_memo_bal )
• b_cy_actual_bal ( type: esriFieldTypeDouble, alias: b_cy_actual_bal )
• b_cy_actl_from_ly ( type: esriFieldTypeDouble, alias: b_cy_actl_from_ly )
• b_cy_est_actual ( type: esriFieldTypeDouble, alias: b_cy_est_actual )
• d_cy_statistics ( type: esriFieldTypeDouble, alias: d_cy_statistics )
• b_cy_encumb ( type: esriFieldTypeDouble, alias: b_cy_encumb )
• b_cy_encmb_frm_ly ( type: esriFieldTypeDouble, alias: b_cy_encmb_frm_ly )
• b_cy_req_balance ( type: esriFieldTypeDouble, alias: b_cy_req_balance )
• d_ly1_orig_bud ( type: esriFieldTypeDouble, alias: d_ly1_orig_bud )
• d_ly1_xfr_bud_in ( type: esriFieldTypeDouble, alias: d_ly1_xfr_bud_in )
• d_ly1_xfr_bud_out ( type: esriFieldTypeDouble, alias: d_ly1_xfr_bud_out )
• d_carry_fwrd_ly1 ( type: esriFieldTypeDouble, alias: d_carry_fwrd_ly1 )
• d_ly1_rev_bud ( type: esriFieldTypeDouble, alias: d_ly1_rev_bud )
• b_ly_memo_bal ( type: esriFieldTypeDouble, alias: b_ly_memo_bal )
• b_ly1_actual_bal ( type: esriFieldTypeDouble, alias: b_ly1_actual_bal )
• b_closed_yr_bal ( type: esriFieldTypeDouble, alias: b_closed_yr_bal )
• d_ly1_statistics ( type: esriFieldTypeDouble, alias: d_ly1_statistics )
• b_ly1_encumb ( type: esriFieldTypeDouble, alias: b_ly1_encumb )
• d_ly2_orig_bud ( type: esriFieldTypeDouble, alias: d_ly2_orig_bud )
• d_ly2_rev_bud ( type: esriFieldTypeDouble, alias: d_ly2_rev_bud )
• b_ly2_actual_bal ( type: esriFieldTypeDouble, alias: b_ly2_actual_bal )
• d_ly2_statistics ( type: esriFieldTypeDouble, alias: d_ly2_statistics )
• d_ly3_orig_bud ( type: esriFieldTypeDouble, alias: d_ly3_orig_bud )
• d_ly3_rev_bud ( type: esriFieldTypeDouble, alias: d_ly3_rev_bud )
• b_ly3_actual_bal ( type: esriFieldTypeDouble, alias: b_ly3_actual_bal )
• d_ly3_statistics ( type: esriFieldTypeDouble, alias: d_ly3_statistics )
• b_ly4_actual_bal ( type: esriFieldTypeDouble, alias: b_ly4_actual_bal )
• b_ly5_actual_bal ( type: esriFieldTypeDouble, alias: b_ly5_actual_bal )
• b_ly6_actual_bal ( type: esriFieldTypeDouble, alias: b_ly6_actual_bal )
• b_ly7_actual_bal ( type: esriFieldTypeDouble, alias: b_ly7_actual_bal )
• b_ly8_actual_bal ( type: esriFieldTypeDouble, alias: b_ly8_actual_bal )
• b_ly9_actual_bal ( type: esriFieldTypeDouble, alias: b_ly9_actual_bal )
• b_ly10_actual_bal ( type: esriFieldTypeDouble, alias: b_ly10_actual_bal )
• d_incp_orig_bud ( type: esriFieldTypeDouble, alias: d_incp_orig_bud )
• d_incp_rev_bud ( type: esriFieldTypeDouble, alias: d_incp_rev_bud )
• b_ny_memo_bal ( type: esriFieldTypeDouble, alias: b_ny_memo_bal )
• b_ny_encumb_bal ( type: esriFieldTypeDouble, alias: b_ny_encumb_bal )
• b_ny_req_bal ( type: esriFieldTypeDouble, alias: b_ny_req_bal )
• d_ny_rev_bud ( type: esriFieldTypeDouble, alias: d_ny_rev_bud )
• d_budget_factor ( type: esriFieldTypeSingle, alias: d_budget_factor )
• d_carry_fwd_unusd ( type: esriFieldTypeDouble, alias: d_carry_fwd_unusd )
• d_filler ( type: esriFieldTypeString, alias: d_filler, length: 50 )
• a_warn_level ( type: esriFieldTypeDouble, alias: a_warn_level )
• d_req_buddet ( type: esriFieldTypeString, alias: d_req_buddet, length: 1 )
• d_actual_from_ly2 ( type: esriFieldTypeDouble, alias: d_actual_from_ly2 )
• d_spend_plan ( type: esriFieldTypeString, alias: d_spend_plan, length: 4 )
• a_object_desc ( type: esriFieldTypeString, alias: a_object_desc, length: 30 )
• a_object_desc_sh ( type: esriFieldTypeString, alias: a_object_desc_sh, length: 10 )
• a_charcode ( type: esriFieldTypeString, alias: a_charcode, length: 2 )
• ob_object_status ( type: esriFieldTypeString, alias: ob_object_status, length: 1 )
• ob_budqty_label ( type: esriFieldTypeString, alias: ob_budqty_label, length: 10 )
• ob_filler ( type: esriFieldTypeString, alias: ob_filler, length: 50 )
• ob_status_label ( type: esriFieldTypeString, alias: ob_status_label, length: 5 )
• ob_sub_object ( type: esriFieldTypeSmallInteger, alias: ob_sub_object )
• a_charcode_desc ( type: esriFieldTypeString, alias: a_charcode_desc, length: 20 )
• a_org_description ( type: esriFieldTypeString, alias: a_org_description, length: 30 )
• a_org_desc_sh ( type: esriFieldTypeString, alias: a_org_desc_sh, length: 10 )
• gp_deflt_year ( type: esriFieldTypeSmallInteger, alias: gp_deflt_year )
• gp_deflt_period ( type: esriFieldTypeSmallInteger, alias: gp_deflt_period )
• gp_curr_year ( type: esriFieldTypeSmallInteger, alias: gp_curr_year )
• gp_curr_period ( type: esriFieldTypeSmallInteger, alias: gp_curr_period )
• b_cy_encmb_frm_ly2 ( type: esriFieldTypeDouble, alias: b_cy_encmb_frm_ly2 )
• b_desc_ny ( type: esriFieldTypeString, alias: b_desc_ny, length: 30 )
• b_ctl_acct ( type: esriFieldTypeString, alias: b_ctl_acct, length: 4 )
• b_contra ( type: esriFieldTypeString, alias: b_contra, length: 1 )
• b_close_bal ( type: esriFieldTypeString, alias: b_close_bal, length: 1 )
• b_bud_req5_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req5_ny2 )
• b_bud_req4_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req4_ny2 )
• b_bud_req3_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req3_ny2 )
• b_bud_req2_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req2_ny2 )
• b_full_account ( type: esriFieldTypeString, alias: b_full_account, length: 55 )
• d_bud_ny6 ( type: esriFieldTypeDouble, alias: d_bud_ny6 )
• d_bud_ny7 ( type: esriFieldTypeDouble, alias: d_bud_ny7 )
• d_bud_ny8 ( type: esriFieldTypeDouble, alias: d_bud_ny8 )
• d_bud_ny9 ( type: esriFieldTypeDouble, alias: d_bud_ny9 )
• d_bud_ny10 ( type: esriFieldTypeDouble, alias: d_bud_ny10 )
• my_orig_bud_fy ( type: esriFieldTypeDouble, alias: my_orig_bud_fy )
• my_bud_xfr_in_fy ( type: esriFieldTypeDouble, alias: my_bud_xfr_in_fy )
• my_bud_xfr_out_fy ( type: esriFieldTypeDouble, alias: my_bud_xfr_out_fy )
• my_rev_bud_fy ( type: esriFieldTypeDouble, alias: my_rev_bud_fy )
• my_orig_bud_ltd ( type: esriFieldTypeDouble, alias: my_orig_bud_ltd )
• my_bud_xfr_in_ltd ( type: esriFieldTypeDouble, alias: my_bud_xfr_in_ltd )
• my_bud_xfr_out_ltd ( type: esriFieldTypeDouble, alias: my_bud_xfr_out_ltd )
• my_rev_bud_ltd ( type: esriFieldTypeDouble, alias: my_rev_bud_ltd )
• glma_stat2_ny2 ( type: esriFieldTypeDouble, alias: glma_stat2_ny2 )
• glma_stat3_ny2 ( type: esriFieldTypeDouble, alias: glma_stat3_ny2 )
• glma_stat4_ny2 ( type: esriFieldTypeDouble, alias: glma_stat4_ny2 )
• glma_stat5_ny2 ( type: esriFieldTypeDouble, alias: glma_stat5_ny2 )
• glma_stat_ny6 ( type: esriFieldTypeDouble, alias: glma_stat_ny6 )
• glma_stat_ny7 ( type: esriFieldTypeDouble, alias: glma_stat_ny7 )
• glma_stat_ny8 ( type: esriFieldTypeDouble, alias: glma_stat_ny8 )
• glma_stat_ny9 ( type: esriFieldTypeDouble, alias: glma_stat_ny9 )
• glma_stat_ny10 ( type: esriFieldTypeDouble, alias: glma_stat_ny10 )
• glma_charcode ( type: esriFieldTypeString, alias: glma_charcode, length: 2 )
• glma_salary ( type: esriFieldTypeString, alias: glma_salary, length: 1 )
• glma_beg_eff_dt ( type: esriFieldTypeDate, alias: glma_beg_eff_dt, length: 8 )
• glma_end_eff_dt ( type: esriFieldTypeDate, alias: glma_end_eff_dt, length: 8 )
• glma_orig_bud_ny ( type: esriFieldTypeDouble, alias: glma_orig_bud_ny )
• glma_pa_required ( type: esriFieldTypeString, alias: glma_pa_required, length: 1 )
• glma_grant_id ( type: esriFieldTypeString, alias: glma_grant_id, length: 10 )
• d_rollup_budget ( type: esriFieldTypeString, alias: d_rollup_budget, length: 1 )
• s_segment1_desc ( type: esriFieldTypeString, alias: s_segment1_desc, length: 30 )
• s_segment2_desc ( type: esriFieldTypeString, alias: s_segment2_desc, length: 30 )
• s_segment3_desc ( type: esriFieldTypeString, alias: s_segment3_desc, length: 30 )
• s_segment4_desc ( type: esriFieldTypeString, alias: s_segment4_desc, length: 30 )
• s_segment5_desc ( type: esriFieldTypeString, alias: s_segment5_desc, length: 30 )
• s_segment6_desc ( type: esriFieldTypeString, alias: s_segment6_desc, length: 30 )
• s_segment7_desc ( type: esriFieldTypeString, alias: s_segment7_desc, length: 30 )
• s_segment8_desc ( type: esriFieldTypeString, alias: s_segment8_desc, length: 30 )
• d_ny_xfr_bud_in ( type: esriFieldTypeDouble, alias: d_ny_xfr_bud_in )
• d_ny_xfr_bud_out ( type: esriFieldTypeDouble, alias: d_ny_xfr_bud_out )
• d_grant_id ( type: esriFieldTypeInteger, alias: d_grant_id )
• a_account_id ( type: esriFieldTypeInteger, alias: a_account_id )
• account_notes ( type: esriFieldTypeString, alias: account_notes, length: 1073741823 )
• PositiveActualBal ( type: esriFieldTypeDouble, alias: PositiveActualBal )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.AllActiveSWServices (17)

Name: SWSBU.dbo.AllActiveSWServices

Display Field: arcs_name1

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


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: esriFieldTypeOID, 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 )

Table: SWSBU.dbo.MONTHLYACCOUNTSBYSERVICETYPE (18)

Name: SWSBU.dbo.MONTHLYACCOUNTSBYSERVICETYPE

Display Field: DateEntered

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DateEntered ( type: esriFieldTypeDate, alias: DateEntered, length: 8 )
• Tier1 ( type: esriFieldTypeInteger, alias: Tier1 )
• Tier2 ( type: esriFieldTypeInteger, alias: Tier2 )
• Tier3 ( type: esriFieldTypeInteger, alias: Tier3 )
• NonRes ( type: esriFieldTypeInteger, alias: NonRes )
• Total_NonResERU ( type: esriFieldTypeInteger, alias: Total_NonResERU )

Table: SWSBU.dbo.TotalRevenuePerMonth2024 (19)

Name: SWSBU.dbo.TotalRevenuePerMonth2024

Display Field: ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeString, alias: ID, length: 21 )
• BillYear ( type: esriFieldTypeInteger, alias: BillYear )
• BillMonth ( type: esriFieldTypeInteger, alias: BillMonth )
• BillSum ( type: esriFieldTypeDouble, alias: BillSum )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.TotalAccountsPerMonthByServiceCode2024 (20)

Name: SWSBU.dbo.TotalAccountsPerMonthByServiceCode2024

Display Field: ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeString, alias: ID, length: 21 )
• BillYear ( type: esriFieldTypeInteger, alias: BillYear )
• BillMonth ( type: esriFieldTypeInteger, alias: BillMonth )
• TotalAccounts ( type: esriFieldTypeInteger, alias: TotalAccounts )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.BillActiveServiceMonthlySWOnly (21)

Name: SWSBU.dbo.BillActiveServiceMonthlySWOnly

Display Field: utsvm_serv_code

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


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 )
• AmountPaid ( type: esriFieldTypeDouble, alias: AmountPaid )
• SumOfMonthlylRate ( type: esriFieldTypeDouble, alias: SumOfMonthlylRate )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.BillActiveServiceMonthly (22)

Name: SWSBU.dbo.BillActiveServiceMonthly

Display Field: utsvm_serv_code

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


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 )
• AmountPaid ( type: esriFieldTypeDouble, alias: AmountPaid )
• SumOfMonthlyRate ( type: esriFieldTypeDouble, alias: SumOfMonthlyRate )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.BillActiveServiceAllByAddresspoint (23)

Name: SWSBU.dbo.BillActiveServiceAllByAddresspoint

Display Field: utsvm_serv_code

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


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 )
• AmountPaid ( type: esriFieldTypeDouble, alias: AmountPaid )
• SumOfOrgAmt ( type: esriFieldTypeDouble, alias: SumOfOrgAmt )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.BillActiveServiceAnnualSWOnly (24)

Name: SWSBU.dbo.BillActiveServiceAnnualSWOnly

Display Field: utsvm_serv_code

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


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 )
• AmountPaid ( type: esriFieldTypeDouble, alias: AmountPaid )
• SumOfAnnualRate ( type: esriFieldTypeDouble, alias: SumOfAnnualRate )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.BillActiveServiceAnnual2024 (25)

Name: SWSBU.dbo.BillActiveServiceAnnual2024

Display Field: utsvm_serv_code

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


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 )
• AmountPaid ( type: esriFieldTypeDouble, alias: AmountPaid )
• SumOfAnnualRate ( type: esriFieldTypeDouble, alias: SumOfAnnualRate )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.AllSWBillsPerMonth2024 (26)

Name: SWSBU.dbo.AllSWBillsPerMonth2024

Display Field: ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeString, alias: ID, length: 21 )
• BillYear ( type: esriFieldTypeInteger, alias: BillYear )
• BillMonth ( type: esriFieldTypeInteger, alias: BillMonth )
• BillCount ( type: esriFieldTypeInteger, alias: BillCount )
• arbd_chg_def ( type: esriFieldTypeString, alias: arbd_chg_def, length: 6 )
• FullAn ( type: esriFieldTypeInteger, alias: FullAn )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: SWSBU.dbo.BillActiveServiceByAddresspoint (27)

Name: SWSBU.dbo.BillActiveServiceByAddresspoint

Display Field: BillNum

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• BillYear ( type: esriFieldTypeOID, alias: BillYear )
• BillNum ( type: esriFieldTypeInteger, alias: BillNum )
• AdPt ( type: esriFieldTypeString, alias: AdPt, length: 30 )
• OrgAmt ( type: esriFieldTypeDouble, alias: OrgAmt )
• DueAmt ( type: esriFieldTypeDouble, alias: DueAmt )
• FullAn ( type: esriFieldTypeInteger, alias: FullAn )
• DaysOver ( type: esriFieldTypeInteger, alias: DaysOver )
• ServiceLocation ( type: esriFieldTypeString, alias: ServiceLocation, length: 72 )
• utsvm_serv_code ( type: esriFieldTypeString, alias: utsvm_serv_code, length: 6 )
• utsvm_rate_code ( type: esriFieldTypeString, alias: utsvm_rate_code, length: 4 )
• utsvm_route_book ( type: esriFieldTypeString, alias: utsvm_route_book, length: 6 )
• MonthlyRate ( type: esriFieldTypeDouble, alias: MonthlyRate )
• AnnualRate ( type: esriFieldTypeDouble, alias: AnnualRate )