Data Dictionary

Column Type Label Description
PERMIT_NUM text

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

REVISION_NUM text

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

PERMIT_TYPE text

Text field describing the type of permit. The less descriptive permit type names here include:

  • Designated Structures: Designated structure, such as communication towers, crane runways, exterior tanks and supports, pedestrian bridges, retaining walls, satellite dishes and solar collectors.
  • Partial Permits: Permits issued for parts of a building; Excavation, Shoring, Structure, etc...
  • Authority to Occupy: Partial occupancy of a building
STRUCTURE_TYPE text

Identifies that type of structure the application relates to.

WORK text

Overall description of the type of work covered by application.

STREET_NUM text

Address - street number

STREET_NAME text

Address - street name

STREET_TYPE text

Address - street type

STREET_DIRECTION text

Address - street direction

POSTAL text

First 3 digits of postal code

GEO_ID text

City-defined, unique identifier for Property Address

WARD_GRID text
APPLICATION_DATE date

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

ISSUED_DATE date

Date that the permit was issued.

COMPLETED_DATE date

Date work is complete and permit is cleared

STATUS text

Current status of application / permit

DESCRIPTION text

Description of work proposed in application

CURRENT_USE text

Use of the property at the time of application submission

PROPOSED_USE text

Use of the property after completion of work covered by permit

DWELLING_UNITS_CREATED text

Number of residential dwelling units created by completion of permit work.

DWELLING_UNITS_LOST text

Number of residential dwelling units lost by completion of permit work.

EST_CONST_COST text
ASSEMBLY float8

Assembly Occupancy area (in sq metres) covered by permit work. (eg Restaurant, Library, Theatre)

INSTITUTIONAL float8

Institutional Occupancy area (in sq metres) covered by permit work (eg Hospital, Nursing Home)

RESIDENTIAL float8

Residential Occupancy area (in sq metres) covered by permit work

BUSINESS_AND_PERSONAL_SERVICES float8

Business and Personal Services Occupancy area (in sq metres) covered by permit work (Office, Bank, Medical Clinic)

MERCANTILE float8

Mercantile Occupancy area (in sq metres) covered by permit work (eg Department Store, Supermarket)

INDUSTRIAL float8

Industrial Occupancy area (in sq metres) covered by permit work (eg Warehouse, Gas Station)

INTERIOR_ALTERATIONS float8

Floor area (in sq metres) covered by permit work

DEMOLITION float8

Floor area (in sq metres) covered by permit work

BUILDER_NAME text

Builder associated w the permit

Additional Information

Field Value
Data last updated May 5, 2023
Metadata last updated May 9, 2025
Created May 5, 2023
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': 'dfce3b7b-4f17-4a9d-9155-5e390a5ffa97', 'XML': '02f9a3d6-4ea8-4f97-9f38-b39c8d11b608', 'JSON': 'aa1efc2e-dc1a-4666-95b6-cf3e1f79afcd'}
Datastore cache last update13 hours ago
Extract jobAirflow - files_to_datastore.py - building-permits-active-permits
Has viewsTrue
Id6d0229af-bc54-46de-9c2b-26759b01dd05
Is previewTrue
Mimetypetext/csv
Package id108c2bd1-6945-46f6-af92-02f5658ee7f7
Package name or idbuilding-permits-active-permits
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - building-permits-active-permits
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID