Case study · Proof of concept · Palm Beach County, FL

Franchise Site Finder (proof of concept)

A map-based tool that ranks possible locations for a new franchise site using public data. I built it on my own initiative to show how public data can rank franchise sites. It was not commissioned by, and is not affiliated with or endorsed by, any brand or franchisee.

The question

Where could one more auto-service location go?

The example scenario is a single auto-service site for a single franchisee of a national auto-service brand, inside Palm Beach County, FL. The tool places the brand's existing locations on a map, draws an adjustable exclusion radius around each one, and ranks the places outside those circles where a new site could make sense.

It is a working proof of concept, not a client project. Everything it shows comes from public sources, and it says so plainly when an input is an assumption or a proxy.

How it works

Two ways to rank sites, scored live in the browser

Existing stores and exclusion radii

Existing locations are read from the brand's public store pages and cross-checked against OpenStreetMap. Each one gets an exclusion circle with an adjustable radius (default 3 miles, range 0.5 to 15). The radius is labeled as an assumption, because real territory terms live in franchise documents the tool has not seen.

Ranked areas along major roads

Candidate points are sampled every 0.4 miles along FDOT-counted roads in the county, with interstates, freeways, and ramps removed. Points inside any exclusion circle are left out.

Ranked properties

A second view ranks individual Palm Beach County Property Appraiser parcels that pass the property filters and lie outside every exclusion circle. Parcels are potential sites only. They are not confirmed listings, prices, or rents.

Live weighted percentile scoring

Each factor becomes a percentile rank among the sites that pass the filters, and the score is the weighted average × 100. Every weight is adjustable, and the map, ranked list, and match counts update as you change weights or filters.

Bay-size estimate

Parcel records don't include service-bay counts, so automotive and industrial/flex parcels are labeled likely multi-bay, likely single-bay, or unknown, based on Florida Department of Revenue building area and an adjustable cutoff (default 3,000 sq ft). The cutoff is shown as an assumption.

Mobile layout and context help

On a phone, the map, filters, and ranked sites sit behind a bottom tab bar. A "?" button next to each setting opens a short explanation of where its data comes from and how it is scored, and a "How to use" panel walks through the steps.

Screenshots

What it looks like

Screenshots have been edited to remove brand names and private details.

Desktop view of the site finder: a map of Palm Beach County and the coast to the north and south with existing store markers, their exclusion circles, and numbered ranked sites, beside a Ranked sites panel. The top site shows a score of 82.6 with a score breakdown for traffic, nearby vehicles, competitor saturation, median household income, an occupancy-cost proxy, and commercial zoning.
Ranked areas: road sample points outside every exclusion circle, each with a score breakdown by factor.
Desktop view zoomed in on a single parcel. A map popup lists the parcel's appraiser details, including use, lot size, building area, year built, and county values, with the owner name hidden. The Ranked properties panel shows the parcel's zoning, nearest counted road and traffic count, a likely multi-bay estimate, and its score breakdown.
Ranked properties: individual appraiser parcels with use, building area, zoning, a bay-size estimate, and a score breakdown.
Phone view of the site finder: the map on top, a Ranked sites panel below with Ranked areas and Ranked properties tabs and the top-ranked site, and a bottom tab bar with Map, Filters, and Sites buttons.
On a phone, Map, Filters, and Sites each get a tab.

Public data

Where the data comes from

  • Traffic: FDOT annual average daily traffic (AADT) counts by road segment.
  • Households: U.S. Census American Community Survey 5-year estimates by census tract, for median household income and household vehicles.
  • Competitors: auto-repair, tire, and oil-change shops from OpenStreetMap, optionally combined with Property Appraiser auto-use parcels.
  • Zoning: Palm Beach County Planning zoning data, screened with an approximate auto-service compatibility mapping that the tool tells you to verify with the planning department.
  • Parcels and building area: Palm Beach County Property Appraiser parcels, with building area and use codes from the Florida Department of Revenue statewide roll.

Commercial listing sites are not scraped. Each ranked site links out to listing searches instead.

When a data source fails, the tool says so

The data refresh wraps every source so a failure is recorded instead of stopping the run. If a source fails, the page sets that factor's weight to 0 and shows a note explaining why. It never fills in estimated values in place of missing data.

How it's built

Plain HTML, CSS, and JavaScript

The app is static HTML, CSS, and vanilla JavaScript, with Leaflet for the map, stored locally rather than loaded from a CDN. There is no build step. The data is refreshed with a separate script, and the page does all of its scoring in the browser.

See it working

Demo available on request

Want to see the site finder in action, or talk about ranking locations with your own data? Get in touch to set up a walkthrough.

Demo available on request