Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 3 post(s) |
baldurk
The Terrifying League of Dog Fort Missed Connections
0
|
Posted - 2016.07.20 21:05:42 -
[1] - Quote
I've been working on an app to keep a database of the citadels ingame. It's not quite perfect or has everything complete that I want but I believe it's ready to share: CitadelDB
This app records citadels through killmails (thanks zkillboard!!). That is to say if the Citadel has killed something or has been destroyed itself, it will be in the database. I currently do not have a way to record citadels that are not part of a killmail. Additionally I do not have a way to distinguish two of the same citadel type anchored in the same system by the same corporation. With at least one entry we can be sure that there is at least one present.
The site is pretty basic right now, I do intend to add more styling and features to quickly get more overall information on citadels (total built/destroyed, how many per region, etc) but in the meantime it should serve as a decent list of citadels. I'd appreciate any feedback you may have for the app or the projects as web app development is something new for me. Are there features you'd like? Is this a helpful resource for you?
Github links: frontend backend |
|
CCP Tellus
C C P C C P Alliance
70
|
Posted - 2016.07.20 21:26:19 -
[2] - Quote
baldurk wrote:Additionally I do not have a way to distinguish two of the same citadel type anchored in the same system by the same corporation. Killmails have X, Y, and Z coordinates. Kills done by a particular Citadel should be in the general vicinity of each other. |
|
Salgare
Satan's Gut
3
|
Posted - 2016.07.20 21:30:23 -
[3] - Quote
cool beans! |
baldurk
The Terrifying League of Dog Fort Missed Connections
1
|
Posted - 2016.07.20 21:32:48 -
[4] - Quote
That was my thought originally but then realized that those are the co-ordinates of the ship that was destroyed, so they would all be different. I did not think of checking them by general vicinity though, I'll look into that. thanks! |
Salgare
Satan's Gut
3
|
Posted - 2016.07.20 21:49:13 -
[5] - Quote
CCP Tellus wrote:baldurk wrote:Additionally I do not have a way to distinguish two of the same citadel type anchored in the same system by the same corporation. Killmails have X, Y, and Z coordinates. Kills done by a particular Citadel should be in the general vicinity of each other.
It sure would be sweet to be able to get/set xyz bookmark information!
A call for the end of those nasty toilets in Pos'es! (toilets and BM's as in Bowel Movements) |
|
CCP Tellus
C C P C C P Alliance
70
|
Posted - 2016.07.20 21:59:09 -
[6] - Quote
Salgare wrote:It sure would be sweet to be able to get/set xyz bookmark information! The bookmarks endpoint in the XML API gives you the X, Y, and Z coordinates of all your bookmarks. |
|
Salgare
Satan's Gut
3
|
Posted - 2016.07.20 22:03:44 -
[7] - Quote
CCP Tellus wrote:Salgare wrote:It sure would be sweet to be able to get/set xyz bookmark information! The bookmarks endpoint in the XML API gives you the X, Y, and Z coordinates of all your bookmarks.
need a setter, corp level would be sweet |
Zifrian
Distortion. Amplified.
1741
|
Posted - 2016.07.20 22:10:42 -
[8] - Quote
Commendable effort but why can't we get this part of an API or CREST? For industry, I really have no option to get data.
GÇ£Any fool can criticize, condemn, and complain - and most fools do.GÇ¥ - Dale Carnegie
Industry guy, third-party developer, jack-of-all-trades - master of none
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Squizz Caphinator
Primary.
200
|
Posted - 2016.07.21 16:03:40 -
[9] - Quote
Nice use of zkillboard, great thinking!
FYI, killmails have coordinates on them, so you can use that to determine if there is more than 1 citadel per corp in a system if the killmails are say, more than 1000km apart or something like that.
Again, nice work
Various projects I enjoy putting my free time into:
http://zkillboard.com | http://evewho.com
|
baldurk
The Terrifying League Of Dog Fort Missed Connections
1
|
Posted - 2016.07.21 17:04:54 -
[10] - Quote
Squizz Caphinator wrote:Nice use of zkillboard, great thinking!
FYI, killmails have coordinates on them, so you can use that to determine if there is more than 1 citadel per corp in a system if the killmails are say, more than 1000km apart or something like that.
Again, nice work
Thanks. Yeah I'm looking into using the coordinates now. Is there more data on using them? Say, how could I tell if something is 1000km away through the x,y, and z? are those numbers directly reflective of km? |
|
Salgare
Satan's Gut
3
|
Posted - 2016.07.21 17:31:10 -
[11] - Quote
baldurk wrote:Squizz Caphinator wrote:Nice use of zkillboard, great thinking!
FYI, killmails have coordinates on them, so you can use that to determine if there is more than 1 citadel per corp in a system if the killmails are say, more than 1000km apart or something like that.
Again, nice work Thanks. Yeah I'm looking into using the coordinates now. Is there more data on using them? Say, how could I tell if something is 1000km away through the x,y, and z? are those numbers directly reflective of km?
matrix coordinate math .. ouch
I'd check out some 3-d graphics helper/utilities libraries |
|
CCP Tellus
C C P C C P Alliance
70
|
Posted - 2016.07.21 17:43:24 -
[12] - Quote
Salgare wrote:matrix coordinate math .. ouch You can compute the Euclidean distance:
import math
def distance((x1, y1, z1), (x2, y2, z2)): return math.sqrt((x1-x2)**2 + (y1-y2)**2 + (z1-z2)**2) This function will give you the distance between two coordinates. |
|
Salgare
Satan's Gut
3
|
Posted - 2016.07.21 18:10:21 -
[13] - Quote
CCP Tellus wrote:import math
def distance((x1, y1, z1), (x2, y2, z2)): return math.sqrt((x1-x2)**2 + (y1-y2)**2 + (z1-z2)**2) This function will give you the distance between two coordinates.
Capturing that, thank you!
|
baldurk
The Terrifying League Of Dog Fort Missed Connections
1
|
Posted - 2016.07.21 22:31:56 -
[14] - Quote
very cool! thank you. Is there a minimum distance you can place citadels in relation to other citadels? |
WhoBeI
Duty. Mighty Wings.
0
|
Posted - 2016.07.22 10:37:31 -
[15] - Quote
CCP Tellus wrote:Salgare wrote:matrix coordinate math .. ouch You can compute the Euclidean distance: import math
def distance((x1, y1, z1), (x2, y2, z2)): return math.sqrt((x1-x2)**2 + (y1-y2)**2 + (z1-z2)**2) This function will give you the distance between two coordinates.
Isn't it funny how many people forget about Pythagoras when they finish school
If you are recording all the killmails in a table you can do the check using sql instead and maybe gain some performance. Using something like the pseudo code below. (xo,yo,zo) would be the citadel coordinates, (xp,yp,zp) the kills and r the range (r=1000).
// Give me all kills within :r range of the point (:xo,:yo,:zo) select ... from ... where pow( :xo - xp, 2 ) + pow( :yo - yp, 2 ) + pow( :zo - zp, 2 ) < pow( :r, 2 )
Same thing works to do a 'all beer joints within 5km' in G maps provided you express radius, or range, in a lat/lng way. It's not perfect since, well, the earth ain't flat but works fine for small ranges. Nobody wants to go far for a beer anyways .
|
Squizz Caphinator
Primary.
201
|
Posted - 2016.07.22 11:55:14 -
[16] - Quote
WhoBeI wrote:Nobody wants to go far for a beer anyways
I haven't even had my first coffee yet and I'm already affected by wise words of the day
Various projects I enjoy putting my free time into:
https://zkillboard.com | https://evewho.com
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |