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...

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,...

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...

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...

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...

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...

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,...

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...

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...

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,...

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,...

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...

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....

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...

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,...

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...

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 :...

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...

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...

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...