open All Channels
seplocked EVE Technology Lab
blankseplocked Resources in belts and planets in the SDD
 		This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Trenker
Posted - 2011.08.11 16:51:00 - [1]
 
Hi everyone

I tried to get the typeIDs of the resources of a celestial object but could not find it.
More specific: I want to know which ore / ice types can found in a given belt, and which resources are available on a given planet (type) and moon. Couldn't find it in the ram, map and dgm tables.

Using the mysql dump from http://zofu.no-ip.de/inca10/

Any hints on were to look?

Callean Drevus
Caldari
Icosahedron Crafts and Shipping
Silent Infinity
Posted - 2011.08.11 17:33:00 - [2]
 
Most of the data you are looking for is not in the static data dump, as far as I know.

Lutz Major
Posted - 2011.08.11 18:36:00 - [3]
 
Only PI resources are available in the dump:
SELECT resource.* 
FROM invTypes planet, invTypes resource, dgmTypeAttributes dgm1, dgmTypeAttributes dgm2
WHERE dgm1.typeID = dgm2.typeID
-- planet info
AND dgm1.attributeID = 1632 AND dgm1.valueFloat = planet.typeID
-- ressource info
AND dgm2.attributeID = 709 AND dgm2.valueFloat = resource.typeID
AND planet.typeID = 11

All other stuff you are looking for is not available.

Pantload
Gallente
Handsome Millionaire Playboys
Flatline.
Posted - 2011.08.17 04:27:00 - [4]
 
Originally by: Lutz Major
Only PI resources are available in the dump:
SELECT resource.* 
FROM invTypes planet, invTypes resource, dgmTypeAttributes dgm1, dgmTypeAttributes dgm2
WHERE dgm1.typeID = dgm2.typeID
-- planet info
AND dgm1.attributeID = 1632 AND dgm1.valueFloat = planet.typeID
-- ressource info
AND dgm2.attributeID = 709 AND dgm2.valueFloat = resource.typeID
AND planet.typeID = 11

All other stuff you are looking for is not available.


So let's say I don't speak SQL at all. I do speak a bit of Python and I have Entity's Reverence library. How do I do the same lookup in the bulkdata tables?

If I understand at all...that query tells what plants yield what resources? That's all I'm after anyway, if so.

Any help is appreciated. Thanks.


Cheers,
-PL

Lutz Major
Posted - 2011.08.17 06:56:00 - [5]
 
Originally by: Pantload
So let's say I don't speak SQL at all. I do speak a bit of Python and I have Entity's Reverence library. How do I do the same lookup in the bulkdata tables?

If I understand at all...that query tells what plants yield what resources? That's all I'm after anyway, if so.

Any help is appreciated. Thanks.


Cheers,
-PL

I don't know Reverence, but it's static data anyway. So I hope this will help:
|========================================|
| PLANET             | RESSOURCE         |
|========================================|
| Planet (Barren)    | Aqueous Liquids   |
| Planet (Barren)    | Base Metals       |
| Planet (Barren)    | Carbon Compounds  |
| Planet (Barren)    | Micro Organisms   |
| Planet (Barren)    | Noble Metals      |
| Planet (Gas)       | Aqueous Liquids   |
| Planet (Gas)       | Base Metals       |
| Planet (Gas)       | Ionic Solutions   |
| Planet (Gas)       | Noble Gas         |
| Planet (Gas)       | Reactive Gas      |
| Planet (Ice)       | Aqueous Liquids   |
| Planet (Ice)       | Heavy Metals      |
| Planet (Ice)       | Micro Organisms   |
| Planet (Ice)       | Noble Gas         |
| Planet (Ice)       | Planktic Colonies |
| Planet (Lava)      | Base Metals       |
| Planet (Lava)      | Felsic Magma      |
| Planet (Lava)      | Heavy Metals      |
| Planet (Lava)      | Non-CS Crystals   |
| Planet (Lava)      | Suspended Plasma  |
| Planet (Oceanic)   | Aqueous Liquids   |
| Planet (Oceanic)   | Carbon Compounds  |
| Planet (Oceanic)   | Complex Organisms |
| Planet (Oceanic)   | Micro Organisms   |
| Planet (Oceanic)   | Planktic Colonies |
| Planet (Plasma)    | Base Metals       |
| Planet (Plasma)    | Heavy Metals      |
| Planet (Plasma)    | Noble Metals      |
| Planet (Plasma)    | Non-CS Crystals   |
| Planet (Plasma)    | Suspended Plasma  |
| Planet (Storm)     | Aqueous Liquids   |
| Planet (Storm)     | Base Metals       |
| Planet (Storm)     | Ionic Solutions   |
| Planet (Storm)     | Noble Gas         |
| Planet (Storm)     | Suspended Plasma  |
| Planet (Temperate) | Aqueous Liquids   |
| Planet (Temperate) | Autotrophs        |
| Planet (Temperate) | Carbon Compounds  |
| Planet (Temperate) | Complex Organisms |
| Planet (Temperate) | Micro Organisms   |
|----------------------------------------|
or more Excel friendly (copy first in a notepad, then into Excel!):
PLANET	RESSOURCE
Planet (Barren)	Aqueous Liquids
Planet (Barren)	Base Metals
Planet (Barren)	Carbon Compounds
Planet (Barren)	Micro Organisms
Planet (Barren)	Noble Metals
Planet (Gas)	Aqueous Liquids
Planet (Gas)	Base Metals
Planet (Gas)	Ionic Solutions
Planet (Gas)	Noble Gas
Planet (Gas)	Reactive Gas
Planet (Ice)	Aqueous Liquids
Planet (Ice)	Heavy Metals
Planet (Ice)	Micro Organisms
Planet (Ice)	Noble Gas
Planet (Ice)	Planktic Colonies
Planet (Lava)	Base Metals
Planet (Lava)	Felsic Magma
Planet (Lava)	Heavy Metals
Planet (Lava)	Non-CS Crystals
Planet (Lava)	Suspended Plasma
Planet (Oceanic)	Aqueous Liquids
Planet (Oceanic)	Carbon Compounds
Planet (Oceanic)	Complex Organisms
Planet (Oceanic)	Micro Organisms
Planet (Oceanic)	Planktic Colonies
Planet (Plasma)	Base Metals
Planet (Plasma)	Heavy Metals
Planet (Plasma)	Noble Metals
Planet (Plasma)	Non-CS Crystals
Planet (Plasma)	Suspended Plasma
Planet (Storm)	Aqueous Liquids
Planet (Storm)	Base Metals
Planet (Storm)	Ionic Solutions
Planet (Storm)	Noble Gas
Planet (Storm)	Suspended Plasma
Planet (Temperate)	Aqueous Liquids
Planet (Temperate)	Autotrophs
Planet (Temperate)	Carbon Compounds
Planet (Temperate)	Complex Organisms
Planet (Temperate)	Micro Organisms


 

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