Data Dictionary

ID
ID
Type
int4
Description

Record ID

ID
WARD
Type
int4
Description

Ward ID

ID
WARD_NAME
Type
text
Description

Name of Ward

ID
ESTABLISHMENT
Type
text
Description

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

ID
ADDRESS
Type
text
Description

The address/location of where the event is occurring.

ID
APPLICATION_TYPE
Type
text
Description

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.

ID
STARTING_DATE
Type
timestamp
Description

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.

ID
ENDING_DATE
Type
timestamp
Description

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.

ID
LICENCE_YEAR
Type
int4
Description

Year of the event occurring that was applied for.

Additional Information

Field Value
Data last updated Hunyo 30, 2025
Metadata last updated Pebrero 25, 2026
Created Hunyo 30, 2025
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': 'f6a2256d-fc5e-4c67-8777-1645aa749486', '2952': 'dcd46975-1644-42bd-bab7-936905fb8b03'}, 'SHP': {'4326': 'ab2ccb22-e92d-401a-9ee5-8adfd5166a69', '2952': 'ad8b235a-5aa5-4aaf-a969-9f7ba481e023'}, 'GPKG': {'4326': '12ad3ee1-45d8-4318-a8b2-5498575ad1ce', '2952': 'ab866c71-8809-4d6e-8060-988cdf82eebe'}, 'GEOJSON': {'4326': '93233080-289a-447c-9997-8171d60a79a6'}}
Datastore cache last update18 oras ang nakalipas
Extract jobAirflow: Integration Pipeline temporary-extension-and-special-occasion-permit-endorsements-for-liquor-licences
Has viewsTrue
Idf2c84df6-2187-46b9-8a56-333a692c49a6
Is previewTrue
Package idf0b60227-d356-47f3-93b9-c6439be4223c
Position0
Record count4,272
Stateactive
Url typedatastore
Vertex count4,271
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