Icon

Geospatial analytics with KNIME Data Connect events

This workflow shows how to use the nodes of the geospatial analytics extension to:

- Retrieve polygon boundaries,
- Create projections,
- Perform unary union operations to merge polygons,
- Extract representative points,
- Handle legend;
- Visualize events and registrations by regions in a map.

Geospatial Analytics with KNIME Data Connect events in 2022This workflow shows how to use the nodes of the geospatial analytics extension to retrieve polygon boundaries, create projections, perform unary union operations to merge polygons, extract representative points, handle legend andvisualize events and registrations by regions in a map. Read in data and expand countryabbreviations Extract country polygons and create projections (from degreesto meter) Merge country polygons to create macro-regions Extract representative points from polygons and create buffer area around them Handle legend and create dashboard Read DC eventsand registrationsby region in 2022Extract polygonsGet representative pointsInput in lower portwill be displyed on top in Geo ViewCreate buffer areaaround representativepointsProject from degrees to meterDefine bufferdistanceUnite polygonsof macro regionsFrom DACHand North Americato countriesFrom countriesto DACH andNorth AmericaTop: for regional polygonsBottom: for point extraction Table Reader Table Row ToVariable Loop Start OSM Boundary Map Loop End Geometry To Point Concatenate Buffer Projection Math Formula Loop End Chunk Loop Start Table Rowto Variable Unary Union Group Loop Start Loop End Column Appender DuplicateRow Filter Concatenate Expand region names Group countriesto regions Createregistration bins Entry for NAin legend Geospatialdashboard Geospatial Analytics with KNIME Data Connect events in 2022This workflow shows how to use the nodes of the geospatial analytics extension to retrieve polygon boundaries, create projections, perform unary union operations to merge polygons, extract representative points, handle legend andvisualize events and registrations by regions in a map. Read in data and expand countryabbreviations Extract country polygons and create projections (from degreesto meter) Merge country polygons to create macro-regions Extract representative points from polygons and create buffer area around them Handle legend and create dashboard Read DC eventsand registrationsby region in 2022Extract polygonsGet representative pointsInput in lower portwill be displyed on top in Geo ViewCreate buffer areaaround representativepointsProject from degrees to meterDefine bufferdistanceUnite polygonsof macro regionsFrom DACHand North Americato countriesFrom countriesto DACH andNorth AmericaTop: for regional polygonsBottom: for point extraction Table Reader Table Row ToVariable Loop Start OSM Boundary Map Loop End Geometry To Point Concatenate Buffer Projection Math Formula Loop End Chunk Loop Start Table Rowto Variable Unary Union Group Loop Start Loop End Column Appender DuplicateRow Filter Concatenate Expand region names Group countriesto regions Createregistration bins Entry for NAin legend Geospatialdashboard

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: roberto.cadili
Created at: 2023-01-12
On NodePit since: 2023-01-14
Last update: 2024-04-27
Created with KNIME version: v4.7.0
Tags: GeospatialgeopandaspolygonsGeospatial AnalyticsOSM

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!