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.
 

Is there a way to get a database of systems, their security status & stargate neighbors?
Author
Previous Topic Next Topic
Eric Agerwal
Cryosoft
#1 - 2012-08-03 12:30:52 UTC
I don't recall seeing the security status in some data I've seen.
Is it dynamic perhaps? If so is there a way to get a snapshot in database form with some sort of effective date.
Khorkrak
KarmaFleet
Goonswarm Federation
#2 - 2012-08-03 13:12:09 UTC
It's in the static data export database. mapSolarSystems table - see the security column.

Developer of http://www.decloaked.com and http://sourceforge.net/projects/pykb/
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-08-03 13:29:18 UTC
You can grab individual tables in mysql sql or xls from my site. just check http://www.fuzzwork.co.uk/dump/

mapSolarSystems as mentioned above.

As for neighbors, you'd need to use mapSolarSystemJumps, using fromSolarSystemID and toSolarSystemID

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
ArmEagle Kusoni
Knights of Nii
The 20 Minuters
#4 - 2012-10-24 06:11:42 UTC
Since this is the closest related and most recent post about the static data export I'll ask here.

I used a mysql version someone made in/from http://community.eveonline.com/ingameboard.asp?a=topic&threadID=1572481.
I'm seeing quite some security levels very close to 0, where Dotlan reports a number that seems to correspond to the ingame status.

But even http://wiki.eveonline.com/en/wiki/FZCR-3_%28System%29 has a wrong, different number (also different from the export). Any idea where dotlan got their info?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2012-10-24 09:08:36 UTC
Try an updated export. Rather than one from before the changes to the Security ratings in the the drone regions.

Like the inferno 1.2 one from my dump directory.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
ArmEagle Kusoni
Knights of Nii
The 20 Minuters
#6 - 2012-10-24 16:34:18 UTC
Steve Ronuken wrote:
Try an updated export. Rather than one from before the changes to the Security ratings in the the drone regions.

Like the inferno 1.2 one from my dump directory.

Ah, thank you for making that available in an easier format than the large dump file from CCP (only just found the page http://community.eveonline.com/community/toolkit.asp, plenty of links in the forum to older dumps).