These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

eve static data dump map coordinates

First post
Author
Previous Topic Next Topic
Leto Cinque
Aliastra
Gallente Federation
#1 - 2013-06-23 13:54:05 UTC  |  Edited by: Leto Cinque
Hi,
I recently downloaded the static data dump, imported into a database, and started querying it.
Right now, I'm toying with a map renderer.
However I don't find any clear documentation about the content of the mapXXX tables.

In order to render the map in 2D I need to normalize the coordinates.
I'm assuming we have this implicit hierarchy in the database
universe
- regions
- - constellations
- - - systems

Main questions:
* what is the purpose of mapdenormalize ?
* what are the units of the X,Y,Z coordinates ? kilometers ?
* can I use the bbox values to normalize the coordinates ?
E.g. normalize regions positions using universe bbox.
Is this the right approach ?

Thanks a lot in advance :)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-06-23 17:02:44 UTC
All Solar system coordinates are absolute positions in space.

All other coordinates are relative to something else. Planets to the star, moons to the planet etc. that's what the orbitid tells you. http://wiki.eve-id.net/MapDenormalize_%28CCP_DB%29

Some very basic rendering code for javascript:
https://github.com/fuzzysteve/ThreeJs-starmap

As for what the units are in, I'm not actually sure. All I could suggest is calculating the distance in those units between two objects in the same system, and comparing it against what's actually in game. Should tell you very quickly.

mapDenormalize holds the coordinates of /everything/ in the game.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Leto Cinque
Aliastra
Gallente Federation
#3 - 2013-06-24 09:01:00 UTC
Thanks a lot for the reply, it make sense now !

MapDenormalize is duplicate information then ?
I'm assuming the benefits is for perf and convenience...

I'll look at your map sample, thanks for the share .
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2013-06-24 09:15:01 UTC
Leto Cinque wrote:
Thanks a lot for the reply, it make sense now !

MapDenormalize is duplicate information then ?
I'm assuming the benefits is for perf and convenience...

I'll look at your map sample, thanks for the share .



mapDenormalize contains /everything/ in space. The other tables contain subsets of that data, and there's some which isn't covered (like asteroid belts, for example)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
CCP Prism X
C C P
C C P Alliance
#5 - 2013-06-24 15:32:16 UTC
Leto Cinque wrote:
Thanks a lot for the reply, it make sense now !

MapDenormalize is duplicate information then ?
I'm assuming the benefits is for perf and convenience...

I'll look at your map sample, thanks for the share .


Map denormalize contains all static "world" items and is seekable by system, constellation or region. It's a denormalized table containing data from multiple other tables so that we can easily query the contents of a system without doing joins or looking into multiple tables.

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Daugar Draaken
EBSTF Holdings
#6 - 2013-07-10 13:19:11 UTC
I have some trouble accessing the coordinates. I may process this information in an arts manner, without rendering. Is there a text file depicting the relative stellar coordinates of KSpace?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2013-07-10 15:10:17 UTC
Daugar Draaken wrote:
I have some trouble accessing the coordinates. I may process this information in an arts manner, without rendering. Is there a text file depicting the relative stellar coordinates of KSpace?



Well, there's: https://www.fuzzwork.co.uk/dump/odyssey-1.0.12-89967/mapSolarSystems.xls.bz2

Though all the coordinates are absolute. This also contains W-Space, off to the side. It's a fairly large distance away, so you should be able to eliminate them fairly easily.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Daugar Draaken
EBSTF Holdings
#8 - 2013-07-10 19:03:03 UTC
This is perfect, thanks
Daugar Draaken
EBSTF Holdings
#9 - 2013-07-10 19:25:37 UTC  |  Edited by: Daugar Draaken
ignore