This dataset includes over 76,000 service requests received by ServiceOakville by phone, email or through the website since 2018. Each request information contains case number, category and sub-category, case type, status, and the location of the request. This request dataset is linked to Oakville address point dataset, and other datasets such as various bulding permits, property information, etc.
Subject | Community |
Jurisdiction | ServiceOakville, Town of Oakville, Province of Ontario |
Data Provider | Town of Oakville |
Source | https://portal-exploreoakville.opendata.arcgis.com/ |
The Town of Oakville, via ServiceOakville, handles service requests (or cases) for issues about garbage, graffiti, park maintenance, and road and sidewalk maintenance. The service requests can be made by phone, email or through the website. The service types inlude (1) Home, Property, Taxes; (2) Parks, Harbours & Trails; (3) Roads, Sidewalks & Traffics; (4) Trees & Woodlands; (5) Other Services. The service requests are categorized as Works Operations, Forestry, Parks Operations, Traffic, Permits, Inspections and Road Corridor, Transportation Strategy, Finance, Harbours, Engineering and Construction, Park Planning and Development, Building Services, Facilities and Construction Management, etc.
This dataset includes over 76,000 service requests received by ServiceOakville since 2018. The data fields of requests include case number, case type, category and sub-category, case status, created data, the location of the request, ward, etc. Each request data is linked to its property address point data, and also other data such as various building permits.
This dataset includs 76,000 service requests issued by the Building Services of the Town of Oakville since 2018. The number of requests was around 12000 per year from 2018 to 2020, and then it starts growing gradually, by 14% in 2021 and 10% in 2022. In each year, there are ususally more requests received in March to Jun than other months, especially winter months.
The most requested service type is Roads, Sidewalks & Traffics, accounting for 52.23% of all requests. The other service types include Trees & Woodlands (38.03%), Parks, Harbours & Trails (21.51%), Home, Property, Taxes (7.19%), and Other Services (3.61%). The most requested service category is Works Operations (39.25% of all requests), followed by Forestry (38.03%) and Parks Operations (20.34%). The other mostly requested categories include Traffic (9.68%), Permits, Inspections and Road Corridor (4.36%), ServiceOakville (3.61%), Transportation Strategy (3.30%), Finance (1.71%), etc.
The street with the most number of service requests is Lakeshore Rd W, followed by Lakeshore Rd E and Rebecca St. The other prominent street names include Trafalgar Rd, Sixth Line, Bridge Rd, Bronte Rd, Devon Rd, Glenashton Dr, and Westoak Trails Blvd.
Year | Requests | Percent |
---|---|---|
2023 | 7284 | 9.54% |
2022 | 15629 | 20.46% |
2021 | 14207 | 18.60% |
2020 | 12412 | 16.25% |
2019 | 13035 | 17.07% |
2018 | 12013 | 15.73% |
Month | Requests | Percent |
---|---|---|
May 2023 | 985 | 1.29% |
Apr 2023 | 1541 | 2.02% |
Mar 2023 | 2130 | 2.79% |
Feb 2023 | 1429 | 1.87% |
Jan 2023 | 1199 | 1.57% |
Dec 2022 | 713 | 0.93% |
Nov 2022 | 975 | 1.28% |
Oct 2022 | 1057 | 1.38% |
Sep 2022 | 1236 | 1.62% |
Aug 2022 | 1585 | 2.08% |
Jul 2022 | 1492 | 1.95% |
Jun 2022 | 1967 | 2.58% |
Type | Requests | Percent |
---|---|---|
Roads, Sidewalks & Traffi | 32550 | 52.23% |
Trees & Woodlands | 23696 | 38.03% |
Parks, Harbours & Trails | 13402 | 21.51% |
Home, Property, Taxes | 4482 | 7.19% |
Other Services | 2252 | 3.61% |
Category | Requests | Percent |
---|---|---|
Works Operations | 24459 | 39.25% |
Forestry | 23696 | 38.03% |
Parks Operations | 12676 | 20.34% |
Traffic | 6033 | 9.68% |
Permits, Inspections and Road Corridor | 2720 | 4.36% |
ServiceOakville | 2252 | 3.61% |
Transportation Strategy | 2058 | 3.30% |
Finance | 1068 | 1.71% |
Harbours | 439 | 0.70% |
Engineering and Construction | 418 | 0.67% |
Park Planning and Development | 287 | 0.46% |
Building Services | 270 | 0.43% |
Street | Requests | Percent |
---|---|---|
Lakeshore Rd W | 762 | 1.22% |
Lakeshore Rd E | 557 | 0.89% |
Rebecca St | 532 | 0.85% |
Trafalgar Rd | 403 | 0.65% |
Sixth Line | 351 | 0.56% |
Bridge Rd | 318 | 0.51% |
Bronte Rd | 291 | 0.47% |
Devon Rd | 268 | 0.43% |
Glenashton Dr | 245 | 0.39% |
Westoak Trails Blvd | 235 | 0.38% |
Pilgrims Way | 232 | 0.37% |
Kerr St | 232 | 0.37% |
Case Number: 00472930 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-18 Status: Open |
Case Number: 00472984 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-18 Status: Open |
Case Number: 00472895 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Planting Created Date: 2023-05-18 Status: Open |
Case Number: 00472987 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Removal Created Date: 2023-05-18 Status: Open |
Case Number: 00472728 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-18 Status: In Progress |
Case Number: 00472970 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Planting Created Date: 2023-05-18 Status: Open |
Case Number: 00472980 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Removal Created Date: 2023-05-18 Status: Open |
Ortona Park (Ward 2) Case Number: 00472859 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Bronte Heritage Waterfront Park (Ward 1) Case Number: 00472907 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Lighting Created Date: 2023-05-18 Status: Closed |
Case Number: 00472742 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-18 Status: Open |
Munns Creek Park (Ward 5) Case Number: 00472837 Case Type: Trees & Woodlands Category: Forestry Sub Category: Hazardous Tree Created Date: 2023-05-18 Status: Open |
232 NOTTINGHAM DRIVE (Ward 5) Case Number: 00472873 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Utility Permit / Municipa Created Date: 2023-05-18 Status: Open |
West Oak Trails Community Park (Ward 4) Case Number: 00472864 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Washrooms Created Date: 2023-05-18 Status: Open |
Case Number: 00472749 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-18 Status: New |
Lakeside Park (Ward 3) Case Number: 00472979 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Washrooms Created Date: 2023-05-18 Status: Closed |
Case Number: 00472772 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Encroachment on Municipal Created Date: 2023-05-18 Status: Open |
Case Number: 00472845 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Case Number: 00472940 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Ontario Street Park (Ward 1) Case Number: 00472914 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Accessories or Structures Created Date: 2023-05-18 Status: Open |
Case Number: 00472973 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2023-05-18 Status: Open |
Case Number: 00472792 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Case Number: 00472810 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Engineering Records for M Created Date: 2023-05-18 Status: Open |
Case Number: 00472863 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Stumping Created Date: 2023-05-18 Status: Closed |
Case Number: 00472813 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Infestation or Disea Created Date: 2023-05-18 Status: Open |
Case Number: 00472745 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-18 Status: Open |
Case Number: 00472812 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Kingsford Gardens (Ward 3) Case Number: 00472891 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Irrigation and Water Created Date: 2023-05-18 Status: Open |
Case Number: 00472746 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Case Number: 00472876 Case Type: Other Services Category: ServiceOakville Sub Category: Inquiry Created Date: 2023-05-18 Status: Closed |
CHURCH ST/TRAFALGAR RD (Ward 3) Case Number: 00472976 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Signals Created Date: 2023-05-18 Status: In Progress |
Wilmot Park (Ward 1) Case Number: 00472967 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Memorial and Small Tree M Created Date: 2023-05-18 Status: Open |
Case Number: 00472923 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-18 Status: Open |
Case Number: 00472829 Case Type: Home, Property, Taxes Category: Finance Sub Category: Property Taxes Created Date: 2023-05-18 Status: Closed |
Case Number: 00472915 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2023-05-18 Status: Open |
Case Number: 00472926 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Pathways and Trails Created Date: 2023-05-18 Status: Open |
West Oak Trails Community Park (Ward 4) Case Number: 00472785 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Sports Fields Created Date: 2023-05-18 Status: Open |
Case Number: 00472929 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-18 Status: Open |
Case Number: 00472972 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Permit Inquiries Created Date: 2023-05-18 Status: Open |
354 HOWELL ROAD (Ward 5) Case Number: 00472740 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-18 Status: In Progress |
Case Number: 00472882 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-18 Status: Open |
KERR ST (Ward 2) Case Number: 00472878 Case Type: Roads, Sidewalks & Traffi Category: Transportation Strategy Sub Category: Warning Signs and Pavemen Created Date: 2023-05-18 Status: Open |
NORTH SERVICE RD E/IRONOAK WAY (Ward 6) Case Number: 00472732 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Urgent Response (Debris) Created Date: 2023-05-18 Status: Closed |
Case Number: 00472947 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Inquiry Created Date: 2023-05-18 Status: In Progress |
Castlefield Park (Ward 5) Case Number: 00472868 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Park Ambassador Program Created Date: 2023-05-18 Status: Open |
Wilmot Park (Ward 1) Case Number: 00472965 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Fencing Created Date: 2023-05-18 Status: Open |
BRONTE RD/HIXON ST (Ward 1) Case Number: 00472721 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Urgent Response (Other) Created Date: 2023-05-18 Status: Closed |
Bronte Heritage Waterfront Park (Ward 1) Case Number: 00472904 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Lighting Created Date: 2023-05-18 Status: Closed |
Case Number: 00472908 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Case Number: 00472855 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-18 Status: Open |
Wilmot Park (Ward 1) Case Number: 00472826 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-18 Status: Open |
Case Number: 00472949 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Permit Inquiries Created Date: 2023-05-18 Status: Open |
Case Number: 00472487 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-17 Status: In Progress |
Case Number: 00472490 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-17 Status: Closed |
Case Number: 00472532 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Open |
Case Number: 00472442 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Infestation or Disea Created Date: 2023-05-17 Status: Open |
Case Number: 00472424 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Open |
Case Number: 00472507 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Planting Created Date: 2023-05-17 Status: Open |
Case Number: 00472376 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Engineering Records for M Created Date: 2023-05-17 Status: Closed |
Case Number: 00472328 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Closed |
Case Number: 00472428 Case Type: Trees & Woodlands Category: Forestry Sub Category: Barriers (Hoarding) Created Date: 2023-05-17 Status: In Progress |
Case Number: 00472451 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Inspection of a Permit Created Date: 2023-05-17 Status: Closed |
Case Number: 00472356 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-17 Status: Closed |
Case Number: 00472358 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Open |
Case Number: 00472363 Case Type: Trees & Woodlands Category: Forestry Sub Category: Unauthorized Activity Created Date: 2023-05-17 Status: Closed |
Case Number: 00472329 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-17 Status: Closed |
Case Number: 00472366 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2023-05-17 Status: Closed |
Bronte Athletic Park (Ward 1) Case Number: 00472396 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Inquiry Created Date: 2023-05-17 Status: Closed |
Case Number: 00472459 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Lighting Created Date: 2023-05-17 Status: Closed |
Nottinghill Park (Ward 2) Case Number: 00472445 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Removal Created Date: 2023-05-17 Status: Open |
Case Number: 00472518 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Permit Inquiries Created Date: 2023-05-17 Status: Closed |
Case Number: 00472434 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-17 Status: Closed |
90 SPRING AZURE CRESCENT (Ward 1) Case Number: 00472457 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Pathways and Trails Created Date: 2023-05-17 Status: Closed |
Case Number: 00472481 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-17 Status: Open |
Case Number: 00472350 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Development Engineering P Created Date: 2023-05-17 Status: Open |
Case Number: 00472485 Case Type: Trees & Woodlands Category: Forestry Sub Category: Storm Created Date: 2023-05-17 Status: Open |
Case Number: 00472414 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Pathways and Trails Created Date: 2023-05-17 Status: Open |
DUNN ST/RANDALL ST (Ward 3) Case Number: 00472439 Case Type: Roads, Sidewalks & Traffi Category: Transportation Strategy Sub Category: On-Street Parking Created Date: 2023-05-17 Status: Open |
Case Number: 00472321 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2023-05-17 Status: Open |
Case Number: 00472413 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-17 Status: Open |
Morrison Valley South U.M.R. (Ward 6) Case Number: 00472416 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Open |
Case Number: 00472446 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Planting Created Date: 2023-05-17 Status: Open |
Case Number: 00472503 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Open |
Case Number: 00472331 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-17 Status: Closed |
Case Number: 00472330 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Street Lighting Created Date: 2023-05-17 Status: In Progress |
Shannon Creek Trail North - 1 (Ward 7) Case Number: 00472516 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Pathways and Trails Created Date: 2023-05-17 Status: Open |
Case Number: 00472523 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Utility Permit / Municipa Created Date: 2023-05-17 Status: Open |
Case Number: 00472447 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Open |
BRONTE RD/WYECROFT RD (Ward 1) Case Number: 00472390 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Signals Created Date: 2023-05-17 Status: Closed |
Case Number: 00472450 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Permit Inquiries Created Date: 2023-05-17 Status: Open |
Case Number: 00472343 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-17 Status: Open |
Case Number: 00472357 Case Type: Trees & Woodlands Category: Forestry Sub Category: Unauthorized Activity Created Date: 2023-05-17 Status: In Progress |
Case Number: 00472648 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2023-05-17 Status: Open |
Case Number: 00472688 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Utility Permit / Municipa Created Date: 2023-05-17 Status: Open |
Ortona Park (Ward 2) Case Number: 00472602 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-17 Status: Open |
Case Number: 00472707 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2023-05-17 Status: Open |
Case Number: 00472709 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-17 Status: Open |
Case Number: 00472705 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Utility Permit / Municipa Created Date: 2023-05-17 Status: Closed |
Case Number: 00472587 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Utility Permit / Municipa Created Date: 2023-05-17 Status: In Progress |
Case Number: 00472624 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Engineering Records for M Created Date: 2023-05-17 Status: Closed |
Case Number: 00472622 Case Type: Home, Property, Taxes Category: Finance Sub Category: Property Taxes Created Date: 2023-05-17 Status: Closed |