Archive of Neptune (NSB) database backups
收藏资源简介:
This is the state of the Neptune (NSB) database (http://nsb.mfn-berlin.de) as of 2021-08-30 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
本数据集为截至2021年8月30日的海王星(Neptune,NSB)数据库(访问链接:http://nsb.mfn-berlin.de)的存档版本,由Johan Renaudie归档。该数据库以原生PostgreSQL备份文件(nsb_postgresql.zip)形式提供;同时为便于使用,本次同步提供SQLite格式的备份文件(nsb_sqlite.zip)。由于该SQLite版本未保留外键(foreign keys)关系,请参考Renaudie等2020年的研究以获取表间关联规则。非规范化表(Denormalized tables)亦通过denormalized_table.zip文件打包提供:occurrences.csv文件收录了NSB数据库中记录的全部未经过滤的微古生物出现记录(micropaleontological occurrences)。filtered_occurrences.csv文件则呈现了该网站更为典型的输出结果,即已剔除可能存在的再沉积标本、开放命名法(open nomenclature)分类群(taxa)以及存疑鉴定结果的数据集。agemodels.csv文件最终收录了年代模型(age models,以一系列年代锚点序列形式呈现)及其对应的元数据(metadata)。



