I'm trying to use Spatial Join to join my point data with my polygon data. I'm trying to associate points (representing housing resale sites) into polygons (subzones in a country). My goal is to calculate the mean of all these resale points and associate them into a polygon subzone using Spatial Join.
Here's what I've been doing so far:
1) Target Feature - the polygon shapefile which demarcates the subzones
2) Join Features - the layer with the points (resale price per square foot, or resale_psf)
3) Join Operation - one to one
4) Field Map of Join Features - I added a new field called "resale_mean", which computes mean using the source "resale_psf" using the Merge Rule option
5) Match Option - Intersect
I'm getting these errors:
ERROR 999999: Error executing function.
An invalid SQL statement was used.
The table was not found. [MP14_SUBZONE_NO_SEA_PL_Spati1]
Failed to execute (SpatialJoin).
I'm not sure if it's due to differing coordinate systems, although both points and polygon show up on the map just fine.
My points have long/lat values such as
And my shapefile has X_ADDR and Y_ADDR such as
31710 and 38310
And both are in the same area
Any advice would be appreciated. Thank you!