topic Re: Summing point attributes using spatial join? in ArcGIS Pro Questions

Summing point attributes using spatial join?

MichaelMiller8 — Mon, 27 Mar 2017 18:45:44 GMT

This should be a simple thing but I have not been able to accomplish a spatial join summing two binary fields in a point feature class joined to a polygon feature class.

The join completes but the sums of the two binary fields as shown here are not calculated (resulting join fields = 0 for all polygons).

Ideas what I'm doing wrong?

Re: Summing point attributes using spatial join?

DanPatterson_Retired — Mon, 27 Mar 2017 19:50:03 GMT

did you really want to do a 'one to one' join? or are you trying to join many to one?

Re: Summing point attributes using spatial join?

MichaelMiller8 — Mon, 27 Mar 2017 20:09:37 GMT

Hi Dan. "Many to one" is not an option (tho, one-to-many is but not relevant) and my task aligns with the pop-up description of one-to-one.

Re: Summing point attributes using spatial join?

DanPatterson_Retired — Mon, 27 Mar 2017 20:20:24 GMT

you mean integer (or double with 0 decimals) when you say 'binary' field. and everything is in the same projection/coordinate system since I see nothing about projecting on the fly in the help topic. the field type and coordinate system are the only two things that I can think of given your screen grab

Re: Summing point attributes using spatial join?

MichaelMiller8 — Mon, 27 Mar 2017 21:03:17 GMT

Thanks Dan. Yes, join fields are long integers and I double-checked my coordinate systems and they match.

This is a bit frustrating. I already take many of my files to ArcMap for table joins and fields calcs. Pro is cool but I'm having time-soaking problems with pretty basic tasks.

Re: Summing point attributes using spatial join?

DanPatterson_Retired — Mon, 27 Mar 2017 21:21:55 GMT

That was my next suggestion... see if it works in Map... and make sure you are using pro 1.4.1 otherwise, I could check the 'issues addressed' list to see if this is indeed and issue and if it was fixed. report back in any event if you could.

PS 'contains' polygon contains point .... 'within' ... point in polygon just make sure that this is the right way around for your featureclasses

Re: Summing point attributes using spatial join?

MichaelMiller8 — Mon, 27 Mar 2017 22:27:52 GMT

Well, my problem was "solved" by exporting my target file to a shp and then performing the spatial join and table joining back to my original target feature class.

This export-to-shp-file trick has worked for me on several occasions involving spatial or table joins and field calculations, fwiw. Not an ideal situation, but after several hours wasted on a join, I'll take what I can get.