BioTIME
收藏资源简介：
The BioTIME database contains raw data on species identities and abundances in ecological assemblages through time. The database consists of 11 tables; one raw data table plus ten related meta data tables. For further information please see our associated data paper. This data consists of several elements: BioTIMESQL_24_06_2021.sql - an SQL file for the full public version of BioTIME which can be imported into any mySQL database. BioTIMEQuery_24_06_2021.csv - data file, although too large to view in Excel, this can be read into several software applications such as R or various database packages. BioTIMEMetadata_24_06_2021.csv - file containing the meta data for all studies. BioTIMECitations_24_06_2021.csv - file containing the citation list for all studies. BioTIMECitations_24_06_2021.xlsx - file containing the citation list for all studies (some special characters are not supported in the csv format). BioTIMEInteractions_02_04_2018.Rmd - an r markdown page providing a brief overview of how to interact with the database and associated .csv files (this will not work until field paths and database connections have been added/updated). Please note: any users of any of this material should cite the associated data paper in addition to the DOI listed here. To cite the data paper use the following: Dornelas M, Antão LH, Moyes F, Bates, AE, Magurran, AE, et al. BioTIME: A database of biodiversity time series for the Anthropocene. <em>Global Ecol Biogeogr.</em> 2018; 27:760 - 786. https://doi.org/10.1111/geb.12729
BioTIME数据库（BioTIME database）收录了随时间序列变化的生态群落内物种身份与物种多度的原始观测数据。该数据库共包含11张数据表，其中1张为原始数据主表，其余10张为配套元数据表（meta data tables）。如需了解更多详细信息，请参阅本数据库配套的学术数据论文。 本数据集包含以下文件组件： 1. `BioTIMESQL_24_06_2021.sql`：适用于完整公开版BioTIME的SQL脚本文件，可直接导入任意MySQL数据库中使用。 2. `BioTIMEQuery_24_06_2021.csv`：核心数据文件，因体积过大无法在Excel软件中直接查看，但可被R语言及多款数据库工具包读取解析。 3. `BioTIMEMetadata_24_06_2021.csv`：收录所有纳入研究的元数据文件。 4. `BioTIMECitations_24_06_2021.csv`：收录所有纳入研究的参考文献列表文件。 5. `BioTIMECitations_24_06_2021.xlsx`：收录所有纳入研究的参考文献列表文件（CSV格式无法兼容部分特殊字符，因此提供Excel版本）。 6. `BioTIMEInteractions_02_04_2018.Rmd`：R Markdown文档，简要介绍如何与本数据库及配套CSV文件进行交互操作（需补充或更新字段路径与数据库连接配置后方可正常运行）。 请注意：任何使用本数据集相关材料的用户，除需引用本文档中提及的数字对象标识符（DOI）外，还需同时引用本配套数据论文。该数据论文的标准引用格式如下： Dornelas M, Antão LH, Moyes F, Bates AE, Magurran AE, 等. BioTIME：适用于人类世的生物多样性时间序列数据库. *Global Ecol Biogeogr*. 2018; 27:760-786. https://doi.org/10.1111/geb.12729
