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: 00469671 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-05-08 Status: Closed |
Case Number: 00466631 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-04-26 Status: On Hold |
Case Number: 00466384 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: School Crossing Guards Created Date: 2023-04-26 Status: Closed |
Case Number: 00465989 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: School Crossing Guards Created Date: 2023-04-25 Status: Closed |
Case Number: 00465990 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: School Crossing Guards Created Date: 2023-04-25 Status: Closed |
Case Number: 00463050 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2023-04-14 Status: Closed |
Case Number: 00461857 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2023-04-11 Status: Closed |
Case Number: 00461578 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2023-04-11 Status: On Hold |
Case Number: 00461397 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: School Crossing Guards Created Date: 2023-04-06 Status: Closed |
Case Number: 00458004 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Damage - Resi Created Date: 2023-03-24 Status: In Progress |
Case Number: 00454847 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-03-13 Status: Closed |
Case Number: 00454850 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-03-13 Status: In Progress |
Case Number: 00453300 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Damage - Resi Created Date: 2023-03-07 Status: Closed |
Case Number: 00453302 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2023-03-07 Status: Closed |
Case Number: 00452655 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Condition Created Date: 2023-03-06 Status: Closed |
Case Number: 00452718 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-03-06 Status: Closed |
Case Number: 00452919 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-03-06 Status: Closed |
Case Number: 00452356 Case Type: Trees & Woodlands Category: Forestry Sub Category: Storm Created Date: 2023-03-04 Status: Closed |
Case Number: 00451284 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-03-01 Status: Closed |
Case Number: 00451352 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-03-01 Status: Closed |
Case Number: 00450945 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Condition Created Date: 2023-02-28 Status: Closed |
Case Number: 00450331 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Street Lighting Created Date: 2023-02-27 Status: Closed |
Case Number: 00449372 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-02-23 Status: Closed |
Case Number: 00445792 Case Type: Roads, Sidewalks & Traffi Category: Transportation Strategy Sub Category: Speeding and Traffic Calm Created Date: 2023-02-07 Status: Closed |
Case Number: 00442958 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-01-26 Status: Closed |
Case Number: 00442919 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2023-01-26 Status: In Progress |
Case Number: 00442965 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2023-01-26 Status: Closed |
Case Number: 00441501 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Pavement or Potholes Created Date: 2023-01-22 Status: Closed |
Case Number: 00439629 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2023-01-13 Status: Closed |
Case Number: 00433419 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2022-12-08 Status: Closed |
Case Number: 00430555 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2022-11-24 Status: Closed |
Case Number: 00424837 Case Type: Home, Property, Taxes Category: Engineering and Construction Sub Category: Design and Construction P Created Date: 2022-10-28 Status: Closed |
Case Number: 00424190 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2022-10-26 Status: Closed |
Case Number: 00422963 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Windrow Program Ap Created Date: 2022-10-20 Status: Closed |
Case Number: 00419749 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Engineering Records for M Created Date: 2022-10-06 Status: Closed |
Case Number: 00419947 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Activity in a Park Created Date: 2022-10-06 Status: Closed |
Case Number: 00419920 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Graffiti Created Date: 2022-10-06 Status: Closed |
Case Number: 00419643 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2022-10-05 Status: Closed |
Case Number: 00418491 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Curbs Created Date: 2022-10-03 Status: Closed |
Case Number: 00418475 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Street Lighting Created Date: 2022-10-03 Status: Closed |
Case Number: 00412234 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2022-09-07 Status: Closed |
Case Number: 00410738 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2022-08-31 Status: Closed |
Case Number: 00410174 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Urgent Response Created Date: 2022-08-30 Status: Closed |
Case Number: 00401372 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2022-07-25 Status: Closed |
Case Number: 00401172 Case Type: Trees & Woodlands Category: Forestry Sub Category: Bees and Wasps Created Date: 2022-07-25 Status: Closed |
Case Number: 00399080 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Urgent Response (Debris) Created Date: 2022-07-17 Status: Closed |
Case Number: 00391930 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Pathways and Trails Created Date: 2022-06-21 Status: Closed |
Case Number: 00391466 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Signs Created Date: 2022-06-20 Status: Closed |
Case Number: 00389759 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Permit Inquiries Created Date: 2022-06-14 Status: Closed |
Case Number: 00388465 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2022-06-09 Status: Closed |
Case Number: 00384136 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Permit Inquiries Created Date: 2022-05-27 Status: Closed |
Case Number: 00383141 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2022-05-25 Status: Closed |
Case Number: 00383140 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2022-05-25 Status: Closed |
Case Number: 00382614 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2022-05-24 Status: Closed |
Case Number: 00382547 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2022-05-24 Status: Closed |
Case Number: 00382303 Case Type: Other Services Category: ServiceOakville Sub Category: Regional Inquiries Created Date: 2022-05-23 Status: Closed |
Case Number: 00381074 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Planting Created Date: 2022-05-18 Status: Closed |
Case Number: 00380747 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2022-05-17 Status: Closed |
Case Number: 00379991 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2022-05-13 Status: Closed |
Case Number: 00378926 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2022-05-10 Status: Closed |
Case Number: 00376933 Case Type: Home, Property, Taxes Category: Permits, Inspections and Road Corridor Sub Category: Complaints - Permits and Created Date: 2022-05-02 Status: Open |
Case Number: 00374439 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Street Lighting Created Date: 2022-04-22 Status: Closed |
Case Number: 00369903 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2022-04-01 Status: Closed |
Case Number: 00369596 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Sidewalk or Walkway Created Date: 2022-04-01 Status: Open |
Case Number: 00369313 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Snow Removal Created Date: 2022-03-30 Status: Closed |
Case Number: 00369124 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2022-03-30 Status: Closed |
Case Number: 00366192 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2022-03-17 Status: Closed |
Case Number: 00360572 Case Type: Home, Property, Taxes Category: Finance Sub Category: Property Taxes Created Date: 2022-02-22 Status: Closed |
Case Number: 00360448 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2022-02-22 Status: Closed |
Case Number: 00360175 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2022-02-19 Status: Closed |
Case Number: 00360035 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2022-02-18 Status: Closed |
Case Number: 00359796 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Drainage - Residen Created Date: 2022-02-18 Status: Closed |
Case Number: 00358967 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Urgent Response (Winter R Created Date: 2022-02-15 Status: Closed |
Case Number: 00358492 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Damage Created Date: 2022-02-14 Status: Closed |
Case Number: 00353533 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Condition Created Date: 2022-01-24 Status: Closed |
Case Number: 00352248 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Sidewalk Condition Created Date: 2022-01-19 Status: Closed |
Case Number: 00351419 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2022-01-18 Status: Closed |
Case Number: 00351212 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Winter Road Condition Created Date: 2022-01-18 Status: Closed |
Case Number: 00348710 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Playgrounds Created Date: 2022-01-06 Status: Closed |
Case Number: 00347705 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2022-01-01 Status: Closed |
Case Number: 00344335 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2021-12-09 Status: Closed |
Case Number: 00343754 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2021-12-07 Status: Closed |
Case Number: 00343145 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2021-12-05 Status: Closed |
Case Number: 00341794 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2021-11-30 Status: Closed |
Case Number: 00339097 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Grass Cutting Created Date: 2021-11-17 Status: Closed |
Case Number: 00338978 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2021-11-17 Status: Closed |
Case Number: 00338973 Case Type: Roads, Sidewalks & Traffi Category: Traffic Sub Category: Graffiti Created Date: 2021-11-17 Status: Closed |
Case Number: 00329632 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Lost and Found Created Date: 2021-10-12 Status: Closed |
Case Number: 00328627 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Soft Surface Boulevard Created Date: 2021-10-06 Status: Closed |
Case Number: 00327945 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Removal Created Date: 2021-10-04 Status: Closed |
Case Number: 00326028 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Shrubs-Flowers Created Date: 2021-09-28 Status: Closed |
Case Number: 00323187 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Garbage Created Date: 2021-09-18 Status: Closed |
Case Number: 00322957 Case Type: Roads, Sidewalks & Traffi Category: Transportation Strategy Sub Category: Speeding and Traffic Calm Created Date: 2021-09-17 Status: Closed |
Case Number: 00322612 Case Type: Parks, Harbours & Trails Category: Parks Operations Sub Category: Playgrounds Created Date: 2021-09-16 Status: Closed |
Case Number: 00321762 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2021-09-14 Status: Closed |
Case Number: 00320615 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Pruning Created Date: 2021-09-10 Status: Closed |
Case Number: 00320235 Case Type: Roads, Sidewalks & Traffi Category: Transportation Strategy Sub Category: On-Street Parking Created Date: 2021-09-09 Status: Closed |
Case Number: 00318183 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Litter-Debris Created Date: 2021-09-02 Status: Closed |
Case Number: 00317416 Case Type: Roads, Sidewalks & Traffi Category: Works Operations Sub Category: Dumping Created Date: 2021-08-31 Status: Closed |
Case Number: 00316206 Case Type: Trees & Woodlands Category: Forestry Sub Category: Tree Health Concern Created Date: 2021-08-26 Status: Closed |