Settle Spots - using the data!
Printed From: Illyriad
Category: Miscellaneous
Forum Name: Technology & data
Forum Description: Discussions on data dumps, downloads, and third party applications.
URL: http://forum.illyriad.co.uk/forum_posts.asp?TID=5783
Printed Date: 19 Apr 2024 at 20:49
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com
Topic: Settle Spots - using the data!
Posted By: Albatross
Subject: Settle Spots - using the data!
Date Posted: 13 Aug 2014 at 14:32
|
Between the 'world map' and 'player towns', one can find the ideal settle spots with good sovereignty options. It takes a bit of number-crunching, and additional data, to eliminate occupied and uninhabitable sites, and weight the good ones. Here's a slightly unhelpful preview. http://johnvalentine.co.uk/i/Illy_201408_SettleTeaser.png" rel="nofollow">  -------------  |
Replies:
Posted By: Hora
Date Posted: 13 Aug 2014 at 15:23
Grrr... how cunning to blacken those coordinates  Great list! I'll put forward some silly ideas of mine, knowing quite well I won't have enough patience to make such a stunning list myself... You count in the number of neighbours heavily into your ranking (cutting the score in half for 1 neighbour?). I don't know which radius you took for determine those, but maybe you could make a even better score when calculating the actual radius for those 1 neighbour squares and taking this as an additional weighting factor? Might put forward some interesting spots with the neighbour sitting just at the edge of the circle  Oh, and are those neighbours distinguished along confed or not? Might work with taking the alliance ID and comparing with a manual list of confed...
|
Posted By: Albatross
Date Posted: 13 Aug 2014 at 15:31
|
Most of your guesses are correct, and your enhancements would be useful. Indeed, it's always possible add more useful refinements, and vary the criteria. This list was a 'quick win', using SQL that was mildly efficient. Sometimes, it's quicker to investigate the listed squares manually, than to code further refinements. ------------- |
Posted By: Brandmeister
Date Posted: 13 Aug 2014 at 16:20
| What db/SQL tool did you use? |
Posted By: Albatross
Date Posted: 13 Aug 2014 at 16:23
------------- |
Brandmeister wrote:Posted By: Digioso
Date Posted: 12 Feb 2015 at 15:15
|
Could you tell me where you get the Region name <=> Region ID match? Or did you do that on your own? ------------- http://www.digioso.org" rel="nofollow"> 
|
Posted By: Rill
Date Posted: 12 Feb 2015 at 19:53
| hmmm ... Area 51 looks intriguing. |
Posted By: Albatross
Date Posted: 23 Feb 2015 at 12:29
------------- |
Posted By: Digioso
Date Posted: 23 Feb 2015 at 13:25
|
Thanks Albatross. :) I created the table myself this weekend. :D And @Rill: Believe me: Area 51 is not intriguing one bit. :) There are other areas... Areas... without a name. Area 51 has a name: High Hills Other areas... like Area 60. They don't even have a name! Don't believe me? Check out the area name for location http://elgea.illyriad.co.uk/#/World/Map/638/-2702" rel="nofollow - -954|-2666 . There's more than 2k spots like this in the game btw. :) Well... I believe they're bugs and I already informed the devs about them. ------------- http://www.digioso.org" rel="nofollow">
|
Posted By: Fridericus
Date Posted: 31 May 2020 at 18:09
| How the hell did you do this? After a lot of digging I came up with a bunch of queries that calculate FoodSov, but the lookup takes forever due to the amount of rows. This is my first time using Access, so I may be doing something terribly inefficiently. |