New to EVE online api

[erg_cz]

Hi.

How I can get a list of all temperate planets from EVE online database, for example? Programming language does not matter, I just need a hint how to work with EVE online api…

Thank you.

[Blacksmoke16]

This kind of information would best come from the SDE, where you could run a SQL query to get your answer.

[Mr_Twinkie]

https://www.fuzzwork.co.uk/dump/sde-20171205-TRANQUILITY/

I have no idea which one will have this info, but this is where you’ll find it

[Blacksmoke16]

Here you go.

https://pastebin.com/1R4ZGQvx

Basic just used the SDE MapDenormalized table, then filter on typeID where typeID = 11.

11 = Planet (Temperate).

SQL for this would be like SELECT * FROM MapDenormalized WHERE typeID = 11;