These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

List of systems without 50% refineries?
Author
Previous Topic Next Topic
Salpad
Carebears with Attitude
#1 - 2012-08-21 19:34:38 UTC
I tried going to the dotlan site, but couldn't find any search function that's about refineries.

Using Ombey's 2D Maps, it seems as if almost all high-sec systems are marked as "R" meaning they have a refinery, or else they are blank, meaning no station. Yet I seem to remember that several years ago, I had found a system to mine in, rather far from Jita (12-25 jumps), that either didn't have a refinery, or else had only a crappy 30% one, but still had a station so I could dock and dump my ore. I'd build up some ore, then fly in with my Freighter and haul the or to somewhere where I had perfect refine.

How can I get a list of those high-sec systems that do have at least one station, but where there is no 50% refinery available? Is there a way to get that inside the game client? Or is there a dotlan site search function that I overlooked? Or is there some other way?
Idont Getitatall
Doomheim
#2 - 2012-08-21 20:08:03 UTC
Why would you want a system with a crappy refinery station to dump your ore?

Just so you can use your freighter for hauling?

you can find quiet 50% refinery systems to mine quite easily 12-25 jumps from jita....
Salpad
Carebears with Attitude
#3 - 2012-08-21 20:52:35 UTC
But if there's no 50% refinery, odds are very high that system will stay quiet for the next several years.
Tau Cabalander
Retirement Retreat
Working Stiffs
#4 - 2012-08-21 22:36:25 UTC
Salpad
Carebears with Attitude
#5 - 2012-08-21 22:54:23 UTC
Tau Cabalander wrote:
Might help: http://eve-online.itemdrop.net/eve_db/universe/station_search/


Thanks, but I can't seem to enter negative search parameters, e.g. NOT 50% efficiency. Besides, it's station-based. I need to do a system search. Some systems contain half a dozen stations, or even more, and I need all of them to be under 50% efficiency.

By sheer chance, though, I stumbled over Lower Debyl, in the Devoid region. Lots of belts (no ice), marked as "R" in the Ombey 2D Maps, but affording to the search site, it hasn't got any 50% refineries in it, only a couple of 30% ones.

I'll take a look, and report back. But even if it works, it's just a freak occurence, and unless there's some search functionality I've overlooked, the itemdrop search isn't well suited for the task.
Revolution Rising
Last-Light Holdings
#6 - 2012-08-21 23:10:37 UTC
Salpad wrote:
Tau Cabalander wrote:
Might help: http://eve-online.itemdrop.net/eve_db/universe/station_search/


Thanks, but I can't seem to enter negative search parameters, e.g. NOT 50% efficiency. Besides, it's station-based. I need to do a system search. Some systems contain half a dozen stations, or even more, and I need all of them to be under 50% efficiency.

By sheer chance, though, I stumbled over Lower Debyl, in the Devoid region. Lots of belts (no ice), marked as "R" in the Ombey 2D Maps, but affording to the search site, it hasn't got any 50% refineries in it, only a couple of 30% ones.

I'll take a look, and report back. But even if it works, it's just a freak occurence, and unless there's some search functionality I've overlooked, the itemdrop search isn't well suited for the task.


A very quiet area, great place for jumping caps around near there ;)

.
Tau Cabalander
Retirement Retreat
Working Stiffs
#7 - 2012-08-21 23:25:25 UTC
You might be able to do it with http://eve.grismar.net/explorer/index.php but be warned it is VERY outdated (example: Black Rise is missing).
Salpad
Carebears with Attitude
#8 - 2012-08-22 08:39:46 UTC
Tau Cabalander wrote:
You might be able to do it with http://eve.grismar.net/explorer/index.php but be warned it is VERY outdated (example: Black Rise is missing).


I tried doing a search for NOT reprocessing, and got something like 40 systems, all of which looked to be no-sec. But is it possible to search for NOT 50% reprocessing? That should yield a larger number of results, some of which might be high-sec.
Huttan Funaila
Caldari Provisions
Caldari State
#9 - 2012-08-22 15:46:21 UTC
The result is a list of 73 stations.

You can get the database from the toolkit:
http://community.eveonline.com/community/toolkit.asp

How to set up SQL Server to use the data dump:
http://phoenixdiaries.co.uk/eve-online-database-dump

Download SQL Server from Microsoft:
http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Another post on working with the database from the toolkit:
http://k162space.com/2012/04/13/working-with-eve-static-data/

The query to get your list of stations:
Quote:
SELECT stationName, reprocessingEfficiency
FROM staStations AS ST
INNER JOIN mapSolarSystems AS SS
ON SS.solarSystemID = ST.solarSystemID
WHERE ST.solarSystemID NOT IN (SELECT solarSystemID FROM staStations WHERE reprocessingEfficiency = 0.5)
ORDER BY stationName ASC
GO

The "where not in" clause specfically excludes any system that has a 50% refinery.


The list of stations:
Quote:
stationName reprocessingEfficiency
0G-A25 VI - Moon 20 - True Power Mining Outpost 0.32
5E-VR8 I - Moon 10 - Salvation Angels Chemical Refinery 0.35
6QBH-S IV - Moon 13 - True Power Mining Outpost 0.32
7-X3RN VII - Moon 12 - True Power Mining Outpost 0.32
Aimoguier V - Material Acquisition Mining Outpost 0.32
Ainaille VII - Moon 5 - Duvolle Laboratories Factory 0.3
Andabiar I - Ishukone Corporation Factory 0.3
Atreen VIII - Carthum Conglomerate Factory 0.3
A-XASO IV - Moon 4 - True Power Mining Outpost 0.32
Bairshir IV - Moon 11 - Thukker Mix Factory 0.3
B-G1LG VI - Moon 3 - True Power Mining Outpost 0.32
Cadelanne V - Material Acquisition Mining Outpost 0.32
Crielere I - Duvolle Laboratories Research Center 0.25
Crielere I - Ishukone Corporation Research Center 0.25
CVY-UC IX - Moon 17 - Serpentis Corporation Reprocessing Facility 0.4
D5IW-F VIII - Moon 2 - Chemal Tech Factory 0.3
Deven V - Moon 16 - Ducia Foundry Mining Outpost 0.32
E02-IK VIII - Moon 1 - Thukker Mix Factory 0.3
Ebodold X - Moon 17 - Kaalakiota Corporation Research Center 0.25
Futzchag II - Thukker Mix Factory 0.3
Futzchag IX - Moon 9 - Thukker Mix Factory 0.3
Hadonoo III - Moon 9 - Carthum Conglomerate Research Center 0.25
Hodrold VII - Moon 8 - Thukker Mix Factory 0.3
Hodrold VIII - Moon 2 - Kaalakiota Corporation Factory 0.3
Hogimo IV - Deep Core Mining Inc. Mining Outpost 0.32
Hogimo V - Moon 11 - Deep Core Mining Inc. Mining Outpost 0.32
Hogimo V - Moon 16 - Deep Core Mining Inc. Mining Outpost 0.32
Hogimo V - Moon 7 - Poksu Mineral Group Mining Outpost 0.32
Hogimo V - Moon 9 - Poksu Mineral Group Mining Outpost 0.32
Hogimo VI - Moon 17 - Lai Dai Corporation Research Center 0.25
Hrondedir VII - Moon 15 - Impro Factory 0.3
Iaokit IX - Moon 7 - Ducia Foundry Mining Outpost 0.32
Iaokit VI - Moon 14 - Ducia Foundry Mining Outpost 0.32
Isie V - Minedrill Mining Outpost 0.32
J-AYLV III - Moon 14 - True Power Mining Outpost 0.32
Kourmonen II - Moon 2 - X-Sense Chemical Refinery 0.35
Kourmonen IV - Moon 18 - Ishukone Corporation Factory 0.3
Kourmonen V - Ishukone Corporation Factory 0.3
Kourmonen V - Moon 13 - X-Sense Chemical Refinery 0.35
Kourmonen V - Moon 4 - X-Sense Chemical Refinery 0.35
Leurtmar III - Thukker Mix Factory 0.3
Masanuh V - Moon 8 - Ishukone Corporation Factory 0.3
Meunvon IV - Moon 3 - Impro Factory 0.3
Mollin VI - Moon 5 - Material Acquisition Mining Outpost 0.32
Mora VI - Moon 4 - Ishukone Corporation Factory 0.3
Munory VII - Moon 9 - Ducia Foundry Mining Outpost 0.32
NM-OEA V - Moon 4 - Outer Ring Excavations Mining Outpost 0.32
NM-OEA VI - Moon 23 - Outer Ring Excavations Mining Outpost 0.32
Odette VII - Moon 6 - Duvolle Laboratories Factory 0.3
Oishami VII - Moon 12 - Minedrill Mining Outpost 0.32
Ommaerrer VIII - Moon 5 - Material Acquisition Mining Outpost 0.32
Oto VIII - Moon 4 - Minedrill Mining Outpost 0.32
Oto VIII - Moon 6 - Poksu Mineral Group Mining Outpost 0.32
Pedel IV - Moon 1 - HZO Refinery Mining Outpost 0.32
Pedel VII - HZO Refinery Mining Outpost 0.32
Podion VIII - Moon 15 - Nefantar Miner Association Mining Outpost 0.32
PVH8-0 VI - Moon 8 - Thukker Mix Factory 0.3
Rayl VIII - Moon 7 - Carthum Conglomerate Factory 0.3
Rayl X - Moon 3 - Carthum Conglomerate Factory 0.3
Situner VI - Moon 13 - Minmatar Mining Corporation Mining Outpost 0.32
Stayme VI - Moon 3 - X-Sense Chemical Refinery 0.35
Teshkat V - Chemal Tech Factory 0.3
Teshkat VI - Chemal Tech Factory 0.3
Teshkat VI - Impro Factory 0.3
Totkubad III - Thukker Mix Factory 0.3
Trosquesere V - Moon 10 - Duvolle Laboratories Factory 0.3
Tukanas VIII - Moon 6 - Impro Factory 0.3
Tuomuta III - Ducia Foundry Mining Outpost 0.32
Unel IX - Chemal Tech Factory 0.3
Vale II - Moon 1 - Material Acquisition Mining Outpost 0.32
Vale VI - Moon 2 - Chemal Tech Research Center 0.25
Vilinnon I - Material Acquisition Mining Outpost 0.32
Zemalu IX - Moon 2 - Thukker Mix Factory 0.3


You can fiddle with the query if you want regions/constellations, etc.
Piddle Diddy
Doomheim
#10 - 2012-08-22 17:29:20 UTC
It's not system specific, its corp specific. Thukker stations all have 30% refine. I haven't tested recently, but I think each faction has one or two corps (I think always an R&D corp) whose stations are 30%.
Zhilia Mann
Tide Way Out Productions
#11 - 2012-08-23 02:53:08 UTC
Huttan Funaila wrote:
The result is a list of 73 stations.

You can get the database from the toolkit:
http://community.eveonline.com/community/toolkit.asp

How to set up SQL Server to use the data dump:
http://phoenixdiaries.co.uk/eve-online-database-dump

Download SQL Server from Microsoft:
http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Another post on working with the database from the toolkit:
http://k162space.com/2012/04/13/working-with-eve-static-data/

The query to get your list of stations:
Quote:
SELECT stationName, reprocessingEfficiency
FROM staStations AS ST
INNER JOIN mapSolarSystems AS SS
ON SS.solarSystemID = ST.solarSystemID
WHERE ST.solarSystemID NOT IN (SELECT solarSystemID FROM staStations WHERE reprocessingEfficiency = 0.5)
ORDER BY stationName ASC
GO

The "where not in" clause specfically excludes any system that has a 50% refinery.


The list of stations:
Quote:
stationName reprocessingEfficiency
0G-A25 VI - Moon 20 - True Power Mining Outpost 0.32
5E-VR8 I - Moon 10 - Salvation Angels Chemical Refinery 0.35
6QBH-S IV - Moon 13 - True Power Mining Outpost 0.32
7-X3RN VII - Moon 12 - True Power Mining Outpost 0.32
Aimoguier V - Material Acquisition Mining Outpost 0.32
Ainaille VII - Moon 5 - Duvolle Laboratories Factory 0.3
Andabiar I - Ishukone Corporation Factory 0.3
Atreen VIII - Carthum Conglomerate Factory 0.3
A-XASO IV - Moon 4 - True Power Mining Outpost 0.32
Bairshir IV - Moon 11 - Thukker Mix Factory 0.3
B-G1LG VI - Moon 3 - True Power Mining Outpost 0.32
Cadelanne V - Material Acquisition Mining Outpost 0.32
Crielere I - Duvolle Laboratories Research Center 0.25
Crielere I - Ishukone Corporation Research Center 0.25
CVY-UC IX - Moon 17 - Serpentis Corporation Reprocessing Facility 0.4
D5IW-F VIII - Moon 2 - Chemal Tech Factory 0.3
Deven V - Moon 16 - Ducia Foundry Mining Outpost 0.32
E02-IK VIII - Moon 1 - Thukker Mix Factory 0.3
Ebodold X - Moon 17 - Kaalakiota Corporation Research Center 0.25
Futzchag II - Thukker Mix Factory 0.3
Futzchag IX - Moon 9 - Thukker Mix Factory 0.3
Hadonoo III - Moon 9 - Carthum Conglomerate Research Center 0.25
Hodrold VII - Moon 8 - Thukker Mix Factory 0.3
Hodrold VIII - Moon 2 - Kaalakiota Corporation Factory 0.3
Hogimo IV - Deep Core Mining Inc. Mining Outpost 0.32
Hogimo V - Moon 11 - Deep Core Mining Inc. Mining Outpost 0.32
Hogimo V - Moon 16 - Deep Core Mining Inc. Mining Outpost 0.32
Hogimo V - Moon 7 - Poksu Mineral Group Mining Outpost 0.32
Hogimo V - Moon 9 - Poksu Mineral Group Mining Outpost 0.32
Hogimo VI - Moon 17 - Lai Dai Corporation Research Center 0.25
Hrondedir VII - Moon 15 - Impro Factory 0.3
Iaokit IX - Moon 7 - Ducia Foundry Mining Outpost 0.32
Iaokit VI - Moon 14 - Ducia Foundry Mining Outpost 0.32
Isie V - Minedrill Mining Outpost 0.32
J-AYLV III - Moon 14 - True Power Mining Outpost 0.32
Kourmonen II - Moon 2 - X-Sense Chemical Refinery 0.35
Kourmonen IV - Moon 18 - Ishukone Corporation Factory 0.3
Kourmonen V - Ishukone Corporation Factory 0.3
Kourmonen V - Moon 13 - X-Sense Chemical Refinery 0.35
Kourmonen V - Moon 4 - X-Sense Chemical Refinery 0.35
Leurtmar III - Thukker Mix Factory 0.3
Masanuh V - Moon 8 - Ishukone Corporation Factory 0.3
Meunvon IV - Moon 3 - Impro Factory 0.3
Mollin VI - Moon 5 - Material Acquisition Mining Outpost 0.32
Mora VI - Moon 4 - Ishukone Corporation Factory 0.3
Munory VII - Moon 9 - Ducia Foundry Mining Outpost 0.32
NM-OEA V - Moon 4 - Outer Ring Excavations Mining Outpost 0.32
NM-OEA VI - Moon 23 - Outer Ring Excavations Mining Outpost 0.32
Odette VII - Moon 6 - Duvolle Laboratories Factory 0.3
Oishami VII - Moon 12 - Minedrill Mining Outpost 0.32
Ommaerrer VIII - Moon 5 - Material Acquisition Mining Outpost 0.32
Oto VIII - Moon 4 - Minedrill Mining Outpost 0.32
Oto VIII - Moon 6 - Poksu Mineral Group Mining Outpost 0.32
Pedel IV - Moon 1 - HZO Refinery Mining Outpost 0.32
Pedel VII - HZO Refinery Mining Outpost 0.32
Podion VIII - Moon 15 - Nefantar Miner Association Mining Outpost 0.32
PVH8-0 VI - Moon 8 - Thukker Mix Factory 0.3
Rayl VIII - Moon 7 - Carthum Conglomerate Factory 0.3
Rayl X - Moon 3 - Carthum Conglomerate Factory 0.3
Situner VI - Moon 13 - Minmatar Mining Corporation Mining Outpost 0.32
Stayme VI - Moon 3 - X-Sense Chemical Refinery 0.35
Teshkat V - Chemal Tech Factory 0.3
Teshkat VI - Chemal Tech Factory 0.3
Teshkat VI - Impro Factory 0.3
Totkubad III - Thukker Mix Factory 0.3
Trosquesere V - Moon 10 - Duvolle Laboratories Factory 0.3
Tukanas VIII - Moon 6 - Impro Factory 0.3
Tuomuta III - Ducia Foundry Mining Outpost 0.32
Unel IX - Chemal Tech Factory 0.3
Vale II - Moon 1 - Material Acquisition Mining Outpost 0.32
Vale VI - Moon 2 - Chemal Tech Research Center 0.25
Vilinnon I - Material Acquisition Mining Outpost 0.32
Zemalu IX - Moon 2 - Thukker Mix Factory 0.3


You can fiddle with the query if you want regions/constellations, etc.


You, sir, have made me finally get off my ass and learn some SQL to advance my EVE nerdery.
Salpad
Carebears with Attitude
#12 - 2012-08-23 08:38:42 UTC
Thanks Huttan. I'll do some legwork to refine your list, by combining multiple entries, such as Hogimo, and also noting down which region each system is in, and return here.
Salpad
Carebears with Attitude
#13 - 2012-08-23 09:02:27 UTC  |  Edited by: Salpad
I've refined on Huttan's list:

1. I combined all multiple entries of the same system, such as Hogimo.
2. I deleted all entries that were in high-sec.
3. I wrote down the number of jumps from Jita to the system, autopilot set to "safe", avoid list empty.
4. I wrote down the Region in which the system lies.
5. I marked as (isl.) if the system is in high-sec but you have to travel through low-sec or no-sec to get there, i.e. an "island" as opposed to being part of what one might call "connected high-sec".

Sadly, no such systems in the Devoid Region, but there might be some in neighbouring regions:

Ainaille, 15j Sinq Laison
Andabiar, 15j Domain
Atreen, 15j Genesis
Hadonoo - 15j Domain
Hodrold - 29j Metropolis (isl.)
Hogimo - 6j, Citadel
Leurtmar - 26j, Metropolis
Masanuh - 12j, Kor-Azor
Mollin - 20j, Placid, (isl.)
Mora - 12j, Kor-Azor
Munory - 15j, Kador
Odette - 19j, Sinq Laison (isl.)
Oishami - 11j, Lonetrek (isl.)
Ommaerrer - 20j, Placid (isl.)
Pedel - 13j, Domain
Rayl - 18j, Domain
Situner - 31j, Metropolis
Stayme - 16j, Sinq Laison
Totkubad - 29j, Metropolis
Trosquesere - 13j, Sinq Laison
Tuomuta - 15j, The Bleak Lands
Unel - 10j, Sinq Laison
Vale - 16j, Essence
Vilinno - 20j, Placid (isl.)
Zemalu - 30j, Derelik

I was a bit puzzled by the large number of systems that are exactly 15 jumps away from Jita, and this made me wonder if there was some error in my method, but I double-checked the autopilot settings, and the avoid system list is empty.

edit: Marked Odette as (isl.).
Salpad
Carebears with Attitude
#14 - 2012-08-23 09:30:45 UTC
Huttan, does your database query also include stations that have no refinery at all? I had to admit I don't understand the query syntax. I've never learned databases.
Luscius Uta
#15 - 2012-08-23 11:12:39 UTC  |  Edited by: Luscius Uta
Salpad wrote:
Huttan, does your database query also include stations that have no refinery at all? I had to admit I don't understand the query syntax. I've never learned databases.


I don't know much about refining, but from what I know about databases I can see that the query doesn't seem to filter out stations without refineries, but unless there's another station in the system without a refinery I would just list the systems and not actual stations.

Workarounds are not bugfixes.
Salpad
Carebears with Attitude
#16 - 2012-08-23 12:10:39 UTC
Maybe stations without any referineries/reprocessing plants don't exist at all. I had that thought about an hour ago.
Discova
Nexgen Industry
#17 - 2012-08-23 14:33:49 UTC
Original query cleaned up:
SELECT stationName, reprocessingEfficiency
FROM staStations AS ST
JOIN mapSolarSystems AS SS
ON ST.solarSystemID = SS.solarSystemID
Where SA.reprocessingEfficiency <> 0.5
ORDER BY stationName ASC


I do not know what they have in the reprocessingEfficiency column if the station doesnt have a refinery but I covered it being NULL or blank). This should give you where station has refinery but is not = to (<>) .5 or is null or is blank

SELECT stationName, reprocessingEfficiency
FROM staStations AS ST
JOIN mapSolarSystems AS SS
ON ST.solarSystemID = SS.solarSystemID
Where (SA.reprocessingEfficiency <> 0.5
or SA.reprocessingEfficiency is NULL
or SA.reprocessingEfficiency = '')
ORDER BY stationName ASC
Huttan Funaila
Caldari Provisions
Caldari State
#18 - 2012-08-23 17:38:48 UTC
Salpad wrote:
Huttan, does your database query also include stations that have no refinery at all? I had to admit I don't understand the query syntax. I've never learned databases.
A check of the staStations table shows that every entry (all 5181) has a value above 0 for reprocessingEfficiency. This tells me that every station has refining/reprocessing. I do not recall any high sec stations that I was not able to refine/reprocess stuff at. If there is one, then these columns don't really mean what they say.

Trying some other queries to find stations where staServices.serviceID = 32 (refinery) excluded many stations where I knew from past experience that refining was possible. These stations showed up when you look for staServices.serviceID = 16 (reprocessing plant). I suspect that the game treats refining as a type of reprocessing.
Quote:
SELECT stationName, reprocessingEfficiency, SS.solarSystemName, Str(SS.security, 4, 1) AS SystemSecurity, O.operationName, S.serviceName
FROM staStations AS ST
INNER JOIN mapSolarSystems AS SS -- What system is this station in.
ON SS.solarSystemID = ST.solarSystemID
INNER JOIN staOperations AS O -- What type of operation is at this station.
ON O.operationID = ST.operationID
INNER JOIN staOperationServices as OS -- What services are offered by this type of operation.
ON O.operationID = OS.operationID
INNER JOIN staServices as S -- What are the services.
ON OS.serviceID = S.serviceID
WHERE
S.serviceID = 32 -- Refinery
OR
S.serviceID = 16 -- Reprocessing Plant
ORDER BY stationName ASC
GO
This query should let you fiddle around with trying to determine what services are being offered. The staServices table lists the services, but also lists features that are not in the game (assassination missions? gambling?). Paintshop! Will we ever be able to paint our ships differently? How many Hello Kitty™ ships will there be? How many with flames on the side? Enquiring minds want to know!

264 stations have a Black Market (serviceID = 128). It looks like I need to check them out next time I'm back in Empire.
Totally Trustworthy
Doomheim
#19 - 2012-08-23 18:02:21 UTC
All npc stations have refine abilities. Black market means nothing (they tied into the skill of the same name).

As previously mentioned, the stations with 30% refine are determined by the corporation (e.g. Thukker, Ishukone). If a system has at least one non-30% corp station, it would meet the requirements of your search parameters.
Salpad
Carebears with Attitude
#20 - 2012-08-24 11:43:51 UTC  |  Edited by: Salpad
I checked several of the high-sec systems from Huttan's list, and they all had refine service, but always under 50%.

edit: Those systems I checked had very few stations in them. I guess that makes sense. If there were more stations, chances are higher that one of them would be a 50%.