Data Dictionary

Column Type Label Description
ID int4

Record ID

WARD int4

Ward ID

WARD_NAME text

Name of Ward

ESTABLISHMENT text

The name of the business that has applied for a temporary extension of liquor licence.

ADDRESS text

The address/location of where the event is occurring.

APPLICATION_TYPE text

The is the type of application being applied for. This could be a temporary extension of hours of service or premises, or a Special Occasion Permits.

STARTING_DATE timestamp

The first date applied for in the application. Not all dates in between the start and end dates on the application may have been applied for.

ENDING_DATE timestamp

The last date applied for in the application. Not all dates in between the start and end dates on the application may have been applied for.

LICENCE_YEAR int4

Year of the event occurring that was applied for.

geometry text

Additional Information

Field Value
Data last updated January 10, 2025
Metadata last updated May 9, 2025
Created January 10, 2025
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': '66ed89f8-1f88-4ba3-ba75-4288ea2a7106', '2952': 'ee97c10a-5af4-48c7-a090-b35f43d7c96a'}, 'SHP': {'4326': 'eedeb61a-7a6f-47c6-87ba-f683e55859f7', '2952': 'f4383792-5e7a-449d-9f9c-38f7042df0b5'}, 'GPKG': {'4326': '370d1ea2-9597-46b8-8a7e-c9183f85c405', '2952': '20f8370c-8d75-4a71-8360-2247302883f2'}, 'GEOJSON': {'4326': 'cb3ba855-9565-4aca-8c6e-d7629635b219'}}
Datastore cache last update19 hours ago
Extract jobAirflow: Integration Pipeline temporary-extension-and-special-occasion-permit-endorsements-for-liquor-licences
Has viewsTrue
Id85d40f0a-4216-471d-b1a9-b78f4f7518fe
Is previewTrue
Package idtemporary-extension-and-special-occasion-permit-endorsements-for-liquor-licences
Position0
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline temporary-extension-and-special-occasion-permit-endorsements-for-liquor-licences
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID