Name: Alcohol Control Area
Display Field: BYLAWTITLE
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: The Alcohol Control Area dataset includes a register of current permanent and temporary alcohol bans in Auckland.
Alcohol bans prohibit the drinking and possession of alcohol in some public places in Auckland, like parks and streets, at certain times. Some bans are in place 24 hours a day, seven days a week. Other bans are in place only at night-time or during daylight savings.
The bans aim to reduce crime and disorder in public places.
Licensing & Regulatory Compliance, Auckland Council
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 1726409.9304
YMin: 5859244.5588
XMax: 1800019.432
YMax: 6008135.426
Spatial Reference: 2193 (2193)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"HOURSOFOPERATION","uniqueValueInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":0.95}},"value":"24 hours, 7 days a week","label":"24 hours, 7 days a week"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1}},"value":"5pm to 7am daily","label":"5pm to 7am daily"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,167,127,255],"width":0.95040000000000013}},"value":"7pm to 7am daily","label":"7pm to 7am daily"},{"symbol":{"type":"esriSFS","style":"esriSFSVertical","color":[255,211,127,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,76,0,255],"width":0.4032}},"value":"10pm to 7am during daylight saving and 7pm to 7am outside daylight saving","label":"10pm to 7am during daylight saving and 7pm to 7am outside daylight saving"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":0.4032}},"value":"10pm to 7am during daylight saving and 7pm to 7am outside daylight savings on reserve and 24 hours, 7 days a week on beach/foreshore","label":"Other"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":0.4032}},"value":"7pm to 7am daily, daylight savings only","label":"Other"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":0.4032}},"value":"9pm to 7am daily, daylight saving only","label":"Other"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":0.4032}},"value":"3pm to 7am daily","label":"Other"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":0.4032}},"value":"9pm to 7am during daylight savings and 7pm to 7am outside daylight savings","label":"Other"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,255],"width":2}},"value":"At all hours of the day on the market days of the annual Kowhai Festival each each year","label":"Event"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,255],"width":2}},"value":"Holiday (7pm to 7am daily from Friday of Labour weekend to Tuesday of Easter)","label":"Event"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,255],"width":2}},"value":"Major Event: 12 hours before & after a major event.","label":"Event"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,255],"width":2}},"value":"6am on the day of the concert to 6am the day after the concert","label":"Event"}],"fieldDelimiter":";","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[119,163,116,255],"toColor":[119,163,116,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,219,127,255],"toColor":[215,219,127,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[154,217,216,255],"toColor":[154,217,216,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[125,219,131,255],"toColor":[125,219,131,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[144,224,179,255],"toColor":[144,224,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[115,152,153,255],"toColor":[115,152,153,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,201,147,255],"toColor":[192,201,147,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[152,186,104,255],"toColor":[152,186,104,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[130,189,163,255],"toColor":[130,189,163,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[101,176,99,255],"toColor":[101,176,99,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[156,155,109,255],"toColor":[156,155,109,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,227,152,255],"toColor":[188,227,152,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[104,186,186,255],"toColor":[104,186,186,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: HOURSOFOPERATION
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- BYLAWTYPE (type: esriFieldTypeString, alias: Bylaw Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Alcohol: Alcohol Control], [Brothels: Brothels], [Cemeteries: Cemeteries & Cematoria], ... 7 more ...)
- BYLAWTITLE (type: esriFieldTypeString, alias: Bylaw Area Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- BYLAWAREANAME (type: esriFieldTypeString, alias: Local Board, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Devonport-Takapuna: Devonport - Takapuna], [Franklin: Franklin], [Great Barrier: Great Barrier], ... 18 more ...)
- ADOPTIONDATE (type: esriFieldTypeDate, alias: Adoption Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- REVOCATIONDATE (type: esriFieldTypeDate, alias: Revocation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- BYLAWSTATUS (type: esriFieldTypeString, alias: Bylaw Status, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Current: Current], [Draft: Draft area not yet finalised], [Historic: Historic ban areas], ... 5 more ...)
- HOURSOFOPERATION (type: esriFieldTypeString, alias: Alcohol Ban Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10pm to 7am during daylight saving and 7pm to 7am outside daylight saving: 10pm to 7am during daylight saving and 7pm to 7am outside daylight saving], [10pm to 7am during daylight saving and 7pm to 7am outside daylight saving on reserve and 24 hours, 7 days a week on beach/foreshore: 10pm to 7am during daylight saving and 7pm to 7am outside daylight savings on reserve and 24 hours, 7 days a week on beach/foreshore], [24 hours, 7 days a week: 24 hours, 7 days a week], ... 12 more ...)
- BYLAWCONTROLTYPE (type: esriFieldTypeString, alias: Alcohol Ban Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Permanent: Permanent ], [Temporary: Periodic or Event based restriction], [Prohibited: Totally prohibited], ... 5 more ...)
- COMMENTS (type: esriFieldTypeString, alias: Comments & Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- COUNCILDECISIONREF (type: esriFieldTypeString, alias: Council Decision Reference Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- VALIDATIONSTATE (type: esriFieldTypeSmallInteger, alias: ValidationState, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Valid], [1: Not Valid and Public], [2: Valid and Private], ... 1 more ...)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: 24 hours, 7 days a week
Name: 24 hours, 7 days a week
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 24 hours, 7 days a week
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 24 hours, 7 days a week
ID: 5pm to 7am daily
Name: 5pm to 7am daily
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 5pm to 7am daily
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 5pm to 7am daily
ID: 7pm to 7am daily
Name: 7pm to 7am daily
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 7pm to 7am daily
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 7pm to 7am daily
ID: 10pm to 7am during daylight saving and 7pm to 7am outside daylight saving
Name: 10pm to 7am during daylight saving and 7pm to 7am outside daylight saving
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 10pm to 7am during daylight saving and 7pm to 7am outside daylight saving
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 10pm to 7am during daylight saving and 7pm to 7am outside daylight saving
ID: 10pm to 7am during daylight saving and 7pm to 7am outside daylight savings on reserve and 24 hours, 7 days a week on beach/foreshore
Name: Other
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 10pm to 7am during daylight saving and 7pm to 7am outside daylight savings on reserve and 24 hours, 7 days a week on beach/foreshore
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 10pm to 7am during daylight saving and 7pm to 7am outside daylight savings on reserve and 24 hours, 7 days a week on beach/foreshore
ID: 7pm to 7am daily, daylight savings only
Name: Other
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 7pm to 7am daily, daylight savings only
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 7pm to 7am daily, daylight savings only
ID: 9pm to 7am daily, daylight saving only
Name: Other
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 9pm to 7am daily, daylight saving only
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 9pm to 7am daily, daylight saving only
ID: 3pm to 7am daily
Name: Other
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 3pm to 7am daily
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 3pm to 7am daily
ID: 9pm to 7am during daylight savings and 7pm to 7am outside daylight savings
Name: Other
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 9pm to 7am during daylight savings and 7pm to 7am outside daylight savings
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 9pm to 7am during daylight savings and 7pm to 7am outside daylight savings
ID: At all hours of the day on the market days of the annual Kowhai Festival each each year
Name: Event
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: At all hours of the day on the market days of the annual Kowhai Festival each each year
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: At all hours of the day on the market days of the annual Kowhai Festival each each year
ID: Holiday (7pm to 7am daily from Friday of Labour weekend to Tuesday of Easter)
Name: Event
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: Holiday (7pm to 7am daily from Friday of Labour weekend to Tuesday of Easter)
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: Holiday (7pm to 7am daily from Friday of Labour weekend to Tuesday of Easter)
ID: Major Event: 12 hours before & after a major event.
Name: Event
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: Major Event: 12 hours before & after a major event.
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: Major Event: 12 hours before & after a major event.
ID: 6am on the day of the concert to 6am the day after the concert
Name: Event
Domains:
- Field Name: BYLAWTYPE
Inherited
- Field Name: BYLAWAREANAME
Inherited
- Field Name: BYLAWSTATUS
Inherited
- Field Name: HOURSOFOPERATION
Inherited
- Field Name: BYLAWCONTROLTYPE
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: last_edited_date
Inherited
- Field Name: created_date
Inherited
Templates:
Name: 6am on the day of the concert to 6am the day after the concert
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- VALIDATIONSTATE: 0
- HOURSOFOPERATION: 6am on the day of the concert to 6am the day after the concert
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/13/2026 12:07:28 PM
Schema Last Edit Date: 3/13/2026 12:07:28 PM
Data Last Edit Date: 3/13/2026 12:07:28 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat