Query for anyone who wants to create his own atlas xls for any map if they have the respective map dump file.
Thanks Cory for posting the file for the v2 map(v2.db):
discord.com/channels/354299073689419779/359350778277920772/844206472061911050select
mq.name QuadName, --Sector/Quad name,
mf.factionName PrimaryFaction, -- quad Primary Faction,
mp.name PlanetName, --System/Planet name,
mz.name ZoneName,
CASE
WHEN mz.factionId =0 THEN 'Independents'
WHEN mz.factionId =1 THEN 'De Valtos Syndicate'
WHEN mz.factionId =2 THEN 'Cadar Syndicate'
WHEN mz.factionId =3 THEN 'Syndicate Rychart'
WHEN mz.factionId =4 THEN 'House Thulun'
WHEN mz.factionId =5 THEN 'Clan Javat'
WHEN mz.factionId =6 THEN 'Steel Song Clan'
WHEN mz.factionId =7 THEN 'Moklumnue Clan'
WHEN mz.factionId =8 THEN 'Clan Alta Mesa'
WHEN mz.factionId =9 THEN 'Clan Zenrin'
WHEN mz.factionId =10 THEN 'Templar Order'
ELSE 'UNDEFINED'
END as Owner, --zone faction
mz.zoneType ZoneNType, -- zone type number
CASE
WHEN mz.zoneType =1 THEN 'Population'
WHEN mz.zoneType =2 THEN 'Farming'
WHEN mz.zoneType =3 THEN 'Mining'
WHEN mz.zoneType =4 THEN 'Refinery'
WHEN mz.zoneType =5 THEN 'Industrial'
WHEN mz.zoneType =6 THEN 'High Tech Industrial'
WHEN mz.zoneType =7 THEN 'Luxury Population'
WHEN mz.zoneType =8 THEN 'Tradeway'
WHEN mz.zoneType =9 THEN 'Wilderness'
WHEN mz.zoneType =10 THEN 'Orbital'
ELSE 'UNDEFINED'
END as ZoneType, --zone type name
mz.econRating Econ,
mz.populationRating Pop,
mz.starportRating Port,
mz.militaryRating Mil,
mz.govRating Govt,
mz.spiceRating Spice,
mz.lawType TradeLaw,
mz.richnessRating Rich, -- explorer richness
mz.explorerRating Exp, --Explorer rating
mz.dangerRating ExpDanger, --Exploration danger
mp.size PlanetNSize,--PlanetN size
CASE
WHEN mp.size=1 THEN 'Tiny'
WHEN mp.size=2 THEN 'Small'
WHEN mp.size=3 THEN 'Standard'
WHEN mp.size=4 THEN 'Large'
WHEN mp.size=5 THEN 'Huge'
ELSE 'UNDEFINED'
END as PlanetSize, --Planet size,
mp.type PlanetNType,--Planet type,
CASE
WHEN mp.type =1 THEN 'Ice'
WHEN mp.type =2 THEN 'Desert'
WHEN mp.type =3 THEN 'Desert'
WHEN mp.type =4 THEN 'Garden'
WHEN mp.type =5 THEN 'Garden'
WHEN mp.type =6 THEN 'Oceanic'
WHEN mp.type =7 THEN 'Oceanic'
WHEN mp.type =8 THEN 'Jungle'
WHEN mp.type =9 THEN 'Jungle'
WHEN mp.type =10 THEN 'Radiation'
WHEN mp.type =11 THEN 'Radiation'
WHEN mp.type =12 THEN 'Molten'
ELSE 'UNDEFINED'
END as PlanetTypeName, --Planet type Name,
mp.atmosphere AtmoN,--Planet Atmo Number,
CASE
WHEN mp.atmosphere =1 THEN 'Hard vaccum'
WHEN mp.atmosphere =2 THEN 'Vaccum'
WHEN mp.atmosphere =3 THEN 'Thin'
WHEN mp.atmosphere =4 THEN 'Very Thin'
WHEN mp.atmosphere =5 THEN 'Standard'
WHEN mp.atmosphere =6 THEN 'Standard'
WHEN mp.atmosphere =7 THEN 'Dense'
WHEN mp.atmosphere =8 THEN 'Very Dense'
WHEN mp.atmosphere =9 THEN 'Ultra Dense'
WHEN mp.atmosphere =10 THEN 'Extreme'
ELSE 'UNDEFINED'
END as Atmo, --Atmo name
mp.danger PlanetNDanger, --Planet Danger Number
CASE
WHEN mp.danger =0 THEN 'Very safe'
WHEN mp.danger =1 THEN 'Safe'
WHEN mp.danger =2 THEN 'Harmless'
WHEN mp.danger =3 THEN 'Benign'
WHEN mp.danger =4 THEN 'Normal'
WHEN mp.danger =5 THEN 'Tainted'
WHEN mp.danger =6 THEN 'Hazardous'
WHEN mp.danger =7 THEN 'Toxic'
WHEN mp.danger =8 THEN 'Corrosive'
WHEN mp.danger =9 THEN 'Deadly'
WHEN mp.danger =10 THEN 'Insidious'
ELSE 'UNDEFINED'
END as PlanetDanger --Planet Danger Name
from MapZone mz, MapPlanet mp, MapFaction mf , MapQuadrant mq
where mz.planetId=mp._id
and mf._id=mq.factionId
and mq.regionId=mp.regionId
Cheers
