Dicionario de datos

ID
APPLICATION_TYPE
Tipo
text
Descrición

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

ID
APPLICATION#
Tipo
text
Descrición

The application number provided to applicants to identify their application.

ID
STREET_NUM
Tipo
text
Descrición

Street address number of the primary address for the application.

ID
STREET_NAME
Tipo
text
Descrición

Street address name of the primary address for the application.

ID
STREET_TYPE
Tipo
text
Descrición

Street type of the primary address of the application.

ID
STREET_DIRECTION
Tipo
text
Descrición

Street direction of the primary address of the application.

ID
POSTAL
Tipo
text
Descrición

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

ID
DATE_SUBMITTED
Tipo
timestamp
Descrición

The submission date of the application.

ID
STATUS
Tipo
text
Descrición

The internal status of the application in the review process.

ID
X
Tipo
text
Descrición

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

ID
Y
Tipo
text
Descrición

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

ID
DESCRIPTION
Tipo
text
Descrición

The written description of the application.

ID
REFERENCE_FILE#
Tipo
text
Descrición

The reference file number of the application.

ID
FOLDERRSN
Tipo
text
Descrición

The internal database identifier for the application.

ID
WARD_NUMBER
Tipo
text
Descrición

The ward number of the primary address of the application.

ID
WARD_NAME
Tipo
text
Descrición

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

ID
COMMUNITY_MEETING_DATE
Tipo
timestamp
Descrición

The date of the community consultation meeting for the application.

ID
COMMUNITY_MEETING_TIME
Tipo
text
Descrición

The time of the community consultation meeting for the application.

ID
COMMUNITY_MEETING_LOCATION
Tipo
text
Descrición

The location of the community consultation meeting for the application.

ID
APPLICATION_URL
Tipo
text
Descrición

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

ID
CONTACT_NAME
Tipo
text
Descrición

The name of the planner assigned to the application.

ID
CONTACT_PHONE
Tipo
text
Descrición

The phone number of the planner assigned to the application.

ID
CONTACT_EMAIL
Tipo
text
Descrición

The email address of the planner assigned to the application.

ID
PARENT_FOLDER_NUMBER
Tipo
text
Descrición

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

Información adicional

Campo Valor
Última actualización de datos 26 de maio de 2023
Última actualización de metadatos 21 de febreiro de 2026
Creado 26 de maio de 2023
Formato CSV
Licenza 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 updatehai 20 horas
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