How to create a new joint layer from two separate layers containing different categories and lat/long coor points, and produce a .csv file from it
I have two layers in ArcMap. One contains flooding areas in a city, categorized by nuisance flooding (objectid 1 and represented by color yellow) and deep flooding (objectid 2 and represented by color purple). I also have another layer, containing street flooding complaints from residents in a given year (represented by the green box symbol, and utilizes lat/long coord from a .csv file). I want to create a new layer that only highlights the areas on the map that are deep flooding AND has flooding complaint(s) within the deep (purple) flooding area. Flooding complaints within nuisance (yellow) flooding or unshaded areas are to be excluded from this layer. Below is a screenshot of my current map:
In addition to that, I also want to create a .csv file that contains all areas that satisfy this condition, and returns the address (intersection, street name, etc.) of each location. I am not able to attempt this, however, because of the prior issue.
I attempted the Join and relate data option when selecting a layer. Specifically, the "Join data from another layer based on spatial location". However, when trying this, I was met with an error stating: "Source table must have an objectID column to perform a join by location". I think this is the option I want, although I am not sure if I'm choosing the right sub options or the files I've provided can satisfy the requirements to perform this operation.
Hi Jeff,
Yes, there is an objectID for each row for the nuisance and deep flooding layer. I've attached some screenshots for a closer look.
I was actually able to perform the spatial join operation (by right clicking on the flooding area to join and relate instead of the flooding complaints layer). However, the problem that remains now is that it is still treating both the nuisance and deep flooding as one, when I want only deep flooding to join with the flooding complaints. I am not sure how to only select the deep flooding object/ category
