Simplify, simplify, simplify! with Brian Timoney

When 19th century American mystic Henry Thoreau exclaimed "Our life is frittered away by detail. Simplify, simplify, simplify! ", you better believe he was urging you to reconsider your 2024 web mapping stack. Since the dominant use case for your web maps continues to be "user does a screen capture and jams it into a PowerPoint"--it is time to reconsider your approach. Let's give the people what they want, but using just SQL! This presentation will demonstrate using pg_svg library to create a variety of choropleth maps as SVG files that can be viewed in any browser and just as importantly be imported into presentations as native shapes. As a bonus we'll demonstrate easy integration with an open-source charting engine outputting SVG using Postgres JSON functions + pgsql-http. Similar to my presentation last year, we will conquer the last-mile delivery challenge by using pg_featureserv so the end-user can navigate everything through their favorite BI tool: Microsoft Excel.