Hello there, 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 1.353138 103.9379173 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! Bryan
... View more
