# The EVE Online Ecosystem Outlook

**URL:** <https://forums.eveonline.com/t/the-eve-online-ecosystem-outlook/287097>\
**Category:** Dev Blogs\
**Tags:** feedback, official\
**Created:** [December 27, 2020, 11:25am UTC](https://forums.eveonline.com/t/the-eve-online-ecosystem-outlook/287097 "2020-12-27T11:25:12Z")\
**Posts on this page:** 1\
**Showing post:** 365

<div class="post-metadata">

**Author:** ![RealEchnaton](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/realechnaton/32/243119_2.png) [@RealEchnaton](https://forums.eveonline.com/u/RealEchnaton)\
**Post date:** [December 29, 2020, 5:32am UTC](https://forums.eveonline.com/t/the-eve-online-ecosystem-outlook/287097/365 "2020-12-29T05:32:46Z")

</div>

> [@Flanidia](#):
>
> > [@Fartsniffer\_Munba](#):
> >
> > The MER is not only a bunch of pictures, but also a data file with raw info, that’s where he got those.
> 
> Indeed, I’m looking at the data file for kills right now and while there is a column for system and system id, there is no column for system security status.
> 
> Maybe you should look at the file before jumping in : )

You can get the static data from here

[https://forums.eveonline.com/t/sde-conversion-2021201/284253](https://forums.eveonline.com/t/sde-conversion-2021201/284253)

and I got the numbers from SQL via join, example for highsec:

```
 SELECT COUNT(*),regionname,`security`,m.itemName FROM test.killdump k
 INNER JOIN sdeyaml.mapdenormalize m
 on k.solarSystemID = m.solarSystemID
 WHERE (destroyedShipgroup IN ("Mining Barge","Exhumer")
 OR destroyedShipType = 'Venture') AND regionname <> "Pochven"
 and SECURITY >= 0.5 

```

Pochven has to be excluded, because it is still with the old security listedn for example Niarja is with security 0,5 in the database.

---

_[View the full topic](https://forums.eveonline.com/t/the-eve-online-ecosystem-outlook/287097)._