One question was always bugging me: how to get the ores and ices in a system. The current approach by many others was to use the securityClass value of the mapSolarSystems table and combine it with manually generated data.
None of the above was a satisfying solution, so I went back into the data dump. Then I started to look at the eveItems table. A table with more than 6 million entries must be good for something. After some testing the query was done:
SELECT items.locationID AS systemID, sys.solarSystemName AS systemName, items.typeID AS oreID , types.typeName AS oreName, IF (types.groupID = 465, 'ice', 'ore') AS beltType FROM invItems AS items INNER JOIN mapSolarSystems AS sys ON items.locationID = sys.solarSystemID INNER JOIN invTypes AS types ON items.typeID = types.typeID INNER JOIN invGroups AS grps ON types.groupID = grps.groupID WHERE grps.categoryID = 25 GROUP BY items.typeID, items.locationID ORDER BY items.locationID
This creates a list of ores and ices per solar system. Extending the where clause allows you to limit the result to certain types or regions.
-- All belts and ice fields in the metropolis region AND sys.regionID = 10000042 -- Show all systems with Glacial Mass AND items.typeID = 16263
Have fun with it.