OSGeo (Open Source Geospatial Foundation)

Mentors: Student: Mohit242-bit

This project implements pgr_makeBiconnectedPlanar and pgr_makeMaximalPlanar as new pgRouting SQL functions, completing the planar graph preparation. Together they unlock downstream Boost layout algorithms currently inaccessible to pgRouting users. Stretch goal: pgr_findOddCycle. Estimated 350 hours.

Mentors: Student: Kinshuk Sanand

This project adds proper role-based access control to istSOS4 by making the web administration interface reflect the permissions already enforced in PostgreSQL through Row-Level Security (RLS). Right now, the backend enforces access correctly, but the UI does not — every user sees the same controls. This project fixes that. Each role (administrator, editor, viewer, sensor) will only see the pages and actions they are allowed to use. It also simplifies user and policy management by removing the current two-step workflow. Creating or updating a user will automatically apply the appropriate policies, reducing configuration mistakes and making the system easier to operate. To support real deployments, the project adds basic observability and debugging tools. A permission matrix shows what each role can do, and audit logs record access-related events. In addition, small utilities like permission explanation, access simulation, and change impact preview help admins understand and verify changes before applying them. The project also explores integration with external authentication providers (OIDC) so istSOS4 can work with single sign-on setups, including Grafana, without changing how permissions are enforced. Overall, the focus is to make permissions visible, predictable, and manageable for administrators.

Mentors: Student: Bhudev Bhanpuriya

The istSOS backend already provides strong support for time-travel queries and versioned data through parameters like as_of and from_to. However, these capabilities are currently only accessible through manual API usage, which makes them difficult to use for most users. This project focuses on bringing these features into the web administration UI by building an intuitive and accessible interface for exploring historical data. Users will be able to select a specific timestamp or time range, view the exact past state of entities such as Things, Sensors, and Datastreams, and understand how data evolved over time without writing API queries. The approach is to design lightweight frontend components that map user input to existing backend parameters, keeping the backend unchanged while making the feature usable. In addition, a Commit History Viewer will be implemented to allow users to browse changes, view metadata like author and timestamp, and load past snapshots directly into the UI. By the end of the project, istSOS will have: - Time selection controls integrated into the UI (instant and range) - Historical views for all major entities - A commit history explorer for tracking data changes - A clean query mapping layer between UI and API - Proper testing and documentation for long-term maintainability Overall, the goal is to make time-travel functionality a first-class feature in istSOS, improving transparency, usability, and accessibility for both technical and non-technical users.

Mentors: Student: Mayur Galhate

This project intends to implement a Maximum Weighted Matching algorithm for pgRouting within the OSGeo ecosystem, enabling efficient graph-based optimization for spatial networks. Maximum weighted matching is a fundamental problem that identifies a set of non-overlapping edges with maximum total weight, widely applicable in logistics, vehicle assignment, and supply-demand matching. The implementation will include development of a pgr_maximumWeightedMatching() function with a SQL interface and a high-performance C++ backend leveraging Boost Graph Library or optimized custom routines, integrated seamlessly with existing pgRouting structures. The project will also provide support for weighted graphs, comprehensive documentation, unit testing using pgTap, and performance benchmarking on large-scale and real-world datasets. This addition will enhance pgRouting’s analytical capabilities by introducing advanced matching functionality for transportation and network optimization while adhering to project coding standards.

Mentors: Student: Vishmayraj

A fundamental gap in the OGC SensorThings API ecosystem is addressed by this project: istSOS4 can serve rich sensor data, but it is difficult to find that data outside of its own API. This project aims to create a lightweight metadata connector that extracts data from istSOS4, transforms it into DCAT-AP 3.0 and SpatioTemporal Asset Catalog(STAC) formats, and exposes it through simple REST endpoints (/stac, /dcat). As a result, istSOS4 deployments are searchable, interoperable, and simple to integrate with contemporary data platforms and geospatial tools thanks to a plug-and-play service.