Archive of Neptune (NSB) database backups
收藏资源简介:
This is the state of the Neptune (NSB) database (http://nsb.mfn-berlin.de) as of 2016-10-31 archived by Johan Renaudie.. The database is given as a native PostgreSQL backup (nsb_postgresql.zip) and is also provided here in SQLite for convenience (nsb_sqlite.zip). As the foreign keys are not preserved in the latter, please check Renaudie et al. 2020 to find back the table relations. Denormalized tables are also provided in file denormalized_table.zip: occurrences.csv contains the full unfiltered micropaleontological occurrences recorded in NSB. filtered_occurrences.csv represent a more typical output from the website, i. e. with possibly reworked specimens, open nomenclature taxa and questionable identifications filtered out. agemodels.csv finally contains the age models (as a serie of tiepoints) with their metadata
本数据集为约翰·勒诺迪(Johan Renaudie)于2016年10月31日归档的海王星(Neptune,NSB)数据库(http://nsb.mfn-berlin.de)的当前状态。 该数据库以原生PostgreSQL备份文件(nsb_postgresql.zip)形式提供,同时为便于使用,同步提供了SQLite版本(nsb_sqlite.zip)。由于SQLite版本未保留外键(foreign key)约束,请参考Renaudie等人2020年的研究以恢复各表间的关联关系。 非规范化数据表同样打包于denormalized_table.zip压缩包中: 1. occurrences.csv 收录了NSB数据库中全部未经过滤的微古生物出现记录; 2. filtered_occurrences.csv 为该网站更具代表性的输出结果,即已剔除可能存在再沉积的标本、开放命名(open nomenclature)分类单元以及存疑鉴定结果的数据; 3. agemodels.csv 最终收录了年代模型(age models,以一系列锚点(tiepoints)序列形式)及其元数据(metadata)。



