I'm doing a project that involves metropolitan areas according to the Census/BLS. I was able to merge Census and BLS data for metro areas because of their geoIDs. In some instances I had cities missing that I was able to then find in the census under different sections (NECTA, Metropolitan DIVISION, etc), which varies a bit from the standard MSA data I find when I go to the KML/geographic data section of their website. For example, some cities are represented in multiple ways -- New York, Los Angeles and Detroit for instance have multiple tracts with varying geoIDs.
I was wondering if there was any way there was an easier way to find these missing cities from Metropolitan Division, etc. as far as KML files so I could map my project accordingly. I have 395 cities about and a lot of them I have the KML files for from MSA geographic data on the census site, but there are a decent amount missing.