01
Every license on one map
One pin per active license, sized and colored by 2025 purchases, switching between bars and stores. Pins cluster when zoomed out and split apart as you zoom in.
Case study · My own business
Spirits Territory Map is my own tool for liquor sales reps working Michigan. Every active spirits license is a pin, sized and colored by what that bar or store bought from the Michigan Liquor Control Commission in 2025, with the four years before it on the card. Open it on a phone, tap Near me, and the accounts around you are ranked by what they buy.
No. 01 / The problem
A rep’s territory is thousands of bars and stores, and the only public record of who buys what is a set of state spreadsheets and PDFs. Calls get planned from memory or a distributor printout. The numbers that say which accounts matter already exist and are public, but nobody can use them from a parking lot.
No. 02 / What I built
01
One pin per active license, sized and colored by 2025 purchases, switching between bars and stores. Pins cluster when zoomed out and split apart as you zoom in.
02
A 5, 10 or 25 mile ring around the rep, or around any searched place, filters the map and a ranked list. Sort that list by purchases, growth, or distance.
03
Licensee, license number, change from the year before, a five-year trend with each year’s figure, rank in the area, plus directions and a share link.
04
Find any business, licensee, city or license number, with a keyboard shortcut and quick actions. A shared link opens the same view, filters and sort.
05
A pipeline parses the state’s workbooks and older PDF reports, joins them on license number and type, and checks every total against the totals printed in the source files. A test suite runs against the built data before every deploy.
Built with
Related services
No. 03 / More work

Agency site and candidate network, built to bring applicants in without a third-party job board taking the first handshake.
Read the case study
Menu and daily specials sync straight from their Toast POS — nobody has to update the website.
Read the case study