I’m attempting to find the total roadway area for specific tracts across the US (thousands, so not a small number). I downloaded the TIGER shapefiles (Primary, Primary and Secondary, and All Roadways) and wanted to compare them. The problem that I ran into was that there are many of the same records, just with a different name (State Highway would also have a name like El Camino Real). So two lines for one street, which would increase the actual area number, but not be a true representation.
Do you know if a different shapefile exists that solves this problem of multiple records? I’m ok with not having all three roadway shapefiles – the “all roads” would be preferred. I've tried using the "delete identical" tool in ArcGIS but was not successful. In a perfect world, I'd rather just have a shapefile with no duplicates rather than deleting them myself.