Let there be Database Rows
The only edits that I had to make to the project code were the database connection details in scraper.ini and a narrowing down of ship classes listed in toaster_shiplist.json. After getting the data into mySQL and importing the invTypes and mapSolarSystems tables from the static dump into my database, I could start to filter and sort the results.
Kicking off the scraper:
pi@charon ~/eve_prosper $ python zkb_scraper.py — startdate=2013-12-01DB Connection: GOODzKillboard connection: GOODno crash log found. Executing as normal…Parsed Capital Industrial Ship: [200, 29713239, 0, ‘2013-04-08’] sleep=20.0Parsed Capital Industrial Ship: [290, 27468307, 1, ‘2012-12-30’] sleep=20.0
Here is the query to get Racial JFs and also include the solar system name and security value:
— Get Racial JFs
SELECT destruction_data.date, destruction_data.week, destruction_data.typeID, destruction_data.systemID, destruction_data.destroyed, invTypes.typeName, mapSolarSystems.solarSystemName, mapSolarSystems.security
ON (destruction_data.typeID = invTypes.typeID)
ON (destruction_data.systemID = mapSolarSystems.solarsystemID)
WHERE destruction_data.typeID IN (28850, 28844, 28848, 28846)
ORDER BY destruction_data.date DESC
Out of 975 Jump Freighter kills covering 334 days, there is an average of 20 a week killed. It turns out that you are most likely to get caught in Lowsec in a Rhea.
When we look at kills by system, Purjola (0.5), a Highsec system in the Forge stands out as the system with the most losses at 54. Not surprisingly the Lowsec system of Sagain (0.4) comes in second, most likely due to the terrible kickout station that I have covered here.
More coming soon as I start to think of what types of statistics and trends I can pull out of the data. If you have something you would like me to look at, please leave a comment or tweet @K162space.
The Sagain Lowsec system in the Tash-Murkon region is a major hub for jump capable ships as it allows you to reach Khanid, Querious, Stain, Catch, and the majority of Providence within one jump with Jump Drive Calibration V. Since Sagain is also a Lowsec station system that connects to contiguous Highsec, it is popular for Jump Freighter pilots as a midpoint connection into Highsec.
The system has two stations that can be used for cyno traffic. Sagain VIII – Moon 11 – TransStellar Shipping Storage is a Gallente station that has excellent cyno placement opportunities while the other station, Sagain V – Inherent Implants Biotech Production, is much more problematic due to its shape and how Eve handles object barriers.
All objects in the Eve universe have a sphere around them that dictates their physical barrier. With the Gallente station being flatter and in a curve shape with a large section missing, you undock within the sphere barrier and can dock immediately. As shown here you are well within the station’s edge sphere when undocking.
The design of the Amarr station pushes you out the bottom and right out of 0 docking range — hence the ‘kickout’ nickname for stations of this type.
Even with my speedy shuttle that issued a stop command after undocking, I was at 1,000 m on the station after the space environment rendered and ultimately ended up 3,300 m after reaching a full stop.
Be careful when choosing a station for cyno activity by keeping the geometry of the station in mind. You don’t want to end up like these careless Jump Freighter pilot that I can only assume used the wrong station and got bumped out of docking range after undocking.