I set out to look into the distribution of Earth-like worlds in the galaxy, to see if there are any regions where they are more frequent. I got the data for this from the EDDB and EDSM nightly dumps (I worked with the Aug. 26 dump), so the first thanks go to their respective teams: this much data wouldn't have been possible without them. Then, iain666 and Redfox helped me with a program to build an SQL database from the bodies JSON, so the second round of thanks go to them: that saved me a huge amount of work.
Thanks also to Ian Doncaster, for a bit of Unix help so that I could get the total systems calculation run more swiftly.
Lastly, for the newest versions (2019.05.30), thanks a lot to Orvidius as well! Those automated spreadsheets saved me a lot of work.
Rather than discard the characteristics (not really needed for the distribution), I instead them as well, to go over them later. So I compiled the characteristics of the Earth-likes and did some analysis on those too.
Before I go into things further, here's the data in two separate sheets:
The current version for 2019/05/30 is at https://docs.google.com/spreadsheets/d/1kkBLWH0vUad_fJoKEbmwCrNKGMCKN3qljTUT5maFW4E/edit?usp=sharing
An additional version containing separate data and charts for ringed ELWs: https://docs.google.com/spreadsheets/d/19Ba346EnduiQ879pAvhfPi25R_KZ4XhyNS3eueN9SsQ/edit?usp=sharing
An earlier version with ringed ELWs for 2018/05/30 is at https://docs.google.com/spreadsheets/d/14omEBNBTcbDVKHC5l5gS8ZB4vCR5jXGdldispB33F0E/edit?usp=sharing
The older version from 2017/08/26 is at https://docs.google.com/spreadsheets/d/1r0NM1dmTpon6ZBamjQYWMJlewcsQC4uD-El-zkuHbEs/edit?usp=sharing
Further analysis on per-ELW breakdowns for 2019/05/30 is at https://docs.google.com/spreadsheets/d/1eG_PRhJEXIEfWUiQNBel4VIrN4HpFRyS6BzS7aOVrww/edit?usp=sharing. Note that this doesn't include the ELW data itself, just the results: Google Sheets couldn't handle that many data. It does, however, include ringed ELW data. If somebody would like the data too, send me a PM and I'll send it over.
An earlier per-ELW breakdown for 2018/05/30 is at https://docs.google.com/spreadsheets/d/1t-6w0X71LX6-GbOIL4-ag23LSe5DVbGMI0lxQ7o5QS8/edit?usp=sharing. It contains coordinates, and rudimentary map-charts rendered from them.
The full detailed planetary data (with statistics) for 2017/08/26 is at https://docs.google.com/spreadsheet...H-MPIak3LjdpVJnYsRQPA5lcHc/edit#gid=353619881.
I've removed terraformed Earth-likes from both lists, as well as ones in non-procedural star systems. Those might still be created with the regular Forge generation, but I wanted to be sure.
Also, there were some ELWs with value errors: I removed those from the second list, but not the first.
Missing is any information on rings, and moons aren't included either. Perhaps those will come later. But first, I'll look into how things differ in different mass codes (if they do at all).
About the distribution of Earth-likes:
About the characteristics of Earth-likes:
As I mentioned, I'll look into more things later. Right now, I'm looking at doing subsets based on mass codes, and separating Earth-like moons too. Once I do and find anything interesting, I'll post it in this thread again.
Thanks for reading! If you spot any errors, do let me know!
Thanks also to Ian Doncaster, for a bit of Unix help so that I could get the total systems calculation run more swiftly.
Lastly, for the newest versions (2019.05.30), thanks a lot to Orvidius as well! Those automated spreadsheets saved me a lot of work.
Rather than discard the characteristics (not really needed for the distribution), I instead them as well, to go over them later. So I compiled the characteristics of the Earth-likes and did some analysis on those too.
Before I go into things further, here's the data in two separate sheets:
The current version for 2019/05/30 is at https://docs.google.com/spreadsheets/d/1kkBLWH0vUad_fJoKEbmwCrNKGMCKN3qljTUT5maFW4E/edit?usp=sharing
An additional version containing separate data and charts for ringed ELWs: https://docs.google.com/spreadsheets/d/19Ba346EnduiQ879pAvhfPi25R_KZ4XhyNS3eueN9SsQ/edit?usp=sharing
An earlier version with ringed ELWs for 2018/05/30 is at https://docs.google.com/spreadsheets/d/14omEBNBTcbDVKHC5l5gS8ZB4vCR5jXGdldispB33F0E/edit?usp=sharing
The older version from 2017/08/26 is at https://docs.google.com/spreadsheets/d/1r0NM1dmTpon6ZBamjQYWMJlewcsQC4uD-El-zkuHbEs/edit?usp=sharing
Further analysis on per-ELW breakdowns for 2019/05/30 is at https://docs.google.com/spreadsheets/d/1eG_PRhJEXIEfWUiQNBel4VIrN4HpFRyS6BzS7aOVrww/edit?usp=sharing. Note that this doesn't include the ELW data itself, just the results: Google Sheets couldn't handle that many data. It does, however, include ringed ELW data. If somebody would like the data too, send me a PM and I'll send it over.
An earlier per-ELW breakdown for 2018/05/30 is at https://docs.google.com/spreadsheets/d/1t-6w0X71LX6-GbOIL4-ag23LSe5DVbGMI0lxQ7o5QS8/edit?usp=sharing. It contains coordinates, and rudimentary map-charts rendered from them.
The full detailed planetary data (with statistics) for 2017/08/26 is at https://docs.google.com/spreadsheet...H-MPIak3LjdpVJnYsRQPA5lcHc/edit#gid=353619881.
I've removed terraformed Earth-likes from both lists, as well as ones in non-procedural star systems. Those might still be created with the regular Forge generation, but I wanted to be sure.
Also, there were some ELWs with value errors: I removed those from the second list, but not the first.
Missing is any information on rings, and moons aren't included either. Perhaps those will come later. But first, I'll look into how things differ in different mass codes (if they do at all).
About the distribution of Earth-likes:
The maps on this sheet are based on EfilOne's masscode sectors map.
To me, it looks like we don't have enough data for anything conclusive yet. From what we do have though, I'd say that significant differences between regions are unlikely. When looking at the ratios between known ELWs and known systems, sectors of special interest stand out, especially the places where players can dock and sell their data. Just take a look at the Eol Prou sector. (If the vicinity of the bubble weren't carved up with all those non-procedural sector overrides, it would likely be the same.)
Basically, the places stand out where players have searched for Earth-likes or done detailed surveys, as opposed to areas where most people just travelled through. Of course, the Sol-Sag. A*-Jaques lines are still significant.
Also, the ratio is only calculated for sectors which have more than ten known ELWs and one thousand known systems. You can easily adjust both values in the top row (if you make a copy of the sheet), and experiment with how things would look like with other limits.
Rather than looking at the entire galaxy, I think it would be better to look at thorough surveys of specific sectors, in different regions of the galaxy. (Some near the edges, others in the core, and so on.)
To me, it looks like we don't have enough data for anything conclusive yet. From what we do have though, I'd say that significant differences between regions are unlikely. When looking at the ratios between known ELWs and known systems, sectors of special interest stand out, especially the places where players can dock and sell their data. Just take a look at the Eol Prou sector. (If the vicinity of the bubble weren't carved up with all those non-procedural sector overrides, it would likely be the same.)
Basically, the places stand out where players have searched for Earth-likes or done detailed surveys, as opposed to areas where most people just travelled through. Of course, the Sol-Sag. A*-Jaques lines are still significant.
Also, the ratio is only calculated for sectors which have more than ten known ELWs and one thousand known systems. You can easily adjust both values in the top row (if you make a copy of the sheet), and experiment with how things would look like with other limits.
Rather than looking at the entire galaxy, I think it would be better to look at thorough surveys of specific sectors, in different regions of the galaxy. (Some near the edges, others in the core, and so on.)
About the characteristics of Earth-likes:
This was in part inspired by Sapyx's recent thread. It's interesting to compare how things differ on this larger sample.
I included only two histograms as examples, since Google Sheets can't really run more with this much data, but it's interesting to see others too. You can easily modify them to show others: just change the range.
Seems like smaller Earth-likes happen to be more popular with the Stellar Forge. Especially interesting is how the universe seems to hate ELWs with gravities around 0.86-0.92 g. Likely an effect of how they are generated - and I wonder if there are two (or more) "types" of how this happens. I'll try to see if this might be due to differences between mass codes.
Speaking of gravity, there doesn't appear to be a hard limit for it (like for temperatures): instead, it's likely controlled indirectly by other variables. Namely that the atmosphere has to be breathable.
Also, speaking of the Forge hating things, note how rare eccentric orbits are for ELWs. Little wonder though.
As for volcanism, there were six Earth-likes with nitrogen volcanism, and one with water magma volcanism. I'd check these for possible bugs, especially the water one. Sadly, it's not on the ELW list.
A bit of trivia: the farthest distance a Commander had to fly to an ELW was 660k ls. Right on, Commander Goemon!
I included only two histograms as examples, since Google Sheets can't really run more with this much data, but it's interesting to see others too. You can easily modify them to show others: just change the range.
Seems like smaller Earth-likes happen to be more popular with the Stellar Forge. Especially interesting is how the universe seems to hate ELWs with gravities around 0.86-0.92 g. Likely an effect of how they are generated - and I wonder if there are two (or more) "types" of how this happens. I'll try to see if this might be due to differences between mass codes.
Speaking of gravity, there doesn't appear to be a hard limit for it (like for temperatures): instead, it's likely controlled indirectly by other variables. Namely that the atmosphere has to be breathable.
Also, speaking of the Forge hating things, note how rare eccentric orbits are for ELWs. Little wonder though.
As for volcanism, there were six Earth-likes with nitrogen volcanism, and one with water magma volcanism. I'd check these for possible bugs, especially the water one. Sadly, it's not on the ELW list.
A bit of trivia: the farthest distance a Commander had to fly to an ELW was 660k ls. Right on, Commander Goemon!
Thanks for reading! If you spot any errors, do let me know!
Last edited: