Icon

Challenge 25 - Zurich Clustermap_​PV

<p>Challenge 25 - Zurich Clustermap</p><p><strong>Level: </strong>Medium<br><strong><br>Description: </strong>You have been called upon by Zurich’s city council to interpret a growing dataset of citizen-submitted service reports. To ensure equitable and efficient resource distribution, the council wants to break down the city into smaller, more manageable clusters. Can you pinpoint a systematic method to group Zurich’s neighborhoods based on these incoming reports?<br><br><em>Beginner-friendly objective: </em>(1) Read and preprocess the dataset.<br><br><em>Intermediate-friendly objectives: </em>(1) Extract features that can differentiate and quantify areas of the city. (2) Cluster the city into sections and visualize the clusters.</p>

BEGINNNER FRIENDLY

Challenge 25 - Zurich Clustermap

Challenge 25 - Zurich Clustermap


Level: Medium

Description:
You have been called upon by Zurich’s city council to interpret a growing dataset of citizen-submitted service reports. To ensure equitable and efficient resource distribution, the council wants to break down the city into smaller, more manageable clusters. Can you pinpoint a systematic method to group Zurich’s neighborhoods based on these incoming reports?

Beginner-friendly objective: (1) Read and preprocess the dataset.

Intermediate-friendly objectives: (1) Extract features that can differentiate and quantify areas of the city. (2) Cluster the city into sections and visualize the clusters.

Translator
GeoFile Reader
Projection
Column Filter
Missing Value
Joiner
Boundary MapProjection and Filtering
Preprocess
Constant Value Column
Dissolve
Categoty Count
Pivot
CAGR
Joiner
GroupBy
Spatial Join
Column Renamer
Remove Extra Stuff
Column Filter
Get lat/lon for input location
OSM Boundary Map
Create H3 Grid
AZP
Joiner
Geospatial View
Normalizer
Join the gridsto the original data
Spatial Join
Group Bygeometry
GroupBy
Filter outthe columnsthat are not needed
Column Filter
Visualization
Sum up the dummies
GroupBy
Renaming anddenormalizing
Preprocess
Normalizethe values
Normalizer
Get the geocolumn tothe clustereddata
Joiner
K-means
Optimized K-Means (Silhouette Coefficient)
Denormalize the data
Denormalizer
Creating dummies for the categorical variables
One to Many
Sort the databy k number
Sorter
Read the geopackagedata.gpkg file
GeoPackage Reader
Create grid in thecity
Create Grid

Nodes

Extensions

Links