View In:   ArcGIS Online map viewer

Name: Unpaid or Inactive Utility Billing Accounts (June 2021)

Display Field: Addresses_ST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 11753ef09ebd4330b2f636d09b960515

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 500000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -89.01369170790103
YMin: 39.80232554864615
XMax: -88.88486987464964
YMax: 39.90126820999758
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• UB_Unpaid_or_Inactive_account ( type: esriFieldTypeString, alias: UB_Unpaid_or_Inactive_account, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UB_Unpaid_or_Inactive_account )
• UB_Unpaid_or_Inactive_service_a ( type: esriFieldTypeString, alias: UB_Unpaid_or_Inactive_service_address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UB_Unpaid_or_Inactive_service_a )
• UB_Unpaid_or_Inactive_zipcode ( type: esriFieldTypeString, alias: UB_Unpaid_or_Inactive_zipcode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UB_Unpaid_or_Inactive_zipcode )
• UB_Unpaid_or_Inactive_inactive_ ( type: esriFieldTypeDate, alias: UB_Unpaid_or_Inactive_inactive_since, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UB_Unpaid_or_Inactive_inactive_ )
• UB_Unpaid_or_Inactive_billing_c ( type: esriFieldTypeString, alias: billing customer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: billing_customer )
• UB_Unpaid_or_Inactive_unpaid_bi ( type: esriFieldTypeDouble, alias: UB_Unpaid_or_Inactive_unpaid_bill_count, editable: true, nullable: true, defaultValue: null, modelName: UB_Unpaid_or_Inactive_unpaid_bi )
• UB_Unpaid_or_Inactive_unpaid_ba ( type: esriFieldTypeDouble, alias: UB_Unpaid_or_Inactive_unpaid_balance, editable: true, nullable: true, defaultValue: null, modelName: UB_Unpaid_or_Inactive_unpaid_ba )
• UB_Unpaid_or_Inactive_oldest_bi ( type: esriFieldTypeDate, alias: UB_Unpaid_or_Inactive_oldest_bill_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UB_Unpaid_or_Inactive_oldest_bi )
• UB_Unpaid_or_Inactive_bills_fro ( type: esriFieldTypeString, alias: UB_Unpaid_or_Inactive_bills_from_latest_customer_owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UB_Unpaid_or_Inactive_bills_fro )
• UB_Unpaid_or_Inactive_customer_ ( type: esriFieldTypeString, alias: UB_Unpaid_or_Inactive_customer_owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UB_Unpaid_or_Inactive_customer_ )
• Addresses_OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• Addresses_X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Addresses_Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• Addresses_STREET_NUM ( type: esriFieldTypeDouble, alias: STREET_NUM, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• Addresses_STREET_SUP ( type: esriFieldTypeString, alias: STREET_SUP, editable: true, nullable: true, length: 3, defaultValue: null, modelName: STREET_SUP )
• Addresses_STREET_DIR ( type: esriFieldTypeString, alias: STREET_DIR, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STREET_DIR )
• Addresses_STREET_TYP ( type: esriFieldTypeString, alias: STREET_TYP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: STREET_TYP )
• Addresses_UNIT_TYPE ( type: esriFieldTypeString, alias: UNIT_TYPE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: UNIT_TYPE )
• Addresses_UNIT_DESC ( type: esriFieldTypeString, alias: UNIT_DESC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNIT_DESC )
• Addresses_ZIPCODE ( type: esriFieldTypeDouble, alias: ZIPCODE, editable: true, nullable: true, defaultValue: null, modelName: ZIPCODE )
• Addresses_PIN_NUM ( type: esriFieldTypeString, alias: PIN_NUM, editable: true, nullable: true, length: 13, defaultValue: null, modelName: PIN_NUM )
• Addresses_ST_NAME ( type: esriFieldTypeString, alias: ST_NAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ST_NAME )
• Addresses_COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENTS )
• Addresses_ALT_NAME ( type: esriFieldTypeString, alias: ALT_NAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ALT_NAME )
• Addresses_ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• Addresses_ISSUEDDATE ( type: esriFieldTypeDate, alias: ISSUEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ISSUEDDATE )
• Addresses_ISSUEDBY ( type: esriFieldTypeString, alias: ISSUEDBY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ISSUEDBY , Coded Values: [1: Previous Staff] , [2: Vasu] , [3: Suzy] , ...2 more... )
• Addresses_BUILDINGID ( type: esriFieldTypeInteger, alias: BUILDINGID, editable: true, nullable: true, defaultValue: null, modelName: BUILDINGID )
• Addresses_ADDR_STATE ( type: esriFieldTypeString, alias: ADDR_STATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADDR_STATE , Coded Values: [Active: Active] , [Passive: Passive] )
• Addresses_OCCUPANCY ( type: esriFieldTypeString, alias: OCCUPANCY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OCCUPANCY , Coded Values: [Vacant Building: Vacant Building] , [Vacant Lot: Vacant Lot] , [Occupied Building: Occupied Building] )
• Addresses_BLANK ( type: esriFieldTypeString, alias: BLANK, editable: true, nullable: true, length: 2, defaultValue: null, modelName: BLANK )
• Addresses_ADDRESS_CO ( type: esriFieldTypeInteger, alias: ADDRESS_CO, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_CO )
• Addresses_CITY ( type: esriFieldTypeString, alias: Addresses_CITY, editable: true, nullable: true, length: 36, defaultValue: null, modelName: CITY )
• Addresses_STATE ( type: esriFieldTypeString, alias: Addresses_STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Unpaid or Inactive Utility Billing Accounts (June 2021)
  Description:
  Prototype:
  Addresses_STATE: null
  Addresses_CITY: null
  UB_Unpaid_or_Inactive_account: null
  UB_Unpaid_or_Inactive_service_a: null
  UB_Unpaid_or_Inactive_zipcode: null
  UB_Unpaid_or_Inactive_inactive_: null
  UB_Unpaid_or_Inactive_billing_c: null
  UB_Unpaid_or_Inactive_unpaid_bi: null
  UB_Unpaid_or_Inactive_unpaid_ba: null
  UB_Unpaid_or_Inactive_oldest_bi: null
  UB_Unpaid_or_Inactive_bills_fro: null
  UB_Unpaid_or_Inactive_customer_: null
  Addresses_OBJECTID: null
  Addresses_X: null
  Addresses_Y: null
  Addresses_STREET_NUM: null
  Addresses_STREET_SUP: null
  Addresses_STREET_DIR: null
  Addresses_STREET_TYP: null
  Addresses_UNIT_TYPE: null
  Addresses_UNIT_DESC: null
  Addresses_ZIPCODE: null
  Addresses_PIN_NUM: null
  Addresses_ST_NAME: null
  Addresses_COMMENTS: null
  Addresses_ALT_NAME: null
  Addresses_ADDRESS: null
  Addresses_ISSUEDDATE: null
  Addresses_ISSUEDBY: null
  Addresses_BUILDINGID: null
  Addresses_ADDR_STATE: null
  Addresses_OCCUPANCY: null
  Addresses_BLANK: null
  Addresses_ADDRESS_CO: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata