I already tried to find the solution for my problem in any of the previous answers for similar problems, but none of it works for me.
I have two polygon shapefiles and would like to do a spatial join based on a certain field.
One polygon shapefile contains count-data for different dates. Each polygon refers to a certain date, but there could be several polygons for the same date at different locations. Each polygon is in a different row, so the date is also shown in rows.
Then I have a second polygon shapefile containing the cropstatus for different fields (parcels) at different dates of the year. The different fields (parcels) and corresponding information are listed in rows and the date with the corresponding cropstatus is in columns.
Now I would like to spatially join the count-data polygons with the cropstatus polygons based on a certain date (using the centerpoint of the count-data polygons). The result should be a new file with all count-data-polygons having a certain cropstatus at the appropiate date.
Unfortunately, I don't have any experience with Python scripting.
I'm using ArcGIS 10.2 and Windows 7
Here is an example of my data:
Pink circles/ellipses are birdcounts on different days and/or areas, and the filled polygons indicate different fields (parcels). Different colours have different cropstatus/fieldstatus.
And here are examples of my attribute tables:
These are the bird counts with polygons for different days and/or areas (Antal...=Number of birds).
This is the attribute table of the cropstatus. The different fields (parcels) are in lines and the date of the field status is in columns (fields).
Both attribute tables have much more columns than shown here with further information. Also, the dates for the cropstatus range from 13.Sept.2013 to 31.Dec.2013, so Johns suggestion of spatially joining each date separately will take too long.