-
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 -
Food Premise Registration
Co-LabTable 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...Created 31 January 2024 • Updated 3 March 2025 -
Dog Registration
Co-LabInformation 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...Created 31 January 2024 • Updated 3 March 2025 -
Food Premise Verification
Co-LabTable 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...Created 31 January 2024 • Updated 3 March 2025 -
Owner Classification Event To Dog
Co-LabInformation 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...Created 31 January 2024 • Updated 3 March 2025 -
Parks and Community Assets - Areas
Co-LabThis 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...Created 3 December 2024 • Updated 3 March 2025 -
Parks and Community Assets - Points
Co-LabThis 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...Created 3 December 2024 • Updated 3 March 2025 -
Parks and Community Assets - Lines
Co-LabThis 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...Created 3 December 2024 • Updated 3 March 2025 -
Waipa District Plan - Protected Trees and Bushstands
Co-LabThe 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...Created 3 December 2024 • Updated 3 March 2025 -
Assets - Channels
Co-LabChannels 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 LayerCreated 31 January 2024 • Updated 3 March 2025 -
Assets - Embankments
Co-LabEmbankments around waterways in the Waikato Region. See metadata for feature RACS_EMBANKMENT in RACS - Assets - GIS LayerCreated 31 January 2024 • Updated 3 March 2025 -
Assets - Floodgates
Co-LabFloodgates in the Waikato Region. See metadata for feature RACS_FLOODGATE in RACS - Assets - GIS LayerCreated 31 January 2024 • Updated 3 March 2025 -
Assets - Pumpstations
Co-LabThe 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 LayerCreated 31 January 2024 • Updated 3 March 2025 -
Assets - River Works (Line)
Co-LabLine 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 LayerCreated 31 January 2024 • Updated 3 March 2025 -
Assets - River Works (Polygon)
Co-LabPolygon 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 LayerCreated 31 January 2024 • Updated 3 March 2025 -
Assets - River Works (Point)
Co-LabPoint 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 LayerCreated 31 January 2024 • Updated 3 March 2025 -
Integrated Catchment Management (ICM) - Boundary Zones
Co-LabIntegrated 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 LayerCreated 31 January 2024 • Updated 3 March 2025