Select to view content in your preferred language

How to join a .CSV to a .SHP to have a spatial location

4267
2
06-28-2019 11:34 AM
JessicaO_Hanlon
New Contributor

I am trying to associate data (.csv file) with a spatial location (.shp file). Both attribute tables include a zip code which I am trying to join them by. In addition, the are multiple rows of data associated with a zip code. How do I apply the spatial location of the zip code to each entry? Thanks

Joining (.shp):                To the data (.csv):                    So that each .shp 1, 2, 3 apply to each entry applicable 

               1                                 3 data                                                      

               2                                 2 data

               3                                 3 data           

                                                  1 data

                                                  2 data

2 Replies
DanPatterson_Retired
MVP Emeritus

 convert the csv to a file geodatabase table, then check the contents of the joining field to make sure they are indeed common (numbers are right justified, text left, but numbers can look like text if they aren't translated properly.

A many to one is a relate, not a join.

Do a screen grab of the two tables when you get things in order for the join

MehdiPira1
Esri Contributor

Dan is right. One to Many relationship is a relate not a join. Here are some useful links that explains better:

http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/about-joining-and-relating-tables.htm

https://gisgeography.com/relate-vs-join-attribute-tables-arcgis/