Select to view content in your preferred language

spatial join result in empty records

4433
9
03-06-2018 09:15 PM
maherelayyan2
Emerging Contributor

Hi  i am trying to do SJ between a buffer poly with a road layer using the Spatial Join with match options

intersect or within a distance 

but it keep resulting in a one part of attributes filled and the other part from the second layer empty 

although both layers intersect with each other and they are within of this distance , any suggestions ? 

0 Kudos
9 Replies
DanPatterson_Retired
MVP Emeritus

Are both in the same coordinate system?

(projection-on-the-fly may give the illusion that their geometry intersects, when in reality they don't)

maherelayyan2
Emerging Contributor

Thanks i will check the projection 

0 Kudos
maherelayyan2
Emerging Contributor

I checked both have lambert projection system 

0 Kudos
maherelayyan2
Emerging Contributor

0 Kudos
DanPatterson_Retired
MVP Emeritus

Maher, have you then checked that they should be matched and do indeed overlap.

BTW I hope you are using the Extents of the file in its properties to assess what the coordinate system is and not its textual description... which could have been defined incorrectly.

0 Kudos
maherelayyan2
Emerging Contributor

Dan see this 

0 Kudos
DanPatterson_Retired
MVP Emeritus

Maher which is why I asked about the coordinate system check... 

If you make a small selection of that area, and use the Intersect tool, you should get a line where the polyline intersects the buffer.  If you don't, then they are in a different coordinate system.

What I suspect is happening is that your lines are continuous for the most pare and your buffere are disjoint and overlapping.  Perhaps the spatial join is assigning a buffer to a different polyline than you think..  For example what do you get for James Sea road?  I can see 4 possible buffers that could have been picked during a spatial join.  Which is why I think you may be getting those 'missing' values.  You can try to split your buffers and/or segment your lines if you need a more fine-grained association, or try an attribute join

maherelayyan2
Emerging Contributor

what do you mean by  split your buffers and/or segment your lines if you need a more fine-grained association

0 Kudos
DanPatterson_Retired
MVP Emeritus

You may need to add one to many in spatial join or

as they note hear, the Near table

it is possible that two or more join features are at the same distance from the target feature. When this situation occurs, one of the join features is randomly selected as the matching feature (the join feature's FID does not influence this random selection). If you want to find the 2nd, 3rd, or Nth closest feature, use the Generate Near Table tool.

or switch the order of the join until you get the data where you want it