topic Re: Joining Census tract to this Excel table is giving me fits. in Data Management Questions

Joining Census tract to this Excel table is giving me fits.

TimothyWendeborn — Thu, 27 Apr 2017 14:29:29 GMT

Hi,

I'm on a time crunch or would read through and find the answer that certainly exist here. I want to join census tract to the excel file attached and nothing I am attempting is working. I did this 3 times with very similar files yesterday and no problem. Ive hit a wall and need some guidance. Thank you for taking the time.

Re: Joining Census tract to this Excel table is giving me fits.

DanPatterson_Retired — Thu, 27 Apr 2017 14:44:25 GMT

What is the common field between the two? The content and field type need to be the same if you doing a join

Re: Joining Census tract to this Excel table is giving me fits.

TimothyWendeborn — Thu, 27 Apr 2017 14:54:13 GMT

I downloaded the Tiger shapefile and added a field to its table Census_Trc (double) calculated based on GEOID. The I added the same field (double) Census_Trc to the Meriden census table but abbreviated the GEOID number using Python script. Thus both have the Census_Trc field. I am not figuring out how to create a matching field on the crime table to base the final join on.

Re: Joining Census tract to this Excel table is giving me fits.

GeorgeKatsambas — Thu, 27 Apr 2017 15:04:05 GMT

The only way you could use the excel file is to do a spatial join to the census tract polygons?

Re: Joining Census tract to this Excel table is giving me fits.

TimothyWendeborn — Thu, 27 Apr 2017 15:17:05 GMT

Wow, It worked but only captured 17/190 records. Just so happens that the Meriden census table has 17 rows. But the data joined matches correctly. Getting closer. Thank you so much. I still dont see how to get the rest but its an improvement. I might need to spit the crime table into sections of 17 rows? Seems convoluted but should work.