topic Re: How to join a .CSV to a .SHP to have a spatial location in ArcGIS Spatial Analyst Questions

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

JessicaO_Hanlon — Fri, 28 Jun 2019 18:34:41 GMT

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

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

DanPatterson_Retired — Fri, 28 Jun 2019 19:31:44 GMT

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

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

MehdiPira1 — Thu, 08 Aug 2019 06:24:16 GMT

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/