I am trying to get a mapping of "all cities of United States" to Census tracts. I know that it wont be perfect, there can be cases of one to many and many to one, however it will still be useful for me.
I don't have any experience or access to any GIS software so I need some way to get it in R or python. Or if some mapping already exists, I can utilize that as well. As of now I am not worried about periodic changes in definition of cities/tracts as well.
The census data itself is huge and confusing that trial and error has already taken lot of time. I tried the answers here, however could not make any of them work. Answer by @GL_Li could be useful, however data download fails, and I could not figure out which data to download.
This website provides census tract to zip mapping, and some websites also provide city to zip mapping and one can try to use these to arrive at census tract to city mapping, however it will just multiply errors.
I am hoping that a table should exist on census website which has following data: tract, place, place type, wherein place type points to 'city' for lot of records, it can be used to create a mapping.
