Data Dictionary

ID
PERMIT_NUM
Type
text
Aprašymas

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

ID
REVISION_NUM
Type
text
Aprašymas

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

ID
PERMIT_TYPE
Type
text
Aprašymas

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
Aprašymas

Identifies that type of structure the application relates to.

ID
WORK
Type
text
Aprašymas

Overall description of the type of work covered by application.

ID
STREET_NUM
Type
text
Aprašymas

Address - street number

ID
STREET_NAME
Type
text
Aprašymas

Address - street name

ID
STREET_TYPE
Type
text
Aprašymas

Address - street type

ID
STREET_DIRECTION
Type
text
Aprašymas

Address - street direction

ID
POSTAL
Type
text
Aprašymas

First 3 digits of postal code

ID
GEO_ID
Type
text
Aprašymas

City-defined, unique identifier for Property Address

ID
APPLICATION_DATE
Type
date
Aprašymas

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

ID
ISSUED_DATE
Type
date
Aprašymas

Date that the permit was issued.

ID
COMPLETED_DATE
Type
date
Aprašymas

Date work is complete and permit is cleared

ID
STATUS
Type
text
Aprašymas

Current status of application / permit

ID
DESCRIPTION
Type
text
Aprašymas

Description of work proposed in application

ID
CURRENT_USE
Type
text
Aprašymas

Use of the property at the time of application submission

ID
PROPOSED_USE
Type
text
Aprašymas

Use of the property after completion of work covered by permit

ID
DWELLING_UNITS_CREATED
Type
text
Aprašymas

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

ID
DWELLING_UNITS_LOST
Type
text
Aprašymas

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

ID
ASSEMBLY
Type
float8
Aprašymas

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

ID
INSTITUTIONAL
Type
float8
Aprašymas

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

ID
RESIDENTIAL
Type
float8
Aprašymas

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

ID
BUSINESS_AND_PERSONAL_SERVICES
Type
float8
Aprašymas

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

ID
MERCANTILE
Type
float8
Aprašymas

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

ID
INDUSTRIAL
Type
float8
Aprašymas

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

ID
INTERIOR_ALTERATIONS
Type
float8
Aprašymas

Floor area (in sq metres) covered by permit work

ID
DEMOLITION
Type
float8
Aprašymas

Floor area (in sq metres) covered by permit work

ID
BUILDER_NAME
Type
text
Aprašymas

Builder associated w the permit

Papildoma informacija

Laukas Reikšmė
Data last updated 2023 m. gegužės 5 d.
Metadata last updated 2026 m. vasario 21 d.
Sukurtas 2023 m. gegužės 5 d.
Formatas CSV
Licencija 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 updateprieš 3 valandas
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