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.
 

universal station query?
Author
Previous Topic Next Topic
Sam Splam
Center for Advanced Studies
Gallente Federation
#1 - 2016-01-16 14:36:28 UTC
Hello all, it was recommended in another sub-forum I present my problem here.

I have been attempting to find a way to get a list of all NPC stations in all k-space systems ordered by number of stations. I know there are various 3rd party resources (maps and otherwise) that will return number of stations in systems, but they all seem to at the very least require the entry of the region (ie. I'd have to go region by region, compiling a list manually, which seems inefficient and tedious). Seemingly, the data is there, but no one has written a query, or handled the available data , to allow for this. It seems a couple of the 3rd party maps will actually display the data in map form, but not in a list. Again, seems inefficient as I'd have to actually look at each system individually. A list would be the preferred result since I could then just order it ascending or descending at will.

Does anyone know of a tool I could use to get the result I am looking for?

My post on the forums here, and the commensurate responses, might better explain what I am looking for if I am not explaining it very well: https://forums.eveonline.com/default.aspx?g=posts&m=6280748#post6280748

In advance, thank you very much for any assistance rendered!
Moryg H'qarr
The Scope
Gallente Federation
#2 - 2016-01-16 16:00:47 UTC
I don't know of any tool that would allow you to do that - but if you can get yourself an export of the static database export (https://developers.eveonline.com/resource/resources), you can get it easily with a query. If you don't know how to do that, let me know and I'll make you an export (a CSV or something).
Drapko Nitzhonot
Abdera Logistics
#3 - 2016-01-16 16:03:55 UTC
This is SQL query (from latest SQL dump):

Quote:

USE [YC118]
GO

SELECT region.[regionName] AS [Region]
,solar.[solarSystemName] AS [Solar System]
,count(solar.[solarSystemName]) AS [Stations]
FROM [YC118].[dbo].[staStations] sta
LEFT JOIN [YC118].[dbo].[mapSolarSystems] solar ON sta.[solarSystemID] = solar.[solarSystemID]
LEFT JOIN [YC118].[dbo].[mapRegions] region ON sta.[regionID] = region.[regionID]
GROUP BY solar.[solarSystemName]
,region.[regionName]
ORDER BY [Stations] DESC


Results: http://dl.eve-files.com/media/1601/Stations_per_SolarSystem.zip
Sam Splam
Center for Advanced Studies
Gallente Federation
#4 - 2016-01-16 16:56:56 UTC
Thank you both, very much! Double thanks to you, Drapko! You rock! o7