Show us your interesting discoveries!
- Thread starter Orvidius
- Start date
A lot of Class IV gas giants there. Is it a coincidence or there is something in these that either increases the probability of having rings or the probability of the rings being larger?The thing that's difficult about rings is that many of them are invisible, particularly the largest ones. I think it has something to do with the density of matter in them, but I don't think anyone has worked out an equation that reliably predicts whether the ring is rendered or not in-game. So pulling a list will probably give us some nice record largest + invisible rings.But having said that, here's a top-10 list:
Code:mysql> select planets.name Planet,subType,rings.name Ring,outerRadius/299792 as radiusLS,innerRadius,outerRadius,mass,type from planets,rings where planet_id=planets.id order by outerRadius desc limit 10; +--------------------------------+-----------------------+---------------------------------------+----------+-------------+-------------+-----------------+------------+ | Planet | subType | Ring | radiusLS | innerRadius | outerRadius | mass | type | +--------------------------------+-----------------------+---------------------------------------+----------+-------------+-------------+-----------------+------------+ | Col 107 Sector UY-Q b34-4 AB 3 | Class IV gas giant | Col 107 Sector UY-Q b34-4 AB 3 B Ring | 150.9947 | 7129100 | 45267000 | 39905000000000 | Icy | | Phroi Byoe ZT-Y d1-679 6 | Class IV gas giant | Phroi Byoe ZT-Y d1-679 6 C Ring | 133.0022 | 632440 | 39873000 | 6221100000000 | Icy | | Thaileia TM-A c2-0 7 | Class IV gas giant | Thaileia TM-A c2-0 7 C Ring | 131.0909 | 1547300 | 39300000 | 98900000000000 | Icy | | Ploi Aewsy AB-V d3-4 14 | Helium-rich gas giant | Ploi Aewsy AB-V d3-4 14 C Ring | 128.4624 | 6078500 | 38512000 | 29507000000000 | Metal Rich | | Swoiphs RL-J d10-47 9 | Class IV gas giant | Swoiphs RL-J d10-47 9 C Ring | 124.6231 | 926680 | 37361000 | 898880000000000 | Icy | | Koiju IR-M d7-2 11 | Class IV gas giant | Koiju IR-M d7-2 11 B Ring | 124.2061 | 3694300 | 37236000 | 160610000000000 | Icy | | Ellaisms QY-Z d13-12 8 | Class IV gas giant | Ellaisms QY-Z d13-12 8 C Ring | 123.3122 | 916920 | 36968000 | 268980000000000 | Rocky | | Traikeou RY-Q d5-1 10 | Class IV gas giant | Traikeou RY-Q d5-1 10 B Ring | 122.9286 | 23220000 | 36853000 | 13346000000000 | Icy | | Dryeia Prou TY-Z d3 B 4 | Class III gas giant | Dryeia Prou TY-Z d3 B 4 C Ring | 122.5716 | 1446800 | 36746000 | 13833000000000 | Icy | | Synuefuae RY-S d3-0 AB 1 | Class IV gas giant | Synuefuae RY-S d3-0 AB 1 C Ring | 121.6710 | 5744500 | 36476000 | 16241000000000 | Metal Rich | +--------------------------------+-----------------------+---------------------------------------+----------+-------------+-------------+-----------------+------------+ 10 rows in set (3 min 54.47 sec)
Thank you for the compliment. But I don't have any updated data any longer, since EDSM doesn't provide the bodies-file any longer. They have of course no obligation to do so. The last version I have is from November.
Them Class IVs being the heavier ones among GGs may be a contributing factor.
Ouch! The database is getting a bit big then
Yeah, and it wasn't even running a map+spreadsheet update yesterday either. I expect it to be even slower if it's running a bunch of other DB-heavy scripts at the same time, but that wasn't the case here. Of course, I don't have indexes on the radius columns though, and that might have helped in this case.
I don't store trojan status in the database, but the spreadsheet shows 101 of the known Trojans as being Ammonia Worlds.
Thankfully the body dump is back. The most recent one is from Feb 7.
Woohoo … The first time I wished I could like a post several times.
Thank you for telling me. I stopped looking after there wasn't an update for two months.
Yeah, and it wasn't even running a map+spreadsheet update yesterday either. I expect it to be even slower if it's running a bunch of other DB-heavy scripts at the same time, but that wasn't the case here. Of course, I don't have indexes on the radius columns though, and that might have helped in this case.
BTW, here's the table sizes currently:
Rings: 14,813,692 rows
Planets: 111,833,451 rows
I expected there to be a lot more rings. But it's those planets... So many of them!
What scares me is not the current number of rows, but the idea that only a tiny percentage of the galaxy is mapped. If there's a game update that allows us to explore more quickly, these databases that you all are being so kind to manage for the community won't be able to deal with the I/O.
Ouch! The database is getting a bit big then
Well, he did have to join on the two tables. And he may not have an index for this particular query
Nah, this just means more clever management with the table structures, indexes, and queries. ED data is tiny tiny compared to some of the commercial DBs.
Then you missed the discussion about my "quick question" on the previous page. Because those 15 moons amounts to the 15th one to having an "O"I don't recall ever seeing enough moons to get an O before...
. Pretty rare, but as Orvidius' table shows the record is 16 or a "P".Edit: Added an image of the system
Last edited:
I'm actually scanning a whole mass code D boxel for HRGGs and until now, most, if not all HRGGs I found and resemble a Class III giant look like the one below:
It is a normal Class III GG, not a HRGG though...
Yesterday I jumped into my second system of the day and crossed paths with this beast:
I landed on its closest moon (that was 4.1 ls away) and took another screenie:
A look at the sys map made me realize that it was my personal first "Blue" HRGG and the most beautiful GG I came across so far :
It is a normal Class III GG, not a HRGG though...
Yesterday I jumped into my second system of the day and crossed paths with this beast:
I landed on its closest moon (that was 4.1 ls away) and took another screenie:
A look at the sys map made me realize that it was my personal first "Blue" HRGG and the most beautiful GG I came across so far
:
Wow. I wonder if this is worth a GMP POI?I'm actually scanning a whole mass code D boxel for HRGGs and until now, most, if not all HRGGs I found and resemble a Class III giant look like the one below:
It is a normal Class III GG, not a HRGG though...
Yesterday I jumped into my second system of the day and crossed paths with this beast:
I landed on its closest moon (that was 4.1 ls away) and took another screenie:
A look at the sys map made me realize that it was my personal first "Blue" HRGG and the most beautiful GG I came across so far
View attachment 162790
O7 CMDR, I just submitted the planet as "Bilberry Helium Dream" to the GMP. I think it is definitely worth a try and even if it would not be added, it is something special to be found for me