topic Spatial Join in Python Questions

Spatial Join

DavidPike — Tue, 25 Feb 2020 22:55:29 GMT

I'm attempting to do a spatial join of polylines in desktop 10.4.1.

The join is against itself to create a join count field for features within the same feature class. I.e. the target is itself. I just want each polygon segment to have a join count I dont really care if theres overlapping segments.

The problem is that I seem to be losing records even though I have 'keep all' specified and this is also the default.

Thanks for your time.

Re: Spatial Join

BlakeTerhune — Wed, 26 Feb 2020 15:51:05 GMT

Could you post a sample (or representation) of your data? Also, if all you want is a count of distinct values in a field, have you considered using the Frequency tool?

Re: Spatial Join

DavidPike — Wed, 26 Feb 2020 18:55:47 GMT

Hi Blake thanks for your reply, unfortunately the dataset is at work.

I'm trying to count the number of exactly overlapping polyline geometries (road segments that have been crossed multiple times in a network analyst route) for some reason I get the correct join count appended but with missing rows. Keep all is enabled and an outer join.

I've got around this with a search cursor and geometry token but it seemed strange behaviour.

Re: Spatial Join

BlakeTerhune — Wed, 26 Feb 2020 21:10:42 GMT

Have you tried making a copy of the feature class to use in the spatial join instead of using the same input feature class twice?

Re: Spatial Join

DavidPike — Wed, 26 Feb 2020 21:16:36 GMT

That is actually an obvious and very good idea I haven't tried. I'll see if it works tomorrow!