Name: Alcohol Control Area
Display Field: BYLAWTITLE
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON
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":[203,222,129,255],"toColor":[203,222,129,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[98,156,153,255],"toColor":[98,156,153,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[104,186,114,255],"toColor":[104,186,114,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[156,155,114,255],"toColor":[156,155,114,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[160,222,191,255],"toColor":[160,222,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[109,161,120,255],"toColor":[109,161,120,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,214,159,255],"toColor":[210,214,159,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[135,227,127,255],"toColor":[135,227,127,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[173,171,97,255],"toColor":[173,171,97,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[136,218,219,255],"toColor":[136,218,219,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[159,201,127,255],"toColor":[159,201,127,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[100,156,90,255],"toColor":[100,156,90,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[163,227,170,255],"toColor":[163,227,170,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], ... 6 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/22/2024 12:24:54 PM
Schema Last Edit Date: 3/22/2024 12:24:54 PM
Data Last Edit Date: 3/22/2024 12:24:41 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates