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
2019-03-19
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 [...]
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 from researchers in sustainability science to government employees involved in national emergency planning.
Click on title to download individual files attached to this item.
transformative_processes_input.zip “Comma-separated text files that show the process/subsystem hierarchy”
66.17 KB
application/zip
YSTAFDB_CSV_files.zip “The 38 tables in the YSTAFDB”
1,020.4 KB
application/zip
YSTAFDB_metadata.xml “Metadata file” Original FGDC Metadata
View
251.93 KB
application/fgdc+xml
ystafdb_mysql.zip “YSTAFDB in MySQL format”
1.29 MB
application/zip
ystafdb_postgresql.zip “YSTAFDB in PostgreSQL format”
1.35 MB
application/zip
YSTAFDB_structure.jpg “Figure showing the representative table structure and relations in YSTAFDB”
267.56 KB
image/jpeg
Related External Resources
Type: Citation
Myers, R.J., Fishman, T., Reck, B.K., and Graedel, T.E., 2018, Unified Materials Information System (UMIS) - An integrated material stocks and flows data structure: Journal of Industrial Ecology, 19 p., https://doi.org/10.1111/jiec.12730.
Myers, R.J., Reck, B.K., and Graedel, T.E., 2019, YSTAFDB, a unified database of material stocks and flows for sustainability science: Scientific Data 6, article 84, 13 p., https://doi.org/10.1038/s41597-019-0085-7.
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/.
Preview Image
Figure showing the representative table structure and relations in YSTAFDB