topic Re: ARC GIS won't let me join data in Data Management Questions

ARC GIS won't let me join data

ChaseBergklint — Sun, 27 Jan 2019 04:45:00 GMT

I have a shape file of all the counties in the United States and data from the 208-2016 United States Presidential Elections. I am trying to join the data so that when I click on the county name, the results for the election will show. I have tried joining by the FIPS code but that doesn't help.

Here is the data if you think you can help me:

Re: ARC GIS won't let me join data

DanPatterson_Retired — Sun, 27 Jan 2019 12:57:16 GMT

rather than post the large files, perhaps you can just do a screen grab of the two tables that show the fields you are trying to use in the join.

fields must be of the same type (number or text)
if one field is text and the other is numeric, then you need to create a new field to use in the join and convert it to text using the field calculator
values in the fields must have exact matching pairs
matching pairs for text would include their case ( 'owner' doesn't equal 'Owner')
partial matches aren't any good

Covers most problems when people are trying to formulate joins

Re: ARC GIS won't let me join data

ChaseBergklint — Mon, 28 Jan 2019 02:51:43 GMT

I got a screenshot. I am trying to link the United States Counties layer and the election results (either csv 1 or 2). Both layers have the fips codes and county names.

Re: ARC GIS won't let me join data

Asrujit_SenGupta — Mon, 28 Jan 2019 04:25:10 GMT

The Excel sheet name in your screenshot and the one attached to your original post, don't seem to be the same.

Anyway, as Dan mentioned, you need to make sure the fields you are joining, should have the same Data Type. The Esri Counties data, has FIPS as String(Text), however the one in the excel you show in the screenshot has Long Int. So that join won't work.

I added a new Column in the Counties Shapefile, FIPS_Num, populated the FIPS code in it from the existing FIPS Code field and that allows the join.

Re: ARC GIS won't let me join data

TedKowal — Mon, 28 Jan 2019 15:51:52 GMT

FYI -- Tip --

For those of you who do not know -- The first 8 Rows of an excel spreadsheet determines the datatype... so if you have rows of number but have one blank or text character within the first eight rows that column will be treated as text....in esri ...

Re: ARC GIS won't let me join data

ChaseBergklint — Tue, 05 Feb 2019 00:30:35 GMT

Thank you for your help. I have tried numerous ways but I can't get the join to work. Do you still have the file?

Thanks for your help.

Re: ARC GIS won't let me join data

JoeBorgione — Tue, 05 Feb 2019 01:25:33 GMT

Ditch the csv and use real tables in a file geodatabase.

Re: ARC GIS won't let me join data

Asrujit_SenGupta — Tue, 05 Feb 2019 07:18:18 GMT

I do have it...check if this helps..

Re: ARC GIS won't let me join data

ChaseBergklint — Thu, 28 Feb 2019 22:35:48 GMT

I am using the 2010 population as a benchmark for whether a county is rural (2,499 or less), suburban (2500-49,999) and urban (50,000 or more). Is there a way in ARCGIS to make a formula that will automatically divide the counties up?

Re: ARC GIS won't let me join data

JoeBorgione — Thu, 28 Feb 2019 22:46:22 GMT

Drawing features to show quantity by category—Help | ArcGIS Desktop

Symbolization—ArcGIS Pro | ArcGIS Desktop

Re: ARC GIS won't let me join data

DanPatterson_Retired — Sat, 11 Dec 2021 17:51:22 GMT

def classify(val):
    """ """
    if val < 25000:
        return 'A'
    if 25000 <= val <= 50000:
        return 'B'
    return 'C'
    

vals = [24000, 49000, 100000]

[classify(val) for val in vals]
Out[76]: ['A', 'B', 'C']‍‍‍‍‍‍‍‍‍‍‍‍‍

if you don't want to symbolize, you can reclassify

Add a text field

'classify' is your code block (change thresholds and return values as appropriate)

python parser

call you function using

classify(!YourFieldName!)

in the expression... obviously keep the ! marks and just change the fieldname

Re: ARC GIS won't let me join data

ChaseBergklint — Sun, 07 Apr 2019 04:45:47 GMT

I am trying to join Presidential Election data from 2008-2016 from the county level to a shapefile depending on what region they are in. What would I join them to?