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

**URL:** <https://forums.eveonline.com/t/mysql-table-containing-secure-and-insecure-distances-from-and-to-every-system-in-new-eden/61322>\
**Category:** Third Party Developers\
**Tags:** null-sec, low-sec, high-sec\
**Created:** [March 6, 2018, 1:49am UTC](https://forums.eveonline.com/t/mysql-table-containing-secure-and-insecure-distances-from-and-to-every-system-in-new-eden/61322 "2018-03-06T01:49:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EveDataRules](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/evedatarules/32/52946_2.png) [@EveDataRules](https://forums.eveonline.com/u/EveDataRules)\
**Post date:** [March 6, 2018, 1:49am UTC](https://forums.eveonline.com/t/mysql-table-containing-secure-and-insecure-distances-from-and-to-every-system-in-new-eden/61322/1 "2018-03-06T01:49:36Z")

</div>

Download here: [https://github.com/antihax/eve-jumps](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
> 
> ```

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [June 4, 2018, 1:49am UTC](https://forums.eveonline.com/t/mysql-table-containing-secure-and-insecure-distances-from-and-to-every-system-in-new-eden/61322/2 "2018-06-04T01:49:37Z")

</div>

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