Datasets
-
Traffic Signal Detector
Hamilton City CouncilTraffic signal detectors at each SCATS site Column_InfoSite_Number, int : SCATS ID - Unique identifierDetector_Number, int : Detector number from 1 to 48Is_Active, int : Detector is recording volume dataIs_Limit_Line_Detector, int : Detector is installed at the limit line and can be used for volume count Relationship This table is referenced by...Created 30 April 2025 • Updated 30 April 2025 -
HireDevice Route
Hamilton City CouncilGPS point data of HireDevice trips in Hamilton City. To get data for this dataset, please call the API directly talking to the HCC Data Warehouse: https://api.hcc.govt.nz/OpenData/get_hiredevice_route?Page=1&Start_Date=2020-10-01&End_Date=2020-10-02. For this API, there are three mandatory parameters: Page, Start_Date, End_Date. Sample values for these...Created 30 April 2025 • Updated 30 April 2025 -
Dog Complaint
Hamilton City CouncilInformation about dog complaints received including when, where, type of complaint and outcome. Column_InfoDog_Complaint_Number, int : CRM numberDog_Complaint_Year, smallint : YearUrgency_Code, char : Urgency codeUrgency_Description, char : Urgency descriptionCurrent_Status_ID, int : Current statusCurrent_Status_Code, char : Status...Created 30 April 2025 • Updated 30 April 2025 -
Traffic Signal Detector Count
Hamilton City CouncilRecorded volume data at SCATS intersections or pedestrian crossings in Hamilton. To get data for this dataset, please call the API directly talking to the HCC Data Warehouse: https://api.hcc.govt.nz/OpenData/get_traffic_signal_detector_count?Page=1&Start_Date=2020-10-01&End_Date=2020-10-02. For this API, there are three mandatory parameters: Page,...Created 30 April 2025 • Updated 30 April 2025 -
Excess Dog Register
Hamilton City CouncilInformation about multi-dog permits. Column_InfoExcess_Dog_Account, char : Multipermit accountAccount_Year, smallint : YearExcess_Dog_Number, int : ?? Permit numberApplication_Type_Code, char : Application type codeApplication_Description, char : Application descriptionLodged_Date, datetime : Date lodgedEffective_Date, datetime : Efective dateExpiry_Date,...Created 30 April 2025 • Updated 30 April 2025 -
Food Premise To Food Premise Registration
Hamilton City CouncilTable about the links between Food_Premise table and Food_Premise_Registration table.One registration can be applied to multiple sites whereas 1 site can have only 1 active registration. But It is possible to have links with inactive registrations Column_InfoFood_Premise_Registration_Account_Number, varchar : This is a foreign key referencing...Created 30 April 2025 • Updated 30 April 2025 -
Dog Complaint To Dog
Hamilton City Councilinformation linking dog complaints to dogs. Column_InfoDog_Complaint_Account, char : ?? CRM numberDog_Number, int : Animal number Relationship This table reference to table DogThis table reference to table Dog_Complaint Analytics For convenience Hamilton City Council has also built a Quick Analytics Dashboard over this dataset that you can access here....Created 30 April 2025 • Updated 30 April 2025 -
Owner Classification Event
Hamilton City CouncilInformation about the type of events leading to the classification of dogs as menacing or dangerous. Column_InfoDog_Classification_Account, char : Account numberAccount_Year, smallint : Account yearDog_Classification_Number, int : Classification numberClassification_Code, int : Classification codeClassification_Description, char : Classification...Created 30 April 2025 • Updated 30 April 2025 -
Food Premise Operation Type
Hamilton City CouncilTable about product sector, processes of interest and trading operations Column_InfoFood_Premise_Registration_Account_Number, varchar : Unique Identifier of a food premise registration. This is also a foreign key referencing Account_Number in Food_Premise_Registration tableItem_Number, int : Identifier for the sub category of check type Check_Type,...Created 30 April 2025 • Updated 30 April 2025 -
Traffic Route
Hamilton City CouncilAttributes of routes at which vehicle travel time data is recorded in Hamilton City. Note: A route is an ordered collection of links that a vehicle must follow exactly. Column_InfoRoute_Id, int : Unique identifierRoute_Name, varchar : Description of the routePrimary_Road_Name, varchar : Primary road of the routeStart_End_Description, varchar : Locations...Created 30 April 2025 • Updated 30 April 2025 -
Food Premise To Parcel
Hamilton City CouncilTable about links between Food_Premise table and Parcel table. This is a many to many relationship. needs row level filtering. Note: Some food premises are excluded in this list as their addresses are made private Column_InfoFood_Premise_Account_Number, varchar : This is a foreign key referencing account_number in food_premise tableParcel_Number, int :...Created 30 April 2025 • Updated 30 April 2025 -
Traffic Link
Hamilton City CouncilAttributes of the sections of road in Hamilton City on which travel time data is recorded by Bluetooth sensors. Column_InfoLink_Id, int : Unique identifierLink_Name, varchar : Description of the link locationOrigin_Site_Id, int : Originating site ID of the linkDestination_Site_Id, int : Terminating site ID of the linkIs_Enabled, varchar : Link is...Created 30 April 2025 • Updated 30 April 2025 -
Traffic Site
Hamilton City CouncilAttributes of sites in Hamilton City which collect anonymised data from a sample of vehicles. Note: A Link is the section of the road between two sites Column_InfoSite_Id, int : Unique identiferNumber, int : Asset number. Note: If the site is at a signalised intersection, Number will match 'Site_Number' in the table 'Traffic Signal Site...Created 30 April 2025 • Updated 30 April 2025 -
Food Premise
Hamilton City CouncilTable about all food businesses including home kitchen, mobile, restaurants, cafe .. registered with council. Column_InfoAccount_Number, varchar : Unique Identifier of a food premise. Also used as PRIMARY KEY of this tableFood_Premise_Name, varchar : Trading name of businessStatus, varchar : Shows whether the premise is active or...Created 30 April 2025 • Updated 30 April 2025 -
HireDevice Trip
Hamilton City CouncilStatistics of trips taken on HireDevice in Hamilton City. To get data for this dataset, please call the API directly talking to the HCC Data Warehouse: https://api.hcc.govt.nz/OpenData/get_hiredevice_trip?Page=1&Start_Date=2020-10-01&End_Date=2020-10-02. For this API, there are three mandatory parameters: Page, Start_Date, End_Date. Sample values for...Created 30 April 2025 • Updated 30 April 2025 -
Food Premise Registration
Hamilton City CouncilTable about registrations held by food businesses Column_InfoFood_Premise_Name, varchar : Trading name of food premiseAccount_Number, varchar : Unique identifier of a registration. Also used as PRIMARY KEY of this tableExternal_Reference, varchar : Unique registration number with MPIRegistration_Date, datetime : Date when initial registration was first...Created 30 April 2025 • Updated 30 April 2025 -
Food Premise Verification
Hamilton City CouncilTable about verifications (audits) Column_InfoFood_Premise_Account_Number, varchar : Unique identifier of a food premise. This is a foreign key referencing account_number in food_premise tableAction_Code, varchar : Code used to define the type of task including Annual Audit, Inspection, Compaint Inspection ..Action_Description, varchar : Type of task...Created 30 April 2025 • Updated 30 April 2025 -
HireDevice Status Change
Hamilton City CouncilDrop off and pick up records of HireDevice in Hamilton City. To get data for this dataset, please call the API directly talking to the HCC Data Warehouse: https://api.hcc.govt.nz/OpenData/get_hiredevice_status_change?Page=1&Start_Date=2020-10-01&End_Date=2020-10-02. For this API, there are three mandatory parameters: Page, Start_Date, End_Date. Sample...Created 30 April 2025 • Updated 30 April 2025 -
Owner Classification Event To Dog
Hamilton City CouncilInformation about classification events linked to specific dogs. Column_Info Relationship This table reference to table DogThis table reference to table Owner_Classification_Event Analytics For convenience Hamilton City Council has also built a Quick Analytics Dashboard over this dataset that you can access here. Disclaimer Hamilton City Council does not...Created 30 April 2025 • Updated 30 April 2025 -
DP Notable Tree WFS
Hamilton City Council{{description}}Created 30 April 2025 • Updated 30 April 2025