raorn wrote:There are lots and lots of Passenger Mission Guides everywhere and I'm not going to write just another one. Instead, I made simple tool that helps you find those "The Two" systems without clicking the hell out of EDDB. Included README explains the process a bit, feel free to ask questions and if you think you can improve something - pull requests are most welcome
https://github.com/raorn/EliteDangerousP.S. And I also made a copy of Reddit thread about combat outfitting. Check out the docs/ foder.
Ok, I just need to rebuild the db to check the faction stuff, but without that, the output from my patch currently looks like this:
► Show Spoiler
username@one:~/src/EliteDangerous$ bundle exec ./bin/edpmh search --min-dist=1000000
2 possible targets found:
[ 8 sources within 15 Ly of the Destination. ]
Destination System: LTT 9360 (12853)
Allegiance: Independent (Dictatorship)
Power: Archon Delaine (Exploited)
Primary Economy: Industrial
Station: Gregory Park (10421), 1865738 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Smeaton Orbital (10419), 1871713 Ls
Type: Ocellus Starport
Landing Pad: L
Station: Deere Horizons (10420), 1873132 Ls
Type: Commercial Outpost
Landing Pad: M
[ Source pool: 11 systems within 15 Ly radius having landing pad size: L ]
System: LTT 9455 (12857), 3.06 Ly
Allegiance: Federation (Democracy)
Power: Archon Delaine (Exploited)
Primary Economy: High Tech
Station: O'Leary Vision (7910), 15 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Shaw Refinery (42312), 15 Ls
Type: Planetary Port
Landing Pad: L
Station: Shaikh Horizons (7911), 25 Ls
Type: Scientific Outpost
Landing Pad: M
Station: Goonan Station (7909), 39 Ls
Type: Commercial Outpost
Landing Pad: M
Station: Lee Settlement (47491), 39 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Gaffney Vision (42850), 1258 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 10 systems within 15 Ly radius having landing pad size: L ]
System: HK Aquarii (9085), 10.5 Ly
Allegiance: Independent (Dictatorship)
Primary Economy: Industrial
Station: Leestma Enterprise (16443), 490 Ls
Type: Ocellus Starport
Landing Pad: L
Station: Dunn Laboratory (45327), 515 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Torricelli Enterprise (16444), 895 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Usachov Dock (16445), 1239 Ls
Type: Commercial Outpost
Landing Pad: M
[ Source pool: 15 systems within 15 Ly radius having landing pad size: L ]
System: LP 762-3 (12478), 10.7 Ly
Allegiance: Independent (Dictatorship)
Power: Yuri Grom (Exploited)
Primary Economy: Refinery
Station: Lucretius Port (7772), 8 Ls
Type: Mining Outpost
Landing Pad: M
Station: Houssay Outpost (23133), 22 Ls
Type: Mining Outpost
Landing Pad: M
Station: McCoy Landing (47448), 22 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 8 systems within 15 Ly radius having landing pad size: L ]
System: LP 876-26 (12511), 10.97 Ly
Allegiance: Independent (Feudal)
Power: Zachary Hudson (Exploited)
Primary Economy: Colony
Station: Haipeng Terminal (7787), 1905 Ls
Type: Mining Outpost
Landing Pad: M
Station: White Mines (7788), 1919 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Napier's Claim (68515), 1931 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Bogdanov Prospect (68516), 1948 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Galiano Beacon (42052), 3276 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Chang-Diaz Penal Colony (68517), 3276 Ls
Type: Planetary Settlement
Landing Pad: None
[ Source pool: 11 systems within 15 Ly radius having landing pad size: L ]
System: Upsilon Aquarii (18277), 11.34 Ly
Allegiance: Independent (Cooperative)
Primary Economy: Industrial
Station: Allen Hub (4447), 209 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Jones Legacy (43206), 209 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Winne Station (10397), 491 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Hackworth Port (10398), 494 Ls
Type: Commercial Outpost
Landing Pad: M
[ Source pool: 10 systems within 15 Ly radius having landing pad size: L ]
System: GD 1192 (5146), 11.76 Ly
Allegiance: Independent (Dictatorship)
Primary Economy: Industrial
Station: Melvin Hub (13903), 424 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Kotov City (27038), 587 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Wheeler Arsenal (47914), 588 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 10 systems within 15 Ly radius having landing pad size: L ]
System: Huichi (9538), 12.49 Ly
Allegiance: Independent (Anarchy)
Power: Archon Delaine (Control)
Primary Economy: Industrial
Station: Collins Station (11946), 112 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Johnson Orbital (16447), 156 Ls
Type: Industrial Outpost
Landing Pad: M
[ Source pool: 9 systems within 15 Ly radius having landing pad size: L ]
System: LHS 538 (12117), 14.1 Ly
Allegiance: Independent (Dictatorship)
Power: Archon Delaine (Exploited)
Primary Economy: Industrial
Station: Jemison Vision (3948), 750 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Pytheas Point (61142), 794 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Eisele Point (42849), 1544 Ls
Type: Planetary Outpost
Landing Pad: L
[ 12 sources within 15 Ly of the Destination. ]
Destination System: Medb (13516)
Allegiance: Federation (Corporate)
Power: Zachary Hudson (Exploited)
Primary Economy: Refinery
Station: Meade Terminal (8039), 1683871 Ls
Type: Military Outpost
Landing Pad: M
Station: Clark Terminal (8038), 1684642 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Vela Dock (1159), 1687051 Ls
Type: Ocellus Starport
Landing Pad: L
Station: Lie Silo (42132), 1687052 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 10 systems within 15 Ly radius having landing pad size: L ]
System: Eea (4464), 5.72 Ly
Allegiance: Federation (Corporate)
Power: Zachary Hudson (Exploited)
Primary Economy: Military
Station: Shriver Settlement (1146), 415 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Bell Colony (1148), 758 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Malocello Point (42925), 2784 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 14 systems within 15 Ly radius having landing pad size: L ]
System: Edenapel (4454), 7.06 Ly
Allegiance: Federation (Corporate)
Power: Zachary Hudson (Exploited)
Primary Economy: Agriculture
Station: Yu Market (290), 81 Ls
Type: Orbis Starport
Landing Pad: L
Station: Tapinas Escape (44212), 113 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Cousin's Folly (44213), 113 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Lanier Station (288), 118 Ls
Type: Orbis Starport
Landing Pad: L
Station: Sleator Port (284), 208 Ls
Type: Orbis Starport
Landing Pad: L
Station: Meyrink Station (18259), 2832 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Williams Prospect (44218), 2858 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Lowry City (18255), 2864 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Womack Hub (18256), 2864 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Hennepin Station (18254), 2871 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Potrykus City (42896), 2902 Ls
Type: Planetary Port
Landing Pad: L
Station: Schilling Terminal (44054), 2930 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Kessel Hub (18258), 2935 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Fuchs Port (18253), 2946 Ls
Type: Orbis Starport
Landing Pad: L
Station: Crick Enterprise (44222), 4499 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Norman Landing (44217), 4528 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Rucker Depot (44220), 4528 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Metz Arsenal (44221), 4528 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Hovgaard's Folly (44223), 4528 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Moorcock Deport (44216), 4532 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Newcomen Vision (44214), 4594 Ls
Type: Planetary Settlement
Landing Pad: None
Station: Fearn Vision (44215), 4594 Ls
Type: Planetary Settlement
Landing Pad: None
[ Source pool: 8 systems within 15 Ly radius having landing pad size: L ]
System: Corycia (3864), 7.94 Ly
Allegiance: Federation (Democracy)
Primary Economy: Industrial
Station: Piper Hub (270), 34 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Lasswitz Hub (50613), 34 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Paez Hub (50614), 34 Ls
Type: Planetary Port
Landing Pad: L
Station: Drexler Hub (278), 59 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Armstrong Port (13176), 103 Ls
Type: Commercial Outpost
Landing Pad: M
[ Source pool: 8 systems within 15 Ly radius having landing pad size: L ]
System: Kamuy (10400), 10.19 Ly
Allegiance: Independent (Dictatorship)
Primary Economy: Industrial
Station: Low Bastion (48519), 741 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Ockels Terminal (2324), 1287 Ls
Type: Ocellus Starport
Landing Pad: L
[ Source pool: 11 systems within 15 Ly radius having landing pad size: L ]
System: LHS 6031 (12125), 11.41 Ly
Allegiance: Federation (Democracy)
Power: Zachary Hudson (Exploited)
Primary Economy: Agriculture
Station: Dobrovolskiy Station (7646), 388 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Appel Dock (7645), 193826 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Volta Hub (7650), 193888 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Farkas Terminal (7647), 193892 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Tudela Point (51799), 193919 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Hopkinson Town (46444), 193922 Ls
Type: Planetary Port
Landing Pad: L
Station: Fontana Dock (1242), 193927 Ls
Type: Ocellus Starport
Landing Pad: L
Station: Polansky Hub (7649), 193927 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Oefelein Terminal (7648), 193962 Ls
Type: Coriolis Starport
Landing Pad: L
[ Source pool: 9 systems within 15 Ly radius having landing pad size: L ]
System: Isleta (9892), 12.03 Ly
Allegiance: Independent (Dictatorship)
Power: Zachary Hudson (Exploited)
Primary Economy: Industrial
Station: Olsen Station (296), 277 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Ivanov Enterprise (14801), 171025 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Atwater Dock (14802), 171025 Ls
Type: Mining Outpost
Landing Pad: M
Station: Shinn's Inheritance (51843), 171034 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Palmer's Progress (50735), 171047 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 7 systems within 15 Ly radius having landing pad size: L ]
System: Nornari (14726), 12.71 Ly
Allegiance: Federation (Corporate)
Power: Zachary Hudson (Exploited)
Primary Economy: Refinery
Station: Semeonis Orbital (856), 14 Ls
Type: Coriolis Starport
Landing Pad: L
Station: Carstensz Settlement (51584), 14 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Klein Orbital (5108), 1000 Ls
Type: Civilian Outpost
Landing Pad: M
[ Source pool: 12 systems within 15 Ly radius having landing pad size: L ]
System: Mulachi (13931), 12.9 Ly
Allegiance: Independent (Corporate)
Power: Zachary Hudson (Control)
Primary Economy: Agriculture
Station: Akers Market (3455), 549 Ls
Type: Orbis Starport
Landing Pad: L
Station: Cauchy Installation (62157), 550 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Shepard Enterprise (8123), 594402 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Fleming City (1246), 594452 Ls
Type: Orbis Starport
Landing Pad: L
Station: Clark Terminal (700), 594470 Ls
Type: Orbis Starport
Landing Pad: L
Station: Laue City (8122), 594474 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Gernhardt Terminal (8121), 594475 Ls
Type: Orbis Starport
Landing Pad: L
Station: Eisenstein Plant (47258), 594487 Ls
Type: Planetary Port
Landing Pad: L
Station: Jemison's Pride (42562), 594493 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Simonyi Enterprise (8124), 594503 Ls
Type: Civilian Outpost
Landing Pad: M
Station: Clark Hub (8119), 594515 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Dalton Orbital (8120), 594536 Ls
Type: Civilian Outpost
Landing Pad: M
[ Source pool: 13 systems within 15 Ly radius having landing pad size: L ]
System: Nu-2 Lupi (14766), 13.08 Ly
Allegiance: Independent (Dictatorship)
Primary Economy: Refinery
Station: Pudwill Gorie Holdings (264), 1567 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Gauss City (63), 3425 Ls
Type: Industrial Outpost
Landing Pad: M
Station: West Asylum (53523), 168021 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 12 systems within 15 Ly radius having landing pad size: L ]
System: LP 917-1 (12522), 14.22 Ly
Allegiance: Federation (Corporate)
Primary Economy: Industrial
Station: Daimler Station (12634), 9 Ls
Type: Ocellus Starport
Landing Pad: L
Station: Kagan Enterprise (42903), 9 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Ferguson Ring (14803), 16 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Acharya Landing (42907), 16 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Thirsk Port (14804), 1096 Ls
Type: Civilian Outpost
Landing Pad: M
[ Source pool: 16 systems within 15 Ly radius having landing pad size: L ]
System: Jiuyou (10145), 14.37 Ly
Allegiance: Federation (Corporate)
Power: Felicia Winters (Exploited)
Primary Economy: Military
Station: Keyes Refinery (3366), 347 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Birmingham Freeport (13187), 471 Ls
Type: Industrial Outpost
Landing Pad: M
Station: Hiraga Arsenal (53373), 889 Ls
Type: Planetary Port
Landing Pad: L
Station: Poncelet Survey (53374), 889 Ls
Type: Planetary Outpost
Landing Pad: L
[ Source pool: 9 systems within 15 Ly radius having landing pad size: L ]
System: Parutis (15351), 14.74 Ly
Allegiance: Federation (Corporate)
Power: Zachary Hudson (Control)
Primary Economy: Agriculture
Station: Evans Port (905), 302 Ls
Type: Orbis Starport
Landing Pad: L
Station: Teng-hui Hub (511), 503 Ls
Type: Orbis Starport
Landing Pad: L
Station: Menzies Penal colony (43148), 504 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Shuttleworth Terminal (45842), 504 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Nelson Base (58600), 504 Ls
Type: Planetary Outpost
Landing Pad: L
Station: Schweickart City (516), 839 Ls
Type: Orbis Starport
Landing Pad: L
Station: Parmitano Station (520), 1383 Ls
Type: Orbis Starport
Landing Pad: L
As you can see, Nornari may be an even better system for Medb, with a mission pool of 7 (Vs Kamuy's 8 and Parutis' 9)
Nornari also has 7 factions and according to
https://eddb.io/system/factions/14726 3 of those can be boosted with exploration data.
The Nornari source station is a mere 14 Ls out from the star too, so faster turnarounds, not that it matters much.
For runs out to Smeaton, LHS 538 is likely a better system with 7 factions and 9 in the pool Vs 6 factions and 11 pool for Upsilon Aquarii.
Dea Motrona has potential too (higher arrival distance than Medb, but only 1 destination) if you don't mind planetary landings, but it's not matched by the tool at the moment.
Now. it's possible that since the mission pool isn't the only source of missions (because of VIPs going where ever the hell they want etc), the pool may not even be much of a factor. It's hard to say one way or the other without doing some kind of statistical analysis (nope).
I'm not sure why my indentation is being clobbered by the board. Here's a pastebin link with indentation:
https://pastebin.com/s2dse4EdRealistically, this is probably a crap hack. I've had to learn about ruby, sequel and sql a bit so you may want to implement these changes yourself, if you are interested in them. I'll sort out a patch when I've checked that the faction additions to the db are working though and then it's up to you.
Edit: the other issue is that if you have a lower system pool but a higher overall number of stations across those systems, the effective pool may end up being larger. My SQL fu is not strong though so I'll have to investigate that after some wax on - wax off.