The dataset of the Global Collections survey of natural history collections

From 2016 to 2018, we surveyed the world’s largest natural history museum collections to begin mapping this globally distributed scientific infrastructure. The resulting dataset includes 73 institutions across the globe. It has: Basic institution data for the 73 contributing institutions, including estimated total collection sizes, geographic locations (to the city) and latitude/longitude, and Research Organization Registry (ROR) identifiers where available. Resourcing information, covering the numbers of research, collections and volunteer staff in each institution. Indicators of the presence and size of collections within each institution broken down into a grid of 19 collection disciplines and 16 geographic regions. Measures of the depth and breadth of individual researcher experience across the same disciplines and geographic regions. This dataset contains the data (raw and processed) collected for the survey, and specifications for the schema used to store the data. It includes: A diagram of the MySQL database schema. A SQL dump of the MySQL database schema, excluding the data. A SQL dump of the MySQL database schema with all data. This may be imported into an instance of MySQL Server to create a complete reconstruction of the database. Raw data from each database table in CSV format. A set of more human-readable views of the data in CSV format. These correspond to the database tables, but foreign keys are substituted for values from the linked tables to make the data easier to read and analyse. A text file containing the definitions of the size categories used in the collection_unit table. The global collections data may also be accessed at https://rebrand.ly/global-collections. This is a preliminary dashboard, constructed and published using Microsoft Power BI, that enables the exploration of the data through a set of visualisations and filters. The dashboard consists of three pages: <strong>Institutional profile:</strong> Enables the selection of a specific institution and provides summary information on the institution and its location, staffing, total collection size, collection breakdown and researcher expertise. <strong>Overall heatmap:</strong> Supports an interactive exploration of the global picture, including a heatmap of collection distribution across the discipline and geographic categories, and visualisations that demonstrate the relative breadth of collections across institutions and correlations between collection size and breadth. Various filters allow the focus to be refined to specific regions and collection sizes. <strong>Browse:</strong> Provides some alternative methods of filtering and visualising the global dataset to look at patterns in the distribution and size of different types of collections across the global view.2016年至2018年间，我们对全球规模最大的自然历史博物馆馆藏开展调研，以期绘制这一全球分布式科学基础设施的分布图谱。 本数据集共收录全球73家机构，包含以下内容： 1. 参与机构基础信息：涵盖73家机构的估算馆藏总规模、精确至城市的地理位置及经纬度，以及可获取的研究组织注册表（Research Organization Registry, ROR）标识符； 2. 资源配置信息：统计各机构的研究人员、馆藏管理人员及志愿者人数； 3. 馆藏表征指标：按照由19个馆藏学科与16个地理区域组成的分类网格，记录各机构内馆藏的存在情况与规模； 4. 研究者经验表征指标：针对上述学科与地理区域，量化各机构研究者经验的深度与广度。 本数据集包含调研收集的原始与处理后数据，以及数据存储的模式规范，具体包括： - MySQL数据库模式示意图； - 不含数据的MySQL数据库模式SQL转储文件； - 包含完整数据的MySQL数据库模式SQL转储文件，可导入MySQL Server实例以完整重建该数据库； - 各数据库表的CSV格式原始数据； - 一组可读性更强的CSV格式数据视图：其结构对应数据库表，但外键已替换为关联表中的实际取值，便于数据读取与分析； - 一个文本文件，内含collection_unit表中使用的馆藏规模类别定义。 全球馆藏数据还可通过链接https://rebrand.ly/global-collections 访问。该页面为基于Microsoft Power BI构建并发布的初步可视化仪表盘，支持通过多种可视化与筛选功能探索数据集。仪表盘包含三个页面： **机构概览**：支持选择特定机构，展示该机构的概况、地理位置、人员配置、馆藏总规模、馆藏分类及研究者专长等摘要信息； **全局热力图**：支持交互式探索全球馆藏分布，包括跨学科与地理类别的馆藏分布热力图，以及展示各机构馆藏相对广度、馆藏规模与广度间相关性的可视化内容。多种筛选功能可将聚焦范围细化至特定区域与馆藏规模区间； **浏览模式**：提供多种替代筛选与可视化方式，用于探索全球数据集内不同类型馆藏的分布与规模特征。