11. Analyzing US National Wetlands Inventory#

11.1. Introduction#

11.2. Learning Objectives#

11.3. Datasets Used in This Chapter#

11.3.1. National Wetlands Inventory (NWI) Dataset#

11.3.2. US States Boundary Dataset#

11.3.3. Data Access and Format Advantages#

11.3.4. Understanding the Analysis Scale#

11.4. Understanding the Dataset Source#

11.4.1. Data Download from Source#

11.4.2. Data Conversion to GeoParquet#

11.5. Accessing Wetland Data with DuckDB#

11.5.1. Environment Setup and Extension Loading#

11.5.2. Querying a Single State’s Wetlands#

11.5.3. Inspecting the Data Schema#

11.5.4. Alternative Access Methods#

11.6. Visualizing Wetland Distributions#

11.6.1. Loading and Preparing State-Level Data#

11.6.2. Creating Thematic Visualizations by Wetland Type#

11.7. National-Scale Wetland Analysis#

11.7.1. Counting All Wetland Features Nationally#

11.7.2. Analyzing Wetlands by State#

11.7.3. Creating Tables for Spatial Joins#

11.7.4. Loading State Boundaries for Mapping#

11.7.5. Joining Wetland Statistics with State Geometries#

11.7.6. Preparing Data for Visualization#

11.7.7. Creating a Choropleth Map#

11.7.8. Statistical Visualizations#

11.7.9. Analyzing Wetland Area#

11.7.10. Classification by Wetland Type#

11.8. Key Takeaways#

11.9. Exercises#

11.9.1. Exercise 1: State-Level Wetland Analysis#

11.9.2. Exercise 2: Regional Wetland Comparisons#

11.9.3. Exercise 3: National Wetland Type Classification#

11.9.4. Exercise 4: Focused Regional Analysis#