Development Applications
Dataset description:
This dataset lists all currently active (open) and inactive (closed) Community Planning applications and Committee of Adjustment applications received by the City between January 1st 2008...
Data Dictionary
- ID
- APPLICATION_TYPE
- Type
- text
- 描述
2-letter code used to identify the type of application.
- ID
- APPLICATION#
- Type
- text
- 描述
The application number provided to applicants to identify their application.
- ID
- STREET_NUM
- Type
- text
- 描述
Street address number of the primary address for the application.
- ID
- STREET_NAME
- Type
- text
- 描述
Street address name of the primary address for the application.
- ID
- STREET_TYPE
- Type
- text
- 描述
Street type of the primary address of the application.
- ID
- STREET_DIRECTION
- Type
- text
- 描述
Street direction of the primary address of the application.
- ID
- POSTAL
- Type
- text
- 描述
First 3 characters of the postal code of the primary address of the application.
- ID
- DATE_SUBMITTED
- Type
- timestamp
- 描述
The submission date of the application.
- ID
- STATUS
- Type
- text
- 描述
The internal status of the application in the review process.
- ID
- X
- Type
- text
- 描述
The NAD27 x coordinate of the primary address of the application.
- ID
- Y
- Type
- text
- 描述
The NAD27 y coordinate of the primary address of the application.
- ID
- DESCRIPTION
- Type
- text
- 描述
The written description of the application.
- ID
- REFERENCE_FILE#
- Type
- text
- 描述
The reference file number of the application.
- ID
- FOLDERRSN
- Type
- text
- 描述
The internal database identifier for the application.
- ID
- WARD_NUMBER
- Type
- text
- 描述
The ward number of the primary address of the application.
- ID
- WARD_NAME
- Type
- text
- 描述
The name of the ward of the primary address of the application.
- ID
- COMMUNITY_MEETING_DATE
- Type
- timestamp
- 描述
The date of the community consultation meeting for the application.
- ID
- COMMUNITY_MEETING_TIME
- Type
- text
- 描述
The time of the community consultation meeting for the application.
- ID
- COMMUNITY_MEETING_LOCATION
- Type
- text
- 描述
The location of the community consultation meeting for the application.
- ID
- APPLICATION_URL
- Type
- text
- 描述
The web URL for the AIC application details page for the application.
- ID
- CONTACT_NAME
- Type
- text
- 描述
The name of the planner assigned to the application.
- ID
- CONTACT_PHONE
- Type
- text
- 描述
The phone number of the planner assigned to the application.
- ID
- CONTACT_EMAIL
- Type
- text
- 描述
The email address of the planner assigned to the application.
- ID
- PARENT_FOLDER_NUMBER
- Type
- text
- 描述
The application number of the higher-level application associated with this application (if one exists).
其他信息
| 域 | 价值 |
|---|---|
| Data last updated | 2023年5月26日 |
| Metadata last updated | 2026年7月1日 |
| 创建的 | 2023年5月26日 |
| 格式 | CSV |
| 授权 | License not specified |
| Datastore active | True |
| Datastore cache | {'CSV': '77f8a66a-bd43-40e6-b6c9-12a2b03a5032', 'XML': 'dbf1d79e-e89b-41c3-89ff-81a38528c9c9', 'JSON': '778b8927-2b7c-4d45-8037-8cb37a290b64'} |
| Datastore cache last update | 7小时前 |
| Extract job | Airflow - files_to_datastore.py - development-applications |
| Has views | True |
| Id | 8907d8ed-c515-4ce9-b674-9f8c6eefcf0d |
| Is preview | True |
| Mimetype | text/csv |
| Package id | 0aa7e480-9b48-4919-98e0-6af7615b7809 |
| Package name or id | development-applications |
| Position | 0 |
| Record count | 26,316 |
| State | active |
| Url type | datastore |
| Extract Job | Airflow - files_to_datastore.py - development-applications |
| Is Datastore Cache File? | |
| Datastore Cache |
|
| Datastore Cache Last Updated | |
| Datastore resource's ID |