Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sam Splam
Center for Advanced Studies Gallente Federation
0
|
Posted - 2016.01.16 05:34:14 -
[1] - Quote
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
Bad Influence I N G L O R I O U S
4
|
Posted - 2016.01.16 05:51:47 -
[2] - Quote
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. |
Sam Splam
Center for Advanced Studies Gallente Federation
0
|
Posted - 2016.01.16 06:05:43 -
[3] - Quote
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
5660
|
Posted - 2016.01.16 10:04:53 -
[4] - Quote
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
0
|
Posted - 2016.01.16 14:19:54 -
[5] - Quote
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
Meticulously Indifferent
1460
|
Posted - 2016.01.16 23:59:31 -
[6] - Quote
Maybe you can run a parser on this.
https://public-crest.eveonline.com/industry/facilities/
Edit: Reading Material
Adventures
New player with questions? Join my public channel in game: House Forelli
Titan's Lament
|
Cara Forelli
Meticulously Indifferent
1460
|
Posted - 2016.01.17 01:54:29 -
[7] - Quote
I went ahead and did it for you.
Output Script
Edit: Please excuse my amateur Python skills
Adventures
New player with questions? Join my public channel in game: House Forelli
Titan's Lament
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5845
|
Posted - 2016.01.17 17:41:56 -
[8] - Quote
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 X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Malcanis
Vanishing Point. The Initiative.
17359
|
Posted - 2016.01.17 18:15:22 -
[9] - Quote
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?
"It is difficult to get a man to understand something, when his ISK/hr depends upon his not understanding it!"
|
Moonlit Raid
State War Academy Caldari State
279
|
Posted - 2016.01.17 19:20:29 -
[10] - Quote
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.
|
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |