Discussion Complex queries on Systems

[mono_no_aware]

I'm trying to find a way of making complex queries on System data using various third party API tools, but nothing quite fits the bill. The kinds of queries I want to run are, for example,
All systems with Independent Allegiance and Communist Government where arrival star != M, at least 1 station has L landing pad and system population <= 1000. Anyone know if there are any tools where I could make this kind of request?

 

[gazelle]

Download

https://www.edsm.net/dump/systemsPopulated.json

and do it yourself?

 

[Factabulous]

yeah, people use EDSM / EDDB data dumps to populate a local database for those types of adhoc queries

 

[mono_no_aware]

Yes, I thought I might have to do that. Just wanted to see if someone had made something to do it for me. Thanks for your help

 

[T'kael]

There are some tools that can get part of the way there, but I believe your query is more specialized than they're designed to handle. You'll need to use the data dump recommended above. Derive the largest landing pad size from the station model by excluding outposts. The arrival star will be the star with distance (or distanceToArrival) of zero.