I built a programmatic SEO site 8 months ago targeting local business data in the US. We hit 100k monthly pageviews yesterday. Here is how I structured the database and URL routing.