Archive of Neptune (NSB) database backups

This is the state of the Neptune (NSB) database (http://nsb.mfn-berlin.de) as of 2021-06-29 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于2021年6月29日归档的海王星（Neptune，简称NSB）数据库（http://nsb.mfn-berlin.de）截至当日的完整状态。 该数据库提供原生PostgreSQL备份文件（nsb_postgresql.zip）；为便于使用，同时提供SQLite格式版本（nsb_sqlite.zip）。由于后者（即SQLite格式版本）未保留外键约束，如需还原表间关联关系，请参考Renaudie等人2020年的研究文献。 反规范化数据表（Denormalized tables）已打包至denormalized_table.zip文件中： occurrences.csv 收录了NSB数据库中全部未经过滤的微古生物化石产出记录。 filtered_occurrences.csv 则是该网站更为典型的输出结果，即已剔除可能经过再改造的标本、开放命名分类群（open nomenclature taxa）以及存疑鉴定结果的数据集。 agemodels.csv 最后收录了带有元数据的年代模型，其以一系列年代锚点（tiepoints）的形式存储。