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 General Discussion

 
  • Topic is locked indefinitely.
 

List of every single eve system, security level and jump connections?
Author
Previous Topic Next Topic
morrosis
Ministry of War
Amarr Empire
#1 - 2012-02-08 10:03:29 UTC  |  Edited by: morrosis
http://community.eveonline.com/community/toolkit.asp

Just found the above so hoping that will have everything I need.



Working on a little project, I am looking for something that gives a full run down of all the system, what security status they are and how they link togeather

I have found this https://api.eveonline.com/map/Jumps.xml.aspx

But it doesn't list all the the systems and also doesn't list security or how they link.

and
http://evemaps.dotlan.net/map

But I need the data file for my coding

I am making a route planner if anyone would like to know.

I know there are a million and one of these about but it's a personal project and something to keep me busy.
baltec1
Bat Country
Pandemic Horde
#2 - 2012-02-08 10:12:37 UTC
You could do it the manly way and use the in game map and do it all by handCool
Serge Bastana
GWA Corp
#3 - 2012-02-08 10:58:22 UTC
Dotlan

WoW holds your hand until end game, and gives you a cookie whether you win or lose. EVE not only takes your cookie, but laughs at you for bringing one in the first place...

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-02-08 11:15:04 UTC
The information you want is in the static data dump. The one on the toolkit page is in sql server export format. the thread below has several alternates.

https://forums.eveonline.com/default.aspx?g=posts&t=61544

Once you have it loaded up:

select * from mapSolarSystems where SolarSystemName='Jita';

Will give you basic information about Jita.

select * from mapSolarSystemJumps where fromSolarSystemID=30000142;
will give Basic information about the jumps out of jita.

select solarSystemName,security from mapSolarSystemJumps,mapSolarSystems where fromSolarSystemID=30000142 and toSolarSystemID=mapSolarSystems.SolarSystemID;
Will list the names and security levels of the systems you can get to (directly) from jita

And so on.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Ris Dnalor
Tribal Liberation Force
Minmatar Republic
#5 - 2012-02-09 06:50:10 UTC
Steve Ronuken wrote:
The information you want is in the static data dump. The one on the toolkit page is in sql server export format. the thread below has several alternates.

https://forums.eveonline.com/default.aspx?g=posts&t=61544

Once you have it loaded up:

select * from mapSolarSystems where SolarSystemName='Jita';

Will give you basic information about Jita.

select * from mapSolarSystemJumps where fromSolarSystemID=30000142;
will give Basic information about the jumps out of jita.

select solarSystemName,security from mapSolarSystemJumps,mapSolarSystems where fromSolarSystemID=30000142 and toSolarSystemID=mapSolarSystems.SolarSystemID;
Will list the names and security levels of the systems you can get to (directly) from jita

And so on.


If they hadn't deleted all the (pre warp to zero) gate to gate bookmarks from my folders I could've sent you a copy, but alas they're gone :(

https://forums.eveonline.com/default.aspx?g=posts&t=118961

EvE = Everybody Vs. Everybody

  • Qolde
Akirei Scytale
Okami Syndicate
#6 - 2012-02-09 06:51:33 UTC
baltec1 wrote:
You could do it the manly way and use the in game map and do it all by handCool


then write a program that presents it all in an easy to use and intuitive interface.

using assembly.