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 374: Line 374:
'''volume''' - packaged ship volume in m<sup>3</sup>
'''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 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/mapConstellationJumps.csv.bz2 mapConstellationJumps.csv.bz2]||  
| [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/mapConstellations.csv.bz2 mapConstellations.csv.bz2]|| Constellation position, faction, name, region, name, and radius.
| [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/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/mapConstellations.csv.bz2 mapConstellations.csv.bz2]|| Describes constellations<br>
'''regionID''' - ID of the costellation's region. Corresponds to regionID in mapRegions<br>
'''constellationID''' - defined ID for this table<br>
'''constellationName''' - defines names of constellations<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/mapJumps.csv.bz2 mapJumps.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/mapLandmarks.csv.bz2 mapLandmarks.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/mapLocationScenes.csv.bz2 mapLocationScenes.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapLandmarks.csv.bz2 mapLandmarks.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/mapLocationWormholeClasses.csv.bz2 mapLocationWormholeClasses.csv.bz2]|| Each location's wormholeClassID
| [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/mapRegionJumps.csv.bz2 mapRegionJumps.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/mapRegions.csv.bz2 mapRegions.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/mapRegions.csv.bz2 mapRegions.csv.bz2]||