MapRegionIceTypes

From EVEDev
Jump to: navigation, search

This table lists available ice types based on mapSolarSystems.regionID and mapSolarSystems.security columns. Drone regions are set to use Gallente racial ice types. The table was exported from mySQL.

Update: Updated for Empyrean Age datadump.

This table only looks up which ice types are present based on region and security status of a given solar system. It does not check if there are ice belts present in the actual system.

Sample SQL

 
SELECT t.typeName FROM mapRegionIceTypes i
LEFT JOIN invTypes t ON i.typeID=t.typeID
LEFT JOIN mapSolarSystems s ON s.regionID=i.regionID
WHERE s.solarSystemName='oe-9uf' AND i.maxSecurity >= s.security AND i.minSecurity <= s.security
 

Data dump

 
CREATE TABLE `mapRegionIceTypes` (
  `regionID` int(11) NOT NULL,
  `typeID` int(11) NOT NULL,
  `maxSecurity` float NOT NULL,
  `minSecurity` float NOT NULL,
  UNIQUE KEY `UNIQUE` (`regionID`,`typeID`)
);
 
INSERT INTO `mapRegionIceTypes` (`regionID`, `typeID`, `maxSecurity`, `minSecurity`) VALUES
(10000033, 16265, 1, 0.05),
(10000033, 17976, 0.049, -1),
(10000033, 16266, 0.35, -0.149),
(10000033, 16268, -0.15, -0.65),
(10000033, 16267, 0.15, -0.449),
(10000033, 16269, -0.5, -1),
(10000002, 16265, 1, 0.05),
(10000002, 17976, 0.049, -1),
(10000002, 16266, 0.35, -0.149),
(10000002, 16268, -0.15, -0.65),
(10000002, 16267, 0.15, -0.449),
(10000002, 16269, -0.5, -1),
(10000016, 16265, 1, 0.05),
(10000016, 17976, 0.049, -1),
(10000016, 16266, 0.35, -0.149),
(10000016, 16268, -0.15, -0.65),
(10000016, 16267, 0.15, -0.449),
(10000016, 16269, -0.5, -1),
(10000069, 16265, 1, 0.05),
(10000069, 17976, 0.049, -1),
(10000069, 16266, 0.35, -0.149),
(10000069, 16268, -0.15, -0.65),
(10000069, 16267, 0.15, -0.449),
(10000069, 16269, -0.5, -1),
(10000055, 16265, 1, 0.05),
(10000055, 17976, 0.049, -1),
(10000055, 16266, 0.35, -0.149),
(10000055, 16268, -0.15, -0.65),
(10000055, 16267, 0.15, -0.449),
(10000055, 16269, -0.5, -1),
(10000035, 16265, 1, 0.05),
(10000035, 17976, 0.049, -1),
(10000035, 16266, 0.35, -0.149),
(10000035, 16268, -0.15, -0.65),
(10000035, 16267, 0.15, -0.449),
(10000035, 16269, -0.5, -1),
(10000029, 16265, 1, 0.05),
(10000029, 17976, 0.049, -1),
(10000029, 16266, 0.35, -0.149),
(10000029, 16268, -0.15, -0.65),
(10000029, 16267, 0.15, -0.449),
(10000029, 16269, -0.5, -1),
(10000023, 16265, 1, 0.05),
(10000023, 17976, 0.049, -1),
(10000023, 16266, 0.35, -0.149),
(10000023, 16268, -0.15, -0.65),
(10000023, 16267, 0.15, -0.449),
(10000023, 16269, -0.5, -1),
(10000045, 16265, 1, 0.05),
(10000045, 17976, 0.049, -1),
(10000045, 16266, 0.35, -0.149),
(10000045, 16268, -0.15, -0.65),
(10000045, 16267, 0.15, -0.449),
(10000045, 16269, -0.5, -1),
(10000010, 16265, 1, 0.05),
(10000010, 17976, 0.049, -1),
(10000010, 16266, 0.35, -0.149),
(10000010, 16268, -0.15, -0.65),
(10000010, 16267, 0.15, -0.449),
(10000010, 16269, -0.5, -1),
(10000003, 16265, 1, 0.05),
(10000003, 17976, 0.049, -1),
(10000003, 16266, 0.35, -0.149),
(10000003, 16268, -0.15, -0.65),
(10000003, 16267, 0.15, -0.449),
(10000003, 16269, -0.5, -1),
(10000015, 16265, 1, 0.05),
(10000015, 17976, 0.049, -1),
(10000015, 16266, 0.35, -0.149),
(10000015, 16268, -0.15, -0.65),
(10000015, 16267, 0.15, -0.449),
(10000015, 16269, -0.5, -1),
(10000030, 16263, 1, 0.05),
(10000030, 17977, 0.049, -1),
(10000030, 16266, 0.35, -0.149),
(10000030, 16268, -0.15, -0.65),
(10000030, 16267, 0.15, -0.449),
(10000030, 16269, -0.5, -1),
(10000042, 16263, 1, 0.05),
(10000042, 17977, 0.049, -1),
(10000042, 16266, 0.35, -0.149),
(10000042, 16268, -0.15, -0.65),
(10000042, 16267, 0.15, -0.449),
(10000042, 16269, -0.5, -1),
(10000028, 16263, 1, 0.05),
(10000028, 17977, 0.049, -1),
(10000028, 16266, 0.35, -0.149),
(10000028, 16268, -0.15, -0.65),
(10000028, 16267, 0.15, -0.449),
(10000028, 16269, -0.5, -1),
(10000007, 16263, 1, 0.05),
(10000007, 17977, 0.049, -1),
(10000007, 16266, 0.35, -0.149),
(10000007, 16268, -0.15, -0.65),
(10000007, 16267, 0.15, -0.449),
(10000007, 16269, -0.5, -1),
(10000012, 16263, 1, 0.05),
(10000012, 17977, 0.049, -1),
(10000012, 16266, 0.35, -0.149),
(10000012, 16268, -0.15, -0.65),
(10000012, 16267, 0.15, -0.449),
(10000012, 16269, -0.5, -1),
(10000005, 16263, 1, 0.05),
(10000005, 17977, 0.049, -1),
(10000005, 16266, 0.35, -0.149),
(10000005, 16268, -0.15, -0.65),
(10000005, 16267, 0.15, -0.449),
(10000005, 16269, -0.5, -1),
(10000056, 16263, 1, 0.05),
(10000056, 17977, 0.049, -1),
(10000056, 16266, 0.35, -0.149),
(10000056, 16268, -0.15, -0.65),
(10000056, 16267, 0.15, -0.449),
(10000056, 16269, -0.5, -1),
(10000011, 16263, 1, 0.05),
(10000011, 17977, 0.049, -1),
(10000011, 16266, 0.35, -0.149),
(10000011, 16268, -0.15, -0.65),
(10000011, 16267, 0.15, -0.449),
(10000011, 16269, -0.5, -1),
(10000025, 16263, 1, 0.05),
(10000025, 17977, 0.049, -1),
(10000025, 16266, 0.35, -0.149),
(10000025, 16268, -0.15, -0.65),
(10000025, 16267, 0.15, -0.449),
(10000025, 16269, -0.5, -1),
(10000031, 16263, 1, 0.05),
(10000031, 17977, 0.049, -1),
(10000031, 16266, 0.35, -0.149),
(10000031, 16268, -0.15, -0.65),
(10000031, 16267, 0.15, -0.449),
(10000031, 16269, -0.5, -1),
(10000009, 16263, 1, 0.05),
(10000009, 17977, 0.049, -1),
(10000009, 16266, 0.35, -0.149),
(10000009, 16268, -0.15, -0.65),
(10000009, 16267, 0.15, -0.449),
(10000009, 16269, -0.5, -1),
(10000062, 16263, 1, 0.05),
(10000062, 17977, 0.049, -1),
(10000062, 16266, 0.35, -0.149),
(10000062, 16268, -0.15, -0.65),
(10000062, 16267, 0.15, -0.449),
(10000062, 16269, -0.5, -1),
(10000008, 16263, 1, 0.05),
(10000008, 17977, 0.049, -1),
(10000008, 16266, 0.35, -0.149),
(10000008, 16268, -0.15, -0.65),
(10000008, 16267, 0.15, -0.449),
(10000008, 16269, -0.5, -1),
(10000061, 16263, 1, 0.05),
(10000061, 17977, 0.049, -1),
(10000061, 16266, 0.35, -0.149),
(10000061, 16268, -0.15, -0.65),
(10000061, 16267, 0.15, -0.449),
(10000061, 16269, -0.5, -1),
(10000006, 16263, 1, 0.05),
(10000006, 17977, 0.049, -1),
(10000006, 16266, 0.35, -0.149),
(10000006, 16268, -0.15, -0.65),
(10000006, 16267, 0.15, -0.449),
(10000006, 16269, -0.5, -1),
(10000064, 16264, 1, 0.05),
(10000064, 17975, 0.049, -1),
(10000064, 16266, 0.35, -0.149),
(10000064, 16268, -0.15, -0.65),
(10000064, 16267, 0.15, -0.449),
(10000064, 16269, -0.5, -1),
(10000037, 16264, 1, 0.05),
(10000037, 17975, 0.049, -1),
(10000037, 16266, 0.35, -0.149),
(10000037, 16268, -0.15, -0.65),
(10000037, 16267, 0.15, -0.449),
(10000037, 16269, -0.5, -1),
(10000048, 16264, 1, 0.05),
(10000048, 17975, 0.049, -1),
(10000048, 16266, 0.35, -0.149),
(10000048, 16268, -0.15, -0.65),
(10000048, 16267, 0.15, -0.449),
(10000048, 16269, -0.5, -1),
(10000032, 16264, 1, 0.05),
(10000032, 17975, 0.049, -1),
(10000032, 16266, 0.35, -0.149),
(10000032, 16268, -0.15, -0.65),
(10000032, 16267, 0.15, -0.449),
(10000032, 16269, -0.5, -1),
(10000044, 16264, 1, 0.05),
(10000044, 17975, 0.049, -1),
(10000044, 16266, 0.35, -0.149),
(10000044, 16268, -0.15, -0.65),
(10000044, 16267, 0.15, -0.449),
(10000044, 16269, -0.5, -1),
(10000068, 16264, 1, 0.05),
(10000068, 17975, 0.049, -1),
(10000068, 16266, 0.35, -0.149),
(10000068, 16268, -0.15, -0.65),
(10000068, 16267, 0.15, -0.449),
(10000068, 16269, -0.5, -1),
(10000051, 16264, 1, 0.05),
(10000051, 17975, 0.049, -1),
(10000051, 16266, 0.35, -0.149),
(10000051, 16268, -0.15, -0.65),
(10000051, 16267, 0.15, -0.449),
(10000051, 16269, -0.5, -1),
(10000046, 16264, 1, 0.05),
(10000046, 17975, 0.049, -1),
(10000046, 16266, 0.35, -0.149),
(10000046, 16268, -0.15, -0.65),
(10000046, 16267, 0.15, -0.449),
(10000046, 16269, -0.5, -1),
(10000058, 16264, 1, 0.05),
(10000058, 17975, 0.049, -1),
(10000058, 16266, 0.35, -0.149),
(10000058, 16268, -0.15, -0.65),
(10000058, 16267, 0.15, -0.449),
(10000058, 16269, -0.5, -1),
(10000057, 16264, 1, 0.05),
(10000057, 17975, 0.049, -1),
(10000057, 16266, 0.35, -0.149),
(10000057, 16268, -0.15, -0.65),
(10000057, 16267, 0.15, -0.449),
(10000057, 16269, -0.5, -1),
(10000041, 16264, 1, 0.05),
(10000041, 17975, 0.049, -1),
(10000041, 16266, 0.35, -0.149),
(10000041, 16268, -0.15, -0.65),
(10000041, 16267, 0.15, -0.449),
(10000041, 16269, -0.5, -1),
(10000034, 16264, 1, 0.05),
(10000034, 17975, 0.049, -1),
(10000034, 16266, 0.35, -0.149),
(10000034, 16268, -0.15, -0.65),
(10000034, 16267, 0.15, -0.449),
(10000034, 16269, -0.5, -1),
(10000013, 16264, 1, 0.05),
(10000013, 17975, 0.049, -1),
(10000013, 16266, 0.35, -0.149),
(10000013, 16268, -0.15, -0.65),
(10000013, 16267, 0.15, -0.449),
(10000013, 16269, -0.5, -1),
(10000066, 16264, 1, 0.05),
(10000066, 17975, 0.049, -1),
(10000066, 16266, 0.35, -0.149),
(10000066, 16268, -0.15, -0.65),
(10000066, 16267, 0.15, -0.449),
(10000066, 16269, -0.5, -1),
(10000053, 16264, 1, 0.05),
(10000053, 17975, 0.049, -1),
(10000053, 16266, 0.35, -0.149),
(10000053, 16268, -0.15, -0.65),
(10000053, 16267, 0.15, -0.449),
(10000053, 16269, -0.5, -1),
(10000040, 16264, 1, 0.05),
(10000040, 17975, 0.049, -1),
(10000040, 16266, 0.35, -0.149),
(10000040, 16268, -0.15, -0.65),
(10000040, 16267, 0.15, -0.449),
(10000040, 16269, -0.5, -1),
(10000027, 16264, 1, 0.05),
(10000027, 17975, 0.049, -1),
(10000027, 16266, 0.35, -0.149),
(10000027, 16268, -0.15, -0.65),
(10000027, 16267, 0.15, -0.449),
(10000027, 16269, -0.5, -1),
(10000018, 16264, 1, 0.05),
(10000018, 17975, 0.049, -1),
(10000018, 16266, 0.35, -0.149),
(10000018, 16268, -0.15, -0.65),
(10000018, 16267, 0.15, -0.449),
(10000018, 16269, -0.5, -1),
(10000021, 16264, 1, 0.05),
(10000021, 17975, 0.049, -1),
(10000021, 16266, 0.35, -0.149),
(10000021, 16268, -0.15, -0.65),
(10000021, 16267, 0.15, -0.449),
(10000021, 16269, -0.5, -1),
(10000054, 16262, 1, 0.05),
(10000054, 17978, 0.049, -1),
(10000054, 16266, 0.35, -0.149),
(10000054, 16268, -0.15, -0.65),
(10000054, 16267, 0.15, -0.449),
(10000054, 16269, -0.5, -1),
(10000001, 16262, 1, 0.05),
(10000001, 17978, 0.049, -1),
(10000001, 16266, 0.35, -0.149),
(10000001, 16268, -0.15, -0.65),
(10000001, 16267, 0.15, -0.449),
(10000001, 16269, -0.5, -1),
(10000036, 16262, 1, 0.05),
(10000036, 17978, 0.049, -1),
(10000036, 16266, 0.35, -0.149),
(10000036, 16268, -0.15, -0.65),
(10000036, 16267, 0.15, -0.449),
(10000036, 16269, -0.5, -1),
(10000043, 16262, 1, 0.05),
(10000043, 17978, 0.049, -1),
(10000043, 16266, 0.35, -0.149),
(10000043, 16268, -0.15, -0.65),
(10000043, 16267, 0.15, -0.449),
(10000043, 16269, -0.5, -1),
(10000067, 16262, 1, 0.05),
(10000067, 17978, 0.049, -1),
(10000067, 16266, 0.35, -0.149),
(10000067, 16268, -0.15, -0.65),
(10000067, 16267, 0.15, -0.449),
(10000067, 16269, -0.5, -1),
(10000052, 16262, 1, 0.05),
(10000052, 17978, 0.049, -1),
(10000052, 16266, 0.35, -0.149),
(10000052, 16268, -0.15, -0.65),
(10000052, 16267, 0.15, -0.449),
(10000052, 16269, -0.5, -1),
(10000049, 16262, 1, 0.05),
(10000049, 17978, 0.049, -1),
(10000049, 16266, 0.35, -0.149),
(10000049, 16268, -0.15, -0.65),
(10000049, 16267, 0.15, -0.449),
(10000049, 16269, -0.5, -1),
(10000065, 16262, 1, 0.05),
(10000065, 17978, 0.049, -1),
(10000065, 16266, 0.35, -0.149),
(10000065, 16268, -0.15, -0.65),
(10000065, 16267, 0.15, -0.449),
(10000065, 16269, -0.5, -1),
(10000020, 16262, 1, 0.05),
(10000020, 17978, 0.049, -1),
(10000020, 16266, 0.35, -0.149),
(10000020, 16268, -0.15, -0.65),
(10000020, 16267, 0.15, -0.449),
(10000020, 16269, -0.5, -1),
(10000038, 16262, 1, 0.05),
(10000038, 17978, 0.049, -1),
(10000038, 16266, 0.35, -0.149),
(10000038, 16268, -0.15, -0.65),
(10000038, 16267, 0.15, -0.449),
(10000038, 16269, -0.5, -1),
(10000014, 16262, 1, 0.05),
(10000014, 17978, 0.049, -1),
(10000014, 16266, 0.35, -0.149),
(10000014, 16268, -0.15, -0.65),
(10000014, 16267, 0.15, -0.449),
(10000014, 16269, -0.5, -1),
(10000060, 16262, 1, 0.05),
(10000060, 17978, 0.049, -1),
(10000060, 16266, 0.35, -0.149),
(10000060, 16268, -0.15, -0.65),
(10000060, 16267, 0.15, -0.449),
(10000060, 16269, -0.5, -1),
(10000039, 16262, 1, 0.05),
(10000039, 17978, 0.049, -1),
(10000039, 16266, 0.35, -0.149),
(10000039, 16268, -0.15, -0.65),
(10000039, 16267, 0.15, -0.449),
(10000039, 16269, -0.5, -1),
(10000059, 16262, 1, 0.05),
(10000059, 17978, 0.049, -1),
(10000059, 16266, 0.35, -0.149),
(10000059, 16268, -0.15, -0.65),
(10000059, 16267, 0.15, -0.449),
(10000059, 16269, -0.5, -1),
(10000063, 16262, 1, 0.05),
(10000063, 17978, 0.049, -1),
(10000063, 16266, 0.35, -0.149),
(10000063, 16268, -0.15, -0.65),
(10000063, 16267, 0.15, -0.449),
(10000063, 16269, -0.5, -1),
(10000047, 16262, 1, 0.05),
(10000047, 17978, 0.049, -1),
(10000047, 16266, 0.35, -0.149),
(10000047, 16268, -0.15, -0.65),
(10000047, 16267, 0.15, -0.449),
(10000047, 16269, -0.5, -1),
(10000050, 16262, 1, 0.05),
(10000050, 17978, 0.049, -1),
(10000050, 16266, 0.35, -0.149),
(10000050, 16268, -0.15, -0.65),
(10000050, 16267, 0.15, -0.449),
(10000050, 16269, -0.5, -1),
(10000022, 16262, 1, 0.05),
(10000022, 17978, 0.049, -1),
(10000022, 16266, 0.35, -0.149),
(10000022, 16268, -0.15, -0.65),
(10000022, 16267, 0.15, -0.449),
(10000022, 16269, -0.5, -1);
 
Personal tools