Data Dictionary

ID
PERMIT_NUM
Type
text
描述

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

ID
REVISION_NUM
Type
text
描述

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

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

ID
STRUCTURE_TYPE
Type
text
描述

Identifies that type of structure the application relates to.

ID
WORK
Type
text
描述

Overall description of the type of work covered by application.

ID
STREET_NUM
Type
text
描述

Address - street number

ID
STREET_NAME
Type
text
描述

Address - street name

ID
STREET_TYPE
Type
text
描述

Address - street type

ID
STREET_DIRECTION
Type
text
描述

Address - street direction

ID
POSTAL
Type
text
描述

First 3 digits of postal code

ID
GEO_ID
Type
text
描述

City-defined, unique identifier for Property Address

ID
APPLICATION_DATE
Type
date
描述

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

ID
ISSUED_DATE
Type
date
描述

Date that the permit was issued.

ID
COMPLETED_DATE
Type
date
描述

Date work is complete and permit is cleared

ID
STATUS
Type
text
描述

Current status of application / permit

ID
DESCRIPTION
Type
text
描述

Description of work proposed in application

ID
CURRENT_USE
Type
text
描述

Use of the property at the time of application submission

ID
PROPOSED_USE
Type
text
描述

Use of the property after completion of work covered by permit

ID
DWELLING_UNITS_CREATED
Type
text
描述

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

ID
DWELLING_UNITS_LOST
Type
text
描述

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

ID
ASSEMBLY
Type
float8
描述

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

ID
INSTITUTIONAL
Type
float8
描述

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

ID
RESIDENTIAL
Type
float8
描述

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

ID
BUSINESS_AND_PERSONAL_SERVICES
Type
float8
描述

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

ID
MERCANTILE
Type
float8
描述

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

ID
INDUSTRIAL
Type
float8
描述

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

ID
INTERIOR_ALTERATIONS
Type
float8
描述

Floor area (in sq metres) covered by permit work

ID
DEMOLITION
Type
float8
描述

Floor area (in sq metres) covered by permit work

ID
BUILDER_NAME
Type
text
描述

Builder associated w the permit

其他信息

价值
Data last updated 2023年5月5日
Metadata last updated 2026年2月21日
创建的 2023年5月5日
格式 CSV
授权 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 update1天前
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
Record count236,724
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