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

EVE Technology and Research Center Third Party Developers
, ,
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
1 Like
2

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