Settle Spots - using the data! |
Post Reply |
Author | |
Albatross
Postmaster General Joined: 11 May 2011 Status: Offline Points: 1118 |
Post Options
Thanks(0)
Posted: 13 Aug 2014 at 14:32 |
|
|
Hora
Postmaster Joined: 10 May 2010 Status: Offline Points: 839 |
Post Options
Thanks(0)
|
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...
|
|
Albatross
Postmaster General Joined: 11 May 2011 Status: Offline Points: 1118 |
Post Options
Thanks(0)
|
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. |
|
|
|
Brandmeister
Postmaster General Joined: 12 Oct 2012 Location: Laoshin Status: Offline Points: 2396 |
Post Options
Thanks(0)
|
What db/SQL tool did you use?
|
|
Albatross
Postmaster General Joined: 11 May 2011 Status: Offline Points: 1118 |
Post Options
Thanks(0)
|
|
|
|
|
Digioso
Forum Warrior Joined: 09 Feb 2015 Location: Germany Status: Offline Points: 312 |
Post Options
Thanks(0)
|
Could you tell me where you get the Region name <=> Region ID match? Or did you do that on your own?
|
|
Rill
Postmaster General Player Council - Geographer Joined: 17 Jun 2011 Location: California Status: Offline Points: 7078 |
Post Options
Thanks(0)
|
hmmm ... Area 51 looks intriguing.
|
|
Albatross
Postmaster General Joined: 11 May 2011 Status: Offline Points: 1118 |
Post Options
Thanks(0)
|
|
|
|
|
Digioso
Forum Warrior Joined: 09 Feb 2015 Location: Germany Status: Offline Points: 312 |
Post Options
Thanks(0)
|
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 -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. |
|
Fridericus
New Poster Joined: 31 May 2020 Status: Offline Points: 3 |
Post Options
Thanks(0)
|
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.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |