Wenzel Frick

Open Data St.Gallen

Open Data St.Gallen is an open data portal for the canton of St.Gallen, Switzerland. The data comes from public sources and is made available via a Rest API. In addition to media releases from the city and canton of St.Gallen administrations, information on members and processes of the cantonal council is also published.

Media releases

The published media releases are communications from the administration of the city and canton of St. Gallen, the city police, and information on consultations by the cantonal council.

In order to minimize the number of requests to the REST API, data from individual releases is stored in a database in a user-driven process and updated at regular intervals. As part of this process, the structure of the HTML markup is slightly modified.

Data on the St. Gallen Cantonal Council

The data on the Cantonal Council includes information on members, committees, business, and votes of the Cantonal Council. Entries in each category can be searched using keywords.

The pages are linked to each other, for example, the detailed views of members of the Cantonal Council with their voting behavior or membership in committees.

The voting results of the Cantonal Council are broken down by region, constituency, and party affiliation.

Libraries, frameworks, and services used

  • Code on GitHub
  • React frontend library
  • Remix framework for server side rendering, routing and general tooling
  • Architect framework for configuration of and deployment to AWS services
  • AWS cloud services for hosting, computing, and data storage
Screenshot of the website odsg.ch with an overview of the latest press releases from the city and canton of St. Gallen administrations.
The homepage provides an overview of the latest media releases from the city and canton of St. Gallen administrations.
Screenshot of the media release on the odsg.ch website.
The data in the media releases is provided by the canton of St. Gallen. It can be searched by category or keyword.
The screenshot shows the overview page with information about the cantonal council.
The overview page for information about the St. Gallen Cantonal Council allows users to search for business, votes, committees, and members of the Cantonal Council by keyword or name.
The screenshot shows a chronological list of the transactions of the St. Gallen Cantonal Council.
The business of the cantonal council can be displayed either chronologically or searched by keyword.
The screenshot shows the details page for a transaction by the St. Gallen Cantonal Council.
The detailed view of a transaction lists the persons involved, links to documents, and other relevant information. The data portal is therefore particularly aimed at people who are interested in detailed information about proceedings in the cantonal council.
The screenshot shows the detailed view with information about a member of the St. Gallen Cantonal Council.
The data portal provides information on cantonal councilors and their associations and affiliations.
Here is a screenshot of the voting results on the website odsg.ch.
The results of the cantonal council votes are presented and illustrated in detail.
The screenshot shows the results of the cantonal council vote. These are broken down both tabularly and graphically by constituency.
The results of the cantonal council vote are presented in tables and graphs broken down by constituency, among other things.
The voting results are presented by party in both tabular form and as a bar chart. Screenshot of the website odsg.ch.
The various breakdowns and presentations are intended to illustrate and clarify the key points of the voting results.