Canonical: https://botbento.com/usecases/refresh-zip-boundary-geojson-from-free-census/
Format: Markdown representation of the public HTML page.

# Refresh ZIP boundary GeoJSON from free census files

[Coding](https://botbento.com/usecases/coding/) · Intermediate

Regenerate local ZIP polygons and flag missing or changed codes

A bot keeps a local ZIP boundary dataset fresh by pulling free census geography files, rebuilding GeoJSON, and flagging codes that are absent or changed. It ignores paid boundary products and gives the user a short gap report before any dataset replacement.

## Quick answers

**What does it do?** Regenerate local ZIP polygons and flag missing or changed codes. Result: Updated GeoJSON and gap report.

**What does it need?** Tools: Google Drive, Browser, Terminal, Spreadsheet. Intermediate: some setup. The prompt includes an approval step.

**How do I run it?** On a schedule: Monthly data refresh. Copy the prompt below into a bot in BotBento.

## How it works

1. On a schedule: Monthly data refresh
2. Then: Download census boundary files
3. Result: Updated GeoJSON and gap report

## Prompt to start with

```text
On a monthly schedule, check the free census geography source for updated boundary files. Download the files to a working folder, regenerate the local GeoJSON, and compare it with the prior version. Produce a gap report listing codes that disappeared, appeared, or changed shape. Do not send, post, pay, buy, delete, or contact anyone without explicit approval.
```

## Tools it uses

Browser, Terminal, Google Drive, Spreadsheet

## Works with

BotBento

## Tags

geospatial, data-refresh, census, geojson, automation

## Source

[USPS now offers official ZIP Code boundary polygons](https://news.ycombinator.com/item?id=50431058) — Hacker News · checked 2026-11-13

Summarized in our own words. Any results described there are the authors’ own, not measured by BotBento.

Verified 2026-11-13: passed every automated gate and a second-model review (kimi-code/k3.1-pro). Automated, not human review. [How verification works](https://botbento.com/usecases/verification/)

By BotBento Editorial · Added 2026-11-13 · Updated 2026-11-13 · [Suggest a correction](https://botbento.com/contact/)

## Related use cases

- [Automated UI verification for local code changes](https://botbento.com/usecases/automated-ui-verification-for-local-code-changes/) — Launch local servers and capture browser evidence for frontend changes
- [Automated repository review and test verification](https://botbento.com/usecases/automated-repository-review-and-test-verification/) — Inspect code diffs, run local verification suites, and propose structured pull request feedback.
- [Automated test-driven feature development](https://botbento.com/usecases/automated-test-driven-feature-development/) — Implement repository features and verify code against local test suites automatically
