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.
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: 00472728 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-18 Status: In Progress |
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: 00472923 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes 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 |
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 |
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 |
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 |
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: 00472356 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway 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: 00472434 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping 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: 00472331 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-17 Status: Closed |
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: 00472709 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-17 Status: Open |
2370 ROBMAR DRIVE (Ward 6) Case Number: 00472657 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Spring Cleanup Created Date: 2023-05-17 Status: Open |
Case Number: 00472700 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-17 Status: Open |
Case Number: 00472714 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-17 Status: Closed |
BROCK ST/REBECCA ST (Ward 2) Case Number: 00472699 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-17 Status: Open |
Case Number: 00472638 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-17 Status: Open |
Case Number: 00472617 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-17 Status: Open |
Case Number: 00471877 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-16 Status: Open |
Case Number: 00471931 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Soft Surface Boulevard Created Date: 2023-05-16 Status: On Hold |
DUNDAS ST E/WINSTON CHURCHILL BLVD (Ward 6) Case Number: 00472006 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Damage - Main Created Date: 2023-05-16 Status: Closed |
CENTRAL PARK DR/GEORGIAN DR (Ward 5) Case Number: 00472269 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-16 Status: Closed |
Case Number: 00472180 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-16 Status: Reassigned |
GEORGIAN DR/TAUNTON RD (Ward 5) Case Number: 00472271 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-16 Status: Closed |
BROCK ST/REBECCA ST (Ward 2) Case Number: 00472166 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-16 Status: Closed |
Case Number: 00472088 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-16 Status: Open |
Case Number: 00472127 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-16 Status: Closed |
Case Number: 00472055 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-16 Status: Open |
Case Number: 00472156 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Soft Surface Boulevard Created Date: 2023-05-16 Status: On Hold |
CORNWALL RD/CROSS AVE/SPEERS RD (Ward 3) Case Number: 00472212 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-16 Status: Closed |
Case Number: 00471890 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-16 Status: Open |
Case Number: 00472097 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-16 Status: Open |
Case Number: 00471476 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-15 Status: Open |
2141 MEADOWLAND DRIVE (Ward 5) Case Number: 00471605 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-15 Status: Open |
Case Number: 00471481 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-15 Status: Closed |
Case Number: 00471482 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-15 Status: Closed |
Case Number: 00471483 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-15 Status: Closed |
Case Number: 00471591 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-15 Status: Open |
DUNN ST/LAKESHORE RD E (Ward 3) Case Number: 00471582 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Curbs Created Date: 2023-05-15 Status: Closed |
Case Number: 00471684 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-15 Status: Closed |
Case Number: 00471639 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-15 Status: Closed |
Case Number: 00471824 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-15 Status: Open |
Case Number: 00471793 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Fencing - Walls Created Date: 2023-05-15 Status: Open |
Case Number: 00471827 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sweeping-Flushing Created Date: 2023-05-15 Status: Open |
Case Number: 00471484 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-15 Status: Closed |
Case Number: 00471496 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-15 Status: Closed |
Case Number: 00471734 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Shoulders Created Date: 2023-05-15 Status: Open |
Case Number: 00471624 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-15 Status: Open |
Case Number: 00471488 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-15 Status: Closed |
Case Number: 00471480 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-15 Status: Closed |
Case Number: 00471567 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-15 Status: Open |
Case Number: 00471584 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-15 Status: Open |
Case Number: 00471485 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-15 Status: Closed |
Case Number: 00471489 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-15 Status: Open |
Case Number: 00471837 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Catchbasins Created Date: 2023-05-15 Status: Closed |
Case Number: 00471490 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-15 Status: Closed |
BURNHAMTHORPE RD W/REGIONAL ROAD 25 (Ward 7) Case Number: 00471468 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Urgent Response (Debris) Created Date: 2023-05-14 Status: Closed |
Case Number: 00471424 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Urgent Response (Debris) Created Date: 2023-05-13 Status: Closed |
Case Number: 00471388 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-13 Status: On Hold |
Case Number: 00471366 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-12 Status: Closed |
Case Number: 00471311 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-12 Status: Open |
Case Number: 00471166 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-12 Status: Closed |
Case Number: 00471140 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Catchbasins Created Date: 2023-05-12 Status: Closed |
Case Number: 00471132 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-12 Status: Closed |
Case Number: 00471235 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sweeping-Flushing Created Date: 2023-05-12 Status: Open |
Case Number: 00471219 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-12 Status: Closed |
Case Number: 00471343 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-12 Status: Open |
Case Number: 00471048 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-12 Status: Closed |
Case Number: 00471289 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-12 Status: Closed |
Case Number: 00471179 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-12 Status: Open |
Case Number: 00471218 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-12 Status: Open |
Case Number: 00471137 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Catchbasins Created Date: 2023-05-12 Status: Closed |
Case Number: 00471079 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-12 Status: Open |
MCPHERSON RD/SOUTH SERVICE RD W (Ward 1) Case Number: 00471285 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-12 Status: Closed |
Case Number: 00471189 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-12 Status: Open |
Case Number: 00470919 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-11 Status: Open |
422 CHARTWELL ROAD (Ward 3) Case Number: 00470968 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Soft Surface Boulevard Created Date: 2023-05-11 Status: Closed |
Case Number: 00470760 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Soft Surface Boulevard Created Date: 2023-05-11 Status: Closed |
Case Number: 00470923 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-11 Status: Open |
Case Number: 00470710 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-11 Status: Open |
Case Number: 00470884 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-11 Status: Open |
Case Number: 00470994 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Ditches and Culverts Created Date: 2023-05-11 Status: On Hold |
Case Number: 00470761 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-05-11 Status: Open |
Case Number: 00470892 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-11 Status: Closed |
Case Number: 00470857 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-11 Status: Open |
Case Number: 00470812 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-11 Status: Closed |
Case Number: 00470673 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-10 Status: Closed |
GOLDEN BRIAR TRAIL/UPPER MIDDLE RD E (Ward 6) Case Number: 00470383 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-10 Status: Closed |
Case Number: 00470401 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-05-10 Status: Open |
Case Number: 00470277 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-05-10 Status: Closed |
Case Number: 00470500 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sweeping-Flushing Created Date: 2023-05-10 Status: On Hold |
Case Number: 00470403 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-10 Status: Closed |
Case Number: 00470317 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-05-10 Status: Closed |