[Project] Highways Sorted by each U.S. County

[TBKS1]

I don't know exactly where the best place to post this thread would be, this can be moved elsewhere if needed.

I initially started working on this project over the pandemic, mainly to create a listing of all the highways in my home state of Arkansas, and sorting them by the counties in which these routes were located. After that, I started working on making lists for adjacent states as well, such as Missouri, and Oklahoma, and kept expanding the project further and further. I gathered a bunch of documents from different state transportation agencies and departments to help me out (thank you KYTC and TXDOT!) and kept working on the project off and on until the end of 2024 when I finally finished the last state in the sheet (which was Ohio). I've since had to reform this quite a bit, lots of routes have since been turned back, some new ones added here and there as well.

Personally I don't really know what I would do with this sheet now that I've otherwise finished it, maybe I could transfer some stuff on it to the wiki later, but I mostly wanted to create this thread not just to showcase it, but also get some peer review for this project as well. There may be some additional routes that I may need to add or remove to keep the list accurate. Definitely let me know if there's anything I missed in this sheet.

LINK: https://docs.google.com/spreadsheets/d/1USzJSiMLB5R65Gzw9FuZBVgoSgyxN-cY9Z_bbyZZnMk/edit?usp=sharing

A little side note, only signed highways are included. Let me know if this link doesn't work.

~ Ethan

[kurumi]

Interesting. No 2xx state routes in former Fairfield County, CT; and only one 3xx.

[webny99]

Thanks for sharing! I have considered making an attempt to track TM mileage by county, and this would absolutely be a valuable resource if I ever follow through on that plan.

[TBKS1]

Interesting. No 2xx state routes in former Fairfield County, CT; and only one 3xx.

Oh yeah... I made that list back before Connecticut replaced their administrative boundaries. Probably not gonna change it because I'm lazy.

[bassoon1986]

Very Cool! Louisiana must have been tough. Especially with many that have fully or partially rolled back to local jurisdictions.

I was going to say I saw some missing for LA, like some signed Spur state routes. Are you not including any bannered routes? (Business, Alt, Spurs)

I'd be happy to look over the Louisiana section. You've caught a lot that have only recently become signed 

[gonealookin]

My avatar's feelings are a bit hurt, because you don't include it in Douglas County in Nevada.

Nevada DOT has a full index of its highway inventory here:  2025 NDOT Description Index.  So that would be a good cross-check.

In Carson City, SR 512 and SR 518 were relinquished to Carson City several years ago.  SR 529 is unsigned (it's a part of US 395 Business).  Also in Douglas County, SR 705 doesn't have any shields but it's marked by a couple of the small paddle-style mileposts, as shown here, so I don't know whether you consider that "signed" or not:

[-- US 175 --]

Great work, TBKS1.

First, ask the admins to pin this thread.

Next, there is a typo in the TX section.  It's *Gillespìe County, not "Gillepsie County".

[TBKS1]

A couple updates, I shared this with some friends of mine and had a complete overhaul of New Jersey and had to remake that list. Thank you Alps for helping me!

My avatar's feelings are a bit hurt, because you don't include it in Douglas County in Nevada.

Nevada DOT has a full index of its highway inventory here:  2025 NDOT Description Index.  So that would be a good cross-check.

Added NV 207 at the very least and removed 512, 518, and 529. I'll review this list later.

Very Cool! Louisiana must have been tough. Especially with many that have fully or partially rolled back to local jurisdictions.

I was going to say I saw some missing for LA, like some signed Spur state routes. Are you not including any bannered routes? (Business, Alt, Spurs)

I'd be happy to look over the Louisiana section. You've caught a lot that have only recently become signed 

I didn't include any bannered routes for Louisiana, I did include them for a couple of other states (usually suffixed routes that are usually alternates or spurs of the main route). I recently had to update Louisiana as I missed a few split routes and a few of them have recently been turned back as well.

Great work, TBKS1.

First, ask the admins to pin this thread.

Next, there is a typo in the TX section.  It's *Gillespìe County, not "Gillepsie County".

IMO this doesn't deserve to be pinned, I know I put a lot of work into this but I do want to see what other people think first. Also fixed that spelling error.