I have an idea in my head, but need assistance in how to process my data to get the answers I need.
Restrictions: Where I work we use Esri products, and third-party packages and add-ins are prohibited, so packages such as R or QGIS are not available to me. Python or ModelBuilder are available.
Problem Statement: I have a nation-wide point data set with values (approximately 60k points). The higher the value, the more "important" the site. Nationally, a site may rank low, but I am interested in how that site ranks to those nearby it. The goal is to find the local "big dog" sites.
Minimum value is 0. In practice, the maximum value is 119, but the theoretical maximum value is unlimited.
I do not want to divide the analysis by state, county, or any other political boundary. That would provide a scenario whereby a site would ignore a nearby site just over a border. The question I am trying to answer is "How do I compare to all of the sites within X miles of me?"
I would like to have three columns in the table:
This is the existing value
2) National Percentile:
A normalized value between 0-100 that indicates rank nationwide
ex: 99; 50; 23
3) Local Percentile:
A normalized value between 0-100 that indicates rank locally
Ideally, I would like an assessment done for each point that selects all points within X miles and determines the percentile of that point for the set of points within X miles of that one. Let's assume X = 100 miles
ex: 99; 50; 23