topic Re: unusual merge in Science Questions

unusual merge

GustavoAmadoRigatto — Tue, 23 Mar 2021 19:35:52 GMT

I need to reorganize my data.

to do this i need to merge points in a particular way.

i need to merge the data from points that have less records to the point with most records inside a 5 km buffer created around the latter.

the problem is that to generate that buffer i need to find all the "points with most records", but the "points with most records" is a locally determined, because i have to compare the data in a small scale.

and i dont know how to do any of that
(i don't even know if it is possible to do this in arcmap)

Re: unusual merge

VictoriaPhillips1 — Tue, 23 Mar 2021 19:53:21 GMT

Hi! Going to tag @DawnWright to see if she knows how to do this.

Re: unusual merge

VictoriaPhillips1 — Tue, 23 Mar 2021 19:56:33 GMT

Also going to tag @DavidPike !

Re: unusual merge

DavidPike — Tue, 23 Mar 2021 20:40:08 GMT

I would guess the 'most records' points would be highly dependant upon the order of the process. Probably talking about some multiple moving windows kind-of analysis to initially find the points you'll then buffer by, but I think it's non-trivial, but I may be wrong of course.

Also have no idea what 'most records' means for your points other than guessing it's a numeric attribute. Also not sure what the merge would be - is each point a separate feature class/shapefile, or are these points all within the same feature class? If so, would the merge also include combining/summing those attributes, or simply removing the non-maximum points in the 5km buffer?

Maybe if you explained the rationale behind doing this, others could offer up alternatives.

Re: unusual merge

VictoriaPhillips1 — Tue, 23 Mar 2021 22:27:03 GMT

Also, your question might get more traffic on the ArcMap Questions page! This page is mostly used for questions about scientific information and research but not technical GIS questions:)

Here's a link to the ArcMap page. Let me know if I can help in any other way!

https://community.esri.com/t5/arcmap-questions/bd-p/arcmap-questions

Re: unusual merge

GustavoAmadoRigatto — Wed, 24 Mar 2021 12:56:36 GMT

yeah it was difficult trying to explain. The technical terms gets me too (I am from brazil)

the "records" mentioned earlier are mammal sighting records in the atlantic forest, variables inside each point or number of lines inside a spreadsheet, and so the same shapefile.

I would like to, while merging the "non-maximum points" to "the most record point", erase the non maximum from the map.

I am analyzing the effect invasive mammals cause in native mammals, to do that I am using the data from a data set with a lot of points, which in many cases doesn’t correspond with that Community by itself, i.e. They could be resampling, so I need to merge the records in a 5km buffer of a point (the “most record point” by my adviser suggestion) to create an unique local comunnity point,
The problem is each “cluster” of points has its own “most record” point and I need a single point to analyze as the local mammal Community.

I hope it is more clear now

Re: unusual merge

GustavoAmadoRigatto — Wed, 24 Mar 2021 12:57:05 GMT

thanks!
I'll post there too!!