We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Marion Baumgartner: PostGIS and pgRouting: Extensions for spatial data in PostgreSQL (PGConf.EU 23)
Explore the power of spatial data with PostGIS and pgRouting, extensions for PostgreSQL, and discover how they can be used to find the shortest path, optimize routes, and more.
- PostGIS can be considered a spatial database or used as a spatial database, providing functionality like finding the shortest path.
- PG Roting answers questions like finding the shortest path between two points on a graph, taking into account different costs and restrictions.
- PG Roting can be used for emergencies, where the algorithm can be adjusted to prioritize faster routes.
-
The
st_simplifyfunction can simplify geometries to reduce the number of points used to represent it. - PG Roting uses a library of functions, including the Dijkstra and A* algorithms, to find the shortest path.
- PG Roting can be used to find the driving distance between two points, taking into account the edges of a graph.
- Indexing is an important concept in PG Roting, as it can speed up queries.
- PG Roting can be used to extract data from OpenStreetMap.
- PG Roting has a wide range of use cases, including finding the shortest path between multiple points.
-
The
stfunctions in PostGIS provide various spatial functions, includingst_withinandst_simplify. - PG Roting can be used to optimize queries, such as finding the shortest path between two points.
- PG Roting can be used to solve the traveling salesman problem.
- PG Roting has tools to analyze the results of a query, making it easier to understand the output.
- The performance of PG Roting can be optimized by adding indexes and using the correct algorithms.
- PG Roting can be used to find the shortest path between two points on a graph, taking into account the edges of a graph.
-
The
PG Routingextension brings the ability to perform routing within the Postgres database.