SUPPLEMENTAL MATERIAL
IMPORTANT: This page will be updated regularly to include new suplemental material.
Databases
- Introduction to PostgreSQL Tutorial: Video tutorial in three parts: Part 1 | Part 2 |Part 3.
- Entity Relatioship Diagram (ERD) tutorial
- Python and PostgreSQL tutorial
- Structured Query Language (SQL) tutorial by W3Schools
- PostgresSQL tutorial by W3Schools
- pgAdmin 4 Tutorial [Video]
- Online Book: Database Systems, 4th Edition by Thomas M. Connolly & Carolyn E. Begg
Python and Data Science
Maps and Visualizations
- How to Create And Customize Google Maps
- JavaScript Libraries to Create Interactive and Customized Maps
Datasets
- Climate Data API: World Bank's climate data repository (with informatation about third party apps that have utilize this APIs).
- IRI Data Library: The IRI Data Library is a powerful and freely accessible online data repository and analysis tool that allows a user to view, analyze, and download hundreds of terabytes of climate-related data through a standard web browser.
- USGS Data Catalog: The USGS Science Data Catalog provides seamless access to USGS research and monitoring data from across the United States. Data about Atmosphere and Climate, Earth Characteristics, Geographic Analysis and Maps, Natural Hazards, and more can be found there. Check their catalog of topics for more.
-
NOAA National Climate Data Center: NOAA's National Centers for Environmental Information (NCEI) is responsible for preserving, monitoring, assessing, and providing public access to the Nation's treasure of climate and historical weather data and information.
- Climate Data Online: Web Services Documentation
- NASA Earth Science Data: Variety of datasets from wildfires data to tropical cyclones, and much more.
Git and GitHub
- Git and GitHub Tutorial: New to Git? Follow this link for an intro to Git and GitHub for beginners.
- Github Pages: Websites for you and your projects. Hosted directly from your GitHub repository. Just edit, push, and your changes are live.
- GitHub Learning Lab
- GitHub Guides, for everything GitHub
Books
- An Introduction to Erth and Evironmental Data Science By Ryan Abernathey. This book grew out of a course developed at Columbia University called Research Computing in Earth Science. It was written mostly by Ryan Abernathey, with significant contributions from Kerry Key and Tim Crone. By separating the book from the class, we hope to create an open-source community resource for Python education in the Earth and Environmental Sciences.