Relate CSV table to a Point Feature Class

Question

I have a location point feature for wine production facilities and a csv table that shows the total, red, and white grapes received in tons. I want to join the csv table to the production points by facility name. However, I need to be able to summarize the total tons received, red tones received and white tons received by year in the final point feature class. I created a one to many relationships but I am having trouble with the next steps. How can I isolate the different grape varietals and still visualize and symbolize the tons received for each year in the table?

Thanks!

JoeBorgione · Answer

Visualizing related data is a topic that comes up from time to time.  See https://community.esri.com/thread/200210-symbolize-based-on-related-data among others.  I don't know you can do it straight up: the link above points to another link where the answer is to create a view of the data.  That's way more than a desktop type of procedure.

FrancisHourigan1 · Answer

I have added the excel table to the geodatabase where the point features live. I used the excel to geodatabase tool in ArcGIS Pro. However, I still have the problem with the One to Many relationship. I cannot share proprietary data but I can outline the format. Each point in the Point Feature has a location name. Let's use Shasta as an example. Within the table, I have a column that has Shasta listed multiple times because each year that location was delivered X amount of grapes (in tons) and each year those tones are broken down by REc, White, and Total.

2000  |   Shasta  |  Total = 100 tons

Red = 50 Tons

White = 50 tons

2001  | Shasta | Total = 100 tons

Red = 50 Tons

White = 50 tons

Etc....

I want to relate the table to the point feature with Shasta as the Primary Key but I also want to be able to access the related table information in Pro so that I can filter or symbolize by Red or White tons or total tons.

Hopefully, that is a little more clear?

DanPatterson_Retired · Answer

Whatever you plan to do, convert/save the csv file as a geodatabase table... much like excel files, text, csv files have their limits within the geodatabase environment.