Static Data Export: Difference between revisions

Line 410:

|-

| [https://www.fuzzwork.co.uk/dump/latest/mapConstellations.csv.bz2 mapConstellations.csv.bz2]|| Describes constellations

'''regionID''' - ID of the costellation's region. Corresponds to regionID in mapRegions

'''regionID''' - ID of the costellation's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize

'''constellationID''' - ~~defined~~ ID ~~for this table~~

'''constellationID''' - - ID of the costellation region. Corresponds to itemID in mapDenormalize

'''constellationName''' - defines names of constellations

'''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

Line 448:

|-

| [https://www.fuzzwork.co.uk/dump/latest/mapRegions.csv.bz2 mapRegions.csv.bz2]|| Describes regions

'''regionID''' - ID of the region. Corresponds to itemID in mapDenormalize

nebula - the ID of the graphics of nebulae in the region. Corresponds to graphicID in eveGraphics

'''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

|-

| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystemJumps.csv.bz2 mapSolarSystemJumps.csv.bz2]||

| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystemJumps.csv.bz2 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

|-

| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystems.csv.bz2 mapSolarSystems.csv.bz2]||

| [https://www.fuzzwork.co.uk/dump/latest/mapSolarSystems.csv.bz2 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

|-

| [https://www.fuzzwork.co.uk/dump/latest/mapUniverse.csv.bz2 mapUniverse.csv.bz2]|| Possibly to differentiate between K-space and J-space? (speculation)

@@ Line 410: / Line 410: @@
 |-
 | [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>
+'''regionID''' - ID of the costellation's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize<br>
-'''constellationID''' - defined ID for this table<br>
+'''constellationID''' -  - ID of the costellation region. Corresponds to itemID in mapDenormalize<br>
-'''constellationName''' - defines names of constellations<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>
@@ Line 448: / Line 448: @@
 |-
 | [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>
-nebula - the ID of the graphics of nebulae in the region. Corresponds to graphicID in eveGraphics
+'''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/mapSolarSystemJumps.csv.bz2 mapSolarSystemJumps.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/mapSolarSystems.csv.bz2 mapSolarSystems.csv.bz2]||
+| [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/mapUniverse.csv.bz2 mapUniverse.csv.bz2]|| Possibly to differentiate between K-space and J-space? (speculation)