-
Dog Impounding To Dog Complaint
Co-LabInformation linking dog impoundings to complaints. Column_InfoImpounding_Account, char : Impounding accountDog_Complaint_Account, char : Complaint account Relationship This table reference to table Dog_ComplaintThis table reference to table Dog_Impounding Analytics For convenience Hamilton City Council has also built a Quick Analytics Dashboard over this...Created 31 January 2024 • Updated 3 March 2025 -
Traffic Route Stats
Co-LabVehicle travel time and delay data on routes in Hamilton City, based on Bluetooth sensor records. 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_route_stats?Page=1&Start_Date=2021-06-02&End_Date=2021-06-03. For this API, there are three mandatory parameters: Page,...Created 31 January 2024 • Updated 3 March 2025 -
Dog Infringement
Co-LabInformation about infringements. Column_InfoInfringement_Number, char : Infringement numberDate_Issued, datetime : Date issuedOffence_Date_Time, datetime : Offence date and timeDog_Number, int : Animal numberInfringement_Type, smallint : Infringemnt typeInfringement_Type_Description, char : Infringement descriptionOffence_Code, smallint : Offence...Created 31 January 2024 • Updated 3 March 2025 -
Dog Complaint To Dog Infringement
Co-LabInformation linking dog complaints to infringements. Column_InfoDog_Complaint_Account, char : Complaint account numberInfringement_Number, char : Infringement number Relationship This table reference to table Dog_ComplaintThis table reference to table Dog_Infringement Analytics For convenience Hamilton City Council has also built a Quick Analytics...Created 31 January 2024 • Updated 3 March 2025 -
Cycling Count
Co-LabCyclist count at counters 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_cycling_count?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 parameters are...Created 31 January 2024 • Updated 3 March 2025 -
Pedestrian Count
Co-LabPedestrian count at counters 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_Pedestrian_count?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 31 January 2024 • Updated 3 March 2025 -
Pedestrian Counter Information
Co-LabDescription of pedestrian counters in Hamilton City Column_InfoCounter_Id, int : Unique identifier of the counterName, varchar : Textual description of the counter location and directionDescription, varchar : Textual description of the counter location and directionInterval, int : Smallest time interval in minutes that the count is recorded inLatitude,...Created 31 January 2024 • Updated 3 March 2025 -
HireDevice Route
Co-LabGPS 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 31 January 2024 • Updated 3 March 2025 -
Dog Complaint
Co-LabInformation 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 31 January 2024 • Updated 3 March 2025 -
Traffic Signal Detector Count
Co-LabRecorded 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 31 January 2024 • Updated 3 March 2025 -
Excess Dog Register
Co-LabInformation 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 31 January 2024 • Updated 3 March 2025 -
Food Premise To Food Premise Registration
Co-LabTable 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 31 January 2024 • Updated 3 March 2025 -
Dog Complaint To Dog
Co-Labinformation 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 31 January 2024 • Updated 3 March 2025 -
Owner Classification Event
Co-LabInformation 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 31 January 2024 • Updated 3 March 2025 -
Food Premise Operation Type
Co-LabTable 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 31 January 2024 • Updated 3 March 2025 -
Dog Transaction
Co-LabFinancial information about dog transactions/fees. Column_InfoTransaction_Date, datetime : Transaction dateTransaction_Value, decimal : Value $Transaction_GST, decimal : GST componentTransaction_Type, varchar : Transaction type Relationship This table reference to table Dog_ImpoundingThis table reference to table Dog_InfringementThis table reference to...Created 31 January 2024 • Updated 3 March 2025 -
Food Premise To Parcel
Co-LabTable 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 31 January 2024 • Updated 3 March 2025 -
Food Premise Transaction
Co-LabTable about all the payment transactions Column_InfoFood_Premise_Name, nvarchar : Trading name of food premiseAccount_Number, varchar : This can account number of registration or food premise. This column has foreign key reference to food_premise and food_premise_registration tablePayment, decimal : Payment amountTransaction_Value, decimal : payment...Created 31 January 2024 • Updated 3 March 2025 -
Food Premise
Co-LabTable 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 31 January 2024 • Updated 3 March 2025 -
HireDevice Trip
Co-LabStatistics 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 31 January 2024 • Updated 3 March 2025