Nature Inventory Delta
A project for the Canton of Basel-Stadt. It’s still in its very early stages, and paused for now: the databases that justify it aren’t available yet.
The idea behind this is simple: to help the team at the Canton of Basel-Stadt query the nature inventory database more easily. The inventory exists in different versions, so the tool compares two of them and shows how species and nature objects differ, with maps and charts next to the numbers.
You can ask it questions in German. A ReAct-style agent answers: it plans in JSON, picks one of 29 tools, runs it against a read-only database, and reads what came back before deciding on the next step. The database is opened read-only, and any SQL has to pass a guard that only allows certain views and tables and blocks everything that could change data. The language model is optional. Without one, a simple built-in planner (meant for testing) takes over, and with one it can be a hosted model such as DeepSeek or a local one through Ollama. With a hosted model, the question and the sample rows the tools return are sent to that provider.
The catch is the data. The tool needs a prepared database that compares the two versions, and that database isn’t included and isn’t available to me yet. The public geodata behind it can be ordered from the Basel-Stadt Geodaten-Shop or looked at in MapBS. Without the real database there is nothing to query, so it doesn’t really work yet, and that’s why the project is paused. The code and tests are in the repository, and the showcase shows the idea on made-up sample data.