Add Filter

Organisations: Co-Lab

  • Dog Impounding To Dog Complaint

    Co-Lab
    Information 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-Lab
    Vehicle 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-Lab
    Information 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-Lab
    Information 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-Lab
    Cyclist 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-Lab
    Pedestrian 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-Lab
    Description 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-Lab
    GPS 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-Lab
    Information 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-Lab
    Recorded 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-Lab
    Information 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-Lab
    Table 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-Lab
    information 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-Lab
    Information 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-Lab
    Table 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-Lab
    Financial 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-Lab
    Table 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-Lab
    Table 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-Lab
    Table 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-Lab
    Statistics 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