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.
 

SDE map question

First post
Author
Previous Topic Next Topic
Jarno Midumulf
Riders of Sleipnir
Backdoor Crashers
#1 - 2015-05-21 10:02:03 UTC
Last night i got the SDE working on my database server and was looking true what it all has to offer, and found some interesting tables about the map:
- mapCelestialStatistics
- mapConstellationJumps
- mapConstellations
- mapDenormalize
- mapJumps
- mapLandmarks
- mapLocationScenes
- mapLocationWormholeClasses
- mapRegionJumps
- mapRegions
- mapSolarSystemJumps
- mapSolarSystems
- mapUniverse

whit this i was thinking i could make my own custom map, but it turns out that wasn't so easy...
multiple tables have x,y,z off the system id's, so i wrote a query to get the system names and x,y,z values off them and did parse that out on a image.
i was hoping to get a flat map off new eden.. but it turns out that was not what i got: map

is there a way to get the right xyz position off the systems from the SDE or is there something i am missing?

-jarno
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-05-21 12:10:54 UTC
The details in mapSolarSytems are accurate.

If you're wanting a flat map, I'd suggest projecting with X and Z. (and you'll probably want to reflect the X, as the coordinates are based from bottom left, rather than the top left graphics will give you).

They're in meters.


How do I know this for sure? https://github.com/fuzzysteve/eve-custom-starmap Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jarno Midumulf
Riders of Sleipnir
Backdoor Crashers
#3 - 2015-05-21 13:11:27 UTC
Steve Ronuken wrote:
The details in mapSolarSytems are accurate.

If you're wanting a flat map, I'd suggest projecting with X and Z. (and you'll probably want to reflect the X, as the coordinates are based from bottom left, rather than the top left graphics will give you).

They're in meters.


How do I know this for sure? https://github.com/fuzzysteve/eve-custom-starmap Smile


Great! thx!

i will take a look at it tonight and see if i can get it to work

but those numbers are negative if i remember correct, that means it should start from the center?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-05-21 15:35:03 UTC
They're both positive and negative. So you're going to have to recenter it Smile

hence the messing around the minx miny, max x max y

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jarno Midumulf
Riders of Sleipnir
Backdoor Crashers
#5 - 2015-05-21 18:17:47 UTC  |  Edited by: Jarno Midumulf
Steve Ronuken wrote:
They're both positive and negative. So you're going to have to recenter it Smile

hence the messing around the minx miny, max x max y


great.. well time to figer it out :)

btw, i did notice this random ";" on line 37

edit:
i got it to work \o/

now its time to make a 3d version off it in webgl
Mr Mac
Dark Goliath
#6 - 2015-05-23 20:30:16 UTC
very nice!
Jarno Midumulf
Riders of Sleipnir
Backdoor Crashers
#7 - 2015-06-05 09:50:01 UTC
didnt have time for a 3d version yet (maby this weekend i can give it a try), but i got the system sec colors working
XeX Znndstrup
#8 - 2015-06-12 13:34:27 UTC
Is it really useful ?
You have already such a map in game.

Could you explain me how you will use that ?
I am sure you have an idea in the head...

Thanks.

Judge of The Law Organization and President of Stellar Order.

"Long is the way, and hard, that out of hell leads up to light". John Milton, Lost Paradise.

@ /// f
Mr Mac
Dark Goliath
#9 - 2015-06-12 15:53:44 UTC
XeX Znndstrup wrote:
Is it really useful ?
You have already such a map in game.

Could you explain me how you will use that ?
I am sure you have an idea in the head...

Thanks.

man, coding is fun Blink
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#10 - 2015-06-12 17:51:07 UTC
XeX Znndstrup wrote:
Is it really useful ?
You have already such a map in game.

Could you explain me how you will use that ?
I am sure you have an idea in the head...

Thanks.



By itself, probably not so useful. But good for visualising certain kinds of data.

'where do I have assets, and what value are they'. For example. or 'Where are my corp getting killed' and so on, and so on.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jarno Midumulf
Riders of Sleipnir
Backdoor Crashers
#11 - 2015-06-15 07:29:27 UTC
XeX Znndstrup wrote:
Is it really useful ?
You have already such a map in game.

Could you explain me how you will use that ?
I am sure you have an idea in the head...

Thanks.


on it self its not that useful yet at the moment.

The first plan was to get it to work in 2D, after that in 3D.
once i got that to worked out i want to add some some fun stuff like steve said; zkillboard data, where your assets are and some other stuff i can get from the eve api.

but i had it very busy lately so i didn't had time to work on the 3D version, i will post an update once i got it working.