SAME ANALYSIS · TWO WORLDS
Find_Stores_Near_Active_Construction.tbx ValidateRunAuto Layout
Stores.shp Construction_Permits.shp Select Layer By Attribute status = 'active' Active_Permits intermediate · 28 MB Buffer distance = 500 m Permit_Buffers intermediate · 64 MB Select Layer By Location intersect scratch_temp_01 scratch_temp_02 xy_tmp.csv
Running... 03:42 elapsed · step 4 of 5 | 6 intermediate files · 184 MB
Schema lock not released on Active_Permits
stores_near_construction.sql DuckDB · spatial 
 1-- Stores within 500m of an active permit
 2-- Same analysis. 11 lines. No clutter.
 3
 4SELECT
 5  s.name,
 6  c.permit_id,
 7  ST_Distance(s.geom, c.geom) AS dist_m
 8FROM   stores s
 9JOIN   construction_permits c
10  ON ST_DWithin(s.geom, c.geom, 500)
11WHERE  c.status = 'active';
QUERY OK
11 lines 4.2s runtime 0 intermediate files
DUCKDB · LOCAL
Old way: 5 tools, 6 intermediate files, 3:42 and counting.
MODEL BUILDER · ARCMAP