topic Re: Join by attribute - not joining random cells in ArcGIS Pro Questions

Join by attribute - not joining random cells

KK2 — Mon, 07 Jun 2021 09:52:42 GMT

I am trying to join an attribute from a *.csv table to a polygon shapefile by using: Join and Relates > Join (by attribute), where I use id attribute as an indicator to join. However, the join does not work for the entire dataset well. After correct processing of some part of data it is joining only every second polygon in my dataset and sett value null to the rest (see attachment where I hatched the polygons where the join function does not join the values to the polygons).

My input data are fine and the id indicator exists in both datasets where the function does not want to join the value. What can still be wrong? Is there a limit to perform join? I have 300 000 polygons and the same number of cells in my csv table to join.

Re: Join by attribute - not joining random cells

JayantaPoddar — Mon, 07 Jun 2021 10:32:16 GMT

I would recommend importing the CSV and shapefile to File Geodatabase, to overcome any constraint linked to shapefiles (the data size could be huge considering the number of records).

First, create a File Geodatabase table from the CSV using Table to Table (Conversion) .

Also import the shapefile to the File GDB Feature Class To Feature Class (Conversion) .

Try a Join now Add Join (Data Management) .

Re: Join by attribute - not joining random cells

JonathanMcDougall — Mon, 07 Jun 2021 10:42:25 GMT

Just to second @JayantaPoddar , important this work is done within a flegeodb feature class importing the Shapefile to Feature Class and importing the CSV as a table.

Re: Join by attribute - not joining random cells

KK2 — Mon, 07 Jun 2021 12:31:08 GMT

Thank you for your answer. The solution proposed by you works perfectly, so I think it had an issue with the number of records in my data.

Re: Join by attribute - not joining random cells

JayantaPoddar — Mon, 07 Jun 2021 13:40:56 GMT

Glad it worked.

Size limitation could be a cause.

Shapefile limit = 2 GB

File Geodatabase Feature Class limit = 1 TB (can be further extended to 256 TB using configuration keyword)

Here are a few good articles that discusses the benefits of File Geodatabase over shapefiles.

The Top 9 Reasons to Use a File Geodatabase

Geoprocessing considerations for shapefile output

Re: Join by attribute - not joining random cells

JonathanMcDougall — Mon, 07 Jun 2021 13:46:32 GMT

Yeah, I stopped using shapefiles years ago - always better to use a feature class. I realise a shapefile can still be required elsewhere, however, for any of your won work feature classes within a filegeodb is the way to go.