Pedestrian_Counter_Information

Description of pedestrian counters in Hamilton City Column_Info Counter_Id, int : Unique identifier of the counter Name, varchar : Textual description of the counter location and direction Description, varchar : Textual description of the counter location and direction Interval, int : Smallest time interval in minutes that the count is recorded in Latitude, decimal : North-south geographic coordinates Longitude, decimal : East-west geographic coordinates Source_System, varchar : Source system that the count was originally recorded in Is_Active, bit : Counter is currently recording count data Installation_Date, datetime : Date that the counter was installed Site_Id, int : Unique identifier of the counting site Site_Name, varchar : Textual description of the counting site Relationship Pedestrian_Count This table is referenced by 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.'

哈密尔顿市行人计数器数据集说明

### 字段信息
1. 计数器ID（Counter_Id）：整数型（int），该计数器的唯一标识符
2. 名称（Name）：字符型（varchar），对计数器位置与朝向的文字描述
3. 描述（Description）：字符型（varchar），对计数器位置与朝向的文字描述
4. 统计间隔（Interval）：整数型（int），记录行人计数的最小时间间隔（单位：分钟）
5. 纬度（Latitude）：十进制数值型（decimal），南北向地理坐标
6. 经度（Longitude）：十进制数值型（decimal），东西向地理坐标
7. 源系统（Source_System）：字符型（varchar），行人计数数据最初记录的源系统
8. 启用状态（Is_Active）：位类型（bit），标识该计数器当前是否正在记录计数数据
9. 安装日期（Installation_Date）：日期时间型（datetime），计数器的安装日期
10. 计数站点ID（Site_Id）：整数型（int），该计数站点的唯一标识符
11. 计数站点名称（Site_Name）：字符型（varchar），对该计数站点的文字描述

### 关联关系
行人计数表（Pedestrian_Count）：本表被分析模块引用。

为便于使用，哈密尔顿市议会（Hamilton City Council）还基于本数据集搭建了快速分析仪表板，您可通过此处访问。

### 免责声明
哈密尔顿市议会不对本次公开发布供公众下载的数据的准确性与完备性作出任何陈述或保证。由于未向议会通报的相关情况，数据中所呈现的工程层级、位置及尺寸可能并不准确。在开展设计或施工前，您应对所有层级、位置及尺寸进行实地核查。
哈密尔顿市议会不对因依赖或使用所提供的数据，或因议会未能提供本数据而产生的任何损失、损害、成本或开支（无论直接或间接）承担责任。
尽管您可自由对数据进行裁剪、导出并重新使用，但我们要求您注明数据来源为哈密尔顿市议会，并明确说明您的作品为衍生作品，并非权威数据源。在分发基于本数据创作的任何作品时，请包含以下声明：
‘本作品全部或部分源自哈密尔顿市议会提供的数据；所提供的信息可随时更新，且有时可能存在过时、不准确和/或不完整的情况。’