PostGIS Day 2024

I will present a comparison of PgRouting with other open-source routing alternatives, outlining their respective pros and cons. I will also provide guidance on how to select the best solution for your project's specific needs.. Attendees will gain valuable insights into the strengths and weaknesses of various routing options, enabling them to make informed decisions for their own applications. https://medium.com/@ibrahimsaricicek/routing-alternatives-with-custom-spatial-data-dbb2a9175ef2

This talk will cover the details of a survey of Danish municipalities where each was asked about their use of FOSS4G software. I will specifically discuss how PostgreSQL/PostGIS and QGIS are generally used and how widespread their use is. The results will be shown via maps and charts.

“Can I use PostGIS from my ArcGIS software?” “Is PostGIS compatible with ArcGIS solutions?” This talk will dive into the use of PostGIS in the world of ArcGIS. We will discuss two main integration options: (1) registering PostGIS tables as read-only layers in ArcGIS, and (2) creating an Esri Enterprise Geodatabase in PostGIS. Each option has unique limitations that we will take a look at. By the end, you’ll have a better understanding of the compatibility between PostGIS and ArcGIS, and their possibilities and limitations.

Combine the multicore speed of the Go programming language with the power of PostGIS. In this talk we'll show how the two effortlessly combine to help you solve problems faster.

Cities are intricate systems hosting diverse elements—people, infrastructure, natural resource capital, and sustainability—interacting in complex ways. This talk explores the intersection of systems thinking, SQL, and geospatial analysis as powerful tools for understanding and managing urban environments. Systems thinking provides a holistic approach to analyzing cities, recognizing patterns and interdependencies between various components and the feedback loops that drive urban dynamics. SQL, with its robust capabilities for organizing, querying, and managing data, serves as a critical framework for processing the vast amounts of information-- not unlike a social metabolism generated by cities. When combined with geospatial analysis adding spatial dimension to data, SQL becomes even more powerful. By the end of the talk, attendees will have a deeper understanding of how to leverage systems thinking and data-driven methodologies to envision smarter, more resilient cities.

This presentation will cover the history of SFCGAL, its integration into PostGIS, and how it complements the spatial processing capabilities of PostGIS. We will compare SFCGAL with GEOS, discussing key similarities and differences. Through practical examples in areas like mining and urban planning, as well as some lighter use cases, we’ll illustrate how SFCGAL is used in real-world scenarios. The talk will also touch on future developments and potential enhancements in SFCGAL, offering a glimpse of what lies ahead for d-D spatial data management in PostGIS.

SF spatial objects work great for a lot of applications and from time to time we found new use cases, also uses where we can notice we need extra tools or a new API to be able to take advantage of it. In this talk we will cover Topology, a special case where geometries do not exist only on their own, like Country divisions, where one edge represents the division between them, where also each Country is constructed by States, and each State can be constructed by smaller geometries. Lets use Postgis Topology to create and represent this type of geometries, be able to have valid geometries, organize the hierarchy and work with them safely, is even more useful when working with sensitive data.

Many complex data types cannot be efficiently indexed using the existing PostgreSQL indices, due to the fact that indexing frameworks represent a tuple as a single index entry. The only exception, GIN, is restricted to indexing 1-dimensional data. In this talk, we present MGiST and MSP-GiST, multi-entry counterparts of the well-known GiST and SP-GiST frameworks. Through the use of an additional external method, each tuple can be split into multiple index entries before indexing. This allows the index to hold a more accurate representation of the indexed tuples. Examples of data types that can make use of this are: multi-ranges, geometry collections (multi-points, multi-polygons), line strings, time-series, spatio-temporal trajectories and more. MGiST and MSP-GiST are implemented as PostgreSQL extensions and we detail their use for indexing complex geometries in PostGIS.

In this talk, I share my experience using PostGIS to build a custom routing solution for the "Find My Classroom" application, a project that required flexibility and fine-tuned control over spatial data. While tools like pgRouting provide out-of-the-box functionality, I discovered that using PostGIS to manage my own graph data structure allowed for greater flexibility and adaptability. I will walk through how PostGIS efficiently handled the spatial aspects of the application, from storing and querying geographic data and a spatial graph of over half a million nodes and edges to finding the nearest nodes to user inputs using spatial indexes. This includes implementing a custom routing algorithm like Dijkstra's or A*, while leveraging GiST indexing and understanding the role of underlying data structures like R-trees for fast spatial queries.

Overture Maps offers free and open global map data, continuously updated and released monthly as GeoParquet files. In this session, we'll give an overview of Overture's schema and six data themes: addresses, base, buildings, divisions, places, and transportation. We'll also share examples and workflows that are particularly relevant to the PostGIS community.

The Postgres ecosystem contains a number of extensions and tools to analyzing and reporting on data. Notably, CARB, the California Air Resources Board, provides PostGIS table data for reporting and verifying fleet compliance. We'll cover how we report to CARB, and how we use other Postgres features and techniques to make fleet reporting and alerting simple and effective.

Geoparquet and parquet files in cloud object stores like s3 now house huge lakes of data. I'll go over Geoparquet from the ground up covering what it is, how it is different from Parquet, and how analysis is being done at scale on Geoparquet. We'll also briefly cover Crunchy Bridge for Analytics, a query engine that fuses Postgres and DuckDB for fast, vectorized analytics.

In PostGIS Day 2023, PostGIS and friends demonstrated how to broadcast critical messages using a custom built imagery alphabet among other tidbits of spatial magic. What more can this cast of characters do? Come watch and leave awestruck.

This talk will cover the open source FastCollections API which allows you to view/query/update geo-spatial data within a PostgreSQL database. FastCollections contains over 20 different endpoints which allows a consumer to view collections as geojson or vector tiles, perform statistical analysis, and download data in multiple formats for consumption within other tools. FastCollection is also OGC compliant which allows it to be consumed in applications like QGIS, ArcPro, ArcGIS Online, etc...

The request was simple: recreate an old street map for the City of Yorkville with an alphanumeric street index (A-1, B-2, etc). The challenge: can we do this without creating any new layers? Can we do it entirely with OpenStreetMap Data from our PostGIS database? Of course! In this talk, we'll go through the query we wrote up to handle the situation.

Pg_featureserv and pg_tileserv are lightweight Go applications for getting your spatial data into web apps. This will be an introductory talk on how to set up these tools, use the sample code, and build your own spatial web maps.

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.

Discover how to supercharge your PostGIS workflows and create cutting-edge spatial applications with unprecedented speed and efficiency. Join us as we demonstrate how Felt's innovative tools seamlessly integrate with your existing PostGIS infrastructure, allowing you to build powerful spatial dashboards and applications in minutes.

H3 is a hierarchical hexagonal grid system created by Uber. It offers some advantages for data aggregation, analysis and visualization. The h3-pg extension makes it easy to use H3 in conjunction with PostGIS data. This talk shows how to use the h3-pg API along with pg_tileserv to provide dynamic and performant data visualization with H3 hexagons as vector tiles. It also presents how to develop a simple web map client for data visualization and querying.

This presentation will explain a geospatial frame data (GFD) model to simplify the map compilation and data integration of polygonal features, using bedrock geology as an example. PostGIS facilitates the implementation of the GFD model in managing geospatial data at different stages of its lifecycle, including the separation of observations from map products, polygonal map integration without edge matching, and the elimination of common topological errors in polygonal coverages.

This talk will give you a quick introduction to what machine learning folks mean when they use the term "vectors". From there it will be a demo of combining pg_vector with PostGIS. We are going to do an image similarity search and constrain it by geography. Come see what all the hubbub is about with this new AI vector thing.

Paul wraps up PostGIS Day with the history of spatial data and maybe where we’re headed in the future.