3-1-1 service requests 2009-2021 — City of Vancouver Open Data Portal

records

records

Active filters Clear all

Clear all

No active filters

Filters

Information Table Map Analyze Export API

Customer initiated service requests received by 3-1-1 Contact Centre from 2009 to 2021. Service requests refer only to those call types that generate a request to a City of Vancouver department to provide service.

This dataset contains location information such as address or intersection where service was requested and the local area corresponding to the case (incident) location.

Due to the volume of records, we segmented the service requests data into multiple datasets. See 3-1-1 service requests for records since 2022.

Note

The 3-1-1 case management system started collecting case service requests data on June 1, 2009. The system was upgraded on August 17, 2022.

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.

When reviewing case location data spatially, consideration should be given to the City’s urban attributes such as vegetation density, population density, age of infrastructure asset, area specific bylaws, etc. Some case types are associated with city locations.

Data currency

Data are static

Data accuracy

Data are electronically extracted from the 3-1-1 case management system.

Address data of some selected service request types was not disclosed to provide privacy protection.

There may be addresses that do not return coordinates in the gecoding process. These records will appear in the Table view but not on the Map.

Websites for further information

Contact the City of Vancouver

Attachments

Click to expand Click to collapse

Dataset schema

Click to expand Click to collapse

Department

Name of an organization unit at the City of Vancouver

No description available for this field.

Name (identifier)	department
Type	text
Sample

Service request type

Specific type of case service request Note: Service request types beginning with ZZ – OLD refers to obsolete types used in the past

No description available for this field.

Name (identifier)	service_request_type
Type	text
Sample

Status

Last known status of the specified service request

No description available for this field.

Name (identifier)	status
Type	text
Sample

Closure reason

Reason the service request was closed

No description available for this field.

Name (identifier)	closure_reason
Type	text
Sample

Service request open timestamp

Timestamp of when the service request was opened

No description available for this field.

Name (identifier)	service_request_open_timestamp
Type	datetime
Sample

Service request close date

Date when the service request was closed

No description available for this field.

Name (identifier)	service_request_close_date
Type	date
Sample

Last modified timestamp

Timestamp when the service request was last updated

No description available for this field.

Name (identifier)	last_modified_timestamp
Type	datetime
Sample

Address

Address corresponding  to the location of the reported service request

No description available for this field.

Name (identifier)	address
Type	text
Sample

Local area

The local area where the service request was associated, derived from the latitude and longitude coordinates in the Geom field. The City of Vancouver has 22 local areas (also known as local planning areas). For more details, please see the Local Area Boundary dataset

No description available for this field.

Name (identifier)	local_area
Type	text
Sample

Channel

Channel

No description available for this field.

Name (identifier)	channel
Type	text
Sample

Latitude

Latitude

No description available for this field.

Name (identifier)	latitude
Type	decimal
Sample

Longitude

Longitude

No description available for this field.

Name (identifier)	longitude
Type	decimal
Sample

geom

No description available for this field.

Name (identifier)	geom
Type	geo point
Sample

JSON Schema

The following JSON object is a standardized description of your dataset's schema. More about JSON schema.

{

"title":"3-1-1-service-requests-2009-2021",
"type":"object",
"oneOf":
[
- {
  - "$ref":"#/definitions/3-1-1-service-requests-2009-2021"
  }
]
,
"definitions":
{
- "3-1-1-service-requests-2009-2021":
  {
  - "properties":
    {
    "records":
    {
    "type":"array",
    "items":
    {
    "$ref":"#/definitions/3-1-1-service-requests-2009-2021_records"
    }
    }
    }
  }
  ,
- "geoJSON":
  {
  - "title":"Geo JSON object",
  - "description":"Schema for a Geo JSON object",
  - "type":"object",
  - "required":
    [
    "type"
    ]
    ,
  - "properties":
    {
    "crs":
    {
    "$ref":"#/definitions/crs"
    }
    ,
    "bbox":
    {
    "$ref":"#/definitions/bbox"
    }
    }
    ,
  - "oneOf":
    [
    {
    "$ref":"#/definitions/geometry"
    }
    ,
    {
    "$ref":"#/definitions/geometryCollection"
    }
    ,
    {
    "$ref":"#/definitions/feature"
    }
    ,
    {
    "$ref":"#/definitions/featureCollection"
    }
    ]
  }
  ,
- "bbox":
  {
  - "description":"A bounding box as defined by GeoJSON",
  - "type":"array",
  - "items":
    {
    "type":"number"
    }
  }
  ,
- "crs":
  {
  - "title":"crs",
  - "description":"a Coordinate Reference System object",
  - "type":
    [
    "object",
    "null"
    ]
    ,
  - "required":
    [
    "type",
    "properties"
    ]
    ,
  - "properties":
    {
    "type":
    {
    "type":"string"
    }
    ,
    "properties":
    {
    "type":"object"
    }
    }
    ,
  - "additionalProperties":false,
  - "oneOf":
    [
    {
    "$ref":"#/definitions/namedCrs"
    }
    ,
    {
    "$ref":"#/definitions/linkedCrs"
    }
    ]
  }
  ,
- "namedCrs":
  {
  - "properties":
    {
    "type":
    {
    "enum":
    [
    "name"
    ]
    }
    ,
    "properties":
    {
    "required":
    [
    "name"
    ]
    ,
    "additionalProperties":false,
    "properties":
    {
    "name":
    {
    "type":"string"
    }
    }
    }
    }
  }
  ,
- "linkedObject":
  {
  - "type":"object",
  - "required":
    [
    "href"
    ]
    ,
  - "properties":
    {
    "href":
    {
    "type":"string",
    "format":"uri"
    }
    ,
    "type":
    {
    "type":"string",
    "description":"Suggested values: proj4, ogjwkt, esriwkt"
    }
    }
  }
  ,
- "linkedCrs":
  {
  - "properties":
    {
    "type":
    {
    "enum":
    [
    "link"
    ]
    }
    ,
    "properties":
    {
    "$ref":"#/definitions/linkedObject"
    }
    }
  }
  ,
- "geometryCollection":
  {
  - "title":"GeometryCollection",
  - "description":"A collection of geometry objects",
  - "required":
    [
    "geometries"
    ]
    ,
  - "properties":
    {
    "type":
    {
    "enum":
    [
    "GeometryCollection"
    ]
    }
    ,
    "geometries":
    {
    "type":"array",
    "items":
    {
    "$ref":"http://json-schema.org/geojson/geometry.json#"
    }
    }
    }
  }
  ,
- "feature":
  {
  - "title":"Feature",
  - "description":"A Geo JSON feature object",
  - "required":
    [
    "geometry",
    "properties"
    ]
    ,
  - "properties":
    {
    "type":
    {
    "enum":
    [
    "Feature"
    ]
    }
    ,
    "geometry":
    {
    "oneOf":
    [
    {
    "type":"null"
    }
    ,
    {
    "$ref":"#/definitions/geometry"
    }
    ]
    }
    ,
    "properties":
    {
    "type":
    [
    "object",
    "null"
    ]
    }
    ,
    "id":
    {
    }
    }
  }
  ,
- "featureCollection":
  {
  - "title":"FeatureCollection",
  - "description":"A Geo JSON feature collection",
  - "required":
    [
    "features"
    ]
    ,
  - "properties":
    {
    "type":
    {
    "enum":
    [
    "FeatureCollection"
    ]
    }
    ,
    "features":
    {
    "type":"array",
    "items":
    {
    "$ref":"#/definitions/feature"
    }
    }
    }
  }
  ,
- "geometry":
  {
  - "title":"geometry",
  - "description":"One geometry as defined by GeoJSON",
  - "type":"object",
  - "required":
    [
    "type",
    "coordinates"
    ]
    ,
  - "oneOf":
    [
    {
    "title":"Point",
    "properties":
    {
    "type":
    {
    "enum":
    [
    "Point"
    ]
    }
    ,
    "coordinates":
    {
    "$ref":"#/definitions/position"
    }
    }
    }
    ,
    {
    "title":"MultiPoint",
    "properties":
    {
    "type":
    {
    "enum":
    [
    "MultiPoint"
    ]
    }
    ,
    "coordinates":
    {
    "$ref":"#/definitions/positionArray"
    }
    }
    }
    ,
    {
    "title":"LineString",
    "properties":
    {
    "type":
    {
    "enum":
    [
    "LineString"
    ]
    }
    ,
    "coordinates":
    {
    "$ref":"#/definitions/lineString"
    }
    }
    }
    ,
    {
    "title":"MultiLineString",
    "properties":
    {
    "type":
    {
    "enum":
    [
    "MultiLineString"
    ]
    }
    ,
    "coordinates":
    {
    "type":"array",
    "items":
    {
    "$ref":"#/definitions/lineString"
    }
    }
    }
    }
    ,
    {
    "title":"Polygon",
    "properties":
    {
    "type":
    {
    "enum":
    [
    "Polygon"
    ]
    }
    ,
    "coordinates":
    {
    "$ref":"#/definitions/polygon"
    }
    }
    }
    ,
    {
    "title":"MultiPolygon",
    "properties":
    {
    "type":
    {
    "enum":
    [
    "MultiPolygon"
    ]
    }
    ,
    "coordinates":
    {
    "type":"array",
    "items":
    {
    "$ref":"#/definitions/polygon"
    }
    }
    }
    }
    ]
    ,
  - "position":
    {
    "description":"A single position",
    "type":"array",
    "minItems":2,
    "items":
    [
    {
    "type":"number"
    }
    ,
    {
    "type":"number"
    }
    ]
    ,
    "additionalItems":false
    }
    ,
  - "positionArray":
    {
    "description":"An array of positions",
    "type":"array",
    "items":
    {
    "$ref":"#/definitions/position"
    }
    }
    ,
  - "lineString":
    {
    "description":"An array of two or more positions",
    "allOf":
    [
    {
    "$ref":"#/definitions/positionArray"
    }
    ,
    {
    "minItems":2
    }
    ]
    }
    ,
  - "linearRing":
    {
    "description":"An array of four positions where the first equals the last",
    "allOf":
    [
    {
    "$ref":"#/definitions/positionArray"
    }
    ,
    {
    "minItems":4
    }
    ]
    }
    ,
  - "polygon":
    {
    "description":"An array of linear rings",
    "type":"array",
    "items":
    {
    "$ref":"#/definitions/linearRing"
    }
    }
  }
  ,
- "3-1-1-service-requests-2009-2021_records":
  {
  - "properties":
    {
    "fields":
    {
    "type":"object",
    "properties":
    {
    "department":
    {
    "type":"string",
    "title":"Department",
    "description":"Name of an organization unit at the City of Vancouver"
    }
    ,
    "service_request_type":
    {
    "type":"string",
    "title":"Service request type",
    "description":"Specific type of case service request Note: Service request types beginning with ZZ – OLD refers to obsolete types used in the past"
    }
    ,
    "status":
    {
    "type":"string",
    "title":"Status",
    "description":"Last known status of the specified service request"
    }
    ,
    "closure_reason":
    {
    "type":"string",
    "title":"Closure reason",
    "description":"Reason the service request was closed"
    }
    ,
    "service_request_open_timestamp":
    {
    "type":"string",
    "format":"date-time",
    "title":"Service request open timestamp",
    "description":"Timestamp of when the service request was opened"
    }
    ,
    "service_request_close_date":
    {
    "type":"string",
    "format":"date",
    "title":"Service request close date",
    "description":"Date when the service request was closed"
    }
    ,
    "last_modified_timestamp":
    {
    "type":"string",
    "format":"date-time",
    "title":"Last modified timestamp",
    "description":"Timestamp when the service request was last updated"
    }
    ,
    "address":
    {
    "type":"string",
    "title":"Address",
    "description":"Address corresponding to the location of the reported service request"
    }
    ,
    "local_area":
    {
    "type":"string",
    "title":"Local area",
    "description":"The local area where the service request was associated, derived from the latitude and longitude coordinates in the Geom field. The City of Vancouver has 22 local areas (also known as local planning areas). For more details, please see the Local Area Boundary dataset"
    }
    ,
    "channel":
    {
    "type":"string",
    "title":"Channel",
    "description":"Channel"
    }
    ,
    "latitude":
    {
    "type":"number",
    "title":"Latitude",
    "description":"Latitude"
    }
    ,
    "longitude":
    {
    "type":"number",
    "title":"Longitude",
    "description":"Longitude"
    }
    ,
    "geom":
    {
    "type":"array",
    "minItems":2,
    "maxItems":2,
    "items":
    {
    "type":"number"
    }
    ,
    "title":"geom",
    "description":""
    }
    }
    }
    }
  }
}

}

Similar datasets