I have about 50,000 rows of wells, each has a lat/long associated with it. I want to have a square box around each well with a list of all of the other wells that are within that box. I.e. I want to have a list for each well of other wells that are close to it. For example if one is 51.9640/111.1443 and another is 51.9641/111.1461 then they would be in the same "box". Seems like this would be something that's easy to do in SQL but I'm not too familiar with it.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Attached example
What is the determination for close? Two decimal places? Close in Latitude? Close in Longitude? Need to understand the criteria for what you consider close?
Let's say if the lat and long are each within one thousandth of each other
I used power query to match the data as specified in post #5.
1. I loaded the orginal data to the Power Query Editor. On the Data Tab, Get and Transform Data, From Range/Table
2. In the PQE, I split the Long from the Lat and rounded each to 3 decimal places
3. I then duplicated the query and joined them on the lat and long
4. Removed the rounded columns from the merged query
5. Closed and Loaded Data to Excel
6. See attached file to review.
I hope this works for you. You can band the rows as needed.
The resulting file is to large to post here, so I have loaded it to Box.net. You may access it at this link
https://app.box.com/s/6a7ob2p47f9o0d6rsjz244hemabhnro8
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks