Microproduct Data GuideBeginner

Vancouver 3-1-1 Service Requests

Resident service requests, locations, departments, statuses, and closure details for building neighbourhood issue and response-time monitors.

Start the Guide Open Official Source Open in Colab
Report a Problem

At a Glance

Difficulty
Beginner — comfortable for a first prototype
Size
Medium · 0.1–1 GB
Formats
CSV, JSON, GeoJSON
Access
Download and API
API Key
Not Required
Provider
City of Vancouver
Updates
Daily
Last Verified
Sep 3, 2026
Source Type
Government Source
Data Terms
Open Government Licence - Vancouver
  • Python Syntax Checked
  • Runnable Notebook

From Source to Product Signal

Test a Product Idea in Four Steps

Start with one service-request type and a small recent API page. Some addresses are suppressed for privacy, some records cannot be geocoded, and the case-management system changed in August 2022.

1

Check the Setup

  • Python 3.10 or newer
  • A notebook environment such as Jupyter or Google Colab
  • An internet connection
2

Access the Data

  1. 1.Open the official dataset page and review the privacy and system-change notes.
  2. 2.Query a bounded page through the OpenDataSoft API.
  3. 3.Keep request type, department, timestamps, status, local area, and coordinates.
Open Official Source
3

Run the Python Example

Install the packages, then run the notebook cell.

python -m pip install pandas requests

import pandas as pd
import requests

url = "https://opendata.vancouver.ca/api/explore/v2.1/catalog/datasets/3-1-1-service-requests/records"
response = requests.get(
    url,
    params={"limit": 100, "order_by": "service_request_open_timestamp DESC"},
    timeout=30,
)
response.raise_for_status()
requests_311 = pd.json_normalize(response.json()["results"])
columns = [
    "service_request_type",
    "department",
    "status",
    "service_request_open_timestamp",
    "service_request_close_date",
    "local_area",
    "latitude",
    "longitude",
]
print(requests_311[columns].head())
4

Test a Useful Signal

Map Recent 3-1-1 Requests

Test whether recent request counts can support a neighbourhood issue monitor.

  1. 01Group the sample by service-request type and local area.
  2. 02Calculate closure durations where both timestamps are available.
  3. 03Explain how privacy suppression, missing coordinates, and the 2022 system change limit comparisons.

Related Datasets

Dataset Details

City of Vancouver is a government source. Last verified 2026-09-03. Temporal coverage: June 2009-present across linked datasets.

Provider

City of Vancouver

Data Terms

Open Government Licence - Vancouver

Send Feedback