CAUTION: I don't know how safe it is to query the EDD db while EDD is open. For safety, close EDD before performing any operation on it

Simple tools to help with the Metallicity Survey during DistantWorlds II

This sql script attempts to find all system names that fall under the DW2 Trans-Galactic Metallicity Survey It relies on the FSS Event "FSSAllBodiesFound". It selects all Systems which have a primary star of type K, G, or F.

Use the SQLite Browser for your OS. It is important the the tool supports Json1. The default binary for windows does so. Feel free to use any other tool or a shell. Open the user database in <eddiscoverydir>\Data\EDDUser.sqlite and run the script.

It might take a while, depending on the size of your DB. It isn't optimized for performance and no QA has been done :)