Icon

City and neighborhood insights with Geo-GenAI

<p><strong>City and neighborhood insights with Geo-GenAI</strong></p><p>This workflow uses data of the city of Zurich (e.g., reports on infrastructural issues, surveys, etc.) on to create a comprehensive data app of the situation in whole city of Zurich. The data app includes a geo-map, a word cloud, an animated bar chart, as well as an AI-generated textual explanation of overall situation in Zurich.</p><p>Additionally, the workflow includes a neighborhood analysis to extract metrics for a specific area and generates a report about the status of the neighborhood using GenAI.</p>

Load Required Data

The different data required for this workflow have been saved into the data area for easy execution.

The data utilized are:

  • Züri wie neu:
    Reports of infrastructural issues and their locations, which are gathered via a portal. Link

  • Quartiere:
    Neighborhoods of Zurich based on survey and their geographical boundaries. Link

  • Adressen Stadt Zürich:
    Addresses submitted in Zurich along with their Geolocation. Link

Neighborhood Analysis

In this page of the Data App, the user can enter an address in the city of Zurich.

The Address is used to extract metrics for that area and additionally, generate a report using GenAI to analyze the status of the neighborhood.

Main Dashboard

A dashboard for all of Zurich which answers the following questions:

  1. What are the urban challenges that Zurich faces?

  2. How are these challenges distributed locally and temporally?

  3. How are these challenges are being addressed?

Using the data, an automated report is generated that summarizes the overall situation of Zurich.

Preprocess Data

In order to analyze data, they need to be preprocesses into a suitable format. The processes involved in this level are:

  1. Column Translation with Google Translate

  2. Table Content Translation and Summarization from German to English using ChatGPT

  3. Projection of Data into a suitable format

  4. removing extra data

Analyze Data

In this step, GenAI is used to quantify textual reports from all of Zurich into metrics. These values then are interpreted using GenAI in order to generate a report.

The report goes over Zurich and mentions the noticeable challenges.

Authenticate to AI provider

City and neighborhood insights with Geo-GenAI

This workflow uses data of the city of Zurich (e.g., reports on infrastructural issues, surveys, etc.) on to create a comprehensive data app of the situation in whole city of Zurich. The data app includes a geo-map, a word cloud, an animated bar chart, as well as an AI-generated textual explanation of overall situation in Zurich. Additionally, the workflow includes a neighborhood analysis to extract metrics for a specific area and generates a report about the status of the neighborhood using GenAI.

Load Data
Exploratory Data Analysison GeoData withGenAI
Primary Analysis
Preprocess Data
Dashboard
OpenAI API key
Credentials Configuration
Report Generation
OpenAI Authenticator

Nodes

Extensions

Links