Use LinkedDataGPT to query Open Linked Data from the City of Zurich

  • Christian Stocker

We've launched LinkedDataGPT, a tool leveraging AI to simplify querying the City of Zurich's linked data. Still in its early stages, this tool provides a user-friendly access to specific datasets.

Learn more about our Custom Development and Open Data services.

After the success of ZĂŒriCityGPT, we've made improvements, incorporating more content, tried out different approaches and showcasing demos for other governments and clients. We still update the data frequently, and we hope you find it still beneficial. If you haven't had a chance, do check it out.

A notable observation was the frequent questions about data that ZĂŒriCityGPT couldn't answer unless explicitly mentioned on the site. A common one: "How many people work for the administration of the City of Zurich?" To be honest, we're still wondering! (And we still can't with this new approach ...)

Nevertheless, the City of Zurich has embraced an open data strategy, generously providing access to Linked Data at However, to tap into this data, one must be proficient with SPARQL, and also be precise about the query parameters. And SPARQL can be challenging at first.

But, what if there was a simpler way? With OpenAI’s chat API and turning a natural question into a SPARQL query for you. Enter LinkedDataGPT. Pose a question about the available data, and, fingers crossed, get an answer.

Of course, it's still in its early stages. While it's optimised for individual cube/dataset queries, the broader purpose of linked data – to enable queries across different datasets – is still a work in progress. That said, for more complicated queries, you can easily copy the generated query and tweak it on according to your specific requirements. We're keen on enhancing its capabilities and would be glad to do so if we see a demand.

Knowing the data you're querying is essential, as is phrasing the question right. Browse the available data on LinkedDataGPT or use one of the example questions below to start with. Occasionally, you might need to specify which cube/dataset you're focusing on for accuracy. Or also tell it what not to do.

The user experience (UX) could also benefit from some fine-tuning – perhaps an intuitive search box for sifting through available data and auto-adding the necessary parameters.

Some sample questions (sorry, only in German for now, but LinkedDataGPT should also understand other languages):

While GPT 4.0 might offer enhanced out-of-the-box results, it comes at a way higher cost. Nevertheless, with the right prompts, our experience shows that GPT 3.5 also can deliver valuable insights.

Lastly, a tip of the hat to the City of Zurich. We've turned to you yet again, mainly because your linked data portal, with its comprehensive metadata, has proven too compelling and reliable to resist. Kudos for that!

Please also note, this is not affiliated with the City of Zurich. At its core, this remains a proof of concept.

Photo by Claudio Schwarz on Unsplash

Tell us what you think