Layers:

Layer: Alcohol Control Area (0)


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.



Copyright Text: 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:

Name : OBJECTID

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