Data Dictionary

Column Type Label Description
APPLICATION_TYPE text

2-letter code used to identify the type of application.

APPLICATION# text

The application number provided to applicants to identify their application.

STREET_NUM text

Street address number of the primary address for the application.

STREET_NAME text

Street address name of the primary address for the application.

STREET_TYPE text

Street type of the primary address of the application.

STREET_DIRECTION text

Street direction of the primary address of the application.

POSTAL text

First 3 characters of the postal code of the primary address of the application.

DATE_SUBMITTED timestamp

The submission date of the application.

STATUS text

The internal status of the application in the review process.

X text

The NAD27 x coordinate of the primary address of the application.

Y text

The NAD27 y coordinate of the primary address of the application.

DESCRIPTION text

The written description of the application.

REFERENCE_FILE# text

The reference file number of the application.

FOLDERRSN text

The internal database identifier for the application.

WARD_NUMBER text

The ward number of the primary address of the application.

WARD_NAME text

The name of the ward of the primary address of the application.

COMMUNITY_MEETING_DATE timestamp

The date of the community consultation meeting for the application.

COMMUNITY_MEETING_TIME text

The time of the community consultation meeting for the application.

COMMUNITY_MEETING_LOCATION text

The location of the community consultation meeting for the application.

APPLICATION_URL text

The web URL for the AIC application details page for the application.

CONTACT_NAME text

The name of the planner assigned to the application.

CONTACT_PHONE text

The phone number of the planner assigned to the application.

CONTACT_EMAIL text

The email address of the planner assigned to the application.

PARENT_FOLDER_NUMBER text

The application number of the higher-level application associated with this application (if one exists).

Additional Information

Field Value
Data last updated May 26, 2023
Metadata last updated May 9, 2025
Created May 26, 2023
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '77f8a66a-bd43-40e6-b6c9-12a2b03a5032', 'XML': 'dbf1d79e-e89b-41c3-89ff-81a38528c9c9', 'JSON': '778b8927-2b7c-4d45-8037-8cb37a290b64'}
Datastore cache last update6 hours ago
Extract jobAirflow - files_to_datastore.py - development-applications
Has viewsTrue
Id8907d8ed-c515-4ce9-b674-9f8c6eefcf0d
Is previewTrue
Mimetypetext/csv
Package id0aa7e480-9b48-4919-98e0-6af7615b7809
Package name or iddevelopment-applications
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - development-applications
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID