9. Interactive Data Visualization

9.1. Introduction

9.2. Learning Objectives

9.3. Sample Datasets

9.4. Installation and Setup

9.5. Downloading Sample Data

9.6. Connecting to DuckDB and Loading Extensions

9.6.1. Installing and Loading the Spatial Extension

9.6.2. Exploring the Database Contents

9.7. Visualizing Point Data

9.7.1. Querying and Converting Point Data

9.7.2. Transforming to GeoDataFrame with CRS Conversion

9.7.3. Creating a Basic Point Map

9.7.4. Customizing Point Symbology

9.8. Visualizing Line Data

9.8.1. Querying and Converting Line Data

9.8.2. Transforming Streets to GeoDataFrame

9.8.3. Creating a Basic Line Map

9.8.4. Customizing Line Symbology

9.9. Visualizing Polygon Data

9.9.1. Querying and Converting Polygon Data

9.9.2. Transforming Census Blocks to GeoDataFrame

9.9.3. Creating a Basic Polygon Map

9.9.4. Customizing Polygon Symbology

9.9.5. Creating Choropleth Maps

9.9.6. Creating 3D Extrusion Maps

9.10. Key Takeaways

9.11. Exercises

9.11.1. Exercise 1: Basic Point Visualization

9.11.2. Exercise 2: Attribute-Based Filtering and Visualization

9.11.3. Exercise 3: Line Network Visualization

9.11.4. Exercise 4: Basic Polygon Visualization

9.11.5. Exercise 5: Choropleth Mapping

9.11.6. Exercise 6: Custom Choropleth Color Schemes

9.11.7. Exercise 7: 3D Extrusion Visualization

9.11.8. Exercise 8: Multi-Layer Visualization

9.11.9. Exercise 9: Spatial Query Visualization

9.11.10. Exercise 10: Custom Analysis and Visualization Pipeline