Icon

Geospatial analysis of retailer reduction

Geodata-based analysis of the decline in the number of pharmacies with KNIME

Geodata-based analysis of the decline in the number of pharmacies with KNIME

Step 1: Read in data, preprocess and (spatially) join
Step 2: Calculate distances between all pharmacies
(alternatively with Haversine Distance after Cross Joiner)
Step 4: Multi-layer geo-visualization with Kepler.gl Geoview, preparing for Foursquare Studio



Step 3: Form key figures based on the spatial location and distances between pharmacies


Create .geojoson file path in the workflow data area
Distance <= 1km
Row Filter (Labs)
Groups: Business statusPivots: Binned distancesAggr.: Count Place_id
Pivot
Count nr. of pharmaciesin radius for any pharmacy
GroupBy
Only distances >5m
Row Filter (Labs)
Geo Distances
Distance to nearest pharmacyfor any pharmacy (minimum distance)
GroupBy
Groups: Business statusPivots: Binned nr. of pharmac.Aggr.: Count Place_id
Pivot
Filter relevant columnsfor geo-visualization
Column Filter
BBSR_Spatial_Organisation_2022.xlsx
Excel Reader
Mean minimum distancesfor remaining & closed pharmacies
GroupBy
Bin nr. of pharmacies
Numeric Binner
Filter relevant columnsfor geo-visualization
Column Filter
Calcuulate relative values
Math Formula (Multi Column)
Cross Joiner
GeoFile Writer
Rename geometry toPharmacy_geometry
Column Renamer
Pharmacies_BaWü_remaining_closed.xlsx
Excel Reader
Impute missing valueswith previous value method
Missing Value
Groups: Business statusPivots: Area typeAggr.: Count Place_id
Pivot
Kepler.gl Geoview
Latitude/Longitude to Coordinate
Join with group totals
Joiner
GeoFile Writer
Join with group totals
Joiner
Latitude/Longitude to Coordinate
Join with group totals
Joiner
Calcuulate relative values
Math Formula (Multi Column)
Joiner
Lat/Lon to Geometry
Geo Distances
Rename geometry toMunicipality_geometry
Column Renamer
Only area type, place_id, and business status
Column Filter
Column Appender
LGL_BaWü_Admin_Boundaries.geojson
GeoFile Reader
Column Distance
Join pharmacieswith municipalities
Spatial Join
Bin distance to nearest pharmacy
Numeric Binner
Only place_id, lat/longand business status
Column Filter
Calcuulate relative values
Math Formula (Multi Column)
Projectionto EPSG 4326
Projection
Remove leading zeroes in Municipality_code
String Manipulation

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: chkn
Created at: 2024-01-16
On NodePit since: 2024-07-04
Last update: 2026-11-13
Created with KNIME version: v5.2.5

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

Try NodePit Runner!