Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.
Revision as of 19:12, 26 August 2025 by Emjay Yvormes (talk | contribs) (added more SDE info)

CCP provides developers a series of static files, known as the Static Data Export(SDE), which contains static data from the Tranquility server. The SDE is currently exported as .yaml and .static files, however, different and easier to use formats(mentioned below) are made by the community. The SDE can be found at the EVE developers Services and Resource page. All resources provided by CCP are subject to the developer license agreement.

Fuzzwork SDE Conversions

To aide fellow developers and players in consuming this data without having to extract or convert from YAML or static format every time Steve Ronuken has hosted conversions in PostgreSQL, SQLite, MySQL, MSSQL, and CSV formats. They can be found at Fuzzwork under SDE or more directly at www.fuzzwork.co.uk/dump. Individual table data can be found in CSV and SQL (MySQL) formats here www.fuzzwork.co.uk/dump/latest.

Opening a file from Fuzzwork SDE Conversions

To extract data from compressed files, use tar for .tar.bz2 files or bunzip2 for .bz2 files in Linux, and something like 7-zip for either format in Windows. Once extracted the files can be opened in the appropriate application that supports the file format.

How does the ESI fit into all this?

The EVE Swagger Interface intends to have endpoints to account for all of the SDE, currently, it's not quite there yet, and the SDE is needed for many projects. The progress can be tracked here.

How to implement the original SDE into your application

Step 0: Preface

This is not a guide to Python or programming, if you don't know how to program, there are tons of resources to learn to code, there are a few of my favorites in the External Links section down below, if your having issues, contact me at Asgore Astroficus (talk).

Step 1: Opening the file

Firstly, find the file containing the data you need, for this example, I'm going to use fsd/blueprints.yaml. This file contains all the information required to build an industry cost predictor. Next, open the file using your desired programming language, I'm going to use python, so to open this I'll run with open("fsd/blueprints.yaml", "r") as f:. The file is open! To the next step!

Step 2: Reading the file

Step 2.1: Installing PyYAML

Assuming you're using pip, this should be as simple as pip install pyyaml. If you having issues, contact me at Asgore Astroficus (talk) or have a look at this article.

Step 2.2: Interpreting the file

Now that PyYAML is installed, we need to use it to parse our file, we have already opened it, so it should just be a matter of parsing it with PyYAML, which can be done by blueprints = yaml.load(f, Loader=yaml.FullLoader), remember to have import yaml at the top of your .py file. Hopefully now if you print out the blueprints variable, your console will be filled with sweet, sweet data and the taste of success. The data will be a dictionary, and the rest from here should be relatively simple, it should just be navigating through the data as if it was a dictionary.

Step 3: Postface

I hope this short guide helped you somewhat get into the SDE, I might write one for the Fuzzwork conversions soon. If you have any issues, pop me a message here Asgore Astroficus (talk).

Content of each table (version 2025-07-07)

Table name Content
agtAgents.csv.bz2 Contains information regarding agents in NPC stations such as location, corporation, type, level, and locator (boolean)

agentID - defined ID for this table
divisionID -
corporationID - the ID of the agent's NPC corporation. Corresponds to itemID in invNames
locationID - the ID of the agent's NPC station. Corresponds to itemID in invNames
level - agent's level (1-5)
quality - not used
agentTypeID - the ID of agent's type. Corresponds to agentTypeID in agtAgentTypes
isLocator - 1 if the agent is a Locator agent, 0 otherwise

agtAgentsInSpace.csv.bz2 Contains information regarding agents in space

agentID - defined ID for this table
dungeonID -
solarSystemID - the ID of the agent's solar system. Corresponds to solarSystemID in mapSolarSystems
spawnPointID -
typeID - the ID of the agent's ship. Corresponds to typeID in invTypes

agtAgentTypes.csv.bz2 Defines agent types

agentTypeID - defined ID for this table
agentType - defined agent type

agtResearchAgents.csv.bz2 Defines skills for each Research Agent

agentID - the ID of the agent. Corresponds to itemID in invNames
typeID - the ID of a skill of the agent. Corresponds to typeID in invTypes

certCerts.csv.bz2 Defines in-game certificates

certID - defined ID for this table
description - description of the certificate
groupID - the ID of the skill group for the certificate. Corresponds to groupID in invGroups
name - the name of the group the certificate applies to

certMasteries.csv.bz2 Defines the level of Mastery for flying ships

typeID - the ID of the ship. Corresponds to typeID in invTypes
masteryLevel - defines each mastery level
certID - the ID of each certificate required for this mastery level. Corresponds to certID in certCerts

certSkills.csv.bz2 Defines skills and skill levels needed to receive certificates

certID - the ID of the certificate. Corresponds to certID in certCerts
skillID - the ID of the skill needed for the certificate. Corresponds to typeID in invTypes
skillLevel - the level of the skill in skillID needed for the certificate
certLevelText - the level of the certificate

charFactions.csv.bz2 Empty file
chrAttributes.csv.bz2 Defines character attributes

attributeID - defined ID for this table
attributeName - defines the names of the attributes
description - the description of attributes
iconID - the ID of the icon for the attribute. Corresponds to iconID in eveIcons

chrBloodlines.csv.bz2 Contains information on what race each bloodline belongs to, descriptions.

bloodlineID - defined ID for this table
bloodlineName - defines the name of the bloodline
raceID - the ID of the race the bloodline belongs to. Corresponds to raceID in chrRaces
description - the description of the bloodline
maleDescription, femaleDescription, shipTypeID - not used in game
corporationID - the ID of the default NPC corporation to join when not in player corporation. Corresponds to itemID in invNames
perception, willpower, charisma, memory, intelligence - the initial values of character attributes on character creation
iconID - the ID of the icon for the bloodline. Corresponds to iconID in eveIcons
shortDescription, shortMaleDescription, shortFemaleDescription - not used in game

chrFactions.csv.bz2 Faction IDs, name, and description. Also what race each faction belongs to, and some other misc. information.

factionID - defined ID for this table
factionName - defines names of factions
description - the description of factions
raceID - the ID of the race the faction belongs to. Corresponds to raceID in chrRaces
solarSystemID - the ID of the home solar system of factions. Corresponds to solarSystemID in mapSolarSystems
corporationID - the ID of the military corporations of factions. Corresponds to itemID in invNames
sizeFactor -
stationCount, stationSystemCount - not used in game
militiaCorporationID - the ID of the militia corporations of factions. Corresponds to itemID in invNames
iconID - the ID of the icon for factions. Corresponds to iconID in eveIcons

chrRaces.csv.bz2 Description of Races

raceID - defined ID for this table
raceName - defines names of races
description - the description of races
iconID - the ID of the icon for races. Corresponds to iconID in eveIcons
shortDescription - short description of races

crpActivities.csv.bz2 Description of activities of NPC corporations

activityID - defined ID for this table
activityName - defines names of activities
description - not used

crpNPCCorporationDivisions.csv.bz2 Description of divisions of NPC corporations

corporationID - ID of NPC corporations. Corresponds to itemID in invNames
divisionID -
size -

crpNPCCorporationResearchFields.csv.bz2 Skills available to Research Agents in NPC corporations

skillID - the ID of skills. Corresponds to typeID in invTypes
corporationID - ID of NPC corporations. Corresponds to itemID in invNames

crpNPCCorporations.csv.bz2 Describes NPC corporations

corporationID - ID of NPC corporations. Corresponds to itemID in invNames
size -
extent -
solarSystemID - the ID of the home solar system of corporations. Corresponds to solarSystemID in mapSolarSystems
investorID1, investorShares1, investorID2, investorShares2, investorID3, investorShares3, investorID4, investorShares4 - not used in game
friendID - ID of a friendly corporation. Corresponds to itemID in invNames
enemyID - ID of an enemy corporation. Corresponds to itemID in invNames
publicShares - not used in game
initialPrice -
minSecurity -
scattered, fringe, corridor, hub, border - not used in game
factionID - ID of the faction corporation belongs to. Corresponds to factionID in chrFactions
sizeFactor, stationCount, stationSystemCount - not used in game
description - description of corporations
iconID - the ID of the icon for factions. Corresponds to iconID in eveIcons

crpNPCCorporationTrades.csv.bz2 Items sold by NPC corporations

corporationID - ID of NPC corporations. Corresponds to itemID in invNames
typeID - the ID of the traded items. Corresponds to typeID in invTypes

crpNPCDivisions.csv.bz2 Empty file
dgmAttributeCategories.csv.bz2 Categories of dogma attributes

categoryID - defined ID for this table
categoryName - defines names of dogma categories
categoryDescription - description of dogma categories

dgmAttributeTypes.csv.bz2 Types of dogma attributes

attributeID - defined ID for this table
attributeName - defines names of dogma attribute types
description - desciption of dogma attribute types
iconID - the ID of the icon for attribute types. Corresponds to iconID in eveIcons
defaultValue - the default value of attribute types
published - Boolean flag for whether the attribute type was published and is available in game
displayName - attribute name displayed in game
unitID - the ID of units for attributes. Corresponds to unitID in eveUnits
stackable - Boolean flag for whether the attribute can be stacked with other attributes
highIsGood - Boolean flag for whether high value of the attribute is beneficial
categoryID - the ID of the attribute category for the attribute type. Corresponds to categoryID in dgmAttributeCategories

dgmEffects.csv.bz2 The effects of dogma attributes

effectID - defined ID for this table
effectName - defines names of dogma effects
effectCategory, preExpression, postExpression - not used in game
description - desciption of dogma effects
guid - qualified names of dogma effects
iconID - the ID of icons for attribute effects. Corresponds to iconID in eveIcons
isOffensive - Boolean flag for whether dogma effects are offensive
isAssistance - Boolean flag for whether dogma effects are assistive
durationAttributeID - the ID of attribute type for duration of the dogma effects. Corresponds to attributeID in dgmAttributeTypes
trackingSpeedAttributeID - the ID of attribute type for tracking speed of the dogma effects. Corresponds to attributeID in dgmAttributeTypes
dischargeAttributeID - the ID of attribute type for discharge of the dogma effects. Corresponds to attributeID in dgmAttributeTypes
rangeAttributeID - the ID of attribute type for range of the dogma effects. Corresponds to attributeID in dgmAttributeTypes
falloffAttributeID - the ID of attribute type for falloff of the dogma effects. Corresponds to attributeID in dgmAttributeTypes
disallowAutoRepeat - Boolean flag for whether dogma effect autorepeat is disallowed
published - Boolean flag for whether dogma effects are published and available in game
displayName - the name of the dogma effect displayed in game
isWarpSafe - Boolean flag for whether dogma effects disrupt warp
rangeChance, electronicChance, propulsionChance, distribution, sfxName, npcUsageChanceAttributeID, npcActivationChanceAttributeID, fittingUsageChanceAttributeID - not used in game
modifierInfo - information about application of modifiers

dgmExpressions.csv.bz2 Empty file
dgmTypeAttributes.csv.bz2 Assigns dogma attribute types to item type

typeID - the ID of the item. Correponds to typeID in invTypes
attributeID - the ID of the dogma attribute type. Corresponds to attributeID in dgmAttributeTypes
valueInt - Integer value of the dogma attribute
valueFloat - Floating point value of the dogma attribute

dgmTypeEffects.csv.bz2 Assigns dogma effects to item types

typeID - the ID of the item. Corresponds to typeID in invTypes
effectID - the ID of the dogma effect. Corresponds to effectID in dgmEffects
isDefault - Boolean flag for whether the dogma effect is default for the item

eveGraphics.csv.bz2 Graphics resources

graphicID - defined ID for this table
sofFactionName - faction name for graphics
graphicFile - file name of graphics
sofHullName - hull name of graphics
sofRaceName - race name of graphics
description - description of graphics

eveIcons.csv.bz2 Icon resources

iconID - defined ID for this table
iconFile - file name of icon
description - description of icon

eveUnits.csv.bz2 Describes units used in dogma and item properties

unitID - defined ID for this table
unitName - defines names of units
displayName, description - not used in game

industryActivity.csv.bz2 Describes industrial activities possible for each blueprint

typeID - the ID of the blueprint. Correponds to typeID in invTypes
activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities
time - base time in seconds for activities

industryActivityMaterials.csv.bz2 Describes materials required to perform each industrial activity for blueprints

typeID - the ID of the blueprint. Correponds to typeID in invTypes
activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities
materialTypeID - the ID of the material. Correponds to typeID in invTypes
quantity - the base required quantity of the material to perform industrial activities

industryActivityProbabilities.csv.bz2 Describes outcomes and probabilities of inventions

typeID - the ID of the blueprint. Correponds to typeID in invTypes
activityID - the ID if industrial activities for blueprints (activityID = 8 for Invention). Corresponds to activityID in ramActivities
productTypeID - the ID of the outcome blueprint. Correponds to typeID in invTypes
probability - the base probability of successful invention

industryActivityProducts.csv.bz2 Describes outcomes of industrial activities

typeID - the ID of the blueprint. Correponds to typeID in invTypes
activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities
productTypeID - the ID of the outcome product. Correponds to typeID in invTypes
quantity - the base quantity of product from industrial activities

industryActivityRaces.csv.bz2 Empty file
industryActivitySkills.csv.bz2 Describes skills required perform industrial activities

typeID - the ID of the blueprint. Correponds to typeID in invTypes
activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities
skillID - the ID of the skill required for activities. Correponds to typeID in invTypes
level - minimum skill level required for activities

industryBlueprints.csv.bz2 Describes the base maximum number of BPC runs

typeID - the ID of the blueprint. Correponds to typeID in invTypes
maxProductionLimit - base maximum number of BPC runs

invCategories.csv.bz2 Item category IDs and names

categoryID - defined ID for this table
categoryName - defines names of categories
iconID - the ID of icons for categories. Corresponds to iconID in eveIcons
published - Boolean flag for whether categories are published and available in game

invContrabandTypes.csv.bz2 Describes items considered contraband for each faction

factionID - the ID of factions. Corresponds to factionID in chrFactions
typeID - the ID of cotraband items. Corresponds to typeID in invTypes
standingLoss - the loss of standings when contraband is found
confiscateMinSec - minimum time in seconds after which the contraband is confiscated
fineByValue - multiplier of value for fine when contraband is found
attackMinSec - minimum time in seconds before attack when contraband is found

invControlTowerResourcePurposes.csv.bz2 Empty file
invControlTowerResources.csv.bz2 Describes control tower properties

controlTowerTypeID - the ID of control towers. Corresponds to typeID in invTypes
resourceTypeID - the ID of resource required by control towers. Corresponds to typeID in invTypes
purpose -
quantity - required quantity of resource
minSecurityLevel - minimum security level of the system in which control tower can be anchored
factionID - the ID of faction of control tower

invFlags.csv.bz2 Flags describing various items

flagID - defined ID for this table
flagName - defines names of flags
flagText - displayed text for flags
orderID -

invGroups.csv.bz2 Describes inventory groups

groupID - defined ID for this table
categoryID - the ID of categories of inventory groups. Corresponds to categoryID in invCategories
groupName - defines names of inventory groups
iconID - the ID of icons for inventory groups. Corresponds to iconID in eveIcons
useBasePrice - Boolean flag to use base item price instead of adjusted item price in job cost calculation
anchored - Boolean flag to mark a permanently anchored items
anchorable - Boolean flag to mark items that can be anchored
fittableNonSingleton - Boolean flag to mark items that are fittable despite not being flagged as Singletons
published - Boolean flag to mark inventory groups that are published and available in game

invItems.csv.bz2 Describes items that have defined owners

itemID - defined ID for this table
typeID - the ID of the item type. Corresponds to typeID in invTypes
ownerID - the ID of items' owner. Corresponds to itemID in invNames
locationID - the ID of items' location. Corresponds to itemID in invPositions
flagID - the ID of items' flag. Corresponds to flagID in invFlags
quantity - the items' quantity. Quantity = -1 means unlimited quantity

invMarketGroups.csv.bz2 Defines the market group hierarchy

marketGroupID - defined ID for this table
parentGroupID - the ID of the parent marketing group, if any. Corresponds to marketGroupID in invMarketGroups
marketGroupName - defines names of marketing groups
description - description of marketing groups
iconID - the ID of icons for marketing groups. Corresponds to iconID in eveIcons
hasTypes - Boolean flag to mark marketing groups that are also parent groups

invMetaGroups.csv.bz2 Description of meta groups

metaGroupID - defined ID for this table
metaGroupName - defines names of meta groups
description - description of meta groups
iconID - the ID of icons for meta groups. Corresponds to iconID in eveIcons

invMetaTypes.csv.bz2 Assigns item types to meta groups

typeID - the ID of the item type. Corresponds to typeID in invTypes
parentTypeID - the ID of the item type's parent, if any (the Tech I item for a Tech II item etc.). Corresponds to typeID in invTypes
metaGroupID - the ID of the item type's meta group. Corresponds to metaGroupID in invMetaGroups

invNames.csv.bz2 Describes unique items

itemID - defined ID for this table
itemName - defines names of unique items

invPositions.csv.bz2 Describes position of unique items

itemID - ID of unique items. Corresponds to itemID in invNames
x, y, z - coordinates of unique items
yaw, pitch, roll - orientation of unique items

invTraits.csv.bz2 Describes traites ("bonuses") of ships

traitID - defined ID for this table
typeID - the ID of the ship type. Corresponds to typeID in invTypes
skillID - the ID of the skill required to fly the ship. Corresponds to typeID in invTypes
bonus - the size of ship's bonus
bonusText - description of ship's bonus
unitID - the ID of the unit of the ship's bonus. Corresponds to unitID in eveUnits

invTypeMaterials.csv.bz2 Describes materials obtained from reprocessing of items

typeID - the ID of the item to reprocess. Corresponds to typeID in invTypes
materialTypeID - the ID of the material obtained from reprocessing. Corresponds to typeID in invTypes
quantity - base quantity of material obtained from reprocessing

invTypeReactions.csv.bz2 Empty file
invTypes.csv.bz2 Defines item types

typeID - defined ID for this table
groupID - ID of inventory groups for items. Corresponds to groupID in invGroups
typeName - defines names of items
description - description of items
mass - mass of items in kg
volume - volume of items in m3
capacity - maximum volume of contained items in m3
portionSize - minimum number of items to reprocess
raceID - ID of item's race. Corresponds to raceID in chrRaces
basePrice - item's base price in ISK
published - Boolean flag to mark items that are published and available in game
marketGroupID - ID of item's market group. Corresponds to marketGroupID in invMarketGroups
iconID - ID of item's icon. Corresponds to iconID in eveIcons
soundID - ID if item's sound resource
graphicID - ID of item's graphic resource. Corresponds to graphicID in eveGraphics

invTypes-nodescription.csv.bz2 Table invTypes excluding description
invUniqueNames.csv.bz2 Describes unique names

itemID - defined ID for this table
itemName - defines unique names
groupID - ID of name's inventory group. Corresponds to groupID in invGroups

invVolumes.csv.bz2 Describes volumes of packaged ships

typeID - the ID of the ship. Corresponds to typeID in invTypes
volume - packaged ship volume in m3

mapCelestialGraphics.csv.bz2 Describes graphics settings of celestials

celestialID - ID of celestials. Corresponds to celestialID in mapDenormalize
heightMap1 -
heightMap2 -
shaderPreset -
population -

mapCelestialStatistics.csv.bz2 Describes physical parameters of celestials

celestialID - ID of celestials. Corresponds to celestialID in mapDenormalize
temperature - celestial's temperature
spectralClass - spectral class for stars, 0 otherwise
luminosity - luminosity for stars, "None" otherwise
age - age in seconds for stars, 0 otherwise
life - remaining lifetime in seconds for stars, 0 otherwise
orbitRadius - celestial's orbit radius in meters, "None" for stars
eccentricity - celestial's orbit eccentricity in meters, "None" for stars, 0 for asteroid belts
massDust - celestial's mass of dust in kg
massGas - celestial's mass of gas in kg
fragmented - Boolean flag to mark whether the celestial is fragmented. "None" for stars
density - celestial's density in kg/m3. "None" for stars
surfaceGravity - celestial's surface gravity in m/s2. "None" for stars
escapeVelocity - celestial's escape velocity in m/s. "None" for stars
orbitPeriod - celestial's orbital period in seconds. "None" for stars
rotationRate - celestial's rotational rate in (?). "None" for stars
locked - Boolean flag
pressure - celestial's atmospheric pressure in atm (?). "None" for stars, 0 for asteroid belts
radius - celestial's radius in m
mass - not used in game

mapConstellationJumps.csv.bz2 Describes gate jumps between constellations

fromRegionID - ID of the starting region. Corresponds to regionID in mapRegions
fromConstellationID - ID of the starting constellation. Corresponds to constellationID in mapConstellations
toConstellationID - ID of the ending constellation. Corresponds to constellationID in mapConstellations
toRegionID - ID of the ending region. Corresponds to regionID in mapRegions

mapConstellations.csv.bz2 Describes constellations

regionID - ID of the costellation's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize
constellationID - - ID of the costellation region. Corresponds to itemID in mapDenormalize
constellationName - defines names of constellations. Same as itemName in mapDenormalize
x, y, z - coordinates of constellation's center in Universe coordinates, in meters
xMin, xMax, yMin, yMax, zMin, zMax - coordinates of constellation's box in Universe coordinates, in meters
factionID - ID of the faction owning the constellation. Corresponds to factionID in chrFactions
radius - radius of sphere circumscribing constellation, in meters

mapDenormalize.csv.bz2 Describes celestials

itemID - defined ID for this table
typeID - the ID of the celestial type. Corresponds to typeID in invTypes
groupID - the ID of the celestial's inventory group. Corresponds to groupID in invGroups
solarSystemID - the ID of the celestial's solar system, if any. Corresponds to solarSystemID in mapSolarSystems. "None" otherwise
constellationID - the ID of the celestial's constellation, if any. Corresponds to constellationID in mapConstellations. "None" otherwise
regionID - the ID of the celestial's region, if any. Corresponds to regionID in mapRegions. "None" otherwise
orbitID - the ID of the body the celestial orbits, if any. Corresponds to itemID in mapDenormalize. "None" otherwise
x, y, z - coordinates of celestial's center in Universe coordinates, in meters
radius - radius of sphere circumscribing celestial, in meters, if any. "None" otherwise
itemName - defines names of celestials
security - security level for solar systems, "None" otherwise
celestialIndex - index of planet, or parent planet, orbiting sun, if any. "None" otherwise. celestialIndex = 2 for the 2nd planet around a star, 1st asteroid belt and 1st moon around the 2nd planet around a star
orbitIndex - index of celestial orbiting parent planet, if any. "None" otherwise. orbitIndex = 1 for the 1st asteroid belt and 1st moon around a planet

mapJumps.csv.bz2 Describes gate jumps between solar systems

stargateID - the ID of the starting solar system. Corresponds to solarSystemID in mapSolarSystems
destinationID- the ID of the ending solar system. Corresponds to solarSystemID in mapSolarSystems

mapLandmarks.csv.bz2 Empty file
mapLocationWormholeClasses.csv.bz2 Each location's wormholeClassID

locationID - ID of the location. Corresponds to itemID in mapDenormalize
wormholeClassID -

mapRegionJumps.csv.bz2 Describes gate jumps between regions

fromRegionID - the ID of the starting region. Corresponds to regionID in mapRegions
toRegionID - the ID of the starting region. Corresponds to regionID in mapRegions

mapRegions.csv.bz2 Describes regions

regionID - ID of the region. Corresponds to itemID in mapDenormalize
regionName - defines names of regions. Same as itemName in mapDenormalize
x, y, z - coordinates of region's center in Universe coordinates, in meters
xMin, xMax, yMin, yMax, zMin, zMax - coordinates of region's box in Universe coordinates, in meters
factionID - ID of the faction owning the constellation. Corresponds to factionID in chrFactions
nebula - the ID of the graphics of nebulae in the region. Corresponds to graphicID in eveGraphics
radius - not used in game

mapSolarSystemJumps.csv.bz2 Describes gate jumps between solar systems

fromRegionID - ID of the starting region. Corresponds to regionID in mapRegions
fromConstellationID - ID of the starting constellation. Corresponds to constellationID in mapConstellations
fromSolarSystemID - ID of the starting solar system. Corresponds to regionID in mapSolarSystems
toSolarSystemID - ID of the ending solar system. Corresponds to regionID in mapSolarSystems
toConstellationID - ID of the ending constellation. Corresponds to constellationID in mapConstellations
toRegionID - ID of the ending region. Corresponds to regionID in mapRegions

mapSolarSystems.csv.bz2 Describes solar systems

regionID - ID of the solar system's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize
constellationID - ID of the solar system's constellation. Corresponds to constellationID in mapConstellations and itemID in mapDenormalize
solarSystemID - ID of the solar system. Corresponds to itemID in mapDenormalize
solarSystemName - defines names of solar systems. Same as itemName in mapDenormalize
x, y, z - coordinates of solar systems's center in Universe coordinates, in meters
xMin, xMax, yMin, yMax, zMin, zMax - coordinates of solar systems's box in Universe coordinates, in meters
luminosity - star's luminoaity
border - Boolean flag to mark whether the solar system is a border system
fringe -
corridor -
hub -
international -
regional -
constellation - not used in game
security - solar system's security
factionID - ID of the faction owning the solar system. Corresponds to factionID in chrFactions
radius - solar system's radius in meters
sunTypeID - ID of the sun type. Corresponds to itemType in invTypes
securityClass - securyty class of the system

mapUniverse.csv.bz2 Defines the K- and J-space unverses

universeID - ID of the universe. Corresponds to typeID in invTypes
universeName - defines universe names
x, y, z - coordinates of universe, in meters
xMin, xMax, yMin, yMax, zMin, zMax - coordinates of universe box, in meters
radius - universe radius in meters

planetSchematics.csv.bz2 Describes Planetary Industry schematics

schematicID - defined ID for this table
schematicName - defines schematic names
cycleTime - schematic cycle time completion in seconds

planetSchematicsPinMap.csv.bz2 Associates pin types with schematics

schematicID - ID of the schematic. Corresponds to schematicID in planetSchematics
pinTypeID - ID of the pin. Corresponds to typeID in invTypes

planetSchematicsTypeMap.csv.bz2 Describes schematic productivity

schematicID - ID of the schematic. Corresponds to schematicID in planetSchematics
typeID - ID of the PI product. Corresponds to typeID in invTypes
quantity - the size of a batch of PI
isInput -

ramActivities.csv.bz2 Describes types of industrial activities

activityID - defined ID for this table
activityName - defines activity names
iconNo -
description - description of activities
published - Boolean flag to mark industrial activities that are published and available in game

ramAssemblyLineStations.csv.bz2
ramAssemblyLineTypeDetailPerCategory.csv.bz2 Information on R.A.M.
ramAssemblyLineTypeDetailPerGroup.csv.bz2
ramAssemblyLineTypes.csv.bz2
ramInstallationTypeContents.csv.bz2
skinLicense.csv.bz2
skinMaterials.csv.bz2
skins.csv.bz2
skinShip.csv.bz2 What skins can be used on what ships
staOperations.csv.bz2
staOperationServices.csv.bz2 Information about what station types offer what services (speculation)
staServices.csv.bz2
staStations.csv.bz2 Information about stations, their security level, location, name, reprocessing level, and much more.
staStationTypes.csv.bz2
translationTables.csv.bz2 Appears to be empty
trnTranslationColumns.csv.bz2
trnTranslationLanguages.csv.bz2
trnTranslations.csv.bz2
warCombatZones.csv.bz2 A small file that updates regularly. It contains information about combat zones (FW I think?)
warCombatZoneSystems.csv.bz2

External links