Dataset methodology report

Methodology

1. OpenStreetMap was used only as a discovery inventory. Physical restaurant locations were manually curated, and discovery links were replaced with official restaurant sites or official brand location pages.
2. Every official URL was requested live. Status, redirect target, title, content hash, and lightweight address/name checks were recorded in source_checks.json. A 401, 403, 405, or 429 is retained as reachable-but-automation-blocked rather than treated as a successful content read.
3. Every complete address was geocoded with the public Esri World Geocoding Service. The selected candidate had to score at least 75 and fall in the district polygon. Requests and candidate responses are preserved in geocode_evidence.json.
4. The U.S. Census Bureau 2025 TIGER/Line unified school district shapefile was loaded and Troy School District, Michigan, GEOID 2634260, was selected. Polygon covers was used so points exactly on the legal boundary pass.
5. Addresses were independently geocoded with the City of Troy Site Address Locator and checked against the City's official Administrative/MapServer/3 feature NAME='TROY SCHOOLS'.
6. The clean verifier enforced the exact seven-column CSV schema, 51 rows, nonblank cells, permitted likelihood values, URL syntax, unique normalized addresses, and both boundary passes.

Sources

• Boundary: U.S. Census Bureau 2025 TIGER/Line Unified School Districts — Michigan.
• Feature: Troy School District, GEOID 2634260; bounds [-83.20768, 42.53977, -83.088776, 42.624208].
• Cross-check: City of Troy official school-district map layer and public map.
• Restaurant operation/address: official URL preserved on each CSV row.
• Geocoding: Esri World Geocoding Service; chosen scores range from 98.2 to 100.0.

Verification outcomes

• Header is exactly the seven requested columns; all required cells are nonblank.
• All 51 normalized physical addresses are unique.
• All 51 Esri-geocoded points are inside or on the Census district polygon.
• All 51 City-locator points are inside or on the City's official TROY SCHOOLS polygon.
• Live official-source statuses: 45 HTTP 200 and 6 HTTP 403 automation blocks.
• High is reserved for official sports-bar identification. Medium reflects a documented full-service bar, brewery, lounge, or group-dining format. Low means official material does not support a sports-viewing inference.

Caveats

• Restaurant operation can change after the generated timestamp. Rerun python run_pipeline.py for a fresh live build and both boundary passes.
• Some official sites use JavaScript or bot controls. Those cases remain visible in source evidence rather than being silently treated as successful page reads.
• TIGER/Line is the Census representation of the unified school district boundary, not an enrollment or attendance guarantee for a parcel. Confirm edge cases with Troy School District.
• Geocoding is address-based. Scores, matched addresses, coordinates, returned candidates, and point-in-polygon results are preserved.