--- title: PostGIS Day 2021 description: Crunchy Data is excited to host the 3rd annual PostGIS Day with the collaboration of several talented community members and friends! image: https://info.crunchydata.com/hubfs/PostGISDay2021OSocial-17.png --- # ![Logo-16](https://info.crunchydata.com/hs-fs/hubfs/Logo-16.png?width=846&name=Logo-16.png) # Virtual PostGIS Day 2021 Thursday, November 18, 2021   # Event Summary A [short summary](https://blog.crunchydata.com/blog/postgis-day-2021?hsLang=en) of the 2021 event is published on the Crunchy Data Blog. # Presentations & Links to Videos |   | | --- | | [Neuroscience in the database: Mapping the morphology of neurons and synapses with PostGIS](https://www.youtube.com/watch?v=u4nmyt3T_pY&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=2) Tom Kazimiers, kazmos GmbH | | [Working with maps in Django and GeoDjango: From Python to PostGIS](https://www.youtube.com/watch?v=k2Y_jBmyGVY&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=3) ### Paolo Melchiorre, 20tab | | [Delivering a National Level Vector Tile Basemap using PostGIS and pg\_tileserv: From Data production to Web Publishing](https://www.youtube.com/watch?v=JnVp3fa9OU8&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=4) Tom van Tilburg, Geodan | | [PostGIS and the Global Wildfire Information System](https://www.youtube.com/watch?v=AWpXE9t0d4s&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=5) Hans Pfeiffer, ikoone – Data and GeoScience Lab | | [Building a PostGIS Web Application with pg\_tileserv and pg\_featureserv](https://www.youtube.com/watch?v=PPou_7Oj-1U&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=6) Augustin Trancart, Oslandia | | [Data Quality Control and Validation with PostGIS at the Portuguese National Mapping Agency](https://www.youtube.com/watch?v=mp-jneQXD50&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=7) Jorge Rocha, Geomaster, Lda | | [Using PostGIS to Generate Real Time Descriptions of Landmarks and Their Position Relative to the User, for Wayfinding Without Maps](https://www.youtube.com/watch?v=409MRtjP1TI&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=8) Phil Bartie, Heriot-Watt University and William Mackaness, University of Edinburgh | | [No Middleware. Build Fast Geospatial APIs with PostGIS and a Scriptable Webserver](https://www.youtube.com/watch?v=HDnGbvZimLk&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=9) Brent Tucker, CPCS | | [Exploring the Many Extensions of PostGIS! PostGIS packages six different extensions and there are many others that further extend PostGIS, like pgrouting, mobilitydb and ogr\_fdw](https://www.youtube.com/watch?v=DvrktJ3Kvvw&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=10) Regina Obe, Paragon Corporation | | [Hurricane Prediction Accuracy Analysis Using the PRAM Stack](https://www.youtube.com/watch?v=I1fTZFWjNIw&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=11) Rhys Stewart, Auchindown | | [Food Inundation Estimates, At-Risk Facilities, and Automatic Analysis of Earthquake Impacts Using PostGIS in Ventura County](https://www.youtube.com/watch?v=pHqkc2JLpPs&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=12) Bruce Rindahl, Ventura County | | [PostGIS in Production at Denver Public Schools: Tying Together Systems to Support Better Planning](https://www.youtube.com/watch?v=30XpbaE7mVw&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=13) Matthew Baker, Denver Public Schools | | [How Did PostGIS Get Fast(er)? A Review of Performance Improvements Over the Recent Release Cycle and a Deep Dive Into Performance Programming](https://www.youtube.com/watch?v=XRq2_9YBziY&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=14) Paul Ramsey, Crunchy Data | | How Ford Leveraged PostGIS to Build a Scalable Cloud-Based Mapping Solution Ganesh Kumar, Ford Motor Company | | [Using PostGIS and Machine Learning to Predict Electricity Demand Growth from Electric Vehicles](https://www.youtube.com/watch?v=2XV07-Sq9A0&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=15) Silas Toms, Volta Charging | | [PostGIS Patterns and Pictures: Exploring Some Common PostGIS Analytical Use Cases and Spatial SQL with Attractive Outputs via SVG](https://www.youtube.com/watch?v=EwxukTXRmiM&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=16) Martin Davis, Crunchy Data | | [Generating a World-Wide Vector Tile Base Map from OpenStreetMap with PostGIS, the Story of OpenMapTiles](https://www.youtube.com/watch?v=uDT7C7Mg83s&list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm&index=17) Yuri Astrakhan, Elastic | # What's PostGIS Day? PostGIS Day is part of [Geography Awareness Week](https://www.nationalgeographic.org/education/programs/geography-awareness-week/) and serves to highlight the features and uses of the PostGIS spatial database as a part of the GIS ecosystem. PostGIS Day is observed the day after [GIS Day](https://www.gisday.com/), for obvious reasons. Spatial data is everywhere these days, and PostGIS is frequently used to manage that data. Logistics, precision agriculture, insurance, risk analysis and many more industries can or are working with spatial data. PostGIS Day is a chance to learn how others are making use of PostGIS, pick up some tips and tricks, and share our stories about bringing this excellent tool into our organizations.   ## Need More PostGIS now? ### [PostGIS Day Videos 2020](https://www.youtube.com/playlist?list=PLesw5jpZchufVkPcwGYpiiijThFcPNlz_) ### [PostGIS Day Videos 2019](https://www.youtube.com/playlist?list=PLesw5jpZchudjfkx3vggVmJAOSBH7m4nj) ### [Crunchy Data PostGIS Blogs](https://blog.crunchydata.com/blog/topic/postgis?hsLang=en)   [![Crunchy Data Solutions logo](https://info.crunchydata.com/hubfs/2021_crunchy_footer_reverse_white.svg)](https://www.crunchydata.com) - - - - - [Privacy Policy](https://www.crunchydata.com/privacy/) - © 2018-2022 Crunchy Data Solutions, Inc. ###### Products - [Crunchy Bridge](https://www.crunchydata.com/products/crunchy-bridge/) - [Crunchy PostgreSQL for Kubernetes](https://www.crunchydata.com/products/crunchy-postgresql-for-kubernetes/) - [Crunchy High Availability PostgreSQL](https://www.crunchydata.com/products/crunchy-high-availability-postgresql/) - [Crunchy Certified PostgreSQL](https://www.crunchydata.com/products/crunchy-certified-postgresql/) - [Crunchy PostgreSQL for Cloud Foundry](https://www.crunchydata.com/products/crunchy-postgresql-for-cloud-foundry/) - [Crunchy MLS PostgreSQL](https://www.crunchydata.com/products/crunchy-mls-postgresql/) - [Crunchy Spatial](https://www.crunchydata.com/products/crunchy-spatial/) ###### Services & Support - [Enterprise PostgreSQL Support](https://www.crunchydata.com/solutions/enterprise-postgresql-support/) - [Red Hat Partner](https://www.crunchydata.com/red-hat-certified-technologies/) - [Trusted PostgreSQL](https://www.crunchydata.com/about/postgresql-enterprise-database/) - [Crunchy Data Subscription](https://www.crunchydata.com/about/value-of-subscription/) ###### Resources - [Customer Portal](https://access.crunchydata.com) - [Software Documentation](https://access.crunchydata.com/documentation/) - [Blog](https://blog.crunchydata.com?hsLang=en) - [Events](https://www.crunchydata.com/events/) - [Videos](https://www.crunchydata.com/videos/) - [DISA STIG for PostgreSQL](https://www.crunchydata.com/files/stig/PGSQL-STIG-9.5+.pdf) - [CIS Benchmark for PostgreSQL](https://www.cisecurity.org/benchmark/postgresql/) ###### Company - [About Crunchy Data](https://www.crunchydata.com/about/) - [News](https://blog.crunchydata.com/news?hsLang=en) - [Careers](https://www.crunchydata.com/careers/) - [Contact Us](https://www.crunchydata.com/contact/) - [Newsletter](https://www.crunchydata.com/newsletter/)