top of page
Surface Soil Wetness in California Visualization with Time Series Analysis
Using the Surface Soil Wetness data from the NASA POWER data set we created a SQL database. This database was used to manage data and create Pandas DataFrames to make visualizations. Data was collected, cleaned, and prepared using SQL, Pandas and Geopandas. Streamlit was used to create an interactive and clear visual of the Surface Soil Wetness using folium to make a choropleth map. Applying the seasonal time series from the Stats Models package allowed us to see how the Soil Wetness changed over time and find trends in our data.
Below is a picture of the interactive map as well as the Entity Relationship Chart


bottom of page