Toggle menu
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
added more SDE info
added more SDE info
Line 322: Line 322:
'''metaGroupID''' - the ID of the item type's meta group. Corresponds to metaGroupID in invMetaGroups
'''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/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/mapCelestialStatistics.csv.bz2 mapCelestialStatistics.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapCelestialStatistics.csv.bz2 mapCelestialStatistics.csv.bz2]||