nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I take a median value every 100 m along a points file?

EllenPatrick

I have air pollution measurements taken throughout cities along bus routes that I need to display on my maps with the data aggregated into set distance segments. Right now when I map the raw data I have points throughout the cities from data collected every 10 seconds. Is there a simple tool I can use that will take the median and/or mean value every 100 m, for example?

Najděte více příspěvků označených jako

Accepted answers

All comments

DanPatterson_Retired

no builtin tool, but I can definitely think of an approach.

I suspect that your points aren't spaced 100 m apart... that would be too easy.

And just to clarify, you just want the value at each 100 m spacing and not a rolling/moving/sliding window median over a 100 m interval?

Can you describe or provide a sample of your point data.

How comfortable are you with a python solution?

EllenPatrick

No they're not currently spaced any set distance, they were collected every 10 seconds so the spacing is quite random. I don't need a rolling median, just a single median for every set distance. Essentially I just want to clean up my map (picture below) so that it's not just a blur of points. I know some people I worked with go along and draw fixed length polygons the entire length of the route and then join the points to each polygon and find the median value that way, but surely there has to be a more simplistic method because drawing out polygons for an entire city is no simple task.

I've touched on Python through the GIS courses I took, but I have not used it in any of my analysis.

Sample Map

DanPatterson_Retired

If you have the appropriate license, why not convert the points to polyline, assuming that they are sequential. Once you have the polyline, there are a variety of things to do. Perhaps you could fill in that detail before I make other suggestions. If the data are being collected in a gps, then there is software that will convert directly

Advise and we can go forward

EllenPatrick

I have the complete advanced ArcGIS license. The coordinates were collected in GPS so each point has a corresponding GPS coordinate.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.