Requests and permits on one address list
A pothole report arrives as a GPS point, a building permit as a typed address. To count them by street or district, both need to land on the same addresses.
A sheet of the city only
gridpin slice usa.bin --city boston --out boston.bin
A cut of the sheet answers faster and fits a small server; an address outside the city has no answer, which is right for a city service.
Points to addresses, addresses to points
gridpin batch boston.bin requests.csv requests_out.csv --reverse gridpin batch boston.bin permits.csv permits_out.csv --with exists
Reverse answers carry gp_distance_m: a point far from any house is a park or a road, not an address.