Open Data Catalogue

Downspout Disconnect Service Requests

311
The file ending with "_YTD.csv" will be updated frequently, often multiple times per week. The file ending with a range will usually be posted early in the following year.
Service to disconnect homeowner downspouts. The dataset contains information on customer initiated service requests entered into the City of Windsor 311 system from various channels (phone, email, online self-serve, text). 311 manages the service request data for City of Windsor departments and divisions represented in this dataset. As such, 311 consulted the participating divisions and subject matter experts for this release. This data set is extracted electronically from the 311 customer request management system.
This data represents only a portion of overall City of Windsor services and the number and location of service requests will not be representative of the full range of services provided by the City of Windsor. This data represents requests for service entered into the 311 system initiated from the customer's perspective based on description provided by the customer at the time of contact with 311. However, during the request fulfillment process, it could be determined that the customer's request may not be valid or may need to be adjusted. For example a request for a tree trim is made, but upon investigation by the Forestry department it is determined that the tree is on private property and therefore the responsibility of the property owner to maintain. Review of data should take into consideration the urban attributes and context of the issue being reported, such as vegetation density, population density, age of infrastructure asset, zoning and applicable by-laws, and it should also be noted that multiple reports may be received for the same issue, which can influence results.
  • ​Service Request Description: A text field of the request for service description created within the 311 system. The 311 service creates requests on behalf of the customer and forwards it to the appropriate department or division for action.
  • Department: A text field indicating the department or division responsible to follow up on the request for service.
  • Method Received: A text field indicating the channel by which the inquiry was received: phone, email, online or text.
  • Created Date: Numeric field indicating the date and time the service request was entered into the system.
  • Block: Numeric field representing the block location of the reported service request.
  • Street: Text field providing the street name location of the reported service request.
  • Ward:  Alpha numeric field indicating the political ward  associated with the reported service request.
Back to List