Vehicle travel time and delay data on sections of road 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_link_stats?Page=1&Start_Date=2021-06-02&End_Date=2021-06-03. For this API, there are three mandatory parameters: Page, Start_Date, End_Date. Sample values for these parameters are in the link above. When calling the API for the first time, please always start with Page 1. Then from the returned JSON, you can see more information such as the total page count and page size. For help on using the API in your preferred data analysis software, please contact dale.townsend@hcc.govt.nz. NOTE: Anomalies and missing data may be present in the dataset.

Column_Info

Relationship









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

This layer is part of Hamilton City Council's Freshwater Dataset.If you wish to download and consume this entire dataset - click on the link for the file format(s) of your choosing: FGDB/File Geodatabase Shapefile Excel CAD (DWG) Please note that the links above may change at any time. For best practice, please refer to this page for the correct links. If any of the links are above are not functioning, please let us know at gis@hcc.govt.nz. This Water (Freshwater) dataset contains the following layers: Water Valve (A tap on a main that controls the flow of water along that main) Water Service Valve (A tap on a service line that controls the flow of water along that line) Water Service Line/Connection (A pipe that delivers water from the main to a building for consumption) Water Meter (A device that measures and displays the amount of water passing through the associated main or service line) Water Main Offset (A point along a main indicating the distance of the main from another known point such as the property boundary or kerb) Water Main Crossover Junction (The junction of one or more pipes where the pipes do not intersect - aka crossover junction) Water Main Abandoned (A water main that is still in the ground, but is now disused and no longer forms part of the active network) Water Hydrant (A tap supplying access to high-pressure water to fight fires, flush pipes and fill water trucks) Water Chamber MH (An opening/structure in a water chamber for the purpose of allowing operators or equipment access to the inside of the chamber) Water Chamber (A chamber on a water main (except bulk mains) containing operational or monitoring devices such as valves or flow meters) Water BM Chamber (A chamber on a water bulk main containing operational devices such as valves or flow meters) Water BM AV Chamber (A chamber on a water bulk main containing an air valve) Water Backflow Device (A device which prevents the accidental backflow of contaminated water into the water system) Water Asbuilts (Plans showing the location and alignment of basic water infrastructure as it was constructed on site, as provided by the contractor or their representatives. Data has not yet been fully incorporated into the Council GIS or asset management system) Hamilton City Council 3 Waters data is derived from the Council’s GIS (ArcGIS) dataset. The GIS dataset is synchronised with asset data contained in the Council’s Asset Management (IPS) database. A subset of the GIS dataset has been made available for download. This GIS dataset is currently updated weekly which in turn dynamically updates to the WLASS open data site. Any questions pertaining to this data should be directed to the City Waters Asset Information Team at CityWatersAssetInfo@hcc.govt.nz 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.'

description: Community Colleges dataset current as of 2011. File name = HCC Only one in the county. http://www.harfordcountymd.gov/gis/Index.cfm.; abstract: Community Colleges dataset current as of 2011. File name = HCC Only one in the county. http://www.harfordcountymd.gov/gis/Index.cfm.

This layer is part of Hamilton City Council's Freshwater Dataset.If you wish to download and consume this entire dataset - click on the link for the file format(s) of your choosing: CAD (DWG)

Please note that the links above may change at any time. For best practice, please refer to this page for the correct links.

If any of the links are above are not functioning, please let us know at gis@hcc.govt.nz.

This Water (Freshwater) dataset contains the following layers:

Water Valve (A tap on a main that controls the flow of water along that main) Water Service Valve (A tap on a service line that controls the flow of water along that line) Water Service Line/Connection (A pipe that delivers water from the main to a building for consumption) Water Meter (A device that measures and displays the amount of water passing through the associated main or service line) Water Main Offset (A point along a main indicating the distance of the main from another known point such as the property boundary or kerb) Water Main Crossover Junction (The junction of one or more pipes where the pipes do not intersect - aka crossover junction) Water Main Abandoned (A water main that is still in the ground, but is now disused and no longer forms part of the active network) Water Hydrant (A tap supplying access to high-pressure water to fight fires, flush pipes and fill water trucks) Water Chamber MH (An opening/structure in a water chamber for the purpose of allowing operators or equipment access to the inside of the chamber) Water Chamber (A chamber on a water main (except bulk mains) containing operational or monitoring devices such as valves or flow meters) Water BM Chamber (A chamber on a water bulk main containing operational devices such as valves or flow meters) Water BM AV Chamber (A chamber on a water bulk main containing an air valve) Water Backflow Device (A device which prevents the accidental backflow of contaminated water into the water system) Water Asbuilts (Plans showing the location and alignment of basic water infrastructure as it was constructed on site, as provided by the contractor or their representatives. Data has not yet been fully incorporated into the Council GIS or asset management system)

Hamilton City Council 3 Waters data is derived from the Council’s GIS (ArcGIS) dataset. The GIS dataset is synchronised with asset data contained in the Council’s Asset Management (IPS) database. A subset of the GIS dataset has been made available for download.

This GIS dataset is currently updated weekly which in turn dynamically updates to the WLASS open data site. Any questions pertaining to this data should be directed to the City Waters Asset Information Team at CityWatersAssetInfo@hcc.govt.nz

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

This layer is part of Hamilton City Council's Stormwater Dataset.If you wish to download and consume this entire dataset - click on the link for the file format(s) of your choosing:CAD (DWG) Please note that the links above may change at any time. For best practice, please refer to this page for the correct links.   If any of the links are above are not functioning, please let us know at gis@hcc.govt.nz. This Stormwater dataset contains the following layers: Stormwater Abandoned Main (A stormwater main that is still in the ground, but is now disused and no longer forms part of the active network) Stormwater Abandoned Manhole (An opening in a pipe for the purpose of allowing operators or equipment access to the inside of the pipe that is still in the ground but is now disused and no longer forms part of the active network) Stormwater Asbuilts (Plans showing the location and alignment of basic stormwater infrastructure as it was actually constructed on site, as provided by the contractor or their representatives.  Data has not yet been fully incorporated into the Council GIS or asset management system) Stormwater Attenuation and Treatment Device (A device used to provide temporary storage and the controlled release of storm water volumes. Located upstream of the receiving environment, devices such as wetlands and ponds may also incorporate a storm water treatment function) Stormwater Catchpit (A device that collects stormwater run-off from the road and transports it along the network) Stormwater Catchpit Lead (A pipe that transports stormwater run-off from catchpits and connects into the stormwater network) Stormwater Channel (An open drain, natural watercourse (such as a stream) or lined channel that collects stormwater run-off from the environment or network) Stormwater Inlet (A structure where stormwater enters either a pipe, pond, culvert or channel) Stormwater Main (A pipe that transports stormwater to a natural watercourse or body of water) Stormwater Manhole (An opening in a pipe for the purpose of allowing operators or equipment access to the inside of the pipe) Stormwater Node (A junction point in a pipe. It can be a structure) Stormwater Outlet (A structure at the end of a pipe or channel that controls the flow of stormwater to a natural watercourse or body of water)Stormwater Service Line (A gravity flow pipeline connecting a building’s direct runoff collection system to a stormwater pipe or a kerb (in the case of kerb and channel connections)) Stormwater Soakage Trench (A subsurface structure into which runoff is conveyed for disposal by infiltration) Stormwater Subsoil Drain (A perforated drain used to collect ground water and transport it to a land drainage or stormwater drainage system)  Hamilton City Council 3 Waters data is derived from the Council’s GIS (ArcGIS) dataset. The GIS dataset is synchronised with asset data contained in the Council’s Asset Management (IPS) database. A subset of the GIS dataset has been made available for download. This GIS dataset is currently updated weekly which in turn dynamically updates to the WLASS open data site. Any questions pertaining to this data should be directed to the City Waters Asset Information Team at CityWatersAssetInfo@hcc.govt.nz 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.  

Description of cycle 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, decimal : North-south geographic coordinatesLongitude, decimal : East-west geographic coordinatesSource_System, varchar : Source system that the count was originally recorded inIs_Active, bit : Counter is currently recording count dataInstallation_Date, datetime : Date that the counter was installedSite_Id, int : Unique identifier of the counting siteSite_Name, varchar : Textual description of the counting site Relationship This table is referenced by Cycling_Count 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.'

HCC 3 Waters Asset Data exported out of InfoAsset at Wellington Water Ltd (WWL). Made up of 19 layers for water, stormwater & wastewater networks - pipes, manholes, hydrants, valves, pump stations, reservoirs, meters, fittings and stormwater open channels. Please check the date for the latest Data Updated date. Height levels are in terms of NZVD2016 as of 1 July 2022. *It has limited symbology, scales and includes Abandoned, removed & virtual assets & some privately owned assets. The data can be added to an Arc Pro project and it allows viewing the attribute tables & change symbols. It's other purpose is that it can be download from our Open Data Portal. https://data-wellingtonwater.opendata.arcgis.com/

The Department of Health and Human Services (DHHS), Health Care Coalitions in Nebraska. Geography from 2020 Census County file. Nebraska counties were merged to create Local Health Departments (LHD). LHD were then merged to create Health Care Coalition Regions (HCC).This data is commonly used by the Division of Public Health (DPH) and the Emergency Preparedness and Response Unit (EPRU). Related contact table (EPRU Health Care Coalition Contacts) will be updated approximately quarterly by EPRU or GIS staff. Associated county stats table (EPRU Health Care Coalition CountyStats) will be updated as needed (2030 census or if a HCC boundary changes).

This layer is part of Hamilton City Council's Freshwater Dataset.If you wish to download and consume this entire dataset - click on the link for the file format(s) of your choosing: CAD (DWG)

Please note that the links above may change at any time. For best practice, please refer to this page for the correct links.

If any of the links are above are not functioning, please let us know at gis@hcc.govt.nz.

This Water (Freshwater) dataset contains the following layers:

Water Valve (A tap on a main that controls the flow of water along that main) Water Service Valve (A tap on a service line that controls the flow of water along that line) Water Service Line/Connection (A pipe that delivers water from the main to a building for consumption) Water Meter (A device that measures and displays the amount of water passing through the associated main or service line) Water Main Offset (A point along a main indicating the distance of the main from another known point such as the property boundary or kerb) Water Main Crossover Junction (The junction of one or more pipes where the pipes do not intersect - aka crossover junction) Water Main Abandoned (A water main that is still in the ground, but is now disused and no longer forms part of the active network) Water Hydrant (A tap supplying access to high-pressure water to fight fires, flush pipes and fill water trucks) Water Chamber MH (An opening/structure in a water chamber for the purpose of allowing operators or equipment access to the inside of the chamber) Water Chamber (A chamber on a water main (except bulk mains) containing operational or monitoring devices such as valves or flow meters) Water BM Chamber (A chamber on a water bulk main containing operational devices such as valves or flow meters) Water BM AV Chamber (A chamber on a water bulk main containing an air valve) Water Backflow Device (A device which prevents the accidental backflow of contaminated water into the water system) Water Asbuilts (Plans showing the location and alignment of basic water infrastructure as it was constructed on site, as provided by the contractor or their representatives. Data has not yet been fully incorporated into the Council GIS or asset management system)

Hamilton City Council 3 Waters data is derived from the Council’s GIS (ArcGIS) dataset. The GIS dataset is synchronised with asset data contained in the Council’s Asset Management (IPS) database. A subset of the GIS dataset has been made available for download.

This GIS dataset is currently updated weekly which in turn dynamically updates to the WLASS open data site. Any questions pertaining to this data should be directed to the City Waters Asset Information Team at CityWatersAssetInfo@hcc.govt.nz

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

This layer is part of Hamilton City Council's Wastewater Dataset.If you wish to download and consume this entire dataset - click on the link for the file format(s) of your choosing: CAD (DWG) Please note that the links above may change at any time. For best practice, please refer to this page for the correct links. If any of the links are above are not functioning, please let us know at gis@hcc.govt.nz. This Wastewater dataset contains the following layers: Wastewater Abandoned Main (A wastewater main that is still in the ground, but is now disused and no longer forms part of the active network) Wastewater Abandoned Manhole (A wastewater manhole that is still in the ground but is now disused and no longer forms part of the active network) Wastewater Asbuilts (Plans showing the location and alignment of basic wastewater infrastructure as it was actually constructed on site, as provided by the contractor or their representatives Data has not yet been fully incorporated into the Council GIS or asset management system) Wastewater Main (A pipe that receives wastewater from domestic and industrial sources and directs it toward the wastewater treatment plant) Wastewater Manhole (An underground structure built over an opening in a pipe for the purpose of allowing operators or equipment access to the inside of the pipe) Wastewater Node (A junction point in a pipe It can be a structure) Wastewater Pump Station (A facility that raises wastewater from areas too low to drain by gravity, into existing pipes) Wastewater Service Line (A gravity or pressure flow pipeline connecting a building’s wastewater system to a wastewater main) Wastewater Storage Unit (A device used to contain or store effluent) Wastewater Valve (A wastewater valve is used to shut off or regulate the flow of wastewater) Hamilton City Council 3 Waters data is derived from the Council’s GIS (ArcGIS) dataset. The GIS dataset is synchronised with asset data contained in the Council’s Asset Management (IPS) database. A subset of the GIS dataset has been made available for download. This GIS dataset is currently updated weekly which in turn dynamically updates to the WLASS open data site. Any questions pertaining to this data should be directed to the City Waters Asset Information Team at CityWatersAssetInfo@hcc.govt.nz 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.'

Attributes of sites in Hamilton City which collect anonymised data from a sample of vehicles. Note: A Link is the section of the road between two sites

Column_InfoSite_Id, int : Unique identiferNumber, int : Asset number. Note: If the site is at a signalised intersection, Number will match 'Site_Number' in the table 'Traffic Signal Site Location'Is_Enabled, varchar : Site is currently enabledDisabled_Date, datetime : If currently disabled, the date at which the site was disabledSite_Name, varchar : Description of the site locationLatitude, numeric : North-south geographic coordinatesLongitude, numeric : East-west geographic coordinates

Relationship









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

This layer is part of Hamilton City Council's Freshwater Dataset.If you wish to download and consume this entire dataset - click on the link for the file format(s) of your choosing: FGDB/File Geodatabase Shapefile Excel CAD (DWG) Please note that the links above may change at any time. For best practice, please refer to this page for the correct links. If any of the links are above are not functioning, please let us know at gis@hcc.govt.nz. This Water (Freshwater) dataset contains the following layers: Water Valve (A tap on a main that controls the flow of water along that main) Water Service Valve (A tap on a service line that controls the flow of water along that line) Water Service Line/Connection (A pipe that delivers water from the main to a building for consumption) Water Meter (A device that measures and displays the amount of water passing through the associated main or service line) Water Main Offset (A point along a main indicating the distance of the main from another known point such as the property boundary or kerb) Water Main Crossover Junction (The junction of one or more pipes where the pipes do not intersect - aka crossover junction) Water Main Abandoned (A water main that is still in the ground, but is now disused and no longer forms part of the active network) Water Hydrant (A tap supplying access to high-pressure water to fight fires, flush pipes and fill water trucks) Water Chamber MH (An opening/structure in a water chamber for the purpose of allowing operators or equipment access to the inside of the chamber) Water Chamber (A chamber on a water main (except bulk mains) containing operational or monitoring devices such as valves or flow meters) Water BM Chamber (A chamber on a water bulk main containing operational devices such as valves or flow meters) Water BM AV Chamber (A chamber on a water bulk main containing an air valve) Water Backflow Device (A device which prevents the accidental backflow of contaminated water into the water system) Water Asbuilts (Plans showing the location and alignment of basic water infrastructure as it was constructed on site, as provided by the contractor or their representatives. Data has not yet been fully incorporated into the Council GIS or asset management system) Hamilton City Council 3 Waters data is derived from the Council’s GIS (ArcGIS) dataset. The GIS dataset is synchronised with asset data contained in the Council’s Asset Management (IPS) database. A subset of the GIS dataset has been made available for download. This GIS dataset is currently updated weekly which in turn dynamically updates to the WLASS open data site. Any questions pertaining to this data should be directed to the City Waters Asset Information Team at CityWatersAssetInfo@hcc.govt.nz 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.'

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 in the link above. When calling the API for the first time, please always start with Page 1. Then from the returned JSON, you can see more information such as the total page count and page size. For help on using the API in your preferred data analysis software, please contact dale.townsend@hcc.govt.nz. NOTE: Anomalies and missing data may be present in the dataset.

Column_InfoCounter_Id, int : Unique identifier of the counterCount_Datetime, varchar : Start of the time interval that the count was recorded forCount_Number, int : Volume of cyclists recorded for the given time interval

Relationship

This table reference to table Cycling_Counter_Information

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

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 : This is a foreign key referencing parcel_number in parcel tableParcel_Flag, varchar : Indicates whether parcel is registered, historic..

Relationship

This table reference to table Food_PremiseThis table reference to table Hamilton_Land_Parcel

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

You may access a GIS viewer that has been set up to view the data by clicking on this LINK.Hamilton City Council undertakes regular traffic counts at approximately 150 sites throughout the city. This information is used for monitoring trends and planning for new works. Some sites are counted continuously and this data is analysed to determine seasonal variations in traffic flows throughout the year. Most sites are counted for a seven day period once every one or two years. These counts are adjusted using factors derived from the continuous sites and then an estimate of the average daily traffic for the year is made.

City of Hobart: Stormwater Network

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 these parameters are in the link above. When calling the API for the first time, please always start with Page 1. Then from the returned JSON, you can see more information such as the total page count and page size. For help on using the API in your preferred data analysis software, please contact dale.townsend@hcc.govt.nz. NOTE: Anomalies and missing data may be present in the dataset.

Column_InfoTrip_Id, varchar : Unique identifier of the tripTrip_Duration, int : Duration of the trip in secondsTrip_Distance, int : Distance of the trip in metresDevice_Id, varchar : Unique identifier of the GPS device on the scooterVehicle_Id, varchar : Unique identifier of the scooterStart_Time, datetime : Date and time that the trip startedEnd_Time, datetime : Date and time that the trip ended

Relationship

This table is referenced by HireDevice_Route

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

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 parameters are in the link above. When calling the API for the first time, please always start with Page 1. Then from the returned JSON, you can see more information such as the total page count and page size. For help on using the API in your preferred data analysis software, please contact dale.townsend@hcc.govt.nz. NOTE: Anomalies and missing data may be present in the dataset.

Column_InfoCounter_Id, int : Unique identifier of the counterCount_Datetime, varchar : Start of the time interval that the count was recorded forCount_Number, int : Volume of pedestrians recorded for the given time interval

Relationship

This table reference to table Pedestrian_Counter_Information

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

This layer is part of Hamilton City Council's Freshwater Dataset.If you wish to download and consume this entire dataset - click on the link for the file format(s) of your choosing: CAD (DWG) Please note that the links above may change at any time. For best practice, please refer to this page for the correct links. If any of the links are above are not functioning, please let us know at gis@hcc.govt.nz. This Water (Freshwater) dataset contains the following layers: Water Valve (A tap on a main that controls the flow of water along that main) Water Service Valve (A tap on a service line that controls the flow of water along that line) Water Service Line/Connection (A pipe that delivers water from the main to a building for consumption) Water Meter (A device that measures and displays the amount of water passing through the associated main or service line) Water Main Offset (A point along a main indicating the distance of the main from another known point such as the property boundary or kerb) Water Main Crossover Junction (The junction of one or more pipes where the pipes do not intersect - aka crossover junction) Water Main Abandoned (A water main that is still in the ground, but is now disused and no longer forms part of the active network) Water Hydrant (A tap supplying access to high-pressure water to fight fires, flush pipes and fill water trucks) Water Chamber MH (An opening/structure in a water chamber for the purpose of allowing operators or equipment access to the inside of the chamber) Water Chamber (A chamber on a water main (except bulk mains) containing operational or monitoring devices such as valves or flow meters) Water BM Chamber (A chamber on a water bulk main containing operational devices such as valves or flow meters) Water BM AV Chamber (A chamber on a water bulk main containing an air valve) Water Backflow Device (A device which prevents the accidental backflow of contaminated water into the water system) Water Asbuilts (Plans showing the location and alignment of basic water infrastructure as it was constructed on site, as provided by the contractor or their representatives. Data has not yet been fully incorporated into the Council GIS or asset management system) Hamilton City Council 3 Waters data is derived from the Council’s GIS (ArcGIS) dataset. The GIS dataset is synchronised with asset data contained in the Council’s Asset Management (IPS) database. A subset of the GIS dataset has been made available for download. This GIS dataset is currently updated weekly which in turn dynamically updates to the WLASS open data site. Any questions pertaining to this data should be directed to the City Waters Asset Information Team at CityWatersAssetInfo@hcc.govt.nz 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.'

Information linking dog classification to specific events (customer complaints).

Column_Info

Relationship

This table reference to table Dog_ComplaintThis 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 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.'