データディクショナリ

ID
APPLICATION_TYPE
タイプ
text
説明

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

ID
APPLICATION#
タイプ
text
説明

The application number provided to applicants to identify their application.

ID
STREET_NUM
タイプ
text
説明

Street address number of the primary address for the application.

ID
STREET_NAME
タイプ
text
説明

Street address name of the primary address for the application.

ID
STREET_TYPE
タイプ
text
説明

Street type of the primary address of the application.

ID
STREET_DIRECTION
タイプ
text
説明

Street direction of the primary address of the application.

ID
POSTAL
タイプ
text
説明

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

ID
DATE_SUBMITTED
タイプ
timestamp
説明

The submission date of the application.

ID
STATUS
タイプ
text
説明

The internal status of the application in the review process.

ID
X
タイプ
text
説明

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

ID
Y
タイプ
text
説明

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

ID
DESCRIPTION
タイプ
text
説明

The written description of the application.

ID
REFERENCE_FILE#
タイプ
text
説明

The reference file number of the application.

ID
FOLDERRSN
タイプ
text
説明

The internal database identifier for the application.

ID
WARD_NUMBER
タイプ
text
説明

The ward number of the primary address of the application.

ID
WARD_NAME
タイプ
text
説明

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

ID
COMMUNITY_MEETING_DATE
タイプ
timestamp
説明

The date of the community consultation meeting for the application.

ID
COMMUNITY_MEETING_TIME
タイプ
text
説明

The time of the community consultation meeting for the application.

ID
COMMUNITY_MEETING_LOCATION
タイプ
text
説明

The location of the community consultation meeting for the application.

ID
APPLICATION_URL
タイプ
text
説明

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

ID
CONTACT_NAME
タイプ
text
説明

The name of the planner assigned to the application.

ID
CONTACT_PHONE
タイプ
text
説明

The phone number of the planner assigned to the application.

ID
CONTACT_EMAIL
タイプ
text
説明

The email address of the planner assigned to the application.

ID
PARENT_FOLDER_NUMBER
タイプ
text
説明

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

追加情報

フィールド
最終更新日 2023年5月26日
メタデータ最終更新日時 2026年2月21日
作成日 2023年5月26日
データ形式 CSV
ライセンス 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 update11 時間前
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
Record count26,161
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