So, when we get a Killmail from API, we get the position in XYZ of where it happened. This is wonderful, and it lets us find the nearest celestial and even the distance from it.
However, The points of the celestials (let’s use a stargate for example) are for its center. So if the calculated distance is 400000m (400km) this is not what the actual distance from the stargate is but from the stargate’s center.
So, my question is: how do I find the radius of the stargate/station/etc to subtract this when calculating distance? With certain celestials, we can use mapCelestialStatistics, but in the case of things like gates/stations, I can not seem to find this information in the SDE. If this information cannot be obtained, any way to get a “best estimate”?
Thanks in advance to anyone that may have an idea as to how to handle this.
o7
54 Caldari Logistics Station
56 Gallente Military Station
57 Gallente Station Hub
58 C-O-1
59 C-O-2
1529 Caldari Administrative Station
1530 Caldari Research Station
1531 Caldari Trading Station
1926 Amarr Station Hub
1927 Amarr Station Military
1928 Amarr Industrial Station
1929 Amarr Standard Station
1930 Amarr Mining Station
1931 Amarr Research Station
1932 Amarr Trade Post
2071 Station (InterBus)
2496 Minmatar Hub
2497 Minmatar Industrial Station
2498 Minmatar Military Station
2499 Minmatar Mining Station
2500 Minmatar Research Station
2501 Minmatar Station
2502 Minmatar Trade Post
3864 Amarr Citadel
3865 Gallente Research Station
3866 Gallente Trading Hub
3867 Gallente Industrial Station
3868 Gallente Administrative Station
3869 Gallente Logistics Station
3870 Gallente Mining Station
3871 Caldari Station Hub
3872 Caldari Military Station
4023 Caldari Mining Station
4024 Caldari Food Processing Plant Station
9856 Amarr Class A Starport
9857 Amarr Class B Starport
9867 Heaven
9868 Concord Starbase
9873 Dark Amarr Station O
10795 Jovian Construct
12242 Station (Conquerable 1)
12294 Station (Conquerable 2)
12295 Station (Conquerable 3)
19757 Research Outpost
21642 Caldari Research Outpost
21644 Amarr Factory Outpost
21645 Gallente Administrative Outpost
21646 Minmatar Service Outpost
22296 Blood Raider Logistics Outpost
22297 Blood Raider Military Outpost
22298 Blood Raider Trading Outpost
29323 Ishukone Corporation Headquarters
29387 Repaired Amarr Station Hub
29388 Repaired Amarr Military Station
29389 Repaired Amarr Trading Post
29390 Damaged CONCORD Station
34325 Sisters of EVE Logistics Station
34326 Sisters of EVE Industrial Station
This data is in the typeIDs.yml SDE file. Looks like @Steve_Ronukenmissed it in his yamlloader :0. But it is on the type_id. So you would have to figure out the type_id the startgate/station then go from there.
It was definitely easy to get all of the stations,
The stargates, sadly, do not have their typeID anywhere that I have found yet, so that will take a bit more time.
Here is a list of all the stations though, if anyone is interested:
Thats what was thinking, looking them up in mapDenormalize, then looking up the gate by itemID, sadly the typeID in the table is not the typeID I would use for that API call.
Okay, I see what the problem was… I am assuming that either the dump I got, or the import was wrong… It was listing all the typeID in mapDenormalize as 127, I just downloaded an export of just that table, and it was all the correct ID’s — no wonder I was having such a hard time with all of this.
Again, thank you, I probably would not have been able to to get this far without you.