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

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

Information about dog registrations Column_InfoDog_Number, int : Animal numberRegistration_ID, char : ?? Tag numberRegistration_From, datetime : Date fromRegistration_To, datetime : Date toEffective_Date, datetime : Effective dateEffective_Flag, char : Effective flagCalculated_Fee, decimal : FeeFee_Code, smallint : Fee codeFee_Code_Description, char : Fee...

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

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

This dataset is sourced from Council's Asset Management system (EAM). It contains area asset categories: Cemetery AssetsPark AssetsPlayground AssetsPrivate Park AssetsPublic Toilet AssetsWalk and Cycleway Assets The GIS dataset is synchronised with asset data contained in the Council’s Enterprise Asset Management (EAM) database. A subset of the GIS...

This dataset is sourced from Council's Asset Management system (EAM). It contains point asset categories: Cemetery AssetsPark AssetsPlayground AssetsPrivate Park AssetsWalk and Cycleway Assets The GIS dataset is synchronised with asset data contained in the Council’s Enterprise Asset Management (EAM) database. A subset of the GIS dataset has been made...

This dataset is sourced from Council's Asset Management system (EAM). It contains line asset categories: Cemetery AssetsPark AssetsPlayground AssetsPrivate Park AssetsWalk and Cycleway Assets The GIS dataset is synchronised with asset data contained in the Council’s Enterprise Asset Management (EAM) database. A subset of the GIS dataset has been made...

The Waipā district, particularly Cambridge, contains a number of significant specimen trees of historic, botanic and amenity value, many of which date from early European settlement. Our protected trees include black walnut, English oak, California redwood and native New Zealand species rimu and silver beech. This feature layer contains the location of...

Channels throughout the Waikato Region used to hold actions for condition surveys and when maintenance works are performed on the waterways. See metadata for feature RACS_CHANNEL in RACS - Assets - GIS Layer

Embankments around waterways in the Waikato Region. See metadata for feature RACS_EMBANKMENT in RACS - Assets - GIS Layer

Floodgates in the Waikato Region.  See metadata for feature RACS_FLOODGATE in RACS - Assets - GIS Layer

The location of Flood Pumpstations and Land Drainage Pumpstations used to drain wet areas rather than just flood waters.  See metadata for feature RACS_PUMPSTATION in RACS - Assets - GIS Layer 

Line features displaying erosion control and structures around waterways in the Waikato region.  Also see Assets - River Works (Point) and Assets - River Works (Polygon).   See metadata for feature RACS_RIVER_WORKS_LINE in RACS - Assets - GIS Layer

Polygon features displaying erosion control and structures around waterways in the Waikato region.  Also see Assets - River Works (Point) and Assets - River Works (Line).   See metadata for feature RACS_RIVER_WORKS_POLY in RACS - Assets - GIS Layer

Point features displaying erosion control and structures around waterways in the Waikato region.  Also see Assets - River Works (Line) and Assets - River Works (Polygon).   See metadata for feature RACS_RIVER_WORKS_POINT in RACS - Assets - GIS Layer

Integrated Catchment Management (ICM) boundary zones. A visual representation of how the Region has been divided for management purposes.  See metadata for feature RACS_ZONE in RACS - Management Boundaries - GIS Layer