Johan RenaudieNov 22, 2023
A message to the Neptune database users: the website and the database server are not currently accessible. An alternate access is available though as (versioned) backups of the database are now available on Zenodo (http://doi.org/10.5281/zenodo.8238613). (1/4)
Archive of Neptune (NSB) database backups

This is the state of the Neptune (NSB) database (http://nsb.mfn-berlin.de) as of 2023-06-05 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

Zenodo
Show threadJohan RenaudieNov 22, 2023
The raw backup, a sqlite version (easier to work with without a server), and occurrences and age models tables are available for each version. Additionally, thanks to Adam Kocsis and Nussaibah Raja chronosphere package, one can access those backups directly from R! (2/4)
Show threadJohan Renaudie
chronosphere works well with our package NSBcompanion too. Once both packages are installed and loaded, just: `nsb <- chronosphere::fetch("neptune")` to open a connection that can be used by NSBcompanion (3/4)
Nov 22, 2023 at 2:03pmWeb
Show threadJohan RenaudieNov 22, 2023
then `getNeptuneData(nsb, fossil_group="R", age_range=c(0,1), ocean="ANT",resolve_syn=TRUE)` to download all antarctic radiolarians from the last Myr for instance or `findAge(nsb, "113_689B", depth_mbsf=c(0,10,100))` to get sample ages (4/4)