Difference between revisions of "Static Data Export"

From EVE University Wiki
Jump to: navigation, search
(Added WIP template)
Line 11: Line 11:
 
! File name !! What it does
 
! File name !! What it does
 
|-
 
|-
| [https://www.fuzzwork.co.uk/dump/latest/ramActivities.csv.bz2 ramActivities.csv.bz2]|| Describe what each R.A.M. does.  See [[Manufacturing]]
+
| [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/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]|| Contains information on inventory groups, such as groupID, categoryID, and other metadata
Line 67: Line 67:
 
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationResearchFields.csv.bz2 crpNPCCorporationResearchFields.csv.bz2]|| Example
 
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationResearchFields.csv.bz2 crpNPCCorporationResearchFields.csv.bz2]|| Example
 
|-
 
|-
| [https://www.fuzzwork.co.uk/dump/latest/certMasteries.csv.bz2 certMasteries.csv.bz2]|| Example
+
| [https://www.fuzzwork.co.uk/dump/latest/certMasteries.csv.bz2 certMasteries.csv.bz2]|| What ships have what certificates.  In this case, typeID is the ship, and certID is the certificate.  See certSkills.csv.bz2
 
|-
 
|-
| [https://www.fuzzwork.co.uk/dump/latest/translationTables.csv.bz2 translationTables.csv.bz2]|| Example
+
| [https://www.fuzzwork.co.uk/dump/latest/translationTables.csv.bz2 translationTables.csv.bz2]|| Appears to be empty as of 12/3/16
 
|-
 
|-
| [https://www.fuzzwork.co.uk/dump/latest/planetSchematics.csv.bz2 planetSchematics.csv.bz2]|| Example
+
| [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/mapConstellations.csv.bz2 mapConstellations.csv.bz2]|| Example
+
| [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/dgmTypeAttributes.csv.bz2 dgmTypeAttributes.csv.bz2]|| Example
 
| [https://www.fuzzwork.co.uk/dump/latest/dgmTypeAttributes.csv.bz2 dgmTypeAttributes.csv.bz2]|| Example

Revision as of 01:18, 4 December 2016

This page is a work in progress.

This article or section is in the process of an expansion or major restructuring. You are welcome to assist in its construction by editing it as well.
If this article or section has not been edited in several days, please remove this template.

How to use the fuzzwork dumps

The fuzzwork dumps, also knows as the SDE (Static Data Export), are very useful for many 3rd party applications. They can be found at www.fuzzwork.co.uk under SDE, then under latest, or more directly at www.fuzzwork.co.uk/dump/latest. This article will go into detail on what each part is for, and how to access it.

Opening a file from the SDE

Directly quoted from the site: "To open bz2 files, use bunzip2 in linux, or something like 7zip in windows" Each file come in two flavors, CSV and SQL. For the purpose of this guide I won't go into opening SQL files, and rather assume that you will be using CSV files.

What each file does

File name What it does
ramActivities.csv.bz2 Describes what each R.A.M. does. See Manufacturing
invGroups.csv.bz2 Contains information on inventory groups, such as groupID, categoryID, and other metadata
agtAgents.csv.bz2 Contains information regarding agents such as location, corporation, type, level, and locator (boolean)
ramAssemblyLineTypeDetailPerCategory.csv.bz2 Information on R.A.M.
dgmExpressions.csv.bz2 Information regarding expressions
dgmEffects.csv.bz2 Information regarding effects, such as launching missiles, scaling damage, and the effects skills have.
warCombatZones.csv.bz2 A small file that updates regularly. Contains information about combat zones (FW I think?)
staOperationServices.csv.bz2 Information about what station types offer what services (speculation)
invMetaGroups.csv.bz2 A small file about meta group ids, such as Tech I, Tech II, Faction, Officer, etc
industryActivitySkills.csv.bz2 Containes information about the skills required to manufacture any blueprint.
chrBloodlines.csv.bz2 Contains information on what race each bloodline belongs to, descriptions.
skinShip.csv.bz2 What skins can be used on what ships
crpNPCCorporationTrades.csv.bz2 Information on what each NPC corp sells.
mapUniverse.csv.bz2 Possibly to differentiate between K-space and J-space? (speculation)
invItems.csv.bz2 Information about itemID and typeID, and some others
staStations.csv.bz2 Information about stations, their security level, location, name, reprocessing level, and much more.
mapLocationWormholeClasses.csv.bz2 Each location's wormholeClassID
invCategories.csv.bz2 Category IDs and category names
eveGraphics.csv.bz2 Information regarding grapics such as graphicID, graphic location, race, and description.
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.
crpActivities.csv.bz2 IDK, maybe names of NPC sturcture groups?
chrRaces.csv.bz2 raceID and raceName, iconID and a long and short description (side note, ORE is a race)
chrFactions.csv.bz2 Faction IDs, name, and description. Also what race each faction belongs to, and some other misc. information.
invNames.csv.bz2 Unknown
invMetaTypes.csv.bz2 typeID, parentTypeID, metaGroupID
dgmTypeEffects.csv.bz2 effectID that each typID had, see also dgmEffects.csv.bz2
crpNPCDivisions.csv.bz2 Information on NPC divisions, mostly deprecated.
crpNPCCorporationResearchFields.csv.bz2 Example
certMasteries.csv.bz2 What ships have what certificates. In this case, typeID is the ship, and certID is the certificate. See certSkills.csv.bz2
translationTables.csv.bz2 Appears to be empty as of 12/3/16
planetSchematics.csv.bz2 schematicID, name, and time it takes to complete that schematic.
mapConstellations.csv.bz2 Constellation position, faction, name, region, name, and radius.
dgmTypeAttributes.csv.bz2 Example
dgmAttributeCategories.csv.bz2 Example
crpNPCCorporationDivisions.csv.bz2 Example
skinLicense.csv.bz2 Example
invPositions.csv.bz2 Example
certSkills.csv.bz2 Example
staStationTypes.csv.bz2 Example
mapSolarSystems.csv.bz2 Example
invTraits.csv.bz2 Example
invControlTowerResourcePurposes.csv.bz2 Example
invContrabandTypes.csv.bz2 Example
mapLandmarks.csv.bz2 Example
invFlags.csv.bz2 Example
industryActivityMaterials.csv.bz2 Example
warCombatZoneSystems.csv.bz2 Example
staServices.csv.bz2 Example
mapConstellationJumps.csv.bz2 Example
mapCelestialStatistics.csv.bz2 Example
trnTranslations.csv.bz2 Example
mapSolarSystemJumps.csv.bz2 Example
dgmAttributeTypes.csv.bz2 Example
agtResearchAgents.csv.bz2 Example
ramAssemblyLineTypeDetailPerGroup.csv.bz2 Example
invTypeMaterials.csv.bz2 Example
mapJumps.csv.bz2 Example
invControlTowerResources.csv.bz2 Example
industryBlueprints.csv.bz2 Example
industryActivity.csv.bz2 Example
certCerts.csv.bz2 Example
invTypes.csv.bz2 Example
mapLocationScenes.csv.bz2 Example
chrAncestries.csv.bz2 Example
invUniqueNames.csv.bz2 Example
trnTranslationLanguages.csv.bz2 Example
trnTranslationColumns.csv.bz2 Example
skins.csv.bz2 Example
ramInstallationTypeContents.csv.bz2 Example
planetSchematicsTypeMap.csv.bz2 Example
mapRegions.csv.bz2 Example
invTypeReactions.csv.bz2 Example
industryActivityRaces.csv.bz2 Example
eveUnits.csv.bz2 Example
eveIcons.csv.bz2 Example
agtAgentTypes.csv.bz2 Example
staOperations.csv.bz2 Example
skinMaterials.csv.bz2 Example
ramAssemblyLineTypes.csv.bz2 Example
ramAssemblyLineStations.csv.bz2 Example
planetSchematicsPinMap.csv.bz2 Example
mapRegionJumps.csv.bz2 Example
invVolumes.csv.bz2 Example
invMarketGroups.csv.bz2 Example
industryActivityProducts.csv.bz2 Example
industryActivityProbabilities.csv.bz2 Example
crpNPCCorporations.csv.bz2 Example
chrAttributes.csv.bz2 Example