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 New Citizens Q&A

 
  • Topic is locked indefinitely.
 

stations and 3rd party maps?

First post
Author
Previous Topic Next Topic
Sam Splam
Center for Advanced Studies
Gallente Federation
#1 - 2016-01-16 05:34:14 UTC
I'm attempting to get a list of systems ranked by number of stations in them. I only really care about K-space. I've looked at the in-game maps as well as DOTLAN and eyeeve, but I cannot seem to query any of those resources in such a way as to receive a list. Certainly I can get the number of stations to display in dotlan, for instance, but that entails me actually having to look at each system to determine the stations. I'd rather have a simple ordered list returned from a query of number of stations for k-space. Any thoughts on how to retrieve said data? It really seems like the data is available since you can get is represented on the maps themselves, but not in a list.
Thorian Baalnorn
State War Academy
Caldari State
#2 - 2016-01-16 05:51:47 UTC  |  Edited by: Thorian Baalnorn
On dotlan

You can bring up a region( use search or the universe map) in list form and it will tell you all systems in that region and how many stations are in each system. It will be the column with the house icon at the top, the one after alliance/faction column.

To get more specific data such as a complied searchable list of all stations, their type, and owner in one list for all of eve, ive never heard of such a list being complied as no one really has ever needed a reason for one.

Sometimes you are the squirrel and sometimes you are the nut. Today, you are the nut and the squirrel is hungry.
Sam Splam
Center for Advanced Studies
Gallente Federation
#3 - 2016-01-16 06:05:43 UTC
Thanks for the reply Thorian, but I was able to get that far myself. Instead of searching by region, however, I wanted to be able to search all regions at once and order by stations per system. Certainly, I could just do through every region that way you are stating and record it myself externally, but it would be a pretty long undertaking.

I don't really care about their type, owner, etc. Just the raw number of stations per system on a universal scale.
Tau Cabalander
Retirement Retreat
Working Stiffs
#4 - 2016-01-16 10:04:53 UTC  |  Edited by: Tau Cabalander
NPC?

http://eve-online.itemdrop.net/eve_db/universe/station_search/

Easier in player controlled nulsec since "There can only be ONE!"

Otherwise the info is available from the API / Crest / data export (see the EVE Technology Lab forum). Steve Ronuken Somone will probably figure it out for you if you ask there nicely.
Sam Splam
Center for Advanced Studies
Gallente Federation
#5 - 2016-01-16 14:19:54 UTC  |  Edited by: Sam Splam
Yes, NPC. I did try itemdrop, but it does not seem to work unless you enter the constellation, and that makes it an even less broad return than the one suggested by Thorian.



Thank you both for your assistance thus far!
Cara Forelli
State War Academy
Caldari State
#6 - 2016-01-16 23:59:31 UTC  |  Edited by: Cara Forelli
Maybe you can run a parser on this.

https://public-crest.eveonline.com/industry/facilities/


Edit: Reading Material

Want to talk? Join my channel in game: House Forelli

Titan's Lament
Cara Forelli
State War Academy
Caldari State
#7 - 2016-01-17 01:54:29 UTC  |  Edited by: Cara Forelli
Cara Forelli wrote:
Maybe you can run a parser on this.

https://public-crest.eveonline.com/industry/facilities/

I went ahead and did it for you.

Output
Script

Edit: Please excuse my amateur Python skills Big smile

Want to talk? Join my channel in game: House Forelli

Titan's Lament
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2016-01-17 17:41:56 UTC  |  Edited by: Steve Ronuken
If you grab a copy of the SDE, (you need staStations, and mapSolarSystems.) then you can do it pretty easily.

Something like:

select solarsystemname,count(staStations.stationid) from staStations join mapSolarSystems on (staStations.solarsystemid=mapSolarSystems.solarsystemid) group by solarsystemname


That's from memory, so you'll probably need to tweak it.


(Edit: Now that I've seen the tech forum post, heh, guess that shows the order I visit the various sections in)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Malcanis
Vanishing Point.
The Initiative.
#9 - 2016-01-17 18:15:22 UTC
Steve Ronuken wrote:
If you grab a copy of the SDE, (you need staStations, and mapSolarSystems.) then you can do it pretty easily.

Something like:

select solarsystemname,count(staStations.stationid) from staStations join mapSolarSystems on (staStations.solarsystemid=mapSolarSystems.solarsystemid) group by solarsystemname


That's from memory, so you'll probably need to tweak it.


(Edit: Now that I've seen the tech forum post, heh, guess that shows the order I visit the various sections in)



Hmmm what happens when Large Citadels are introduced?

"Just remember later that I warned against any change to jump ranges or fatigue. You earned whats coming."

Grath Telkin, 11.10.2016
Moonlit Raid
Doomheim
#10 - 2016-01-17 19:20:29 UTC
If you can get the raw data in a table format; excel (or google sheets) is probably more than capable of doing what you need.

If brute force isn't working, you're just not using enough.

Please Note: Any advice given comes with the caveat that nothing will be suitable for every situation.