Spatial Join gives <Null> to joined features

3377
6
Jump to solution
06-12-2018 07:47 AM
MiriamBelhaine
New Contributor

When I try to spatially join event data (points) and shapefiles (polygon) it does run, however, it displays the polygon attributes as <Null>. Both datasets cover the African continent. As far as I checked both files use the same coordinating system. 

This is what I inserted in the spatial join function:

Target features: point data (10,335 obs)

Join features: polygon data (816 objects)

Join one to one

Intersect / within etc. all give same result

Join_count gives me 0. Also, when I use the polygon data as target and point data as joined features the programme doesnt run at all and gives me: Invalid SQL syntax[near "IN": syntax error].

Anybody who knows what I am doing wrong?

Thanks!

0 Kudos
1 Solution

Accepted Solutions
JoeBorgione
MVP Emeritus

Perhaps you should export the xy events to an actual  feature class in a file geodatabase.  I also suggest when prompted for the spatial reference, select 'Layers' and your African Continent polygon as the reference.

That should just about do it....

View solution in original post

6 Replies
DanPatterson_Retired
MVP Emeritus

check the file 'extent' (left, right, top bottom) to confirm that the coordinate systems are the same.

If one is 'defined' wrong, then the extents may not overlap yielding no intersection/overlaps etc

MiriamBelhaine
New Contributor

They seem to overlap: 

0 Kudos
MiriamBelhaine
New Contributor

Do you know what else could be the problem?

0 Kudos
JoeBorgione
MVP Emeritus

Perhaps you should export the xy events to an actual  feature class in a file geodatabase.  I also suggest when prompted for the spatial reference, select 'Layers' and your African Continent polygon as the reference.

That should just about do it....
MiriamBelhaine
New Contributor

Thanks a lot, it worked! 

0 Kudos
XuanyeZuo221
New Contributor

I also have a similar issue. After projected the layers to same projection, it still didn't match perfectly with spatial join. Then I tried "intersect" function and it worked. Just want to point out this option.

0 Kudos