# Get Structures Info

**URL:** <https://forums.eveonline.com/t/get-structures-info/52902>\
**Category:** Science & Industry\
**Created:** [January 23, 2018, 8:00pm UTC](https://forums.eveonline.com/t/get-structures-info/52902 "2018-01-23T20:00:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amodos\_Oblivion](https://imageserver.eveonline.com/Character/1_512.jpg) [@Amodos\_Oblivion](https://forums.eveonline.com/u/Amodos_Oblivion)\
**Post date:** [January 23, 2018, 8:00pm UTC](https://forums.eveonline.com/t/get-structures-info/52902/1 "2018-01-23T20:00:02Z")

</div>

Hello,  
I’m creating a spreadsheet for industry, and i want to know if it’s possible to fetch citadel information ( i need riggs to apply material reduction in formulas). I look at swagger but didn’t found.  
Should i do it manually ?

Thanks

---

<div class="post-metadata">

**Author:** ![Krysenth](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/krysenth/32/58194_2.png) [@Krysenth](https://forums.eveonline.com/u/Krysenth)\
**Post date:** [January 24, 2018, 1:49am UTC](https://forums.eveonline.com/t/get-structures-info/52902/2 "2018-01-24T01:49:06Z")

</div>

To my knowledge, there is no way to get specifics of citadel industry modifiers without using authenticated endpoints (and even then, it’s a convoluted process). My suggestion would be to join the tweetfleet slack ( [https://www.fuzzwork.co.uk/tweetfleet-slack-invites/](https://www.fuzzwork.co.uk/tweetfleet-slack-invites/) ) and ask in the `#ESI` or `#SCC-Lounge` channels if anyone’s had experience on dealing with that stuff.

---

<div class="post-metadata">

**Author:** ![von\_Susla](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/von_susla/32/227774_2.png) [@von\_Susla](https://forums.eveonline.com/u/von_Susla)\
**Post date:** [January 24, 2018, 9:52am UTC](https://forums.eveonline.com/t/get-structures-info/52902/3 "2018-01-24T09:52:37Z")

</div>

[https://developers.eveonline.com/resource/resources](https://developers.eveonline.com/resource/resources)  
STATIC DATA EXPORT (SDE)  
sde-20180110-TRANQUILITY.zip  
in google you can find converted for most popular DBs

and than you can make requests like this

> citadel bonuses
> 
> ```
> SELECT t.id,t.name, a.id, a.code, a.name, ta.value
> FROM eve_types t,
> eve_groups g,
> eve_type_attributes ta,
> eve_attributes a
> where g.category_id=65 
> and g.published=1
> and t.group_id = g.id 
> and t.published=1
> and ta.type_id = t.id
> and a.id=ta.attribute_id
> #and a.published=1
> and a.id in (2600,2601,2602)
> 
> ```

| ID | Name | AID | ACode | AName | Value |
| --- | --- | --- | --- | --- | --- |
| 35825 | Raitaru | 2600 | strEngMatBonus | N/A | 0.99 |
| 35825 | Raitaru | 2601 | strEngCostBonus | N/A | 0.97 |
| 35825 | Raitaru | 2602 | strEngTimeBonus | N/A | 0.85 |
| 35826 | Azbel | 2600 | strEngMatBonus | N/A | 0.99 |
| 35826 | Azbel | 2601 | strEngCostBonus | N/A | 0.96 |
| 35826 | Azbel | 2602 | strEngTimeBonus | N/A | 0.8 |
| 35827 | Sotiyo | 2600 | strEngMatBonus | N/A | 0.99 |
| 35827 | Sotiyo | 2601 | strEngCostBonus | N/A | 0.95 |
| 35827 | Sotiyo | 2602 | strEngTimeBonus | N/A | 0.7 |

---

<div class="post-metadata">

**Author:** ![Amodos\_Oblivion](https://imageserver.eveonline.com/Character/1_512.jpg) [@Amodos\_Oblivion](https://forums.eveonline.com/u/Amodos_Oblivion)\
**Post date:** [January 24, 2018, 7:54pm UTC](https://forums.eveonline.com/t/get-structures-info/52902/4 "2018-01-24T19:54:20Z")

</div>

Ok, i’ll check that.  
Maybe it’s just impossbile ^^  
Thanks for the help

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [April 24, 2018, 7:54pm UTC](https://forums.eveonline.com/t/get-structures-info/52902/5 "2018-04-24T19:54:47Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.