Historical distribution and habitat characteristics of Ostrea edulis reefs in Europe- supporting dataset

These data form part of the data collection "Historical distribution and habitat characteristics of Ostrea edulis reefs in Europe" 10.6084/m9.figshare.c.6884167which is the supporting data for the publications:https://doi.org/10.32942/X20W43https://doi.org/10.32942/X28C99The collection also includes:1. Location and descriptive data pertaining to historical records of the <i>Ostrea edulis</i> reef ecosystem: 10.6084/m9.figshare.243287682. The locations of historical records of <i>Ostrea edulis</i> reef ecosystems in GIS format: 10.6084/m9.figshare.243213193. Geospatial data resulting from the digitizing of the historical map collection Joubin L, Guérin-Ganivet J (2009). Cartes des gisements de coquilles comestibles des côtes de France. Ifremer. https://doi.org/10.12770/c502ed30-0d7d-11de-a4b1-000086f6a603Spatial data accessible at: 10.6084/m9.figshare.24328783Data file descriptions included in this database:1_Oyster_habitat_location.xlsxThis Excel data file contains the estimated locations of historical oyster reef habitats, details of their depth and assigned certainty of the record. This file contains a mixture of spatial data, quantitative and qualitative data. Labelled columns:UniqueID: assigned ID unique to each record.Year_assigned: the estimated year (AD) when the habitat was either stated to exist or – if year or description was not provided – the year of publication. In instances where negative values are assigned this corresponds to BC e.g. -100 means 100BC.Detailed_location: records where a specific location was provided, most typically a bay or village.Location: records where a location was provided but which was typically non-specific, i.e. a region.Estimated_coordinates: estimated location (decimal GPS coordinates) assigned by the authors, with a precision to 2 decimal places.Description_location: historical descriptions of locations.Description_fishery refers to historical descriptions of the fishery.Ref_number: source reference as listed in file name “4_Oyster_reference_list.docx”Depth: described depth, usually in metres or fathoms.Habitat_certainty: the levels of confidence assigned to historical sources as to whether they were likely referring to biogenic oyster reef habitats (high or low), as opposed to scattered oysters, and confidence in the accuracy of the assigned location (high or low). These were assigned based on the following criteria: High confidence of reef habitat, high location certainty (HH): record of habitat e.g., a bed or bank of oysters, or record of an active fishery using towed gears with no recorded active intervention, thus indicating an initial high abundance of oysters. We are confident of the location to within 10 km e.g., oyster presence within a bay or harbour.High confidence of reef habitat, low location certainty (HL): we were confident a habitat existed, but the location is uncertain to &gt; 10 km e.g., named open water locations without positioning detail. Low confidence of reef habitat, high location certainty (LH): we know oysters were fished but the descriptions (or corresponding descriptions) do not provide evidence that the species formed biogenic reef in this location e.g., individuals were described as attached to rocks. We are confident of the location to within 10 km.Low confidence of reef habitat, low location certainty (LL): we know oysters were fished, but the descriptions (or corresponding descriptions) do not provide evidence that the species formed biogenic reef in this location. The location is uncertain to &gt; 10 km. Centroid latitude: Central point of the 10km2 grid that overlays the original data point, in decimal GPS (latitude). Centroid longitude: Central point of the 10km2 grid that overlays the original data point, in decimal GPS (longitude).2_Oyster_habitat_extent.xlsxThis Excel data file contains the described extent (area or length) of historical oyster reef habitats, and their approximate location. This file contains a mixture of spatial data, quantitative and qualitative data. Labelled columns:UniqueID: assigned ID unique to each record.Year_assigned: the estimated year (AD) when the habitat was either stated to exist or – if year or description was not provided – the year of publication.Location: records where a location was described.Estimated_coordinates: estimated location (decimal GPS coordinates) assigned by the authors, with a precision to 2 decimal places.Description: historical descriptions of the extent.Ref_number: source reference as listed in file name “4_Oyster_reference_list.docx”Area_ha: extent of oyster bed calculated from source description, in hectares.Length_km: length of oyster bed calculated from source description, in kilometres.3_Oyster_habitat_descriptions.docxThis Word document provides qualitative descriptions of habitat, the estimated year, broad location referred to and the numbered references from which oyster reef descriptions were sourced (as listed in file name “4_Oyster_reference_list.docx”).4_Oyster_reference_list.docxThis Word document lists the references from which oyster reef/fishery descriptions were sourced and the assigned number used for cross-referencing across files 1-4.5_Oyster_historical_species_list.docxThis Word document provides a list of the species associated with historical oyster reefs and their taxonomic description. As not all historical descriptions provided quantitative species data this is a presence-only species list.The collection 10.6084/m9.figshare.c.6884167 also includes geospatial data files resulting from these described data and from digitizing the historical map collection: Joubin L, Guérin-Ganivet J (2009). Cartes des gisements de coquilles comestibles des côtes de France. Ifremer. https://doi.org/10.12770/c502ed30-0d7d-11de-a4b1-000086f6a603

本数据构成数据集《欧洲欧洲牡蛎（<i>Ostrea edulis</i>）礁的历史分布与栖息地特征》（10.6084/m9.figshare.c.6884167）的一部分，该数据集是以下出版物的支撑数据：https://doi.org/10.32942/X20W43 https://doi.org/10.32942/X28C99

该数据集还包含：
1. 欧洲牡蛎（<i>Ostrea edulis</i>）礁生态系统历史记录的位置与描述数据：10.6084/m9.figshare.24328768
2. GIS格式的欧洲牡蛎（<i>Ostrea edulis</i>）礁生态系统历史记录位置数据：10.6084/m9.figshare.24321319
3. 源自历史地图集数字化处理的地理空间数据，该地图集为Joubin L、Guérin-Ganivet J（2009）所著《法国海岸可食用贝类栖息地地图集》（Cartes des gisements de coquilles comestibles des côtes de France），由法国海洋开发研究院（Ifremer）发布，DOI：https://doi.org/10.12770/c502ed30-0d7d-11de-a4b1-000086f6a603；相关空间数据可通过以下链接获取：10.6084/m9.figshare.24328783

本数据库包含的文件说明如下：

1_Oyster_habitat_location.xlsx
该Excel文件包含历史牡蛎礁栖息地的估计位置、深度细节及记录的确定性赋值，融合了空间数据、定量数据与定性数据。列标签说明：
UniqueID：每条记录的唯一标识ID
Year_assigned：栖息地被记录存在的估计年份（公元）；若未提供年份或描述，则为出版物发表年份。负值表示公元前，例如-100代表公元前100年
Detailed_location：提供具体位置的记录（通常为海湾或村庄）
Location：提供非特异性位置的记录（通常为区域）
Estimated_coordinates：作者赋值的估计位置（十进制GPS坐标，精度至2位小数）
Description_location：位置的历史描述
Description_fishery：渔业的历史描述
Ref_number：参考编号，对应文件“4_Oyster_reference_list.docx”中的条目
Depth：描述的深度（通常为米或英寻）
Habitat_certainty：历史来源对栖息地是否为生物成因牡蛎礁的置信度（高/低）及位置确定性（高/低），分为以下等级：
- 高栖息地置信度+高位置确定性（HH）：存在栖息地记录（如牡蛎床或堆），或使用拖网渔具且无主动干预记录的活跃渔业记录（表明初始牡蛎丰度较高）；位置确定性在10公里范围内（如海湾或港口内的牡蛎分布）
- 高栖息地置信度+低位置确定性（HL）：栖息地存在置信度高，但位置确定性超出10公里范围（如无定位细节的开放式水域命名位置）
- 低栖息地置信度+高位置确定性（LH）：已知牡蛎被捕捞，但描述未提供其形成生物成因礁的证据（如个体附着于岩石）；位置确定性在10公里范围内
- 低栖息地置信度+低位置确定性（LL）：已知牡蛎被捕捞，但描述未提供其形成生物成因礁的证据；位置确定性超出10公里范围
Centroid latitude：覆盖原始数据点的10km²网格中心点的十进制GPS纬度
Centroid longitude：覆盖原始数据点的10km²网格中心点的十进制GPS经度

2_Oyster_habitat_extent.xlsx
该Excel文件包含历史牡蛎礁栖息地的描述范围（面积或长度）及大致位置，融合了空间数据、定量数据与定性数据。列标签说明：
UniqueID：每条记录的唯一标识ID
Year_assigned：栖息地被记录存在的估计年份（公元）；若未提供年份或描述，则为出版物发表年份
Location：描述的位置
Estimated_coordinates：作者赋值的估计位置（十进制GPS坐标，精度至2位小数）
Description：范围的历史描述
Ref_number：参考编号，对应文件“4_Oyster_reference_list.docx”中的条目
Area_ha：根据来源描述计算的牡蛎床面积（单位：公顷）
Length_km：根据来源描述计算的牡蛎床长度（单位：公里）

3_Oyster_habitat_descriptions.docx
该Word文档提供栖息地的定性描述、估计年份、涉及的大致位置，以及牡蛎礁描述的来源参考编号（对应文件“4_Oyster_reference_list.docx”）

4_Oyster_reference_list.docx
该Word文档列出牡蛎礁/渔业描述的来源参考文献及跨文件1-4使用的交叉引用编号

5_Oyster_historical_species_list.docx
该Word文档提供与历史牡蛎礁相关的物种列表及其分类描述。由于并非所有历史描述均包含定量物种数据，此列表仅记录物种存在情况

数据集10.6084/m9.figshare.c.6884167还包含源自上述描述数据及历史地图集数字化处理的地理空间数据文件：Joubin L、Guérin-Ganivet J（2009）.《法国海岸可食用贝类栖息地地图集》（Cartes des gisements de coquilles comestibles des côtes de France）. Ifremer. https://doi.org/10.12770/c502ed30-0d7d-11de-a4b1-000086f6a603