Information about a dog including breed, colour, address, classification and registration status etc.

Column_InfoDog_Number, int : Animal record numberKept_At_Suburb, varchar : Suburb dog lives inKept_At_Post_Code, varchar : Hamilton City post codeKept_At_Town, varchar : Town/city dog lives inPrimary_Breed_Code, varchar : Primary breed National Dog Database codePrimary_Breed, varchar : Primary breedSecondary_Breed_Code, varchar : Secondary NDD breed codeSecondary_Breed, varchar : Secondary breedPrimary_Colour_Code, varchar : Primary colour NDD codPrimary_Colour, varchar : Primary colourSecondary_Colour_Code, varchar : Secondary colour NDD codeSecondary_Colour, varchar : secondary colourDisabled_Assist_Flag, varchar : Disability assist dogDate_Of_Birth, datetime : Dogs date of birthDate_Of_Death, datetime : Dogs date of deathDate_Of_Departure, datetime : Date dog departed from HCCAnimal_Sex, char : Dog sex/genderDesexed, varchar : Is dog de-sexedWorker, varchar : Is it a working dogExternal_Tag_Source, varchar : Dog moved to HCC from...Current_Tag_Set, char : Current registration yearCurrent_Tag_Effective_Date, datetime : Date current registration effective fromCurrent_Tag_Receipt_Date, datetime : Date current registration was receiptedCurrent_Tag_Reg_Til_Date, datetime : Current registration valid untilSpecial_Category_Code, varchar : Special category codesSpecial_Category_Description, varchar : Special category dogs e.g. guide dogs, hearing assist, police dogsClassification, varchar : Dogs classification staus (N/A, dangerous, menacing)Classification_Date, datetime : Date dog was classifiedClassification_Reason_Code, varchar : Reason for classification codeClassification_Reason_Description, varchar : Reason for classificationDeactivated, varchar : Date animal record deactivatedDeactivated_Description, varchar : Reason for deactivationAnimal_Description, varchar : Description of dogFee_Code, smallint : Fee codeFee_Description, varchar : Fee descriptionMicrochip_Flag, varchar : Microchip statusMicrochip_Brand, varchar : Microchip brandAnimal_Features, varchar : Any distinguishing features on dogOffence_Free_Flag, varchar : Offence free statusActive_Dog_Record, varchar : Dogs currently registered in HCC

Relationship

This table is referenced by Dog_Complaint_To_DogThis table is referenced by Dog_ImpoundingThis table is referenced by Dog_InfringementThis table is referenced by Dog_RegistrationThis table is referenced by Excess_Dog_Register_To_DogThis table is referenced by Owner_Classification_Event_To_Dog

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 make any representation or give any warranty as to the accuracy or exhaustiveness of the data released for public download. Levels, locations and dimensions of works depicted in the data may not be accurate due to circumstances not notified to Council. A physical check should be made on all levels, locations and dimensions before starting design or works.

Hamilton City Council shall not be liable for any loss, damage, cost or expense (whether direct or indirect) arising from reliance upon or use of any data provided, or Council's failure to provide this data.

While you are free to crop, export and re-purpose the data, we ask that you attribute the Hamilton City Council and clearly state that your work is a derivative and not the authoritative data source. Please include the following statement when distributing any work derived from this data:

‘This work is derived entirely or in part from Hamilton City Council data; the provided information may be updated at any time, and may at times be out of date, inaccurate, and/or incomplete.'