Toggle search
Toggle menu
4.5K
7.6K
15.6K
232K
EVE University Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Static Data Export: Difference between revisions

From EVE University Wiki
More actions
← Older edit
VisualWikitext
m changed text formatting
update SDE to new place and format
 
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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 [https://developers.eveonline.com/docs/services/sde/ Services and Resource] page. All resources provided by CCP are subject to the [https://developers.eveonline.com/license-agreement developer license agreement].
{{Update|2025-09-22: CCP has reworked the SDE ([https://developers.eveonline.com/blog/reworking-the-sde-a-fresh-start-for-static-data Reworking the SDE: a fresh start for static data]). This rework is '''not backwards compatible'''.}}
 
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 .jsonl files, however, different and easier to use formats(mentioned below) are made by the community. The SDE can be found at the EVE developers [https://developers.eveonline.com/static-data Static Data] page. All resources provided by CCP are subject to the [https://developers.eveonline.com/license-agreement developer license agreement].
 
== Fuzzwork SDE Conversions ==
== 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 [https://www.fuzzwork.co.uk Fuzzwork] under SDE or more directly at [https://www.fuzzwork.co.uk/dump www.fuzzwork.co.uk/dump]. Individual table data can be found in [[:wikipedia:Comma-separated values|CSV]] and [[:wikipedia:SQL|SQL]] (MySQL) formats here [https://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest].
To aide fellow developers and players in consuming this data without having to extract or convert from YAML or JSON Lines format every time Steve Ronuken has hosted conversions in PostgreSQL, SQLite, MySQL, MSSQL, and CSV formats. They can be found at [https://www.fuzzwork.co.uk Fuzzwork] under SDE or more directly at [https://www.fuzzwork.co.uk/dump www.fuzzwork.co.uk/dump]. Individual table data can be found in [[:wikipedia:Comma-separated values|CSV]] and [[:wikipedia:SQL|SQL]] (MySQL) formats here [https://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest].


=== Opening a file from Fuzzwork SDE Conversions ===
=== Opening a file from Fuzzwork SDE Conversions ===
To extract data from compressed files, use [https://ss64.com/bash/tar.html tar] for <code>.tar.bz2</code> files or [https://ss64.com/osx/bzip.html bunzip2] for <code>.bz2</code> files in Linux, and something like [https://www.7-zip.org/ 7-zip] for either format in windows. Once extracted the files can be opened in the appropriate application that supports the file format.
To extract data from compressed files, use [https://ss64.com/bash/tar.html tar] for <code>.tar.bz2</code> files or [https://ss64.com/osx/bzip.html bunzip2] for <code>.bz2</code> files in Linux, and something like [https://www.7-zip.org/ 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? ==
== 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 [https://github.com/esi/esi-issues/issues/1103 here].
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 on the [https://github.com/esi/esi-issues/issues/1103 SDE parity checklist] at the [https://github.com/esi ESI] GitHub.


== How to implement the original SDE into your application ==
== How to implement the original SDE into your application ==
=== Step 0: Preface ===
=== 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 [[User:Asgore Astroficus|Asgore Astroficus]] ([[User talk:Asgore Astroficus|talk]]).
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|External links]] section.


=== Step 1: Opening the file ===
=== 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!
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 <code>with open("fsd/blueprints.yaml", "r") as f:</code>. The file is open! To the next step!


=== Step 2: Reading the file ===
=== Step 2: Reading the file ===
==== Step 2.1: Installing PyYAML ====
==== 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 [[User:Asgore Astroficus|Asgore Astroficus]] ([[User talk:Asgore Astroficus|talk]]) or have a look at [https://stackabuse.com/reading-and-writing-yaml-to-a-file-in-python/ this article].
Assuming you're using pip, this should be as simple as <kbd>pip install pyyaml</kbd>. If you having issues have a look at [https://stackabuse.com/reading-and-writing-yaml-to-a-file-in-python/ Reading and Writing YAML to a File in Python] on stackabuse.


==== Step 2.2: Interpreting the file ====
==== 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.  
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 <code>blueprints = yaml.load(f, Loader=yaml.FullLoader)</code>, 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 ===
=== 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 [[User:Asgore Astroficus|Asgore Astroficus]] ([[User talk:Asgore Astroficus|talk]]).
I hope this short guide helped you somewhat get into the SDE.


== What each table contains (version 2025-07-07) ==
== Content of each table (version 2025-07-07) ==
{| class="wikitable sortable"
{| class="wikitable sortable"
|-
|-
! Table name !! What it contains
! Table name !! Content
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/agtAgents.csv.bz2 agtAgents.csv.bz2]|| Contains information regarding agents in NPC stations such as location, corporation, type, level, and locator (boolean)<br>
| [https://www.fuzzwork.co.uk/dump/latest/agtAgents.csv.bz2 agtAgents.csv.bz2]|| Contains information regarding agents in NPC stations such as location, corporation, type, level, and locator (boolean)<br>
'''agentID''' - defined ID for this table<br>
'''agentID''' - defined ID for this table<br>
'''divisionID''' - <br>
'''divisionID''' - <br>
'''corporationID''' - the ID of the agent's NPC corporation. Corresponds to itemID in invNames<br>
'''corporationID''' - the ID of the agent's NPC corporation. Corresponds to itemID in invNames<br>
'''locationID''' - the ID of the agent's NPC station. Corresponds to itemID in invNames<br>
'''locationID''' - the ID of the agent's NPC station. Corresponds to itemID in invNames<br>
'''level''' - agent's level (1-5)<br>
'''level''' - agent's level (1-5)<br>
'''quality''' - not used<br>
'''quality''' - not used<br>
'''agentTypeID''' - the ID of agent's type. Corresponds to agentTypeID in agtAgentTypes<br>
'''agentTypeID''' - the ID of agent's type. Corresponds to agentTypeID in agtAgentTypes<br>
'''isLocator''' - 1 if the agent is a Locator agent, 0 otherwise
'''isLocator''' - 1 if the agent is a Locator agent, 0 otherwise
|-
|-
|[https://www.fuzzwork.co.uk/dump/latest/agtAgentsInSpace.csv.bz2 agtAgentsInSpace.csv.bz2]|| Contains information regarding agents in space<br>
|[https://www.fuzzwork.co.uk/dump/latest/agtAgentsInSpace.csv.bz2 agtAgentsInSpace.csv.bz2]|| Contains information regarding agents in space<br>
Line 68: Line 70:
'''certID''' - the ID of each certificate required for this mastery level. Corresponds to certID in certCerts
'''certID''' - the ID of each certificate required for this mastery level. Corresponds to certID in certCerts
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/certSkills.csv.bz2 certSkills.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/certSkills.csv.bz2 certSkills.csv.bz2]|| Defines skills and skill levels needed to receive certificates<br>
'''certID''' - the ID of the certificate. Corresponds to certID in certCerts<br>
'''skillID''' - the ID of the skill needed for the certificate. Corresponds to typeID in invTypes<br>
'''skillLevel''' - the level of the skill in skillID needed for the certificate<br>
'''certLevelText''' - the level of the certificate
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/chrAncestries.csv.bz2 chrAncestries.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/charFactions.csv.bz2 charFactions.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/chrAttributes.csv.bz2 chrAttributes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/chrAttributes.csv.bz2 chrAttributes.csv.bz2]|| Defines character attributes<br>
'''attributeID''' - defined ID for this table<br>
'''attributeName''' - defines the names of the attributes<br>
'''description''' - the description of attributes<br>
'''iconID''' - the ID of the icon for the attribute. Corresponds to iconID in eveIcons
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/chrBloodlines.csv.bz2 chrBloodlines.csv.bz2]|| Contains information on what race each bloodline belongs to, descriptions.
| [https://www.fuzzwork.co.uk/dump/latest/chrBloodlines.csv.bz2 chrBloodlines.csv.bz2]|| Contains information on what race each bloodline belongs to, descriptions.<br>
'''bloodlineID''' - defined ID for this table<br>
'''bloodlineName''' - defines the name of the bloodline<br>
'''raceID''' - the ID of the race the bloodline belongs to. Corresponds to raceID in chrRaces<br>
'''description''' - the description of the bloodline<br>
'''maleDescription''', '''femaleDescription''', '''shipTypeID''' - not used in game<br>
'''corporationID''' - the ID of the default NPC corporation to join when not in player corporation. Corresponds to itemID in invNames<br>
'''perception''', '''willpower''', '''charisma''', '''memory''', '''intelligence''' - the initial values of character attributes on character creation<br>
'''iconID''' - the ID of the icon for the bloodline. Corresponds to iconID in eveIcons<br>
'''shortDescription''', '''shortMaleDescription''', '''shortFemaleDescription''' - not used in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/chrFactions.csv.bz2 chrFactions.csv.bz2]|| Faction IDs, name, and description. Also what race each faction belongs to, and some other misc. information.
| [https://www.fuzzwork.co.uk/dump/latest/chrFactions.csv.bz2 chrFactions.csv.bz2]|| Faction IDs, name, and description. Also what race each faction belongs to, and some other misc. information.<br>
'''factionID''' - defined ID for this table<br>
'''factionName''' - defines names of factions<br>
'''description''' - the description of factions<br>
'''raceID''' - the ID of the race the faction belongs to. Corresponds to raceID in chrRaces<br>
'''solarSystemID''' - the ID of the home solar system of factions. Corresponds to solarSystemID in mapSolarSystems<br>
'''corporationID''' - the ID of the military corporations of factions. Corresponds to itemID in invNames<br>
'''sizeFactor''' - <br>
'''stationCount''', '''stationSystemCount''' - not used in game<br>
'''militiaCorporationID''' - the ID of the militia corporations of factions. Corresponds to itemID in invNames<br>
'''iconID''' - the ID of the icon for factions. Corresponds to iconID in eveIcons
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/chrRaces.csv.bz2 chrRaces.csv.bz2]|| raceID and raceName, iconID and a long and short description (side note, ORE is a race)
| [https://www.fuzzwork.co.uk/dump/latest/chrRaces.csv.bz2 chrRaces.csv.bz2]|| Description of Races<br>
'''raceID''' - defined ID for this table<br>
'''raceName''' - defines names of races<br>
'''description''' - the description of races<br>
'''iconID''' - the ID of the icon for races. Corresponds to iconID in eveIcons<br>
'''shortDescription''' - short description of races
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/crpActivities.csv.bz2 crpActivities.csv.bz2]|| IDK, maybe names of NPC sturcture groups?
| [https://www.fuzzwork.co.uk/dump/latest/crpActivities.csv.bz2 crpActivities.csv.bz2]|| Description of activities of NPC corporations<br>
'''activityID''' - defined ID for this table<br>
'''activityName''' - defines names of activities<br>
'''description''' - not used
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationDivisions.csv.bz2 crpNPCCorporationDivisions.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationDivisions.csv.bz2 crpNPCCorporationDivisions.csv.bz2]|| Description of divisions of NPC corporations<br>
'''corporationID''' - ID of NPC corporations. Corresponds to itemID in invNames<br>
'''divisionID''' - <br>
'''size''' -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationResearchFields.csv.bz2 crpNPCCorporationResearchFields.csv.bz2]|| Unknown
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationResearchFields.csv.bz2 crpNPCCorporationResearchFields.csv.bz2]|| Skills available to Research Agents in NPC corporations<br>
'''skillID''' - the ID of skills. Corresponds to typeID in invTypes<br>
'''corporationID''' - ID of NPC corporations. Corresponds to itemID in invNames
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporations.csv.bz2 crpNPCCorporations.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporations.csv.bz2 crpNPCCorporations.csv.bz2]|| Describes NPC corporations<br>
'''corporationID''' - ID of NPC corporations. Corresponds to itemID in invNames<br>
'''size''' - <br>
'''extent''' - <br>
'''solarSystemID''' - the ID of the home solar system of corporations. Corresponds to solarSystemID in mapSolarSystems<br>
'''investorID1''', '''investorShares1''', '''investorID2''', '''investorShares2''', '''investorID3''', '''investorShares3''', '''investorID4''', '''investorShares4''' - not used in game<br>
'''friendID''' - ID of a friendly corporation. Corresponds to itemID in invNames<br>
'''enemyID''' - ID of an enemy corporation. Corresponds to itemID in invNames<br>
'''publicShares''' - not used in game<br>
'''initialPrice''' - <br>
'''minSecurity''' - <br>
'''scattered''', '''fringe''', '''corridor''', '''hub''', '''border''' - not used in game<br>
'''factionID''' - ID of the faction corporation belongs to. Corresponds to factionID in chrFactions<br>
'''sizeFactor''', '''stationCount''', '''stationSystemCount''' - not used in game<br>
'''description''' - description of corporations<br>
'''iconID''' - the ID of the icon for factions. Corresponds to iconID in eveIcons
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationTrades.csv.bz2 crpNPCCorporationTrades.csv.bz2]|| Information on what each NPC corp sells.
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationTrades.csv.bz2 crpNPCCorporationTrades.csv.bz2]|| Items sold by NPC corporations<br>
'''corporationID''' - ID of NPC corporations. Corresponds to itemID in invNames<br>
'''typeID''' - the ID of the traded items. Corresponds to typeID in invTypes
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCDivisions.csv.bz2 crpNPCDivisions.csv.bz2]|| Information on NPC divisions, mostly deprecated.
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCDivisions.csv.bz2 crpNPCDivisions.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/dgmAttributeCategories.csv.bz2 dgmAttributeCategories.csv.bz2]|| What each categoryID is, and a categoryName
| [https://www.fuzzwork.co.uk/dump/latest/dgmAttributeCategories.csv.bz2 dgmAttributeCategories.csv.bz2]|| Categories of dogma attributes<br>
'''categoryID''' - defined ID for this table<br>
'''categoryName''' - defines names of dogma categories<br>
'''categoryDescription''' - description of dogma categories
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/dgmAttributeTypes.csv.bz2 dgmAttributeTypes.csv.bz2]|| Defines attributes of types (like CPU Load, Powergrid Usage, EM damage)
| [https://www.fuzzwork.co.uk/dump/latest/dgmAttributeTypes.csv.bz2 dgmAttributeTypes.csv.bz2]|| Types of dogma attributes<br>
'''attributeID''' - defined ID for this table<br>
'''attributeName''' - defines names of dogma attribute types<br>
'''description''' - desciption of dogma attribute types<br>
'''iconID''' - the ID of the icon for attribute types. Corresponds to iconID in eveIcons<br>
'''defaultValue''' - the default value of attribute types<br>
'''published''' - Boolean flag for whether the attribute type was published and is available in game<br>
'''displayName''' - attribute name displayed in game<br>
'''unitID''' - the ID of units for attributes. Corresponds to unitID in eveUnits<br>
'''stackable''' - Boolean flag for whether the attribute can be stacked with other attributes<br>
'''highIsGood''' - Boolean flag for whether high value of the attribute is beneficial<br>
'''categoryID''' - the ID of the attribute category for the attribute type. Corresponds to categoryID in dgmAttributeCategories
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/dgmEffects.csv.bz2 dgmEffects.csv.bz2]|| Information regarding effects, such as launching missiles, scaling damage, and the effects skills have.
| [https://www.fuzzwork.co.uk/dump/latest/dgmEffects.csv.bz2 dgmEffects.csv.bz2]|| The effects of dogma attributes<br>
'''effectID''' - defined ID for this table<br>
'''effectName''' - defines names of dogma effects<br>
'''effectCategory''', '''preExpression''', '''postExpression''' - not used in game<br>
'''description''' - desciption of dogma effects<br>
'''guid''' - qualified names of dogma effects<br>
'''iconID''' - the ID of icons for attribute effects. Corresponds to iconID in eveIcons<br>
'''isOffensive''' - Boolean flag for whether dogma effects are offensive<br>
'''isAssistance''' - Boolean flag for whether dogma effects are assistive<br>
'''durationAttributeID''' - the ID of attribute type for duration of the dogma effects. Corresponds to attributeID in dgmAttributeTypes<br>
'''trackingSpeedAttributeID''' - the ID of attribute type for tracking speed of the dogma effects. Corresponds to attributeID in dgmAttributeTypes<br>
'''dischargeAttributeID''' - the ID of attribute type for discharge of the dogma effects. Corresponds to attributeID in dgmAttributeTypes<br>
'''rangeAttributeID''' - the ID of attribute type for range of the dogma effects. Corresponds to attributeID in dgmAttributeTypes<br>
'''falloffAttributeID''' - the ID of attribute type for falloff of the dogma effects. Corresponds to attributeID in dgmAttributeTypes<br>
'''disallowAutoRepeat''' - Boolean flag for whether dogma effect autorepeat is disallowed<br>
'''published''' - Boolean flag for whether dogma effects are published and available in game<br>
'''displayName''' - the name of the dogma effect displayed in game<br>
'''isWarpSafe''' - Boolean flag for whether dogma effects disrupt warp<br>
'''rangeChance''', '''electronicChance''', '''propulsionChance''', '''distribution''', '''sfxName''', '''npcUsageChanceAttributeID''', '''npcActivationChanceAttributeID''', '''fittingUsageChanceAttributeID''' - not used in game<br>
'''modifierInfo''' - information about application of modifiers
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/dgmExpressions.csv.bz2 dgmExpressions.csv.bz2]|| Information regarding expressions
| [https://www.fuzzwork.co.uk/dump/latest/dgmExpressions.csv.bz2 dgmExpressions.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/dgmTypeAttributes.csv.bz2 dgmTypeAttributes.csv.bz2]|| Provides values for the attributes of a type (how much EM damage does the Mjolnir Cruise Missile do) See dgmAttributeTypes and
| [https://www.fuzzwork.co.uk/dump/latest/dgmTypeAttributes.csv.bz2 dgmTypeAttributes.csv.bz2]|| Assigns dogma attribute types to item type<br>
'''typeID''' - the ID of the item. Correponds to typeID in invTypes<br>
'''attributeID''' - the ID of the dogma attribute type. Corresponds to attributeID in dgmAttributeTypes<br>
'''valueInt''' - Integer value of the dogma attribute<br>
'''valueFloat''' - Floating point value of the dogma attribute
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/dgmTypeEffects.csv.bz2 dgmTypeEffects.csv.bz2]|| effectID that each typID had, see also dgmEffects.csv.bz2
| [https://www.fuzzwork.co.uk/dump/latest/dgmTypeEffects.csv.bz2 dgmTypeEffects.csv.bz2]|| Assigns dogma effects to item types<br>
'''typeID''' - the ID of the item. Corresponds to typeID in invTypes<br>
'''effectID''' - the ID of the dogma effect. Corresponds to effectID in dgmEffects<br>
'''isDefault''' - Boolean flag for whether the dogma effect is default for the item
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/eveGraphics.csv.bz2 eveGraphics.csv.bz2]|| Information regarding grapics such as graphicID, graphic location, race, and description.
| [https://www.fuzzwork.co.uk/dump/latest/eveGraphics.csv.bz2 eveGraphics.csv.bz2]|| Graphics resources<br>
'''graphicID''' - defined ID for this table<br>
'''sofFactionName''' - faction name for graphics<br>
'''graphicFile''' - file name of graphics<br>
'''sofHullName''' - hull name of graphics<br>
'''sofRaceName''' - race name of graphics<br>
'''description''' - description of graphics
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/eveIcons.csv.bz2 eveIcons.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/eveIcons.csv.bz2 eveIcons.csv.bz2]|| Icon resources<br>
'''iconID''' - defined ID for this table<br>
'''iconFile''' - file name of icon<br>
'''description''' - description of icon
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/eveUnits.csv.bz2 eveUnits.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/eveUnits.csv.bz2 eveUnits.csv.bz2]|| Describes units used in dogma and item properties<br>
'''unitID''' - defined ID for this table<br>
'''unitName''' - defines names of units<br>
'''displayName''', '''description''' - not used in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/industryActivity.csv.bz2 industryActivity.csv.bz2]|| Contains the number of seconds it takes to create a blueprint product
| [https://www.fuzzwork.co.uk/dump/latest/industryActivity.csv.bz2 industryActivity.csv.bz2]|| Describes industrial activities possible for each blueprint<br>
'''typeID''' - the ID of the blueprint. Correponds to typeID in invTypes<br>
'''activityID''' - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities<br>
'''time''' - base time in seconds for activities
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityMaterials.csv.bz2 industryActivityMaterials.csv.bz2]|| Contains the materials required to create a blueprint product
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityMaterials.csv.bz2 industryActivityMaterials.csv.bz2]|| Describes materials required to perform each industrial activity for blueprints<br>
'''typeID''' - the ID of the blueprint. Correponds to typeID in invTypes<br>
'''activityID''' - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities<br>
'''materialTypeID''' - the ID of the material. Correponds to typeID in invTypes<br>
'''quantity''' - the base required quantity of the material to perform industrial activities
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityProbabilities.csv.bz2 industryActivityProbabilities.csv.bz2]|| Contains the outcome and the probability of an invention  
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityProbabilities.csv.bz2 industryActivityProbabilities.csv.bz2]|| Describes outcomes and probabilities of inventions<br>
'''typeID''' - the ID of the blueprint. Correponds to typeID in invTypes<br>
'''activityID''' - the ID if industrial activities for blueprints (activityID = 8 for Invention). Corresponds to activityID in ramActivities<br>
'''productTypeID''' - the ID of the outcome blueprint. Correponds to typeID in invTypes<br>
'''probability''' - the base probability of successful invention
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityProducts.csv.bz2 industryActivityProducts.csv.bz2]|| Shows what processes create what (such as what products a blueprint creates)
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityProducts.csv.bz2 industryActivityProducts.csv.bz2]|| Describes outcomes of industrial activities<br>
'''typeID''' - the ID of the blueprint. Correponds to typeID in invTypes<br>
'''activityID''' - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities<br>
'''productTypeID''' - the ID of the outcome product. Correponds to typeID in invTypes<br>
'''quantity''' - the base quantity of product from industrial activities
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityRaces.csv.bz2 industryActivityRaces.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/industryActivityRaces.csv.bz2 industryActivityRaces.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/industryActivitySkills.csv.bz2 industryActivitySkills.csv.bz2]|| Contains information about the skills required to manufacture any blueprint.
| [https://www.fuzzwork.co.uk/dump/latest/industryActivitySkills.csv.bz2 industryActivitySkills.csv.bz2]|| Describes skills required perform industrial activities<br>
'''typeID''' - the ID of the blueprint. Correponds to typeID in invTypes<br>
'''activityID''' - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities<br>
'''skillID''' - the ID of the skill required for activities. Correponds to typeID in invTypes<br>
'''level''' - minimum skill level required for activities
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/industryBlueprints.csv.bz2 industryBlueprints.csv.bz2]|| Contains the base maximum amount of BPC runs
| [https://www.fuzzwork.co.uk/dump/latest/industryBlueprints.csv.bz2 industryBlueprints.csv.bz2]|| Describes the base maximum number of BPC runs<br>
'''typeID''' - the ID of the blueprint. Correponds to typeID in invTypes<br>
'''maxProductionLimit''' - base maximum number of BPC runs
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invCategories.csv.bz2 invCategories.csv.bz2]|| Category IDs and category names
| [https://www.fuzzwork.co.uk/dump/latest/invCategories.csv.bz2 invCategories.csv.bz2]|| Item category IDs and names<br>
'''categoryID''' - defined ID for this table<br>
'''categoryName''' - defines names of categories<br>
'''iconID''' - the ID of icons for categories. Corresponds to iconID in eveIcons<br>
'''published''' - Boolean flag for whether categories are published and available in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invContrabandTypes.csv.bz2 invContrabandTypes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invContrabandTypes.csv.bz2 invContrabandTypes.csv.bz2]|| Describes items considered contraband for each faction<br>
'''factionID''' - the ID of factions. Corresponds to factionID in chrFactions<br>
'''typeID''' - the ID of cotraband items. Corresponds to typeID in invTypes<br>
'''standingLoss''' - the loss of standings when contraband is found<br>
'''confiscateMinSec''' - minimum time in seconds after which the contraband is confiscated<br>
'''fineByValue''' - multiplier of value for fine when contraband is found<br>
'''attackMinSec''' - minimum time in seconds before attack when contraband is found
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResourcePurposes.csv.bz2 invControlTowerResourcePurposes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResourcePurposes.csv.bz2 invControlTowerResourcePurposes.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResources.csv.bz2 invControlTowerResources.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResources.csv.bz2 invControlTowerResources.csv.bz2]|| Describes control tower properties<br>
'''controlTowerTypeID''' - the ID of control towers. Corresponds to typeID in invTypes<br>
'''resourceTypeID''' - the ID of resource required by control towers. Corresponds to typeID in invTypes<br>
'''purpose''' - <br>
'''quantity''' - required quantity of resource<br>
'''minSecurityLevel''' - minimum security level of the system in which control tower can be anchored<br>
'''factionID''' - the ID of faction of control tower
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invFlags.csv.bz2 invFlags.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invFlags.csv.bz2 invFlags.csv.bz2]|| Flags describing various items<br>
'''flagID''' - defined ID for this table<br>
'''flagName''' - defines names of flags<br>
'''flagText''' - displayed text for flags<br>
'''orderID''' -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invGroups.csv.bz2 invGroups.csv.bz2]|| Contains information on inventory groups, such as groupID, categoryID, and other metadata
| [https://www.fuzzwork.co.uk/dump/latest/invGroups.csv.bz2 invGroups.csv.bz2]|| Describes inventory groups<br>
'''groupID''' - defined ID for this table<br>
'''categoryID''' - the ID of categories of inventory groups. Corresponds to categoryID in invCategories<br>
'''groupName''' - defines names of inventory groups<br>
'''iconID''' - the ID of icons for inventory groups. Corresponds to iconID in eveIcons<br>
'''useBasePrice''' - Boolean flag to use base item price instead of adjusted item price in job cost calculation<br>
'''anchored''' - Boolean flag to mark a permanently anchored items<br>
'''anchorable''' - Boolean flag to mark items that can be anchored<br>
'''fittableNonSingleton''' - Boolean flag to mark items that are fittable despite not being flagged as Singletons<br>
'''published''' - Boolean flag to mark inventory groups that are published and available in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invItems.csv.bz2 invItems.csv.bz2]|| Information about itemID and typeID, and some others
| [https://www.fuzzwork.co.uk/dump/latest/invItems.csv.bz2 invItems.csv.bz2]|| Describes items that have defined owners<br>
'''itemID''' - defined ID for this table<br>
'''typeID''' - the ID of the item type. Corresponds to typeID in invTypes<br>
'''ownerID''' - the ID of items' owner. Corresponds to itemID in invNames<br>
'''locationID''' - the ID of items' location. Corresponds to itemID in invPositions<br>
'''flagID''' - the ID of items' flag. Corresponds to flagID in invFlags<br>
'''quantity''' - the items' quantity. Quantity = -1 means unlimited quantity
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invMarketGroups.csv.bz2 invMarketGroups.csv.bz2]|| Defines the market group hierarchy
| [https://www.fuzzwork.co.uk/dump/latest/invMarketGroups.csv.bz2 invMarketGroups.csv.bz2]|| Defines the market group hierarchy<br>
'''marketGroupID''' - defined ID for this table<br>
'''parentGroupID''' - the ID of the parent marketing group, if any. Corresponds to marketGroupID in invMarketGroups<br>
'''marketGroupName''' - defines names of marketing groups<br>
'''description''' - description of marketing groups<br>
'''iconID''' - the ID of icons for marketing groups. Corresponds to iconID in eveIcons<br>
'''hasTypes''' - Boolean flag to mark marketing groups that are also parent groups
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invMetaGroups.csv.bz2 invMetaGroups.csv.bz2]|| A small file about meta group ids, such as Tech I, Tech II, Faction, Officer, etc
| [https://www.fuzzwork.co.uk/dump/latest/invMetaGroups.csv.bz2 invMetaGroups.csv.bz2]|| Description of meta groups<br>
'''metaGroupID''' - defined ID for this table<br>
'''metaGroupName''' - defines names of meta groups<br>
'''description''' - description of meta groups<br>
'''iconID''' - the ID of icons for meta groups. Corresponds to iconID in eveIcons
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invMetaTypes.csv.bz2 invMetaTypes.csv.bz2]|| typeID, parentTypeID, metaGroupID
| [https://www.fuzzwork.co.uk/dump/latest/invMetaTypes.csv.bz2 invMetaTypes.csv.bz2]|| Assigns item types to meta groups<br>
'''typeID''' - the ID of the item type. Corresponds to typeID in invTypes<br>
'''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<br>
'''metaGroupID''' - the ID of the item type's meta group. Corresponds to metaGroupID in invMetaGroups
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invNames.csv.bz2 invNames.csv.bz2]|| itemID for everything. Not that itemID is not typeID.
| [https://www.fuzzwork.co.uk/dump/latest/invNames.csv.bz2 invNames.csv.bz2]|| Describes unique items<br>
'''itemID''' - defined ID for this table<br>
'''itemName''' - defines names of unique items
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invPositions.csv.bz2 invPositions.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invPositions.csv.bz2 invPositions.csv.bz2]|| Describes position of unique items<br>
'''itemID''' - ID of unique items. Corresponds to itemID in invNames<br>
'''x''', '''y''', '''z''' - coordinates of unique items<br>
'''yaw''', '''pitch''', '''roll''' - orientation of unique items
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invTraits.csv.bz2 invTraits.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invTraits.csv.bz2 invTraits.csv.bz2]|| Describes traites ("bonuses") of ships<br>
'''traitID''' - defined ID for this table<br>
'''typeID''' - the ID of the ship type. Corresponds to typeID in invTypes<br>
'''skillID''' - the ID of the skill required to fly the ship. Corresponds to typeID in invTypes<br>
'''bonus''' - the size of ship's bonus<br>
'''bonusText''' - description of ship's bonus<br>
'''unitID''' - the ID of the unit of the ship's bonus. Corresponds to unitID in eveUnits
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invTypeMaterials.csv.bz2 invTypeMaterials.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invTypeMaterials.csv.bz2 invTypeMaterials.csv.bz2]|| Describes materials obtained from reprocessing of items<br>
'''typeID''' - the ID of the item to reprocess. Corresponds to typeID in invTypes<br>
'''materialTypeID''' - the ID of the material obtained from reprocessing. Corresponds to typeID in invTypes<br>
'''quantity''' - base quantity of material obtained from reprocessing
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invTypeReactions.csv.bz2 invTypeReactions.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invTypeReactions.csv.bz2 invTypeReactions.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invTypes.csv.bz2 invTypes.csv.bz2]|| Defines the types in the game like market items and celestial objects. Contains typeID, name, description, marketGroupID, ...
| [https://www.fuzzwork.co.uk/dump/latest/invTypes.csv.bz2 invTypes.csv.bz2]|| Defines item types<br>
'''typeID''' - defined ID for this table<br>
'''groupID''' - ID of inventory groups for items. Corresponds to groupID in invGroups<br>
'''typeName''' - defines names of items<br>
'''description''' - description of items<br>
'''mass''' - mass of items in kg<br>
'''volume''' - volume of items in m<sup>3</sup><br>
'''capacity''' - maximum volume of contained items in m<sup>3</sup><br>
'''portionSize''' - minimum number of items to reprocess<br>
'''raceID''' - ID of item's race.  Corresponds to raceID in chrRaces<br>
'''basePrice''' - item's base price in ISK<br>
'''published''' - Boolean flag to mark items that are published and available in game<br>
'''marketGroupID''' - ID of item's market group. Corresponds to marketGroupID in invMarketGroups<br>
'''iconID''' - ID of item's icon. Corresponds to iconID in eveIcons<br>
'''soundID''' - ID if item's sound resource<br>
'''graphicID''' - ID of item's graphic resource. Corresponds to graphicID in eveGraphics
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invUniqueNames.csv.bz2 invUniqueNames.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invTypes-nodescription.csv.bz2 invTypes-nodescription.csv.bz2]|| Table invTypes excluding description
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invVolumes.csv.bz2 invVolumes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invUniqueNames.csv.bz2 invUniqueNames.csv.bz2]|| Describes unique names<br>
'''itemID''' - defined ID for this table<br>
'''itemName''' - defines unique names<br>
'''groupID''' - ID of name's inventory group. Corresponds to groupID in invGroups
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapCelestialStatistics.csv.bz2 mapCelestialStatistics.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invVolumes.csv.bz2 invVolumes.csv.bz2]|| Describes volumes of packaged ships
'''typeID''' - the ID of the ship. Corresponds to typeID in invTypes<br>
'''volume''' - packaged ship volume in m<sup>3</sup>
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapConstellationJumps.csv.bz2 mapConstellationJumps.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapCelestialStatistics.csv.bz2 mapCelestialGraphics.csv.bz2]|| Describes graphics settings of celestials<br>
'''celestialID''' - ID of celestials. Corresponds to celestialID in mapDenormalize<br>
'''heightMap1''' - <br>
'''heightMap2''' - <br>
'''shaderPreset''' - <br>
'''population''' -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapConstellations.csv.bz2 mapConstellations.csv.bz2]|| Constellation position, faction, name, region, name, and radius.
| [https://www.fuzzwork.co.uk/dump/latest/mapCelestialStatistics.csv.bz2 mapCelestialStatistics.csv.bz2]|| Describes physical parameters of celestials<br>
'''celestialID''' - ID of celestials. Corresponds to celestialID in mapDenormalize<br>
'''temperature''' - celestial's temperature<br>
'''spectralClass''' - spectral class for stars, 0 otherwise<br>
'''luminosity''' - luminosity for stars, "None" otherwise<br>
'''age''' - age in seconds for stars, 0 otherwise<br>
'''life''' - remaining lifetime in seconds for stars, 0 otherwise<br>
'''orbitRadius''' - celestial's orbit radius in meters, "None" for stars<br>
'''eccentricity''' - celestial's orbit eccentricity in meters, "None" for stars, 0 for asteroid belts<br>
'''massDust''' - celestial's mass of dust in kg<br>
'''massGas''' - celestial's mass of gas in kg<br>
'''fragmented''' - Boolean flag to mark whether the celestial is fragmented. "None" for stars<br>
'''density''' - celestial's density in kg/m<sup>3</sup>. "None" for stars<br>
'''surfaceGravity''' - celestial's surface gravity in m/s<sup>2</sup>. "None" for stars<br>
'''escapeVelocity''' - celestial's escape velocity in m/s. "None" for stars<br>
'''orbitPeriod''' - celestial's orbital period in seconds. "None" for stars<br>
'''rotationRate''' - celestial's rotational rate in (?). "None" for stars<br>
'''locked''' - Boolean flag<br>
'''pressure''' - celestial's atmospheric pressure in atm (?). "None" for stars, 0 for asteroid belts<br>
'''radius''' - celestial's radius in m<br>
'''mass''' - not used in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapDenormalize.csv.bz2 mapDenormalize.csv.bz2]|| Position, radius, and security status of moons, planets, solar systems, all the way to regions. As such, a very large CSV with more than half a million lines.
| [https://www.fuzzwork.co.uk/dump/latest/mapConstellationJumps.csv.bz2 mapConstellationJumps.csv.bz2]|| Describes gate jumps between constellations<br>
'''fromRegionID''' - ID of the starting region. Corresponds to regionID in mapRegions<br>
'''fromConstellationID''' - ID of the starting constellation. Corresponds to constellationID in mapConstellations<br>
'''toConstellationID''' - ID of the ending constellation. Corresponds to constellationID in mapConstellations<br>
'''toRegionID''' - ID of the ending region. Corresponds to regionID in mapRegions
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapJumps.csv.bz2 mapJumps.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapConstellations.csv.bz2 mapConstellations.csv.bz2]|| Describes constellations<br>
'''regionID''' - ID of the costellation's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize<br>
'''constellationID''' -  - ID of the costellation region. Corresponds to itemID in mapDenormalize<br>
'''constellationName''' - defines names of constellations. Same as itemName in mapDenormalize<br>
'''x''', '''y''', '''z''' - coordinates of constellation's center in Universe coordinates, in meters<br>
'''xMin''', '''xMax''', '''yMin''', '''yMax''', '''zMin''', '''zMax''' - coordinates of constellation's box in Universe coordinates, in meters<br>
'''factionID''' - ID of the faction owning the constellation. Corresponds to factionID in chrFactions<br>
'''radius''' - radius of sphere circumscribing constellation, in meters
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapLandmarks.csv.bz2 mapLandmarks.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapDenormalize.csv.bz2 mapDenormalize.csv.bz2]|| Describes celestials<br>
'''itemID''' - defined ID for this table<br>
'''typeID''' - the ID of the celestial type. Corresponds to typeID in invTypes<br>
'''groupID''' - the ID of the celestial's inventory group. Corresponds to groupID in invGroups<br>
'''solarSystemID''' - the ID of the celestial's solar system, if any. Corresponds to solarSystemID in mapSolarSystems. "None" otherwise<br>
'''constellationID''' - the ID of the celestial's constellation, if any. Corresponds to constellationID in mapConstellations. "None" otherwise<br>
'''regionID''' - the ID of the celestial's region, if any. Corresponds to regionID in mapRegions. "None" otherwise<br>
'''orbitID''' - the ID of the body the celestial orbits, if any. Corresponds to itemID in mapDenormalize. "None" otherwise<br>
'''x''', '''y''', '''z''' - coordinates of celestial's center in Universe coordinates, in meters<br>
'''radius''' - radius of sphere circumscribing celestial, in meters, if any. "None" otherwise<br>
'''itemName''' - defines names of celestials<br>
'''security''' - security level for solar systems, "None" otherwise<br>
'''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<br>
'''orbitIndex''' - index of celestial orbiting parent planet, if any. "None" otherwise. orbitIndex = 1 for the 1st asteroid belt and 1st moon around a planet
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapLocationScenes.csv.bz2 mapLocationScenes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapJumps.csv.bz2 mapJumps.csv.bz2]|| Describes gate jumps between solar systems<br>
'''stargateID''' - the ID of the starting solar system. Corresponds to solarSystemID in mapSolarSystems<br>
'''destinationID'''- the ID of the ending solar system. Corresponds to solarSystemID in mapSolarSystems
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapLocationWormholeClasses.csv.bz2 mapLocationWormholeClasses.csv.bz2]|| Each location's wormholeClassID
| [https://www.fuzzwork.co.uk/dump/latest/mapLandmarks.csv.bz2 mapLandmarks.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapRegionJumps.csv.bz2 mapRegionJumps.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapLocationWormholeClasses.csv.bz2 mapLocationWormholeClasses.csv.bz2]|| Each location's wormholeClassID<br>
'''locationID''' - ID of the location. Corresponds to itemID in mapDenormalize<br>
'''wormholeClassID''' -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapRegions.csv.bz2 mapRegions.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapRegionJumps.csv.bz2 mapRegionJumps.csv.bz2]|| Describes gate jumps between regions<br>
'''fromRegionID''' - the ID of the starting region. Corresponds to regionID in mapRegions<br>
'''toRegionID''' - the ID of the starting region. Corresponds to regionID in mapRegions
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystemJumps.csv.bz2 mapSolarSystemJumps.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapRegions.csv.bz2 mapRegions.csv.bz2]|| Describes regions<br>
'''regionID''' - ID of the region. Corresponds to itemID in mapDenormalize<br>
'''regionName''' - defines names of regions. Same as itemName in mapDenormalize<br>
'''x''', '''y''', '''z''' - coordinates of region's center in Universe coordinates, in meters<br>
'''xMin''', '''xMax''', '''yMin''', '''yMax''', '''zMin''', '''zMax''' - coordinates of region's box in Universe coordinates, in meters<br>
'''factionID''' - ID of the faction owning the constellation. Corresponds to factionID in chrFactions<br>
'''nebula''' - the ID of the graphics of nebulae in the region. Corresponds to graphicID in eveGraphics<br>
'''radius''' - not used in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystems.csv.bz2 mapSolarSystems.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystemJumps.csv.bz2 mapSolarSystemJumps.csv.bz2]|| Describes gate jumps between solar systems<br>
'''fromRegionID''' - ID of the starting region. Corresponds to regionID in mapRegions<br>
'''fromConstellationID''' - ID of the starting constellation. Corresponds to constellationID in mapConstellations<br>
'''fromSolarSystemID''' - ID of the starting solar system. Corresponds to regionID in mapSolarSystems<br>
'''toSolarSystemID''' - ID of the ending solar system. Corresponds to regionID in mapSolarSystems<br>
'''toConstellationID''' - ID of the ending constellation. Corresponds to constellationID in mapConstellations<br>
'''toRegionID''' - ID of the ending region. Corresponds to regionID in mapRegions
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapUniverse.csv.bz2 mapUniverse.csv.bz2]|| Possibly to differentiate between K-space and J-space? (speculation)
| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystems.csv.bz2 mapSolarSystems.csv.bz2]|| Describes solar systems<br>
'''regionID''' - ID of the solar system's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize<br>
'''constellationID''' - ID of the solar system's constellation. Corresponds to constellationID in mapConstellations and itemID in mapDenormalize<br>
'''solarSystemID''' - ID of the solar system. Corresponds to itemID in mapDenormalize<br>
'''solarSystemName''' - defines names of solar systems. Same as itemName in mapDenormalize<br>
'''x''', '''y''', '''z''' - coordinates of solar systems's center in Universe coordinates, in meters<br>
'''xMin''', '''xMax''', '''yMin''', '''yMax''', '''zMin''', '''zMax''' - coordinates of solar systems's box in Universe coordinates, in meters<br>
'''luminosity''' - star's luminoaity<br>
'''border''' - Boolean flag to mark whether the solar system is a border system<br>
'''fringe''' - <br>
'''corridor''' - <br>
'''hub''' - <br>
'''international''' - <br>
'''regional''' - <br>
'''constellation''' - not used in game<br>
'''security''' - solar system's security<br>
'''factionID''' - ID of the faction owning the solar system. Corresponds to factionID in chrFactions<br>
'''radius''' - solar system's radius in meters<br>
'''sunTypeID''' - ID of the sun type. Corresponds to itemType in invTypes<br>
'''securityClass''' - securyty class of the system
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/planetSchematics.csv.bz2 planetSchematics.csv.bz2]|| schematicID, name, and time it takes to complete that schematic.
| [https://www.fuzzwork.co.uk/dump/latest/mapUniverse.csv.bz2 mapUniverse.csv.bz2]|| Defines the K- and J-space unverses<br>
'''universeID''' - ID of the universe. Corresponds to typeID in invTypes<br>
'''universeName''' - defines universe names<br>
'''x''', '''y''', '''z''' - coordinates of universe, in meters<br>
'''xMin''', '''xMax''', '''yMin''', '''yMax''', '''zMin''', '''zMax''' - coordinates of universe box, in meters<br>
'''radius''' - universe radius in meters
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/planetSchematicsPinMap.csv.bz2 planetSchematicsPinMap.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/planetSchematics.csv.bz2 planetSchematics.csv.bz2]|| Describes Planetary Industry schematics<br>
'''schematicID''' - defined ID for this table<br>
'''schematicName''' - defines schematic names<br>
'''cycleTime''' - schematic cycle time completion in seconds
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/planetSchematicsTypeMap.csv.bz2 planetSchematicsTypeMap.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/planetSchematicsPinMap.csv.bz2 planetSchematicsPinMap.csv.bz2]|| Associates pin types with schematics<br>
'''schematicID''' - ID of the schematic. Corresponds to schematicID in planetSchematics<br>
'''pinTypeID''' - ID of the pin. Corresponds to typeID in invTypes
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/ramActivities.csv.bz2 ramActivities.csv.bz2]|| Describes what each R.A.M. does. See [[Manufacturing]]
| [https://www.fuzzwork.co.uk/dump/latest/planetSchematicsTypeMap.csv.bz2 planetSchematicsTypeMap.csv.bz2]|| Describes schematic productivity<br>
'''schematicID''' - ID of the schematic. Corresponds to schematicID in planetSchematics<br>
'''typeID''' - ID of the PI product. Corresponds to typeID in invTypes<br>
'''quantity''' - the size of a batch of PI<br>
'''isInput''' -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineStations.csv.bz2 ramAssemblyLineStations.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/ramActivities.csv.bz2 ramActivities.csv.bz2]|| Describes types of industrial activities<br>
'''activityID''' - defined ID for this table<br>
'''activityName''' - defines activity names<br>
'''iconNo''' - <br>
'''description''' - description of activities<br>
'''published''' - Boolean flag to mark industrial activities that are published and available in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineTypeDetailPerCategory.csv.bz2 ramAssemblyLineTypeDetailPerCategory.csv.bz2]|| Information on R.A.M.
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineStations.csv.bz2 ramAssemblyLineStations.csv.bz2]|| Describes industry activities available at NPC stations<br>
'''stationID''' - ID of NPC stations. Corresponds to stationID in staStations<br>
'''assemblyLineTypeID''' - ID of assembly line type (station service type). Corresponds to assemblyLineTypeID in ramAssemblyLineTypes<br>
'''quantity''' - <br>
'''stationTypeID''' - ID of NPC station type. Corresponds to typeID in invTypes<br>
'''ownerID''' - ID of station owner. Corresponds to itemID in invUniqueNames<br>
'''solarSystemID''' - ID of solar system. Corresponds to solarSystemID in mapSolarSystems<br>
'''regionID''' - ID of region. Corresponds to regionID in mapRegions
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineTypeDetailPerGroup.csv.bz2 ramAssemblyLineTypeDetailPerGroup.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineTypeDetailPerCategory.csv.bz2 ramAssemblyLineTypeDetailPerCategory.csv.bz2]|| Describes time, material, and cost bonuses at NPC station types for each inventory category<br>
'''assemblyLineTypeID''' - ID of assembly line type (station service type). Corresponds to assemblyLineTypeID in ramAssemblyLineTypes<br>
'''categoryID''' - ID of inventory categories. Corresponds to categoryID in invCategories<br>
'''timeMultiplier''', '''materialMultiplier''', '''costMultiplier''' - multipliers for time, material, and cost bonuses
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineTypes.csv.bz2 ramAssemblyLineTypes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineTypeDetailPerGroup.csv.bz2 ramAssemblyLineTypeDetailPerGroup.csv.bz2]|| Describes time, material, and cost bonuses at NPC station types for each inventory group<br>
'''assemblyLineTypeID''' - ID of assembly line type (station service type). Corresponds to assemblyLineTypeID in ramAssemblyLineTypes<br>
'''groupID''' - ID of inventory groups. Corresponds to groupID in invGroups<br>
'''timeMultiplier''', '''materialMultiplier''', '''costMultiplier''' - multipliers for time, material, and cost bonuses
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/ramInstallationTypeContents.csv.bz2 ramInstallationTypeContents.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/ramAssemblyLineTypes.csv.bz2 ramAssemblyLineTypes.csv.bz2]|| Describes installation services<br>
assemblyLineTypeID - defined ID for this table<br>
assemblyLineTypeName - defines installation service names<br>
description - description of installation services<br>
baseTimeMultiplier - multiplier for job time for the service<br>
baseMaterialMultiplier - multiplier for material amount for the service<br>
baseCostMultiplier - multiplier for job cost for the service<br>
volume - not used in game<br>
activityID - ID of activity for the service. Corresponds to activityID in ramActivities<br>
minCostPerHour - minimum cost per hour for the service
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/skinLicense.csv.bz2 skinLicense.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/ramInstallationTypeContents.csv.bz2 ramInstallationTypeContents.csv.bz2]|| Assigns station services to installation types<br>
installationTypeID - ID of installation types. Corresponds to typeID in invTypes<br>
assemblyLineTypeID - ID of installatin service. Corresponds to assemblyLineTypeID in ramAssemblyLineTypes<br>
quantity -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/skinMaterials.csv.bz2 skinMaterials.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/skinLicense.csv.bz2 skinLicense.csv.bz2]|| Assigns licence types to skin types<br>
licenseTypeID - ID of licence types. Corresponds to typeID in invTypes<br>
duration - duration of the license. -1 means a permanent licence<br>
skinID - ID of the skin. Corresponds to skinID in skins
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/skins.csv.bz2 skins.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/skinMaterials.csv.bz2 skinMaterials.csv.bz2]|| <br>
skinMaterialID - <br>
displayNameID - <br>
materialSetID -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/skinShip.csv.bz2 skinShip.csv.bz2]|| What skins can be used on what ships
| [https://www.fuzzwork.co.uk/dump/latest/skins.csv.bz2 skins.csv.bz2]|| <br>
skinID - <br>
internalName - <br>
skinMaterialID -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/staOperations.csv.bz2 staOperations.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/skinShip.csv.bz2 skinShip.csv.bz2]|| Assigns skin types to ships<br>
skinID - ID of skins. Corresponds to skinID in skins<br>
typeID - ID of ship. Corresponds to typeID in invTypes<br>
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/staOperationServices.csv.bz2 staOperationServices.csv.bz2]|| Information about what station types offer what services (speculation)
| [https://www.fuzzwork.co.uk/dump/latest/solarsystemprecise.csv.bz2 solarsystemprecise.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/staServices.csv.bz2 staServices.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/staOperations.csv.bz2 staOperations.csv.bz2]|| <br>
activityID - <br>
operationID - <br>
operationName - <br>
description - <br>
fringe - <br>
corridor - <br>
hub - <br>
border - <br>
ratio - <br>
caldariStationTypeID, minmatarStationTypeID, amarrStationTypeID, gallenteStationTypeID, joveStationTypeID -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/staStations.csv.bz2 staStations.csv.bz2]|| Information about stations, their security level, location, name, reprocessing level, and much more.
| [https://www.fuzzwork.co.uk/dump/latest/staOperationServices.csv.bz2 staOperationServices.csv.bz2]|| <br>
operationID - <br>
serviceID -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/staStationTypes.csv.bz2 staStationTypes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/staServices.csv.bz2 staServices.csv.bz2]|| Description of NPC station services<br>
serviceID - defined ID for this table<br>
serviceName - defines service names<br>
description - description of services
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/translationTables.csv.bz2 translationTables.csv.bz2]|| Appears to be empty
| [https://www.fuzzwork.co.uk/dump/latest/staStations.csv.bz2 staStations.csv.bz2]|| Describes NPC stations<br>
stationID - ID of the station. Corresponds to itemID in mapDenormalize<br>
security - system security<br>
dockingCostPerVolume, maxShipVolumeDockable, officeRentalCost - not used in game<br>
operationID - <br>
stationTypeID - ID of station type. Corresponds to typeID in invTypes<br>
corporationID - <br>
solarSystemID - <br>
constellationID - <br>
regionID - <br>
stationName - <br>
x, y, z - <br>
reprocessingEfficiency - <br>
reprocessingStationsTake - <br>
reprocessingHangarFlag -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/trnTranslationColumns.csv.bz2 trnTranslationColumns.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/staStationTypes.csv.bz2 staStationTypes.csv.bz2]|| <br>
stationTypeID - <br>
dockEntryX - <br>
dockEntryY - <br>
dockEntryZ - <br>
dockOrientationX - <br>
dockOrientationY - <br>
dockOrientationZ - <br>
operationID - <br>
officeSlots - <br>
reprocessingEfficiency - <br>
conquerable -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/trnTranslationLanguages.csv.bz2 trnTranslationLanguages.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/translationTables.csv.bz2 translationTables.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/trnTranslations.csv.bz2 trnTranslations.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/trnTranslationColumns.csv.bz2 trnTranslationColumns.csv.bz2]|| <br>
tcGroupID - <br>
tcID - <br>
tableName - <br>
columnName - <br>
masterID -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/warCombatZones.csv.bz2 warCombatZones.csv.bz2]|| A small file that updates regularly. It contains information about combat zones (FW I think?)
| [https://www.fuzzwork.co.uk/dump/latest/trnTranslationLanguages.csv.bz2 trnTranslationLanguages.csv.bz2]|| <br>
numericLanguageID - <br>
languageID - <br>
languageName -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/warCombatZoneSystems.csv.bz2 warCombatZoneSystems.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/trnTranslations.csv.bz2 trnTranslations.csv.bz2]|| <br>
 
|-
| [https://www.fuzzwork.co.uk/dump/latest/warCombatZones.csv.bz2 warCombatZones.csv.bz2]|| <br>
combatZoneID - <br>
combatZoneName - <br>
factionID - <br>
centerSystemID - <br>
description -
|-
| [https://www.fuzzwork.co.uk/dump/latest/warCombatZoneSystems.csv.bz2 warCombatZoneSystems.csv.bz2]|| <br>
solarSystemID - <br>
combatZoneID -
|}
|}


Line 239: Line 655:
* [https://www.youtube.com/channel/UCCezIgC97PvUuR4_gbFUs5g Corey Schafer]
* [https://www.youtube.com/channel/UCCezIgC97PvUuR4_gbFUs5g Corey Schafer]
* EVE Online Discord Dev Chat [https://discord.com/channels/940573867192221696/972841377798946896 3rd-party-dev-and-esi] - I read most messages sent here, if you need help that StackOverflow can't provide, here is your best bet.
* EVE Online Discord Dev Chat [https://discord.com/channels/940573867192221696/972841377798946896 3rd-party-dev-and-esi] - I read most messages sent here, if you need help that StackOverflow can't provide, here is your best bet.


[[Category:Applications]]
[[Category:Applications]]
Retrieved from "https://wiki.eveuniversity.org/Static_Data_Export"