Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Psinetic
|
Posted - 2009.08.14 14:06:00 -
[1]
Would anyone happen to have the total number of all the Lowsec (0.1 to 0.4) systems and the total number of gates in each one (or just total number of gates in all the lowsec system, for example, if let's say there are 200 lowsec systems, you could either say the system name and the number of stargates in each one, or you could say the number of lowsec systems and the total overall number of gates in lowsec).
I really need this information for research on a project i'm doing, would anyone be able to help me out?
-Psinetic
|
Toter Mann
|
Posted - 2009.08.14 14:21:00 -
[2]
get yourself one of those pirate travel maps and count, its not that hard...
|
Mish'Kala
Minmatar Infiniti Matar Sleepless Knights Alliance
|
Posted - 2009.08.14 15:17:00 -
[3]
more than 9000 ?
|
Harcole
Amarr Sanguine Unity
|
Posted - 2009.08.14 15:18:00 -
[4]
its in the API data, the question is why?
|
Ki Tarra
Ki Tech Industries
|
Posted - 2009.08.14 15:22:00 -
[5]
All of that data is in the dump.
|
gfldex
|
Posted - 2009.08.14 16:34:00 -
[6]
dex@dexhome:~$ psql -A -t eve -c 'select solarsystemname from mapsolarsystems where security < 0.5 and security > 0;'|wc -l 817
dex@dexhome:~$ psql -A -t eve -c 'select solarsystemname as name, (select count(fromsolarsystemid) from mapsolarsystemjumps where mapsolarsystems.solarsystemid = mapsolarsystemjumps.fromsolarsystemid) as num_of_gates from mapsolarsystems where security < 0.5 and security > 0;' Shenela|2 Asabona|2 Onsooh|5 Shamahi|3 Sendaya|4 Nazhgete|1 Futzchag|4 Kazna|3 Podion|1 Lilmad|1 Kuharah|2 Jayneleb|2 Yishinoon|2 Uplingur|2 Dooz|4 Bayuka|3 Uzistoon|3 Bairshir|2 Moh|1 Sari|3 Faspera|2 Jaymass|4 Mifrata|5 Majamar|2 Ihal|3 Camal|1 Fera|1 Iosantin|3 Akhrad|4 Sharir|2 Gomati|4 Nakah|3 Irshah|3 Hasateem|4 Assah|4 Sosa|3 Ilahed|3 Eshwil|1 Aranir|2 Ishkad|1 Hahyil|1 Asilem|2 Mahnagh|1 Shach|4 Kehrara|4 Arena|4 Timeor|2 Uhtafal|3 Dysa|4 Mahti|1 Abha|2 Gamis|5 Nieril|2 Berta|4 Bekirdod|2 Hothomouh|3 Arnola|3 Astabih|5 Ubtes|5 Bimener|4 Kenobanala|4 Khabi|5 Uanzin|3 Maila|2 Akora|4 Messoya|2 Ihakana|4 Otitoh|2 Otomainen|1 Uminas|1 Oijanen|3 Vasala|5 Walvalin|4 Otanuomi|5 Otsela|6 Tasti|2 Otosela|3 Uemon|3 Paala|2 Fuskunen|2 Akkio|3 Uchoshi|3 Mastakomon|4 Eruka|2 Ohkunen|2 Obe|3 Wirashoda|1 Osaa|3 Dantumi|3 Aurohunen|3 Raussinen|1 Akonoinen|4 Vaajaita|3 Autaris|3 Jan|3 Mara|4 Pakkonen|1 Aunenen|3 Litiura|4 Passari|2 Atai|3 Daras|3 Iitanmadan|2 Oishami|1 Ohbochi|3 Isie|1 Tamo|2 Nannaras|3 Anin|3 Karjataimon|5 Tartoken|3 Saranen|3 Oimmo|3 Nalvula|6 Otsasai|4 Taisy|4 Hakonen|4 Gyerzen|1 Gemodi|4 Chamume|1 Pera|3 Yong|3 Hoona|5 Teshkat|4 Keshirou|4 Nasesharafa|2 Tirbam|1 Ordat|3 Rethan|3 Lari|1 Sagain|3 Modun|2 Saminer|2 Hagilur|5 Anher|2 Ragnarg|1 Amo|3 Resbroko|4 Hadozeko|3 Ardar|3 Auner|2 Evati|5 Ofstold|2 Todifrauan|4 Helgatild|3 Arnstur|4 Lasleinur|3 Arnher|3 Brin|2 Tvink|4 Lanngisi|3 Dudreda|4 Hakisalki|2 Arwa|4 Krirald|4 Arifsdald|4 Ansen|3 Floseswin|3 Uisper|4 Aset|7 Eytjangard|4 Turnur|3 Isbrabata|4 Vimeini|2 Avenod|3 Frerstorn|6 Ontorn|4 Sirekur|3 Gebuladi|4 Ebolfer|5 Eszur|4 Hofjaldgund|2 Klogori|2 Orfrold|2 Egmar|3 Taff|3 Ualkin|2 Gukarla|2 Shuria|3 Narai|2 Mazitah|4 Hiramu|1 Sakhti|4 Aldali|2 Nomash|2 Milal|3 Sobenah|2 Bourar|2 Rammi|2 Arodan|2 Rimbah|2 Neziel|3 Ruchy|1 Bika|5 Jerma|3 Miyeli|2 Reyi|2 Avair|4 Rayl|4 Asoutar|2 Porsharrah|2 Tastela|2 Clarelam|1 Gulfonodi|2 Bosena|3 Oddelulf|4 Atlar|3 Heild|3 Hrokkur|2 Hrober|1 Aedald|3 Muttokon|2 Audesder|2 Illamur|3 Meildolf|3 Istodard|4 Gonheim|3 Half|3 Sakulda|1 Hedaleolfarber|1 Altbrard|1 Osvetur|3 Mimiror|3 Skarkon|3 Ennur|3 Unertek|2 Klingt|2 Weld|3 Kadlina|3 Hegfunden|3 Aeditide|4 Egbinger|3 Dammalin|3 Bosboger|3 Olfeim|1 Lulm|2 Gulmorogod|3 Ebodold|1 Amamake|6 Vard|5 Siseide|6 Lantorn|3 Dal|6 Auga|4 Aralgrund|3 Bogelek|2 Wiskeber|3 Eifer|4 Gusandall|5 Atgur|2 Ingunn|3 Gultratren|3 Auren|2 Hrondedir|4 Sotrenzur|4 Hrondmund|2 Bundindus|2 Otraren|2 Hedgiviter|1 Katugumur|2 Balle|4 Decon|2 Sharuveil|2 Carrou|4 Ignoitton|2 Ney|4 Fasse|3 Ala|3 Gratesier|3 Schoorasana|2 Basgerin|1 Barmalie|1 Audaerne|3 Olettiers|4 Artisine|2 Bamiette|2 Crielere|3 Egghelende|6 Odette|2 Stegette|4 Ravarin|1 Aliette|2 Archee|2 Adrallezoen|3 Rancer|2 Miroitem|4 Thelan|3 Rorsins|1 Lamadent|2 Otou|3 Goinard|3 Raeghoscon|2 Allipes|2 Lermireve|3 Aetree|2 Esmes|2 Horkkisen|1 Erila|2 Ishomilken|3 Nikkishina|2 Hasama|2 Uuna|2 Manjonakko|2 Kubinen|3 Enderailen|3 Tunudan|2 Kulelen|3 Inari|1 Oshaima|3 Hysera|3 Kaunokka|2 Hasmijaala|2 Nagamanen|4 Oto|1 Sujarento|4 Eranakko|2 Onatoh|3 Tannolen|2 Tama|3 Aramachi|2 Tzvi|4 Raa|3 Sifilar|4 Arzad|3 Oyeman|2 Ezzara|2 Dital|4 Roushzar|2 Labapi|3 Arayar|3 Asghed|5 Tararan|4 Sosan|3 Halmah|4 Rahadalon|4 Soosat|2 Ibash|3 Itsyamil|2 Ussad|1 Shastal|5 Thakala|1 Palpis|2 Mya|2 Gerper|1 Alachene|2 Elarel|3 Groothese|2 Adeel|1 Mannar|3 Mormelot|2 Angatalie|2 Lamaa|3 Tuomuta|2 Huola|3 Kourmonen|4 Kamela|6 Sosala|5 Anka|4 Iesa|3 Netsalakka|3 Myyhera|3 Gammel|3 Uusanen|3 Saikamon|2 Malpara|1 Sahtogas|4 Haras|1 Oyonata|3 Kurniainen|2 Saidusairos|2 Tannakan|2
|
gfldex
|
Posted - 2009.08.14 16:34:00 -
[7]
Ayeroilen|2 Imata|2 Enden|2 Erstet|2 Anstard|2 Mateber|3 O***e|3 Offikatlin|3 Diromitur|3 Erlendur|3 Tabbetzur|2 Eurgrana|2 Frulegur|2 Odebeinn|2 Konora|3 Sahda|3 Naguton|2 Ealur|2 Shajarleg|2 Basan|3 Akila|2 Amod|2 Unefsih|2 Valmu|2 Sibot|2 Kheram|3 Mai|1 Raravath|3 Namaili|2 Erzoh|2 Miakie|2 Faswiba|3 Hayumtom|2 Zanka|1 Galeh|2 Bittanshal|4 Arton|4 Sieh|1 Mamet|6 Hoshoun|2 Biphi|2 Ziriert|3 Misaba|3 Rephirib|1 Conomette|3 Aimoguier|2 Yveve|4 Meunvon|2 Cadelanne|1 Elore|3 Anckee|3 Vevelonel|2 Pertnineere|2 Sarline|3 Aeter|2 Harner|2 Heluene|4 Arittant|1 Oruse|2 Hare|4 Ogaria|2 Faurulle|4 Agaullores|2 Babirmoult|2 Ratillose|2 Toustain|3 Straloin|2 Agoze|5 Intaki|3 Brarel|2 Vey|3 Annancale|2 Ostingele|6 Harroule|2 Covryn|3 Iges|4 Dastryns|4 Slays|3 Uphallant|2 Alperaute|2 Aunsou|4 Cumemare|2 Reynire|2 Pain|1 Gare|2 Pelille|3 Dour|2 Grispire|2 Aulbres|2 Barleguet|3 Vestouve|3 Ausmaert|2 Espigoure|1 Kenninck|1 Eugales|4 Frarie|3 Aubenall|4 Moclinamaud|3 Renarelle|3 Oulley|2 Chardalane|1 Maut|3 Vlillirier|4 Aldranette|3 Oicx|2 Evaulon|2 Anchauttes|3 Alsavoinon|2 Esesier|1 Avaux|2 Gallusiene|2 Ruerrotta|3 Hedoubel|2 Amoen|3 Amasiree|2 Aubonnie|2 Alparena|2 Reschard|3 Arderonne|3 Mercomesier|2 Alamel|3 Mantenault|2 Athounon|1 Odamia|3 Nourbal|1 Ashmarir|3 Kaira|2 Efa|4 Moro|2 Ainsan|2 Claini|2 Gehi|3 Seshala|2 Vezila|2 Ham|3 Upt|1 Hemouner|1 Chamemi|3 Tegheon|2 Bashyam|2 Parses|4 Rilera|3 Amafi|4 Hakana|2 Ashkoo|2 Baratar|3 Arzieh|1 Nahrneder|2 Nandeza|3 Dimoohan|1 Chitiamem|3 Kuhri|1 Zahefeus|2 Zephan|3 Neda|1 Goudiyah|3 Sassecho|3 Timudan|4 Ibani|2 Cabeki|1 Irmalin|2 Nakis|4 Hezere|2 Fanathor|2 Zirsem|1 Pout|3 Rafeme|2 Hiroudeh|2 Gonan|3 Neburab|2 Ansasos|3 Dehrokh|1 Bordan|4 Zimmem|2 Chaneya|2 Oberen|2 Finid|1 Rayeret|3 Bushemal|3 Ardhis|2 Gasavak|3 Iaokit|2 Menri|2 Garisas|4 Munory|3 Mod|4 Omam|3 Bersyrim|2 Sechmaren|3 Zinoo|2 Hiremir|1 Van|3 Shakasi|3 Zayi|3 Shirshocin|3 Maalna|2 Maseera|3 Yehaba|3 Kenahehab|3 Gens|3 Kamih|4 Hier|3 Jasson|3 Sadana|3 Isid|2 Onanam|2 Udianoor|2 Vehan|2 Marmeha|1 Haimeh|4 Chibi|1 Bazadod|1 Fihrneh|5 Parouz|1 Edilkam|2 Hakatiz|2 Khnar|2 Ertoo|2 Yiratal|4 Balas|3 Pemsah|3 Feshur|2 Hoseen|2 Yekh|1 Gesh|2 Nema|4 Shenda|3 Rashagh|3 Afrah|2 Sota|2 Soliara|6 Nielez|2 Tukanas|4 ***eras|1 Ajna|3 Sheri|2 Ahraghen|3 Nalnifan|4 Jerhesh|2 Getrenjesa|3 Shafrak|3 Defsunun|2 Zazamye|3 Yahyerer|2 Esubara|2 Ghekon|5 Vaini|3 Anohel|2 Soza|2 Pserz|4 Illi|2 Keba|3 Bapraya|3 Efu|2 Tisot|4 Sakht|4 Naga|4 Anath|3 Omigiav|2 Fobiner|5 Huna|2 Esaeel|1 Karan|3 Nouta|2 Ned|1 Hophib|2 Mesybier|4 Yvangier|2 Pemene|3 Heydieles|6 Fliet|3 Indregulle|2 Abune|2 Deven|2 Estaunitte|1 Hulmate|4 Onne|4 Vitrauze|3 Palmon|2 Obalyu|2 Vifrevaert|2 Parts|2 Ladistier|3 Old Man Star|3 Adirain|3 Lisbaetanne|3 Aeschee|5 Allebin|4 Atlulle|3 Haine|2 Isenan|1 Seyllin|3 Ane|2 Fensi|5 Nebian|4 Khabara|2 Jeni|2 Bridi|2 Ami|4 Misha|3 Perbhe|2 Abath|2 Schmaeel|4 Mafra|2 Arzi|4 Kerying|1 Zorenyen|2 Oguser|3 Tadadan|2 Gademam|3 Pananan|2 Daran|2 Shokal|4 Atarli|6 Keproh|3 Zatamaka|4 Rannoze|2 Piri|3 Enal|2 Jedandan|2 Miroona|3 Ranni|2 Arza|1 Liparer|2 Cleyd|3 Vecamia|2 Ahbazon|2 Atreen|2 Tarta|4 Nardiarang|2 Ziasad|3 Sibe|3 Makhwasan|4 Zarer|2 Toon|2 Hesarid|1 Apanake|2 Zoohen|3 Serren|3 Hadji|2 Assez|4 Alal|3 Dom-Aphis|2 Iderion|3 Chamja|2 Pashanai|4 Pamah|3 Leran|2 Beke|2 Noranim|3 Chej|3 Menai|2 Aring|4 Gayar|3 Petidu|2 Naka|2 Hirizan|3 Asanot|2 Anzalaisio|2 Saphthar|3 Itrin|5 Bantish|4 Korridi|2 Lela|1 Keri|1 Antem|4 Djimame|4 Mozzidit|2 Angur|3 Hangond|2 Access|2 Bherdasopt|3 Gonditsa|4 Shalne|4 Shapisin|3 Olin|2 Galnafsad|4 Otakod|3 Azedi|3 Sharza|4 Pirna|1 Seshi|1 Anara|2 Partod|1 Exit|2 Gateway|2 Central Point|4 Promised Land|2 Dead End|1 New Eden|1 Canard|1 Ebasez|3 Bania|2 Murethand|3 Melmaniel|3 Ouelletta|3 Costolle|2 Muetralle|2 Loes|2 Hevrice|3 Jovainnon|2 Reblier|2 Amoderia|3 Arraron|4 Hykanima|3 Okagaiken|3 Kehjari|3 Villasen|4 Sarenemi|2 A****su|3 Korasen|1 Ienakkamon|2 Kinakka|4 Raihbaka|3 Innia|4 Iralaja|2 Martoh|5 Eha|3 Pavanakka|2
|
gfldex
|
Posted - 2009.08.14 16:35:00 -
[8]
Uchomida|3 Uuhulanen|3 Okkamon|3 Vaaralen|3 Asakai|6 Prism|3 Mushikegi|4 Teskanen|1 Elunala|2 Ikoskio|3 Hikkoken|4 Enaluri|3 Aivonen|2 Hallanen|2 Akidagi|4 Immuri|2 Nennamaila|5 Hirri|3 Kedama|5 Oinasiken|3 Notoras|1 Rakapas|3 Teimo|1 Iwisoda|1 Nisuwa|4 Pynekastoh|4 Reitsato|3
|
meppa
Kumovi Sons of Tangra
|
Posted - 2009.08.14 17:37:00 -
[9]
Got to love those dirty word filters on forums. Especially when they attack ccp system names ;)
|
Kelly Smith
Band of Brothers
|
Posted - 2009.08.14 18:49:00 -
[10]
that is some seriously fugly sql
|
|
gfldex
|
Posted - 2009.08.14 20:25:00 -
[11]
Originally by: Kelly Smith that is some seriously fugly sql
OK, next time you answer him.
|
Thernys
Caldari Capital Construction Research Pioneer Alliance
|
Posted - 2009.08.16 05:04:00 -
[12]
Edited by: Thernys on 16/08/2009 05:06:02 'Fugly' SQL notwithstanding, that list contains invalid data. The reason being that, iirc, the lower limit for high sec systems is actually 0.45, which in-game gets displayed as 0.5. Now, I'm not sure if it's >= or > 0.45, but a quick cross-reference by the interested parties should get that sorted in no time at all, if there even are any systems exactly at that threshold.
Edit for spleling.
|
Spurty
Caldari D00M. Triumvirate.
|
Posted - 2009.08.16 05:24:00 -
[13]
His sql was fine, just needs to be 'tweaked' to catch the rounding.
Originally by: Cat o'Ninetails i for one, like 8's that look like 9's lol
|
Ronin Reborn
Wrath of Fenris
|
Posted - 2009.08.16 05:48:00 -
[14]
o/ Dex, how you been?
On topic, don't know why you'd need that information, but try ombey's maps. The Outlaws Guide to LowSec is pretty good.
|
Psinetic
|
Posted - 2009.08.16 07:48:00 -
[15]
Thanks everyone for your help. Wow Dex, that's a nice list, even if it isn't completely accurate, it's a better number than i thought (i was thinking in the thousands lol).
Now I'm just using a rough estimate of about 5 gates per lowsec system, but if anyone could give me a more exact number of the total number of gates in lowsec that'd be great :D
So far, from the list I just got from Dex, I copy and pasted in a text file and showed 817 lines, so there are 817 (roughly) lowsec systems in Eve. :D nice.
As for WHY I need this information, perhaps if you stick with the Eve game long enough (I'd say roughly 5 years) you'll see why i need it. :D |
Psinetic
|
Posted - 2009.08.20 15:34:00 -
[16]
Friendly Bump
|
Lucas Tigh
United Systems Navy Zenith Affinity
|
Posted - 2009.08.20 15:48:00 -
[17]
Originally by: Psinetic Now I'm just using a rough estimate of about 5 gates per lowsec system, but if anyone could give me a more exact number of the total number of gates in lowsec that'd be great :D
The numbers to the right of the system name in the huge list up there are the numbers of gates in that system, silly. -------------------------------------
CCP, make me a winner.
I win. |
Psinetic
|
Posted - 2009.08.23 16:15:00 -
[18]
:P as if i'm going to go through 817 lines individually and count numbers all day. does anyone at least have a fast way to add those up?
|
Banana Torres
The Green Banana Corporation
|
Posted - 2009.08.23 17:46:00 -
[19]
Originally by: Psinetic :P as if i'm going to go through 817 lines individually and count numbers all day. does anyone at least have a fast way to add those up?
Yep, Load the data into your favourite editor and change all the vertical bars to a commas. Save as a .csv file then import into Google docs, or some other spreadsheet, and sum the second column.
|
Usagi Tsukino
Miyazaki Zaibatsu APEX Conglomerate
|
Posted - 2009.08.24 06:34:00 -
[20]
Edited by: Usagi Tsukino on 24/08/2009 06:35:10
Originally by: Psinetic As for WHY I need this information, perhaps if you stick with the Eve game long enough (I'd say roughly 5 years) you'll see why i need it. :D
I've already been with the game for 5 years and I assure you anything you figure out today will be abso-freaking-lutly useless in 5 more.
The only thing that has remained constant in EVE since I started is 'Jita Sucks'. --- Usagi Tsukino // Miyazaki Zaibatsu
|
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |