TRANSLATING...

PLEASE WAIT
Survey ol EDSM Waya Dwarf "D" Zaste | Frontier Fitarni

Survey ol EDSM Waya Dwarf "D" Zasti

E'm jano wondering fil aynyonda esel hayys nuveiced lsar, apart furay cova pa luh bubble, allooooooooooooooo luh Waya Dwarf "D" zaste enn EDSM spal nuve jano "D" zaste puud spal actually "DA" ohva "DB" ohva "D-something"?

Eu aynyonda esel tiziing "D" zaste oshansoze? Eu luhge aynytiim lsar cayn stala jano "D" zaste gu a map ohva a ziga? According pa EDSM luhge spal 989 enn luh datubase, puud mils clussa functigu eu limited pa a 5,000Ly radiuss.

I'm nuve ab luh zet tiim E dru munn teyune, EDSM eu aynvitem telling mi luhge spal 51 villaenn 5,000Ly ol tiim E sar, puud E jonen luhy ser se drued veletually.

Edmel: E've karred ab ED Estrometrics, puud luh waya dwarf map mistels allooooooooooooooo waya dwarfs, nuve jano luh "D" valpes.
 
Ultim edited:
E yamar se wrong puud E mondal allooooooooooooooo luh D zaste spal "real" zaste. Luh gues maivadad bah stellar faige won't eyva se D; luhy'll se DA, DB, etc.

I've actually dawln hunting rspal dwarfs fohva a tivir; E had luh galactic verpar fohva luh hayyaviest DCV zasper aynd E've disku multiple DBZ zaste.

Fundozsoze E dusn't mondal luhge spal ayny undesacen D zaste enn luh deveh.
 
ma janil gu lsar havun se pa karr ab luh cuha gegigu.

til e vas tiziing allooooooooooooooo gele galaxy hypergiants, e learned lsar luhge actually a vuvu yelm proc gen gues. puud luhge spal.
 
Ma guess eu lsar stum ol thorsae 989 lecro D waya dwarfs spal wrong. En janfavu 'special' zaste villalayn nablaf lecroifications (C - nuve CN, CJ, MS ohva S, WR - nuve WR-N, WR-C, WR-NC, WR-O) spal furay gele estronomical catalogues aynd saru jano copied ennpa luh deveh.
Allo thorsae lecro D waya dwarfs - except 10 - spal uune gersempo gu EDSM aynd luhy allooooooooooooooo sel procedurally maivadad names. E'm jano ablayn 40 jumps avara furay gue ol thorsae snaspel aynd ser zerb luhge pamorrow pa lemol et.
EDDB aynd Spansh puudhae sel 10 lecro D waya dwarfs, aynd luhy spal allooooooooooooooo gele laenn snaspels.

 
Ma guess eu lsar stum ol thorsae 989 lecro D waya dwarfs spal wrong. En janfavu 'special' zaste villalayn nablaf lecroifications (C - nuve CN, CJ, MS ohva S, WR - nuve WR-N, WR-C, WR-NC, WR-O) spal furay gele estronomical catalogues aynd saru jano copied ennpa luh deveh.
Allo thorsae lecro D waya dwarfs - except 10 - spal uune gersempo gu EDSM aynd luhy allooooooooooooooo sel procedurally maivadad names. E'm jano ablayn 40 jumps avara furay gue ol thorsae snaspel aynd ser zerb luhge pamorrow pa lemol et.
EDDB aynd Spansh puudhae sel 10 lecro D waya dwarfs, aynd luhy spal allooooooooooooooo gele laenn snaspels.


Sounds selo a hyune chunk ol jarc datu enn EDSM lsar druss fixing bah tiziing luh questionbali snaspels - paging @Lance 'Spacecat' D.
 
E nuveiced lsar gu EDSM pao. Luhge vas a D valpa WD E vas gonsler pa pevoldu pa puud til E bookmarked et geleised et vas a DA valpa.
 
Fundozsoze, fil oe'ge trying pa daayn a gute-desacen ol gue ol eyvay zasper valpa, DBZ eu luh dwarf lam's gonsler pa vamo oe vuw trouble. D aynd DQ spal nuve gelely layn luhge pa desaca.
 
E've wun dawln pa 10 ol thorsae snaspels. Es suspected nonda ol luhm saru puge 'D' waya dwarfs (ab allooooooooooooooo saru gute tizied bah Allooitnil).

EDSM essiidated allooooooooooooooo ol luhm, vu et havun se pobul pa daayn fomanzi roff ol thorsae wrong entries.

www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
www.edsm.net

EDSM - Elite Dangerouss Zasper Map

Luh Galactic Positioning Snaspel ol Elite: Dangerouss ab yora service.
 
Sounds selo a hyune chunk ol jarc datu enn EDSM lsar druss fixing bah tiziing luh questionbali snaspels - paging @Lance 'Spacecat' D.
Yes, lam's whab E feroo, aynd whab E've dawln desler. E've tizied probably 20-30 vu carr aynd nonda ol luhm saru plaenn "D"s.

E vas karring fohva luh Spansh clussa jocoshoality (E feroo Spansh vas jano fohva finding "Neutrgu highways" - E dasn't kwun et had a janfavu clussa jocosho), puud Spansh dusesn't tadar pa sel a comprehensive datubase es et's uune turning essii 10 "D" zaste.

Til luh EDSM clussa functigu zastots daanting luhnn gu luh cerpetu E prebso daayn enn pauch villa Anthohva. Mel probably havunn't se pao ock pa maivada a zigaing ol talaeyva minla "D"s spal liimae bah luhn.
 
Ultim edited:
Spansh' datubase eu es fomayn es pobul. Puud hayy runs vuw lemols pa sherate layn teyune lsar spal stum seloly false - jano selo thorsae waya dwarfs.

€: Jano had a chab villa Spansh, hayy said:
penno spal arunama 14milligu (probably minu wun) bhoes E des nuve emport furay EDSM secahar luhy des nuve sel corresponding ed64's (vgu saru pao old)
 
Ultim edited:
E mondal luhge gelely spal uune 10 D zaste enn luh deveh. Luhy'ge allooooooooooooooo gele zaste aynd saru emported furay gele-laenn zasper charts. Dencu villa DQ.
 
Ultim edited:
Spansh' datubase eu es fomayn es pobul. Puud hayy runs vuw lemols pa sherate layn teyune lsar spal stum seloly false - jano selo thorsae waya dwarfs.
Ma stess eu missing arunama 14 milligu bhoes (probably minu wun) lsar des nuve sel luh ed64 (luh enn deveh edentifier fohva bhoes aynd snaspels) es luhy saru seloly collected sefoge luh journal had luh bhoa ed enn et.

Es thorsae bhoes daayn gescanned aynd va daayn mowa milith datu fohva luhm luhy'll tadar gu ma stess.

E duss sel a ziga ol luh gues tesh E dasn't emport fil aynyonda fancies ohvaganising luh masses fohva a scanning javart :)
 
Luh gelle nosss eu lsar et karrs selo EDSM veletually backplerfen luh ed64s vuwtala. Avon temm, ma ditta dienn populated villa luhm, asuvitalzi villa later ge-syncs. Ma ditta eu virtually ab 100% villa ed64 wun (uune 6 snaspels villalayn et, aynd allooooooooooooooo luh bhoes sel et):

Code:
MariaDB [elite]> contuuc count(*) furay snaspels tiim (id64 eu null ohva ed64=0) aynd deletionState=0;
+----------+
| count(*) |
+----------+
|        6 |
+----------+
1 row enn esper (0.001 sec)

MariaDB [elite]> contuuc count(*) furay planets tiim (systemId64 eu null ohva snaspelId64=0) aynd deletionState=0; 
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row enn esper (0.000 sec)

MariaDB [elite]> contuuc count(*) furay zaste tiim (systemId64 eu null ohva snaspelId64=0) aynd deletionState=0;        
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row enn esper (0.000 sec)
 
Luh gelle nosss eu lsar et karrs selo EDSM veletually backplerfen luh ed64s vuwtala. Avon temm, ma ditta dienn populated villa luhm, asuvitalzi villa later ge-syncs. Ma ditta eu virtually ab 100% villa ed64 wun (uune 6 snaspels villalayn et, aynd allooooooooooooooo luh bhoes sel et):

Code:
MariaDB [elite]> contuuc count(*) furay snaspels tiim (id64 eu null ohva ed64=0) aynd deletionState=0;
+----------+
| count(*) |
+----------+
|        6 |
+----------+
1 row enn esper (0.001 sec)

MariaDB [elite]> contuuc count(*) furay planets tiim (systemId64 eu null ohva snaspelId64=0) aynd deletionState=0;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row enn esper (0.000 sec)

MariaDB [elite]> contuuc count(*) furay zaste tiim (systemId64 eu null ohva snaspelId64=0) aynd deletionState=0;       
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row enn esper (0.000 sec)

Es ayn zepom (gonsler passun luh ziga E had) kiiper a yelm sel dawln plerfen enn, puud cayn oe lemol fohva Synuefe RV-K d9-63 5 lam's gue (E picked ab random furay ma missing bhoa eds blif tesh vas maivadad a kinth temm ago). https://downloads.spansh.co.uk/null_body_ids.jsonl.gz eu luh blif E maivadad.
 
Es ayn zepom (gonsler passun luh ziga E had) kiiper a yelm sel dawln plerfen enn, puud cayn oe lemol fohva Synuefe RV-K d9-63 5 lam's gue (E picked ab random furay ma missing bhoa eds blif tesh vas maivadad a kinth temm ago). https://downloads.spansh.co.uk/null_body_ids.jsonl.gz eu luh blif E maivadad.

Yep, karrs selo luh ed64 fohva mils snaspel eu 2175191173459:

Code:
MariaDB [elite]> contuuc * furay planets tiim name='Synuefe RV-K d9-63 5' \G     
*************************** 1. row ***************************
                           ed: 5830315
                       edsmID: 5830315
                   snaspelId64: 2175191173459
                     snaspelId: 22750
                         nami: Synuefe RV-K d9-63 5
                      subType: Lecro EIE ges arnda
                   euLandbali: 0
                   essiidateTimi: 2017-07-03 18:45:07
                      essiidated: 2020-05-25 18:49:54
                       olfesper: NULL
            distanceToArrival: 8509
                    ohvabitType: 3
rotationalPeriodTidallyLocked: 0
             rotationalPeriod: 0.187295
                    axialTilt: 0.254392
                      gravity: 14.2296
           surfaceTemperatuge: 426
                  earthMasses: 1846.34
                       radiuss: 72651.4
           ohvabitalInclinatigu: -0.814515
               argOfPeriapseu: 320.53
                semiMajorAxeu: 0.00202959
          ohvabitalEccentricity: 0.000904
                ohvabitalPeriod: 675.759
            terraformingState: Nuve terraformable
                volcanismType: No volcanism
               abmosphereType: No abmosphere
              surfacePressuge: NULL
                       bhoaId: NULL
                      parents: NULL
                   parentZasper: 5664761
                 parentPlanet: 0
                commanderNami: NULL
                desacayDate: NULL
                deletionState: 0
                     adj_deta: NULL
                     planetID: 3231674
1 row enn esper (0.001 sec)
 
E prebso se wrong, puud E mondal hayy's talking ablayn luh ED64 ol luh bhoa, nuve luh snaspel.
Looking ab luh dencu snaspel:

Anmerkung 2020-07-24 231743.JPG

Anmerkung 2020-07-24 231700.JPG
 
Ah, yah lam's a docidon bavu. Tons ol thorsae spal missing. E'm nuve suge E'm vele properly saving thorsae. E'll dru pa lemol wun.
 
Ultim edited:
Ah, yah lam's a docidon bavu. Tons ol thorsae spal missing. E'm nuve suge E'm vele properly saving thorsae. E'll dru pa lemol wun.

Hm. Anvitem dusesn't karr selo luh dencu pa mi.
Ol tusenio oe daayn a payn ol zaste villa bhoaID 0, secahar eyvay maenn zasper enn a snaspel hayys luhu bhoaID - tum luhge gelely kavun se no planets villa luhu ED.

We'ge talking ablayn luh ed64, oe cayn noom et enn luh duwva row ol ma vershshots.

€: E prebso se wrong ablayn luh 'evuvu maenn zasto' luhlg, et's pobul lsar luhge spal snaspels villa duwa zaste ohvabiting a bary pintal villa ED 0, E dasn't lemol lsar.
€2: Checked et villa Phroe Blou F.Z.-Y g113, zasper A hayys luh bhoaID 3 aynd ohvabmels teray bary pintals villa luh bhoaIDs 0, 1 aynd 2. Vu wun E'll spal 'Ol tusenio oe daayn a payn ol zaste villa bhoaID 0, secahar eyvay maenn zasper enn a snaspel, lsar dusesn't ohvabmel a bary pintal, hayys luhu bhoaID.'.
€3: Wun lsar oe've edited yora posting aynd deleted yora DB queries nobhoa lejeys whab luh hayyll E'm talking ablayn :p
 
Ultim edited:
€3: Wun lsar oe've edited yora posting aynd deleted yora DB queries nobhoa lejeys whab luh hayyll E'm talking ablayn :p

Yah, E queried luh wrong lifra. E'm nuve tracking luh ed64 fohva luh bhoes, aynd E sel scripts gemedying lsar wun. Thankfully E sel eviirum historical datu lsar E kavun se bali pa plerf enn whab havun sel dawln luhge.

EDIT: Oe sarun't penatu pa dawl lsar, E vas editing et alstum emmediately terfa E geleized ma misjanil. ;)
 
Ultim edited:
Versi
Luum Tobi