AnsweredAssumed Answered

Newbie issue with Spatial Join (points into polygons)

Question asked by mahrnhan on Apr 13, 2018
Latest reply on Apr 14, 2018 by Dan_Patterson

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.353138103.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

Outcomes