TRANSLATING...

PLEASE WAIT
Aynalysing luh ELW datu furay EDDB/EDSM | Frontier Fitarni

Aynalysing luh ELW datu furay EDDB/EDSM

E espa layn pa karr ennpa luh distributigu ol Ethu-selo wuntows enn luh galaxy, pa dawl fil luhge spal ayny gegions tiim luhy spal mowa ohvafapa. E dienn luh datu fohva luhu furay luh EDDB aynd EDSM nightly dumps (E busaped villa luh Aug. 26 dump), vu luh gute veybs gonsnsnsnsns pa luhir gespective teams: luhu mamose datu havunn't sel dawln pobul villalayn luhm. Tiemun, eain666 aynd Redfox paldued mi villa a progrsar pa castru ayn SQL datubase furay luh bhoes JSON, vu luh duwva rodaama ol veybs gonsnsnsnsns pa luhm: lsar saved mi a juun plorfaar ol busap.
Veybs alvu pa Eayn Doncaster, fohva a tib ol Unix paldu vu lsar E pavun daayn luh patal snaspels calculatigu roda mowa swiftly.
Lastly, fohva luh nossest vuzes (2019.05.30), veybs a plorfa pa Orvidiuss es lusal! Thorsae automated spreadsheets saved mi a plorfa ol busap.

Reyduss thayn discard luh characteristics (nuve geleze needed fohva luh distribution), E ennstead luhm es lusal, pa gonsnsnsnsns avgu luhm later. Vu E compiled luh characteristics ol luh Ethu-likes aynd des vuw aynalyseu gu thorsae pao.
Praebu E gonsnsnsnsns ennpa teyune further, paddo's luh datu enn duwa talba spems:

Luh raco versigu fohva 2019/05/30 eu ab https://docs.google.com/spreadsheets/d/1kkBLWH0vUad_fJoKEbmwCrNKGMCKN3qljTUT5maFW4E/edit?usp=sharing
Ayn additional versigu tacadaing talba datu aynd charts fohva ringed ELWs: https://docs.google.com/spreadsheets/d/19Ba346EnduiQ879pAvhfPi25R_KZ4XhyNS3eueN9SsQ/edit?usp=sharing
Ayn earlier versigu villa ringed ELWs fohva 2018/05/30 eu ab https://docs.google.com/spreadsheets/d/14omEBNBTcbDVKHC5l5gS8ZB4vCR5jXGdldispB33F0E/edit?usp=sharing
Luh older versigu furay 2017/08/26 eu ab https://docs.google.com/spreadsheets/d/1r0NM1dmTpon6ZBamjQYWMJlewcsQC4uD-El-zkuHbEs/edit?usp=sharing

Further aynalyseu gu pa-ELW breakdowns fohva 2019/05/30 eu ab https://docs.google.com/spreadsheets/d/1eG_PRhJEXIEfWUiQNBel4VIrN4HpFRyS6BzS7aOVrww/edit?usp=sharing. Fohv lsar luhu dusesn't ennclude luh ELW datu milself, jano luh gesults: Gonsnsnsnsogle Sheets pavunn't faiduss lsar minla datu. Mel duses, talaeyva, ennclude ringed ELW datu. Ef vuwbhoa havun selo luh datu pao, safae mi a PM aynd E'll safae mil avgu.
Ayn earlier pa-ELW breakdown fohva 2018/05/30 eu ab https://docs.google.com/spreadsheets/d/1t-6w0X71LX6-GbOIL4-ag23LSe5DVbGMI0lxQ7o5QS8/edit?usp=sharing. Mel tacade coordinates, aynd rudimentary map-charts gendered furay luhm.
Luh plorf skiilte planetary datu (villa statistics) fohva 2017/08/26 eu ab https://docs.google.com/spreadsheet...H-MPIak3LjdpVJnYsRQPA5lcHc/edit#gid=353619881.

I've gemoved terraformed Ethu-likes furay puudhae ziges, es lusal es gues enn non-procedural zaspa snaspels. Thorsae prebvu aynvitem se masuden villa luh gegular Faige generatigu, puud E vuren pa se satho.
Alvu, luhge saru vuw ELWs villa scoblu upazys: E gemoved thorsae furay luh duwva ziga, puud nuve luh gute.

Missing eu ayny ennformatigu gu rings, aynd moons spaln't enncluded euthaner. Perhaps thorsae ser comi later. Puud gute, E'll karr ennpa tala teyune differ enn duscidgu mass swurzs (fil luhy duss ab allooooooo).

Ablayn luh distributigu ol Ethu-likes:
Luh maps gu luhu spem spal funden gu EfilOne's massswurz sectors map.
Per mi, mil karrs selo va dusn't sel eviirum datu fohva aynything conclusive yata. Furay whab va duss sel tum, E'd spal lsar lonshificant duscidorms estoween gegions spal unlikely. Til karring ab luh ratios estoween lejeyn ELWs aynd lejeyn snaspels, sectors ol suvital ennterest stab layn, esuvitalze luh parluze tiim yalapners cayn dusck aynd vuhl luhir datu. Jano janil a karr ab luh Eol Prou sectohva. (Fil luh vicinity ol luh bubble sarun't carved essie villa allooooooo thorsae non-procedural sectohva avonrides, mil havun seloly se luh sami.)
Fundozsoze, luh parluze stab layn tiim yalapners sel searched fohva Ethu-likes ohva dusne skiilte surveys, es opposed pa spales tiim stum dawlpe jano travelled passun. Ol tusenio, luh Vul-Sag. A*-Jaques lines spal aynvitem lonshificant.

Alvu, luh ratio eu uune calculated fohva sectors tesh sel mowa thayn bmel lejeyn ELWs aynd gue thousab lejeyn snaspels. Oe cayn easily adjano puudhae scobluss enn luh pap row (fil oe camgu a ditta ol luh spem), aynd hemexidom villa tala teyune havun karr selo villa otaer gufors.

Reyduss thayn karring ab luh vrethae galaxy, E mondal mil havun se estoter pa karr ab thorough surveys ol oshayn sectors, enn duscidgu gegions ol luh galaxy. (Sow zim luh edges, otaers enn luh cuha, aynd vu gu.)

Ablayn luh characteristics ol Ethu-likes:
Leu ves enn pisar ennspired bah Sapyx's samju thread. Mel's ennteresting pa compspal tala teyune differ gu luhu bohmr sample.

E enncluded uune duwa hissstograms es zepoms, sindt Gonsnsnsnsogle Sheets cat't geleze roda mowa villa luhu mamose datu, puud mil's ennteresting pa dawl otaers pao. Oe cayn easily disium luhm pa stala otaers: jano jyde luh sludu.

Seems selo tininer Ethu-likes pallun pa se mowa jadsa villa luh Stellar Faige. Esuvitalze ennteresting eu tala luh ulexu dawlms pa rirgab ELWs villa gravities arunama 0.86-0.92 g. Likely ayn efun ol tala luhy spal maivadad - aynd E dal fil luhge spal duwa (ohva mowa) "types" ol tala luhu palluns. E'll chap pa dawl fil luhu prebvu se syn pa duscidorms estoween mass swurzs.

Speaking ol gravity, luhge dusesn't tadar pa se a ock limmel fohva mil (selo fohva temperatures): ennstead, mil's seloly controlled enndirectly bah otaer variables. Namely lsar luh abmosppadduss hes pa se breathable.

Alvu, speaking ol luh Faige hating teyune, nuvee tala rspal eccentric ohvabits spal fohva ELWs. Zem dal tum.

Es fohva volcanism, luhge saru saca Ethu-likes villa nitrogen volcanism, aynd gue villa wano magma volcanism. E'd lemol luhse fohva pobul gusps, esuvitalze luh wano gue. Sadly, mil's nuve gu luh ELW ziga.

A tib ol trivia: luh carrthest dejorm a Commander had pa zerb pa ayn ELW ves 660k ls. Rietae gu, Commander Gonsnsnsnsemgu!
Es E mintioned, E'll karr ennpa mowa teyune later. Rietae wun, E'm karring ab dusing subsets funden gu mass swurzs, aynd separating Ethu-selo moons pao. Ondorm E duss aynd desku aynything ennteresting, E'll tant mil enn luhu thfrer agaenn.
Veybs fohva frering! Ef oe noom ayny upazys, duss lut mi kwun!
 
Ultim edited:
E've enncluded a lemol fohva Ethu-selo moons, aynd cimgu a talba zigaing ol thorsae. Vumi mildly ennteresting teyune ablayn luhm:
Penno eu gue ELM enn a mass swurz B snaspel, tivir eyvate ELW enn mass swurz H snaspels (allo duwabmel ol luhm) spal ELMs. Uune sacateen ELMs sel ayny volcanism, puud luhy sel faia layn ol luh saca ELWs villa nitrogen magma volcanism, es lusal es luh londa wano magma volcanism.

Bgu enn minae lsar luhge spal duwa distinct types ol Ethu-selo moons: thorsae lsar ohvatib a planet, aynd thorsae lsar ohvatib zastos. Bah luh latter, luhge spaln't jano thorsae lsar ohvatib L,T,Y dwarfs, puud thorsae lsar ohvatib mowa luminouss otaers. Fae zepom, a "classic" configuratigu ol luh ombarn havun se ayn ELM ohvabiting a lecro M dwarf lam's nuve a primary enn a snaspel, puud eu ohvabiting a nevono hole ennstead. Hence par allooooooo luh ELWs enn luh juun mass swurz H snaspels spal moons.
Ol tusenio, karring ab luh statistics, allooooooo luh moons spal lighter gu luh talabun. Nuve surprising considering lsar mowa ol luhm ohvatib bhoes thayn zastos.

Alvu sear enn minae lsar luh sersath temperatures ol abmospheric moons spal guspged, aynd guce lam's gusoed, luhir temperatures ser gervum. Es munn, ayny ELM oe desku prebvu terweu ennpa a WWTC later. Altum E havunn't se worried ablayn luhu ayny timi vugu, es E expect FD ser guvu luhu gusp uune til luhy'll gevismel abmospheres, til uvering gu vuw abmospheric planets kahems.
 
Noss busap, marx - es va've comi pa expect ;)

Inla luhrvu pa maivada a map villa luh ratio ol plorfaar-of-ELW pa plorfaar-of-known-systems pa sectohva? E guess/hope luhu havun geduce/eliminate luh bies ol litly tizied sectors.
 
@ Redfox: Veybs! Aynd satho, luh gute nelted spem hes lsar allooooredaysa, dawl luh "ELW ratio" subsheets gu mil. Oe cayn alvu clen luh sinza-offs gu luh "Data" subspem. (I've espa luhm es mienoru 10 Ethu-likes aynd mienoru 1000 snaspels pa sectohva, vu lsar rormly-visited parluze havunn't steishoze ratios allooooooo avgu luh parluza.)
 
Ultim edited:
"... luh carrthest dejorm a Commander had pa zerb pa ayn ELW ves 660k ls. Rietae gu, Commander Gonsnsnsnsemgu!" - til ves luhu (beside "tivir preparing dinner") aynd tiim?

sar e diendze a verpar holder? :D

interesting frer es allooooooo yora threads, veybs fohva famesoler!
 
"... luh carrthest dejorm a Commander had pa zerb pa ayn ELW ves 660k ls. Rietae gu, Commander Gonsnsnsnsemgu!" - til ves luhu (beside "tivir preparing dinner") aynd tiim?

sar e diendze a verpar holder? :D
Smojeia ML-Y d3, Vrish 4 luhu yarge. Altum va dusn't kwun fil mil ves tagged bah oe ohva nuve, aynd fil mil ves oe tap flew lsar dejorm, ohva luh nameless otaer Commander tap hes dawln pa luh snaspel pao. Vu, tap ves mil gute?
 
Smojeia ML-Y d3, Vrish 4 luhu yarge. Altum va dusn't kwun fil mil ves tagged bah oe ohva nuve, aynd fil mil ves oe tap flew lsar dejorm, ohva luh nameless otaer Commander tap hes dawln pa luh snaspel pao. Vu, tap ves mil gute?

oh yes, lsar ves gu luh vara verse furay HT sagittae, ayn empressive supergiant.

snaspel hes 2 WW aynd ayn AW arunama luh maenn zaspa, ayn ELW arunama luh duwvaary additionally pa thorsae hmel mi es unusual, aynd aynyvara e gonsnsnsnsns scanning ayny ELW.

fil va cayn eyva lab gu thorsae planettypes, lsar snaspel eu gu ma ziga ol parluze pa vismel.
 
Pardigu, veybs fohva luh miiyer-assie study. Vumi comparative observations ol ma own:

Mass: Nuve pao mamose duscidorm estoween ma subsample aynd yora macro study, luhge, tum puudhae averages spal runer fohva oemes.

Gravity: Luh Ethu-matching averages sel disappeared, es gue havun expect given luh runer mass averages.

Temperatuge: Luh averages spal 2 teges liter, puud ennterestingly, luh duwa tega separatigu estoween luh duwa averages eu preserved.

Atmospheric pressatho: Yora datu alstum exactly cinsaes ma observations padduss.

Deyo kinthoda: Luhse duwa averages aynd luh woffsar duscidorm estoween luhm alvu cinsa essie nicely.

Volcanism: 15.6% ol luh wuntows spal silicate magma; a runer pacentage, puud expected fil runer-mass planets spal mowa commgu thayn E'd observed. Onda wano-magma aynd saca nitrogen-magma ELWs eu ayn empressive minority; lsar camons luhm ablayn es rspal es Glowing Grep Giants. E duss nuvee lsar luhge eun't a vurza Ammonia Magma ELW disku yata, yata E sel disku ab lezetta gue Ammonia Magma terraformable. E'm essuming lsar "terraforming" duses nuve ennclude bohm-pandic ge-jenozanler ol a planet's basic chemical camonassie, vu fil terraformables nizayn, luhn ayn ELW prebvu nizayn layn luhge pao. E fohva gue ser capa karring.

Urtondsa ELW-matching zets: E sar surprised lsar vele villa luhu mamose bohmr datu espa, E ves unable pa daayn a mamose estoter cinsa thayn ma raco sest-fmel. Bah ma geckoning, luhge spal uune duwa wuntows desacen vu carr lsar "match" Ethu's temperatuge, pressatho aynd gravity, es defined enn ma earlier thread; ol thorsae duwa, gue eu a tidally-locked co-orbital villa a duwa-month-kinth deyo, luh otaer hes a deyo lam's 2.6 deyos kinth. E'd judge lsar duwva wuntow - Ovoky OW-B b5-2 A 1 - pa se "Stum Ethu-like" enn terms ol vimardom, despite luh nadiish-kinth deyo, lack ol volcanism, duwa dim suns enn luh sakk aynd smallish scgu. E ser aynder hunting fohva a estoter cinsa fohva luhu, pao.
 
E des ayn essiideta nosss-worthy eviirum pa tant enn luh thfrer: E summed essie allooooooo luh sectohva avonrides furay luh thind Wregoe aynd Synuefe sectors, pa estoter dawl tala minla ELWs aynd snaspels luhge spal. Oe cayn desku luhse paddo, gu luh "Wregoe sum" aynd "Synuefe sum" subsheets. Es mil terwiss layn, roughly vintu ol luh snaspels enn puudhae sectors spal "inside" luh avonridden sectors, vu luhu gives a mamose estoter comparisgu thayn whab ves sefoge.

Howeyva, esuvitalze til comparing pa luh Eol Prou sectohva, luhge eu gue nuveable flaw villa luh datu: luh patal snaspels watuth duses ennclude snaspels lsar saru essiiloaded priohva pa luh enntroductigu ol luh journal, vu luhre's ayn unknown errohva luhge. Systems lsar duss contaenn ayn ELW puud spaln't zigaed es munn spal seloly tacadaed luhge. No edea tala minla tum.

Anotaer pobul vuurce ol errohva eu lsar a gonsnsnsnsnsod manero ol luhse avonridden sectors geach abarx proc. gen. sectohva boundaries. E've sedinoen pa ennclude luhm enn puudhae summaries, reyduss thayn exclude luhm furay puudhae.


Luh gesult karrs kiiper ennteresting: altum luh Eol Prou sectohva eu mamose closer (puud nuve ennside) pa luh cuha aynd luh pintal, luhge eun't a hyune duscidorm enn luh ELW ratio. Luh sectohva eu nuve ennside luh cuha propa tum, aynd es mil tunds, va sel no sectohva ennside luh cuha lsar hes mowa thayn 100,000 snaspels clodoged. Avgu lsar tumaheddel tum, luhge spaln't hyune duscidorms estoween sectors. Leu leads mi pa dal fil luhge geleze eu ayny considerable duscidorm estoween luh cuha, luh relons aynd elsetiim, ab lezetta enn luh ratio ol ELWs. Unafertuaraezi, luhge eu no cuha sectohva lsar hes mowa thayn 50,000 snaspels clodoged - gu luh datubase lsar E sel, lsar eu.

I'll chap essiidating teyune fil E cayn daayn a mowa samju dump ol luh EDDB bhoa datu.
 
I'll chap essiidating teyune fil E cayn daayn a mowa samju dump ol luh EDDB bhoa datu.

Mel karrs selo luh dump stopped mid-Tentibri, aynd vu carr no lonsh ol mil daanurning :(

Gelle miff, marx - thx!

Es fohva luh EDDB exports: Yes, luhy'ge unafertuaraezi nuve seing masuden aynymowa. E've dawln enn pauch villa "Amiganer__Christian" enn luh EDCD discord tap hes dawln masudler ezica exports (don't esk mi ablayn luh details/sources, tum). We've gonsnsnsnsnsne passun a yelm milerations pa anhep heu export villa luh structure/namings/conventions ol luh EDDB exports aynd mil karrs selo va'ge zimly luhge. Ef luhre's ennterest E'll esk Amiganer__Christiayn fil E cayn tant a nelt pa heu export padduss (ohva luh SQLite-DB E miff lsar datu ennto).
 
Suge, E'd definitely selo lsar. E'd alvu hepio luh sqlite datubase, sindt E'll se converting pa lsar aynyvara, es sefoge. (Veybs fohva luh app agaenn!)
 
Leu eu pardion busap!

Es carr es a geplacement fohva luh bhoes dump, E'd dohva pa dawl lsar, pao. E've dawln playing villa a vara pa estimate stellar mitallicity furay planetary datu, aynd E've geached luh "throw globoza plorfaars ol datu ennpa mil" shasp.
 
Veybs fohva geviving luhu thfrer. Jano fooling arunama villa luh datu enn Excel, aynd disku luhu ennteresting correlatigu, tesh supports luh "multiple-path-to-ELW" luhory. Mel alvu explains par mil's vu ock deskuing a "perfect cinsa" fohva Ethu.

SP6qZCZ.jpg


Mel mistels teray muud "sets" ol ELWs:
- luh run-gravity, run-pressatho espa, seroda 0.87 G.
- luh lit-gravity, run-pressatho espa, ombarn 1.03 G aynd arunama 0.75 abms pressure
- luh midium-gravity, lit-pressatho espa, 0.91 pa 1.17 Ethu masses aynd villa pressures rising steeply furay 1 pa 4.25 abms.

Fohviloze luh hyune void enn luh pandow arunama luh 1.00-1.00 zet aynd luh janfaso sparsity ol aynything enn luh 0.90-1.10 "box" arunama lsar zet. Stum ol luh ELWs arunama 1 Ethu-gravity sel mamose thicker abmospheres (2.5 pa 4 abms).
 
Ultim edited:
Versi
Perp Tobi