Added a spreadsheet for systems with rare quantities of the high-value planets (ELW, AW, WW). Mainly I wanted to see a list of known systems with 6+ WWs or 3+ ELWs, so this spreadsheet includes systems that score "6" or higher, via this equation:
score = 2*ELWs + WWs + AWs
Link: https://edastro.com/mapcharts/files/valuable-planet-systems.csv
At the moment this generates a list of 964 systems, with a lot of obvious hand-created ones in the bubble included.
In my day-job, we usually avoid doing large joins in a database, since it can be heavy-hitting on a production system when you have large data sets. But it's so useful here, I've had to give myself a refresher on the difference between INNER JOIN and LEFT JOIN in MySQL.
score = 2*ELWs + WWs + AWs
Link: https://edastro.com/mapcharts/files/valuable-planet-systems.csv
At the moment this generates a list of 964 systems, with a lot of obvious hand-created ones in the bubble included.
In my day-job, we usually avoid doing large joins in a database, since it can be heavy-hitting on a production system when you have large data sets. But it's so useful here, I've had to give myself a refresher on the difference between INNER JOIN and LEFT JOIN in MySQL.