Check Open Data SA for new historical SAPD Calls for Service rows
(dataset, CC-BY).
Hash-gated: skips when the remote file is unchanged. Force re-downloads and re-upserts.
Existing geocodes and school districts are never overwritten — only blank fields on new/address-less rows are filled from ZIP centroids.
First full import can take hours; prefer CLI
bun run import-pubsafedash-cfs -- --file data/pubsafedash_cfs.csv
for the initial load if the CSV is already local.
—
Loading…
Sources. Live scrape keeps street addresses and active status.
Open Data SA adds disposition, priority, call type, and response seconds, and inserts historical incidents without addresses.
Re-imports only fill missing ZIP-based location and school district — they do not replace street geocodes.
Dataset is not official government data once combined or modified; no City endorsement.
Report history bucket.
Weekly Reports.aspx JSON stays in object storage. This import runs on the API server,
which reads the bucket and writes Postgres directly. It does not download the files to your computer.