[GIS] Joining .csv with shapefile in ArcGIS Desktop

arcgis-desktoparcmapattribute-joinscsv

I'm trying to join a .csv file with a shapefile in ArcGIS. In both the files theres a column named BlockID that are going to be joined the joined attribute between the two files. My problem is that when I do the join validaton it gets stuck at "counting the number of matchingrecords for the join" and after a while it says that the join is cancelled. I have done joins before, big ones like the one I'm doing this time, and never had this problem.

Does anyone know what might be the reason why the validation just cancels?

Best Answer

If you're working in ArcGIS, try this:

  1. Create a new file geodatabase
  2. Import your shapefile into the .gdb
  3. Import your csv into the .gdb (ensure the data types for your fields match those of the imported shapefile that is now a feature in a geodatabase while you're working with the import settings, use the field map window)
  4. Trying joining again

Sometimes csv's and shapefiles get a bit unpredictable in ArcGIS. Since a geodatabase is a proprietary database, anything within a geodatabase tends to operate more smoothly in ArcGIS. Once you do all your processing, you can always export your results out of the geodatabase.

Related Question