This question already has an answer here:
I have a map with location of schools within districts. I was wondering if I can extract all fields of each data point within a polygon and how to go about doing it in ArcMap 10.5?
I produced this map by overlaying a district boundary map (shapefile) and a csv file of school attributes including XY coordinates of the schools. The file includes more than 60 fields for each school, including the XY coordinates.
What I want is a list of schools per district, including the 60 fields. For instance - schools_within_district_A.csv and schools_within_districtB.csv, and so on. If there are 20 schools within one district (one polygon), I would like to obtain the fields for the district. So basically this is equivalent to subsetting the overlayed data by one district.
I tried looking into spatial join, but this seems to find the sum of attributes per polygon. What I want is not the sum but all of the individual fields for each school for a selected district.