Wow. There are some interesting challenges in trying to figure this out.
I have figured some things out about how to find TIGER info in OSM. I can do things like look for “tiger:reviewed”=”no”.
I have downloaded a bunch of the TIGER data. I am going from the directories under ftp://ftp2.census.gov/geo/tiger/TIGER2015/. One challenge I am having is finding the longitude and latitude data. I know it is there somewhere. Is it in the files under EGDES? No. Under ROADS or ADDR? No. Only 40 or so more to check…. But I am looking at only the dbf files in those zipped files, using the dbf2mysql utility for Ubuntu. Is the lat/long data only in SHP files? That would be obnoxious.
But the TIGER data does have TLID fields. So this should help me. Because OSM features have a “tiger:tlid”=num value. So, I should be able to pick a TLID from the TIGER data and see it in OSM, or see and id on OSM and find it in the TIGER data, right? Maybe not so much.
I have over 12,000,000 edges. I have all of OSM. Can I find one place where an id appears in both? No. How should I search? Randomly? I have done a bunch of random checks and so far I hit nothing. Which kinds of id values appear in both? Does OSM only include polygon objects? Or any of the other 20 or so types in TIGER? There are so many ways to slice this. I am sure when I figure this out, it will be sooooooo obvious….. :-)
We will see.