These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Looking to get a list of planets and moon

First post
Author
Previous Topic Next Topic
Kiki Abraxas
The Scope
Gallente Federation
#1 - 2015-08-16 08:26:59 UTC
ok so i am tryign to make a nice spreadsheet so i can be nerdy and just practice with different ideas i have but my first problem i have encountered is i am to lazy to type every planet and moon out individually so can anyone tell me if their is a sheet i can download that has all planets/moons already on it i am currently only looking for syndicate region as i can access it easier
Mr Mac
Dark Goliath
#2 - 2015-08-16 08:52:02 UTC
Kiki Abraxas
The Scope
Gallente Federation
#3 - 2015-08-16 08:55:38 UTC
neither of them links worked
Kiki Abraxas
The Scope
Gallente Federation
#4 - 2015-08-16 09:06:16 UTC
ok the links worked but i mean i want 1 sheet which has it so for Example Coloumn A has systemn Name Coloumn B has planet Number and Colomn C has moon number
Pete Butcher
The Scope
Gallente Federation
#5 - 2015-08-16 10:14:15 UTC
I think you can read it from the SDE: http://wiki.eve-id.net/MapDenormalize_%28CCP_DB%29

http://evernus.com - the ultimate multiplatform EVE trade tool + nullsec Alliance Market tool
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2015-08-16 16:22:11 UTC
Pete Butcher wrote:
I think you can read it from the SDE: http://wiki.eve-id.net/MapDenormalize_%28CCP_DB%29


Exactly this.


https://www.fuzzwork.co.uk/dump/latest/mapDenormalize.csv.bz2 is a converted version of that table, in CSV format. It has quite a few rows.

To break it down to just moons and planets, you'll have to work on it with typeids from https://www.fuzzwork.co.uk/dump/latest/invTypes.xls.bz2

As there are multiple types of planets, this isn't the simplest thing to do.

(you can, if you're comfortable with them, work with the database versions instead. It's easier, if you know what you're doing)

7zip will unzip those files.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter