MySQL Table containing secure and insecure distances from and to every system in New Eden

null-sec
low-sec
high-sec

(EveDataRules) #1

Download here: https://github.com/antihax/eve-jumps

Simple table allowing silly queries to find things within a distance from a system.

CREATE TABLE `jumps` (
  `toSolarSystemID` int(10) unsigned NOT NULL DEFAULT '0',
  `fromSolarSystemID` int(10) unsigned NOT NULL DEFAULT '0',
  `jumps` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `secureJumps` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`toSolarSystemID`,`fromSolarSystemID`),
  KEY `fromSolarSystemID` (`fromSolarSystemID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Can do such queries as this one which will find every highsec “island” system disconnected by low or null from the major trade hubs in 0.125s.

SELECT DISTINCT solarSystemName, regionName 
  FROM evedata.jumps J 
  INNER JOIN mapSolarSystems S ON J.toSolarSystemID = S.solarSystemID
   AND ROUND(S.security, 1) >= 0.5
  INNER JOIN mapRegions R ON S.regionID = R.regionID
  WHERE fromSolarSystemID IN (30000001, 30002510, 30002659, 30002187, 30000142) 
   AND secureJumps >= 254

(system) #2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.