Case study · My own business

Spirits Territory Map:
a sales map built from public state records.

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.

Business
Field sales map · Michigan
Status
Live · My own business
Website
ryankolean.github.io/spirits-territory-map
Screenshot of the Spirits Territory Map website
Pieces built, listed below
5
Tools in the stack
8
Summit services involved
1
My own business
Live

No. 01 / The problem

What Spirits Territory Map needed

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

What I built for Spirits Territory Map

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.

02

Near me, ranked

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

A card for every account

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

Search and shareable views

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

Data checked against the source

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

  • React
  • TypeScript
  • Vite
  • MapLibre GL
  • OpenFreeMap
  • Python
  • Playwright
  • GitHub Pages

Related services

No. 04 / Want one like this?

Your business, the same kind of build.

Or text or call (248) 882-9055