topic Re: How do I discern the correct Census Tract to Join to my Excel .CSV in Data Management Questions https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206755#M11852 <HTML><HEAD></HEAD><BODY><P>Tim: The join field you should be using is GEOID. Unfortunately the GEOIDs in the two files are from different states.</P><P><A class="" href="https://www.census.gov/geo/reference/geoidentifiers.html" title="https://www.census.gov/geo/reference/geoidentifiers.html">Understanding Geographic Identifiers - Geography - U.S. Census Bureau</A>&nbsp;</P><P>OBJECTID is not a valid join field, it is the internally managed ID for every geodatabase table and in most cases should be avoided for joins because it can be modified by the system.</P></BODY></HTML> Tue, 25 Apr 2017 23:09:02 GMT curtvprice 2017-04-25T23:09:02Z How do I discern the correct Census Tract to Join to my Excel .CSV https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206751#M11848 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've attached both of the files I based the join on. The result added Census Data for another part of the state. Im missing something. Thanks for any help. The blacked out columns include offenders personal addresses addresses.</P></BODY></HTML> Tue, 25 Apr 2017 21:16:42 GMT https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206751#M11848 TimothyWendeborn 2017-04-25T21:16:42Z Re: How do I discern the correct Cencus Tract to Join to my Excel .CSV https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206752#M11849 <HTML><HEAD></HEAD><BODY><P>What fields are you using in the join?</P></BODY></HTML> Tue, 25 Apr 2017 21:27:51 GMT https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206752#M11849 ITDGIS 2017-04-25T21:27:51Z Re: How do I discern the correct Cencus Tract to Join to my Excel .CSV https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206753#M11850 <HTML><HEAD></HEAD><BODY><P>I put both tables into the default gdb and used the ObjectID. That was after attempting to join the crime data table many times to other tables with no success. So I either selected the wrong census file or Im not setting up my table correctly, I guess?</P></BODY></HTML> Tue, 25 Apr 2017 21:35:18 GMT https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206753#M11850 TimothyWendeborn 2017-04-25T21:35:18Z Re: How do I discern the correct Census Tract to Join to my Excel .CSV https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206754#M11851 <HTML><HEAD></HEAD><BODY><P>Tim you should delete that worksheet column and repost, it is still easily visible to anyone that would want to see it.</P></BODY></HTML> Tue, 25 Apr 2017 23:00:01 GMT https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206754#M11851 curtvprice 2017-04-25T23:00:01Z Re: How do I discern the correct Census Tract to Join to my Excel .CSV https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206755#M11852 <HTML><HEAD></HEAD><BODY><P>Tim: The join field you should be using is GEOID. Unfortunately the GEOIDs in the two files are from different states.</P><P><A class="" href="https://www.census.gov/geo/reference/geoidentifiers.html" title="https://www.census.gov/geo/reference/geoidentifiers.html">Understanding Geographic Identifiers - Geography - U.S. Census Bureau</A>&nbsp;</P><P>OBJECTID is not a valid join field, it is the internally managed ID for every geodatabase table and in most cases should be avoided for joins because it can be modified by the system.</P></BODY></HTML> Tue, 25 Apr 2017 23:09:02 GMT https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206755#M11852 curtvprice 2017-04-25T23:09:02Z Re: How do I discern the correct Census Tract to Join to my Excel .CSV https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206756#M11853 <HTML><HEAD></HEAD><BODY><P>I take that back, the GEOID in these files seems to start after the text US. I think 14 and 15 are different years or something.</P><P></P><P>So what you need to do to join the tables is to add a new text field in both tables for Census tract, and calculate it to the matching Census GEOID. I think the easiest way is using a Python expression, like this, which starts at the 10th character and drops off the last digit, which is apparently census block group.</P><P></P><P><STRONG>!GEOID![9:-1]</STRONG></P><P></P></BODY></HTML> Tue, 25 Apr 2017 23:24:57 GMT https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206756#M11853 curtvprice 2017-04-25T23:24:57Z Re: How do I discern the correct Census Tract to Join to my Excel .CSV https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206757#M11854 <HTML><HEAD></HEAD><BODY><P>Thank you sir. Sorry for late reply.</P></BODY></HTML> Wed, 26 Apr 2017 16:49:56 GMT https://community.esri.com/t5/data-management-questions/how-do-i-discern-the-correct-census-tract-to-join/m-p/206757#M11854 TimothyWendeborn 2017-04-26T16:49:56Z