To explore the basics of Flask and GeoAlchemy2, we'll build a Flask web application and test and deploy it locally using the included web server. This web application allows the user to find the county, state, and congressional district associated with different arena's located throughout the country. This application will involve downloading shapefiles from a United States Geological Survey (USGS) data catalog and will have views (Python functions that process web requests) performing geospatial queries using the GeoAlchemy2 ORM and table relationship searches using the SQLAlchemy ORM.

This application requires the use of two scripts that create the database and database tables. These scripts are detailed as we proceed further and are in the Chapter11 folder of the book's code package. The final product will be a web application that uses a Leaflet JavaScript map to display the results of ORM-based spatial queries and a relationship query.