Food_Premise_To_Parcel

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_Info Food_Premise_Account_Number, varchar : This is a foreign key referencing account_number in food_premise table Parcel_Number, int : This is a foreign key referencing parcel_number in parcel table Parcel_Flag, varchar : Indicates whether parcel is registered, historic.. Relationship Food_Premise This table reference to table Hamilton_Land_Parcel This table reference to table 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.'本表格用于记录食品场所表（Food_Premise）与地块表（Parcel）之间的关联关系，二者为多对多关联，需进行行级过滤。 注：由于部分食品场所的地址已设为隐私，因此未纳入本列表中。 ### 字段信息 1. Food_Premise_Account_Number（varchar类型）：为外键，关联食品场所表（food_premise）中的account_number字段 2. Parcel_Number（int类型）：为外键，关联地块表（parcel）中的parcel_number字段 3. Parcel_Flag（varchar类型）：用于指示地块是否处于已注册、历史等状态。 ### 关联说明 本表格分别关联至食品场所表（Food_Premise）、Hamilton_Land_Parcel表及Analytics表。 为便于使用，哈密尔顿市议会（Hamilton City Council）还基于本数据集搭建了快速分析仪表板，您可通过此处访问。 ### 免责声明 哈密尔顿市议会（Hamilton City Council）不对本公开下载数据的准确性与完备性作出任何陈述或保证。由于未向议会通报的相关情形，数据中所描绘的工程层级、位置及尺寸可能存在偏差。在开展设计或施工作业前，您应对所有层级、位置及尺寸进行实地核查。 哈密尔顿市议会不对因依赖或使用所提供的数据，或因议会未能提供本数据而产生的任何损失、损害、成本或费用（无论直接或间接）承担责任。 您可自由对数据进行裁剪、导出与二次利用，但请注明数据来源为哈密尔顿市议会，并明确说明您的作品为衍生作品，并非权威数据源。在分发基于本数据集创作的衍生作品时，请附上以下声明： "本作品全部或部分基于哈密尔顿市议会的数据创作；所提供的信息可能随时更新，且有时可能存在过时、不准确和/或不完整的情况。"