Vancouver 311 case volume location data

Case data is a subset of the interactions dataset and refers only to those call types that generate a service request to a department.

This dataset contains additional location information such as the block range where service was requested and the local area corresponding to the case (incident) location.

This dataset is extracted electronically from the 3-1-1 case management system.

This dataset includes approximately 80% of case types which has a case location, taken by 3-1-1.

The case (incident) location is provided by the requestor and may not be the actual location where service was rendered.

The case type is as determined by 3-1-1 based on information provided by the requestor. The service actually rendered may be different from that originally requested. When the case type differs significantly, the original case may be closed and a new case may be initiated.

Testing in production may result in test cases included in this dataset. The number of test cases is statistically insignificant when compared to the total number of cases in the dataset.

Year: A four digit field that indicates the year when the case was created at 3-1-1

Month: A numeric field that indicates the month when the case was created at 3-1-1

Day: A numeric field that indicates the day when the case was created at 3-1-1

Hour: A numeric field that indicates the hour (24 hour clock) when the case was created at 3-1-1

Minute: A numeric field that indicates the minute when the case was created at 3-1-1

Department: Name of an organization unit at the City of Vancouver responsible for the case

Division: The group within a department at the City of Vancouver responsible for the case

Case_Type: Specific type of case

Hundred_Block: The block range portion of the case (incident) location. If the incident was at an intersection, “Intersection” will appear in this field. If the incident was in a block, the starting hundred block range will appear in this field.

Street_Name: The street name portion of the case (incident) location. If the incident was at an intersection, the name(s) of the cross street(s) will appear in this field. If the incident was in a block, the ending hundred block range will prefix the street name.

Local_Area: The name of one of the City’s 22 local planning areas that corresponds to the case location. This field may be blank when a local area cannot be identified.

Note: Department, Division or Call Types beginning with ZZ – OLD refers to obsolete types used in the past. Generally, another call type within the same division, or another division within the same department replaced the obsolete type.

Data and Resources

Additional Info

Field Value
Author City of Vancouver
Last Updated February 20, 2015, 20:46 (UTC)
Created November 4, 2013, 22:01 (UTC)
pkg_creator 1484f3e4-87a0-4c7d-ba88-b0526ce93b40
pkg_invisible False