open All Channels
seplocked EVE Technology Lab
blankseplocked Densest item in EVE?
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Kazuo Ishiguro
House of Marbles
Posted - 2011.03.31 21:51:00 - [1]
 

Counting only items that have well-defined defined mass and volume attributes, which one has the highest density in kg / m^3? If an item can be repackaged, count the packaged volume. Items that cannot be placed in stacks in a station do not count, so no stargates or other celestials please (1e28 kg / m^3).

Best candidate so far: Plutonium, 2000kg/m^3

Worst candidate so far: Station warehouse, 0.009 kg/m^3 (would float in hydrogen under standard conditions).

Catari Taga
Centre Of Attention
Middle of Nowhere
Posted - 2011.03.31 22:06:00 - [2]
 

mysql> SELECT typeName, mass/volume density 
FROM eve_official.invtypes
ORDER BY density DESC LIMIT 5;
+--------------------+-----------------------+
| typeName | density |
+--------------------+-----------------------+
| Scordite | 6.66666666666667e+035 |
| Massive Scordite | 6.66666666666667e+035 |
| Condensed Scordite | 6.66666666666667e+035 |
| Viscous Pyroxeres | 3.33333333333333e+035 |
| Solid Pyroxeres | 3.33333333333333e+035 |
+--------------------+-----------------------+

Kazuo Ishiguro
House of Marbles
Posted - 2011.03.31 23:08:00 - [3]
 

And what's the mass per unit of each of those? It isn't listed in-game Razz

Catari Taga
Centre Of Attention
Middle of Nowhere
Posted - 2011.03.31 23:33:00 - [4]
 

Here you go: Smile
mysql> SELECT typeName,mass,volume,mass/volume density 
FROM eve_official.invtypes
ORDER BY density DESC LIMIT 5;
+--------------------+--------+--------+-----------------------+
| typeName | mass | volume | density |
+--------------------+--------+--------+-----------------------+
| Scordite | 1e+035 | 0.15 | 6.66666666666667e+035 |
| Massive Scordite | 1e+035 | 0.15 | 6.66666666666667e+035 |
| Condensed Scordite | 1e+035 | 0.15 | 6.66666666666667e+035 |
| Viscous Pyroxeres | 1e+035 | 0.3 | 3.33333333333333e+035 |
| Solid Pyroxeres | 1e+035 | 0.3 | 3.33333333333333e+035 |
+--------------------+--------+--------+-----------------------+

Kazuo Ishiguro
House of Marbles
Posted - 2011.03.31 23:53:00 - [5]
 

Is there another attribute on those that sets the mass as not being displayed in-game? If so, could you exclude items with that attribute set to the same value?

Catari Taga
Centre Of Attention
Middle of Nowhere
Posted - 2011.04.01 11:26:00 - [6]
 

Possibly, but since I do not know off hand that would require me to actually spend time on it and I do not want to. Wink

Kazuo Ishiguro
House of Marbles
Posted - 2011.04.02 09:28:00 - [7]
 

I suspect 1e35 is just a placeholder, and it might also function as the trigger that turns off the listing of mass in 'Show Info' windows. If you strip out all instances of that value, I imagine the next mass down will be quite a lot smaller, i.e. 1e9-1e10 for supercapital ships.

Catari Taga
Centre Of Attention
Middle of Nowhere
Posted - 2011.04.02 11:56:00 - [8]
 

Stargates have the same mass and are showing it. But just for you and because I like copy'n'pasting useless queries:

mysql> SELECT typeName,mass,volume,mass/volume density 
FROM eve_official.invtypes
WHERE mass < 1e+035 ORDER BY density DESC LIMIT 5;
+-----------------------------+---------+--------+----------+
| typeName | mass | volume | density |
+-----------------------------+---------+--------+----------+
| Black Morphite | 100000 | 0.01 | 10000000 |
| 30km Minmatar Capture Point | 1000000 | 1 | 1000000 |
| 10km Minmatar Capture Point | 1000000 | 1 | 1000000 |
| 10km Caldari Capture Point | 1000000 | 1 | 1000000 |
| 30km Gallente Capture Point | 1000000 | 1 | 1000000 |
+-----------------------------+---------+--------+----------+

and

mysql> SELECT typeName,mass,volume,mass/volume density
FROM eve_official.invtypes
WHERE mass < 1e+035 AND published = 1 ORDER BY density DESC LIMIT 5;
+-----------------------------+------+--------+------------------+
| typeName | mass | volume | density |
+-----------------------------+------+--------+------------------+
| Nanite Repair Paste | 2500 | 0.01 | 250000 |
| Fulmination Assault Missile | 1000 | 0.015 | 66666.6666666667 |
| Hellfire Assault Missile | 1000 | 0.015 | 66666.6666666667 |
| Torrent Assault Missile | 1000 | 0.015 | 66666.6666666667 |
| Terror Assault Missile | 1000 | 0.015 | 66666.6666666667 |
+-----------------------------+------+--------+------------------+


Those are definitely the last ones I do though. I'll just image you said thanks btw. Razz

Kazuo Ishiguro
House of Marbles
Posted - 2011.04.02 12:20:00 - [9]
 

Edited by: Kazuo Ishiguro on 02/04/2011 12:21:01
Yes, thanks for your efforts. I tried running the same queries (more or less) in SQL server 2008 with a fresh backup but got quite different results:


SELECT top 5 typeName,mass,volume,mass/volume density
FROM invTypes
where invTypes.volume > 0
and invTypes.mass < 10^36
ORDER BY density DESC



typeName mass volume density
---------------------------------------------------------------------------------------------------- ---------------------- ---------------------- ----------------------
Defender I 10 0.015 666.666666666667
Arch Angel Titanium Sabot S 1 0.0025 400
Arch Angel Fusion S 1 0.0025 400
Arch Angel Phased Plasma S 1 0.0025 400
Arch Angel EMP S 1 0.0025 400

(5 row(s) affected)

Catari Taga
Centre Of Attention
Middle of Nowhere
Posted - 2011.04.02 12:41:00 - [10]
 

please don't break the forums.

also I do not know enough about SQL Server 2008 to know why your query does not work correctly, maybe the ORDER BY statement does not work with the alias?

Zeta Zhul
Caldari
Preemptive Paranoia
Posted - 2011.04.02 15:04:00 - [11]
 

1. Did CCP have a hard crash or something because my UI had none of my default channels set up and now when logging in my default character wasn't set.

@CCP: seriously here. WTF are you guys doing? Do you know?

2. What is even more amusing is if you reverse the Order By and remember that pure water has a density of 1 (if I remember right). E.g. 1m3 water = 1,000kg. So it is amusing to see what can *float*.

Kazuo Ishiguro
House of Marbles
Posted - 2011.04.02 22:55:00 - [12]
 

On closer inspection, the table invTypes doesn't even contain an entry for Nanite Repair paste, so perhaps I need to create another one. I think to get the relevant information I'd need to do a merge on eveNames and dgmTypeAttributes (mass = 4, volume = 161), but I'm not quite sure of the syntax.

Talking of things with low densities, I think station warehouses would float in hydrogen (under standard conditions).

Catari Taga
Centre Of Attention
Middle of Nowhere
Posted - 2011.04.03 00:54:00 - [13]
 

Edited by: Catari Taga on 03/04/2011 00:54:45
Originally by: Kazuo Ishiguro
On closer inspection, the table invTypes doesn't even contain an entry for Nanite Repair paste,

it most certainly does, see my post above. whatever database you are using seems to be incomplete and incorrect

Zeta Zhul
Caldari
Preemptive Paranoia
Posted - 2011.04.03 01:00:00 - [14]
 

Nanite Repair Paste, typeid = 28668

Jercy Fravowitz
School of Applied Knowledge
Posted - 2011.04.03 10:11:00 - [15]
 

a bit late to the party, and perhaps i took the initial request too literal ...

but my extensive research indicates the most dense _item_ on tq is 268946627.

which on second thought isnt much of a surprise.

Kazuo Ishiguro
House of Marbles
Posted - 2011.04.03 11:17:00 - [16]
 

Re: not being able to find nanite repair paste: yes, I was being silly. I'm much more familiar with SAS than SQL, so perhaps I should try converting the database into that format instead.

I was trying to work out whether there were any items capable of turning a station into a black hole while respecting the limits on stacks per hangar and the number of players / characters in EVE, as per this post:

http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1489839&page=1#18


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only