Hello ... I don't know if this is the right place for the question, but here goes ... I'm using ArcMap 10.5.1 for a project I'm doing on behalf of a non-profit housing development organization, and I've been attempting to join a Census table to a TIGER shapefile, without luck. In this particular case, I'm attempting to join a table of data at the Census Block level to the appropriate corresponding TIGER shapefile, but I have repeatedly found that the "geoid" numbers fail to match owing to their length (15 numerical digits) and the related tendency of both the shapefile and csv data tables to convert the numbers into exponential versions. This problem only occurs at the Census Block level, perhaps because the Census Block Group geoid number is only 12 digits, versus 15 (without decimals) for Blocks. I've spent hours trying to bypass the obstacle, or to resolve it, with no luck.
Could you essentially create a new field that will display only the first 12 digits of the 15 digit number in order to match up with the other 12 digit field? Would this make the two fields match up and joinable at that point?
We had the same problem, and I didn't find an adequate solution on the forum, but finally got it to work:
#census #block #attribute #join