PostgreSQL / PostGIS to ROS 2 Bridge for Spatial Data

Description

PostGIS is a widely used PostgreSQL extension to store, manipulate, and manage spatial data. We present our PostGIS to ROS 2 bridge, enabling the convenient use of spatial data stored in a PostgreSQL database in the ROS world. The bridge is configurable with custom SQL queries to fetch data and publishes it as a ROS message (e.g., Marker, Point, Polygon, etc.). We show a demo use case where we visualize orthophoto data (satellite or own geoserver), semantic elements from a PostGIS database (powerlines, POIs, areas, etc.), and live data like odometry in a gravel quarry using rviz2 and Foxglove Studio.

Period	20 Oct 2023
Event title	ROSCon 2023
Event type	Conference
Conference number	2023
Location	New Orleans, United States, LouisianaShow on map
Degree of Recognition	International