Icon

Finding Pharmacy Deserts Demo

Pharmacy Lat/Longto point geometry
Lat/Lon to Geometry
Pharm_polygon to EPSG:25832
Projection
Grid_cells intersecting No_pharm_areas
Spatial Join
Pharm_pointto EPSG:25832
Projection
Add No_pharm_area_polygon
Value Lookup
Filter out grid cellsintersecting pharmacies=>only grid cells w/o pharmacies
Reference Row Filter
SimplifyPharm_polygons
Simplify
Build one multi-poliygon w/o Apos
Unary Union
Filter columns, rename geometry column
Table Manipulator
Filter out Buffer and Centroid columns
Column Filter
Box around all 50m-Buffer => 100m grid cells
Bounding Box
Filter columns, rename geometry column
Table Manipulator
6km isodistance around pharmacies to polygon geometry
WKT to Geometry
Read in grid cellcentroids (EPSG:3035)
Excel Reader
Table Manipulator
Concatenate
Geospatial View
Add catergoy=Pharmacy
Constant Value Column Appender
Sum inhabitants and count grid cells per No_pharm_areas
GroupBy
Convert centroid topoint geometry
Lat/Lon to Geometry
Grid_cells intersecting Pharm_polygon
Spatial Join
Buffer 50maround all centroids
Buffer
Geospatial View
Read inpharmacies
CSV Reader
Geometry to No_pharm_areas
Column Renamer
Split multipolygonto multiple polygons =>No_pharm_areas
Multipart To Singlepart
Create id for No_pharm_areas
Create Index
To EPSG:25832
Projection
Add catergory=Area_without_pharmacies
Constant Value Column Appender
Geospatial View

Nodes

Extensions

Links