Dev Tools · 1h ago
Batch Geocoding 14M French Businesses with Free BAN API
A developer built a pipeline to geocode 14.4 million French business establishments using the free BAN API, processing 8,000 rows per request without third-party services. The system runs daily alongside a live application, using a two-layer architecture: monthly full rebuilds from official GeoSirene data and incremental daily updates via the BAN API. The approach avoids database locks and handles exclusions for foreign addresses and overseas territories.
Meridian48 take
The piece is a solid technical walkthrough but lacks novelty—batch geocoding with government APIs is well-established; the value is in the specific thresholds and zero-lock pattern.
Read the full reporting
Batch Geocoding at Scale with France's Free BAN API: Thresholds, Chunks, and Zero Lock Contention →
DEV Community
geocodingapi