Skip to main content
USGS - science for a changing world

Yale stocks and flows database (YSTAFDB) describing anthropogenic materials cycles, recycling, and criticality for 102 materials on spatial scales ranging from suburbs to global and timescales from the early 1800s to circa 2013

Dates

Publication Date
Start Date
1845
End Date
2013

Citation

Myers, R.J., Reck, B.K., Hopple, J.A., Baker, M.S., Nassar, N.T., and Graedel, T.E., 2019, Yale stocks and flows database (YSTAFDB) describing anthropogenic materials cycles, recycling, and criticality for 102 materials on spatial scales ranging from suburbs to global and timescales from the early 1800s to circa 2013: U.S. Geological Survey data release, https://doi.org/10.5066/F7WH2NZ1.

Summary

This data release presents the Yale stocks and flows database (YSTAFDB). Its data describe the use of 102 materials from the early 1800s to circa 2013 through anthropogenic cycles, their recycling and criticality properties, and on spatial scales ranging from suburbs to global. This data collection was previously scattered across multiple non-uniformly formatted files such as journal papers, reports, and unpublished spreadsheets. These data have been synthesized into YSTAFDB, which is presented as individual comma-separated text files and also in MySQL and PostgreSQL database formats. Consolidation of these data into a single database can increase their accessibility and reusability, which is relevant to diverse stakeholders ranging [...]

Contacts

Attached Files

Click on title to download individual files attached to this item.

ystafdb_mysql.zip
“YSTAFDB in MySQL format”
1.29 MB
ystafdb_postgresql.zip
“YSTAFDB in PostgreSQL format”
1.35 MB
YSTAFDB_CSV_files.zip
“The 38 tables in the YSTAFDB”
1,020.4 KB
transformative_processes_input.zip
“Comma-separated text files that show the process/subsystem hierarchy”
66.17 KB
YSTAFDB_structure.jpg
“Figure showing the representative table structure and relationships in YSTAFDB”
thumbnail 267.56 KB
YSTAFDB_metadata.xml
“Metadata file”
Original FGDC Metadata

View
251.84 KB

Purpose

The purpose of the Yale stocks and flows database (YSTAFDB) is to unify stocks and flows (STAF) data that were previously scattered across multiple non-uniformly formatted files into a single, consistently formatted database. By doing so, YSTAFDB facilitates higher availability of STAF data and thus deeper understanding of how materials may be more efficiently used.

Rights

This work is licensed under a Creative Commons Attribution 4.0 International (CC BY 4.0) License, which permits sharing and adapting of the material as long as you provide appropriate credit to the original authors, a link to the Creative Commons Licence, and a description of any changes made. Additional details regarding this CC BY 4.0 License can be found at: https://creativecommons.org/licenses/by/4.0/.
Figure showing the representative table structure and relationships in YSTAFDB
Figure showing the representative table structure and relationships in YSTAFDB

Map

Communities

  • National Minerals Information Center
  • USGS Data Release Products
  • USGS New Jersey Water Science Center 

Tags

Categories
Harvest Set
Theme
Place
USGS Scientific Topic Keyword

Provenance

Additional Information

Identifiers

Type Scheme Key
DOI https://www.sciencebase.gov/vocab/category/item/identifier doi:10.5066/F7WH2NZ1

Item Actions

View Item as ...

Save Item as ...

View Item...