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.
 

Data dump for solar system adjacency?
Author
Previous Topic Next Topic
ichn
Stoned Clones
#1 - 2012-03-01 02:20:28 UTC
Is there anywhere that I can find a dump of all the systems in eve, and all the systems they're connected to? Preferably in an adjacency list format. All I need is a text file or something.

If not, where else can I get this information?
Osku Rei
Pixel 6
#2 - 2012-03-01 08:29:09 UTC
http://api.evejb.com/api/v1/public/system/systeminfo/solarSystemID/30000142.xml

Contact me and we can work something out.

Next generation of lottery tracker coming soon! http://evelotterytracker.com/

Please like my post if it has helped you :)
ichn
Stoned Clones
#3 - 2012-03-01 09:10:05 UTC
That's pretty cool. Is there a site that documents all the info you can get out of that api?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-03-01 12:30:19 UTC
The other option is just taking the data from the static data dump (or I could dump it out in csv or something.)

There's a table that lists all the jumps in the game. It handles everything by system id, so it can then be linked to the system table, and from there to regions.

mapSolarSystemJumps
+---------------------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------+------+-----+---------+-------+
| fromRegionID | int(11) | YES | | NULL | |
| fromConstellationID | int(11) | YES | | NULL | |
| fromSolarSystemID | int(11) | NO | PRI | NULL | |
| toSolarSystemID | int(11) | NO | PRI | NULL | |
| toConstellationID | int(11) | YES | | NULL | |
| toRegionID | int(11) | YES | | NULL | |
+---------------------+---------+------+-----+---------+-------+


Depending on what you're going to do with it, a copy of all the map tables might be of the most use to you.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Osku Rei
Pixel 6
#5 - 2012-03-01 16:41:07 UTC  |  Edited by: Osku Rei
ichn wrote:
That's pretty cool. Is there a site that documents all the info you can get out of that api?


I haven't 'attached' my full library to that API + its not very consistent and / needs tying before its fit for public consumption.

If you need any more data give me a mail and I will look into it.


* Edit *
P.s I added a auto-generated help a while back that will explain the service (system), the methods (systeminfo) and the parameters it takes (solarSystemID) and what it returns.

http://api.evejb.com/api/v1/public/system/help.xml

But as you can see I haven't added the method's headers, so not much use :)

Next generation of lottery tracker coming soon! http://evelotterytracker.com/

Please like my post if it has helped you :)