Most caches in a given town Version 2
This is a continuation of the thread Most caches in a given town in which I failed miserably at producing accurate results. In this newest attempt, we are using data which is much more accurate - much of this is because it utilizes shape files of the borders of all Maine towns. Still, caches very near the borders of towns may be incorrectly listed. Then again, the cache may not be in the town you think it is after all. :)
At my current count, there are active caches in 596 Maine civil divisions, there have been caches placed in 643 civil divisions, out of a total of 916 in the state.
So anyway, here are some preliminary numbers showing the civil divisions with more than 50 active caches. The order of areas with the total number of placed caches is very similar.
Portland ----- 195
Lewiston ----- 133
Bangor ----- 115
Augusta ----- 110
Falmouth ----- 108
Kennebunk ----- 101
Freeport ----- 73
Cumberland ----- 70
Biddeford ----- 64
Yarmouth ----- 64
Moscow ----- 63
Auburn ----- 60
Saco ----- 60
Scarborough ----- 59
South Portland ----- 59
Westbrook ----- 56
Washington ----- 55
China ----- 54
Kennebunkport ----- 54
Brunswick ----- 52
Gorham ----- 52
Lyman ----- 51
Standish ----- 50
I still need to verify some of my data and make an easy to use macro for anyone wishing to list the towns in GSAK. Fins_Up is doing some tedious data entry which hopefully will allow us to add a Maine towns map to the FindStats Macro.
Macro for anyone wanting to test...
Attached is a macro which will primarily populate one of the user data fields in GSAK with the town name and also produce 3 interactive stats based on Maine towns.
All the town data is included with the macro in an embedded zip file, which will (hopefully) be automatically be unzipped into the proper GSAK folder the first time you run the macro.
If you run other macros that populate any of the User Data columns, Make sure you elect a column for the town data that will not interfere as the data for the selected column will be deleted. If you are unsure what columns you might be using select View - Add/Delete Columns from the GSAK menu and check the User Data, User data 2, User data 3, and User data 4 checkboxes. If you wish to keep these columns or the column you save the towns in, you can do so by choosing View - Save current view... from the GSAK menu.
You will need to update the database(s) you wish to list Maine towns when you add caches. Choosing to update only the empty records will speed the update a bit, but if you have non-town data in the column you will want to deselect that option to overwrite the old data.
The stats section of the macro will output D/T, Container(Size), or Cache Type stats, in other words how many of each is in each town. The macro will respect your current GSAK filter, so for example if you want to run towns stats on a particular hider(s), filter GSAK to list only caches hidden by that hider and then run the macro. The image below shows such a list of Ekidokai's hides. If you are running the stats on an unfiltered, large database, such as all Maine caches, you will probably want to limit the stats to towns that have over 25 number of caches, or some number that fits your need.
EDIT: I'll post the macro shortly, I didn't forget! ;-)
EDIT2: macro file is down at the bottom of the post now!
EDIT 3: Macro has been removed and moved to the GSAK web site: http://gsak.net/board/index.php?showtopic=19842