I’ve updated my ZipCodes database to work on Panorama X and updated the data itself to nearly 42,000 zip codes.
The database demonstrates three ways of working with zip codes and miles.
Distance Between Zips uses Find to locate a first zip code and get its coordinates. Then it Finds the second and calculates the distance bewteen them in miles.
Select a Radius uses Lookup equations to get the coordinates for a zip code, then selects all zip codes within a specified radius of the first.
Calculate Mileage also uses Lookup equations to acquire the coordinates of a zip code, then fills the Mileage column with the distance of every zip code from the first.
There are many more potential applications and methods possible. These are simply references for helping to get ideas to build from.
And thanks to David Thompson for the formula that is key to all of it working.