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
PERMIT_TYPE
Type
text
Description

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

ID
STRUCTURE_TYPE
Type
text
Description

Identifies that type of structure the application relates to.

ID
WORK
Type
text
Description

Overall description of the type of work covered by application.

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
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

ID
DESCRIPTION
Type
text
Description

Description of work proposed in application

ID
CURRENT_USE
Type
text
Description

Use of the property at the time of application submission

ID
PROPOSED_USE
Type
text
Description

Use of the property after completion of work covered by permit

ID
DWELLING_UNITS_CREATED
Type
text
Description

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

ID
DWELLING_UNITS_LOST
Type
text
Description

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

ID
ASSEMBLY
Type
float8
Description

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

ID
INSTITUTIONAL
Type
float8
Description

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

ID
RESIDENTIAL
Type
float8
Description

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

ID
BUSINESS_AND_PERSONAL_SERVICES
Type
float8
Description

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

ID
MERCANTILE
Type
float8
Description

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

ID
INDUSTRIAL
Type
float8
Description

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

ID
INTERIOR_ALTERATIONS
Type
float8
Description

Floor area (in sq metres) covered by permit work

ID
DEMOLITION
Type
float8
Description

Floor area (in sq metres) covered by permit work

ID
BUILDER_NAME
Type
text
Description

Builder associated w the permit

Additional Information

Field Value
Data last updated 30 ژوئن 2025
Metadata last updated 21 فوریهٔ 2026
Created 30 ژوئن 2025
Format CSV
لایسنس License not specified
Datastore activeTrue
Datastore cache{'CSV': 'b41c3e9e-4d2d-4b09-a789-9569d8da407c', 'XML': '2bb0b7a1-b1f8-4302-a6d2-be77d3ddf214', 'JSON': '270df380-91d8-4bbc-b927-6492890f6777'}
Datastore cache last update2 ساعت پیش
Extract jobAirflow - files_to_datastore.py - building-permits-cleared-permits
Has viewsTrue
Ida96c0ba4-3026-402b-b09d-5b1268b8f810
Is previewTrue
Package id9e42a85b-180f-4dc5-b0d7-d46661a6c0ec
Position0
Record count381,659
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - building-permits-cleared-permits
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID