I used to have no trouble joining ACS files to shapefiles such as county tracts or block groups. Recently, I find that I cannot. ACS files come with "GEO.id" fields that are numeric and do not join to shapefiles whose GEO.id fields are all text. I have tried numerous ways in Excel to turn the ACS numerical location fields to text, but when I load those files into ArcMap, ArcMap turns them all back into numerical fields.
HELP. Vary frustrated that I can't figure out how join anymore. And frankly, the Census Bureau pdf describes the process, but the process no longer works. What's changed? Me? They? Any and all recommenations will be welcome.
There are a variety of reasons that can cause this process to go awry, so the first step is to elicit some details:
Chris Donohue, GISP
Thanks for the thoughts, Chris. You've listed many of the key issues, and for the most part, I've taken those into account.
The key bugaboo, however, has been my inability (now resolved) to transform the Geo.Id2 data listed in the ACS files into a text-formatted number. For some reason, ACS seems to treat Geo.Id2 as a number to be reported in scientific notation. FIPs numbers are not, in my mind, real numbers. They cannot, should not, be manipulated arithmetically. I attempted over and over again to copy/paste those Geo.Id2 numbers into an Excel text-formatted column. But those attempts never resulted in a field that ArcMap would allow to join to my block-group files.
I did everything that ACS said I should in one of their publications, but even their example process did not work.
I finally stumbled upon a special process for pasting the Geo.Id2 numbers in a way that they stayed as numbers-in-text. And now the joins take. I'm not a klutz with Excel, but this one did confound me. I still don't know why the Census B. puts that Geo.Id2 in scientific notation, and I hope to find out (by complaining a bit).
Thanks again for the reply. If you know of any published ways to convert Geo.Id2 numbers into numbers-in-text, do tell.