Data Dictionary

ID
PERMIT_NUM
Type
text
Description

Last two digits of calendar year, plus IBMS-generated sequence

ID
REVISION_NUM
Type
text
Description

Two digit number identifying revisions to permit application made after permit issuance

ID
STREET_NUM
Type
text
Description

Address - street number

ID
STREET_NAME
Type
text
Description

Address - street name

ID
STREET_TYPE
Type
text
Description

Address - street type

ID
STREET_DIRECTION
Type
text
Description

Address - street direction

ID
POSTAL
Type
text
Description

First 3 digits of postal code

ID
GEO_ID
Type
text
Description

City-defined, unique identifier for Property Address

ID
WARD_GRID
Type
text
Description

Ward information

ID
APPLICATION_DATE
Type
date
Description

Date that the application was received and entered into the city's permit application management system (IBMS)

ID
ISSUED_DATE
Type
date
Description

Date that the permit was issued.

ID
COMPLETED_DATE
Type
date
Description

Date work is complete and permit is cleared

ID
STATUS
Type
text
Description

Current status of application / permit

Additional Information

Field Value
Data last updated 14 October 2025
Metadata last updated 2 April 2026
Created 14 October 2025
Format CSV
License No License Provided
Datastore activeTrue
Datastore cache{'CSV': '884f6db8-0fea-4ccf-bdc4-2970a22ea3a9', 'XML': '100a5c89-3c53-417f-977b-bc158a8c9ff6', 'JSON': '5cc4258c-accc-4716-9b66-4e3457078e9a'}
Datastore cache last update11 hours ago
Extract jobAirflow: Integration Pipeline preliminary-zoning-reviews
Has viewsTrue
Id908dd877-4668-4734-be44-d2bc9612bab9
Is previewTrue
Mimetypetext/csv
Package id1a1bab79-8daf-4c60-9c7a-10cc74507664
Position0
Record count218,687
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline preliminary-zoning-reviews
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID