Difference between revisions of "StatPack"
(7 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{GCA}} | |
− | There | + | The [[Geocaching Australia]] [[StatPack]] was designed to allow you to create your own [[statistics]], but has since been decommissioned. Only empty versions of the files remain. |
− | At the time of writing, the cachers.csv file was about 15kb, caches file was about 800kb and the logs file was 6mb, so | + | |
+ | There were three files in the [[StatPack]]: cachers.csv, caches.csv and logs.csv. | ||
+ | At the time of writing, the cachers.csv file was about 15kb, caches file was about 800kb and the logs file was 6mb, so you needed to keep this in mind and try not to download it more than once a day. The remnants of [[StatPack]] is located [http://geocaching.com.au/stats/statpack here]. | ||
+ | |||
+ | All of the records in the file were double-quote encapsulated with the exception of the header record. Some special characters such as double quotes and single quotes were escaped with the UNIX \ character. | ||
+ | |||
+ | There was a header record contained in the file which described the field names. This header record was not double-quote encapsulated. | ||
+ | |||
+ | Some cache and cacher names such as ¢ha®lie ÃÂelta had special characters. In a MySQL or postgres database these would not have cause problems. In a Microsoft Access database you may have found that these records did not get imported. Keep in mind that cache and cacher names could have contained double-quotes, single-quotes, ampersands and commas as well as others which may have caused formatting or import issues as well. | ||
+ | |||
+ | * The cachers.csv file contained records for each member at geocaching.com.au that had registered a country and state in their profile. At the time of writing, this was not 100% of all members. | ||
+ | * The caches.csv file contained records for each cache that existed in the geocaching.com.au database. | ||
+ | * The logs.csv file contained records for each log that existed in the geocaching.com.au database. | ||
+ | |||
+ | Read more below for the file layout. | ||
==Applications== | ==Applications== | ||
Applications that have been developed from the StatPack are: | Applications that have been developed from the StatPack are: | ||
− | * [http://www.caughtatwork.net/geocaching/graphs/index.php Caught at Work's Geocaching Graphs] | + | * [http://www.caughtatwork.net/geocaching/graphs/index.php Caught at Work's Geocaching Graphs]. This application is no longer available. |
+ | An Explanation and the Useage of the graphs can be found [http://www.caughtatwork.net/geocaching/graphs/explain.php here] | ||
+ | |||
+ | ==Cachers== | ||
+ | The cachers.csv file contained records for each member at geocaching.com.au that had registered a country and state in their profile. At the time of writing, this was not 100% of all members. | ||
+ | |||
+ | The format was as follows | ||
+ | * Cacher name | ||
+ | * State | ||
+ | ** ACT: Australian Capital Territory | ||
+ | ** NSW: New South Wales | ||
+ | ** NT: Northern Territory | ||
+ | ** QLD: Queensland | ||
+ | ** SA: South Australia | ||
+ | ** TAS: Tasmania | ||
+ | ** VIC: Victoria | ||
+ | ** WA: Western Australia | ||
+ | ** NI: North Island (New Zealand) | ||
+ | ** SI: South Island (New Zealand) | ||
+ | * Number of geocaching.com.au caches Hidden | ||
+ | * Number of geocaching.com.au caches Found | ||
==Caches== | ==Caches== | ||
− | The format | + | The caches.csv file contained records for each cache that existed in the geocaching.com.au database. |
− | * Hidden date in | + | |
+ | The format was as follows | ||
+ | * Hidden date in YYYY-MM-DD format | ||
* Waypoint | * Waypoint | ||
* Cache name | * Cache name | ||
Line 47: | Line 83: | ||
==Logs== | ==Logs== | ||
− | * Log date in | + | The logs.csv file contained records for each log that existed in the geocaching.com.au database. |
+ | |||
+ | * Log date in YYYY-MM-DD format | ||
* Waypoint logged | * Waypoint logged | ||
* Cacher who made the log | * Cacher who made the log | ||
Line 55: | Line 93: | ||
** D: Didn't Find it | ** D: Didn't Find it | ||
** E: Needs Archiving | ** E: Needs Archiving | ||
+ | ** F: Found it | ||
** I: Disabled | ** I: Disabled | ||
** L: Enabled | ** L: Enabled | ||
Line 62: | Line 101: | ||
** V: Archived | ** V: Archived | ||
** W: Will Attend | ** W: Will Attend | ||
+ | |||
+ | |||
+ | == See Also == | ||
+ | * [[Statistics]] |
Latest revision as of 12:30, 15 July 2016
This page contains information specific to Geocaching Australia. |
The Geocaching Australia StatPack was designed to allow you to create your own statistics, but has since been decommissioned. Only empty versions of the files remain.
There were three files in the StatPack: cachers.csv, caches.csv and logs.csv. At the time of writing, the cachers.csv file was about 15kb, caches file was about 800kb and the logs file was 6mb, so you needed to keep this in mind and try not to download it more than once a day. The remnants of StatPack is located here.
All of the records in the file were double-quote encapsulated with the exception of the header record. Some special characters such as double quotes and single quotes were escaped with the UNIX \ character.
There was a header record contained in the file which described the field names. This header record was not double-quote encapsulated.
Some cache and cacher names such as ¢ha®lie ÃÂelta had special characters. In a MySQL or postgres database these would not have cause problems. In a Microsoft Access database you may have found that these records did not get imported. Keep in mind that cache and cacher names could have contained double-quotes, single-quotes, ampersands and commas as well as others which may have caused formatting or import issues as well.
- The cachers.csv file contained records for each member at geocaching.com.au that had registered a country and state in their profile. At the time of writing, this was not 100% of all members.
- The caches.csv file contained records for each cache that existed in the geocaching.com.au database.
- The logs.csv file contained records for each log that existed in the geocaching.com.au database.
Read more below for the file layout.
Contents
Applications
Applications that have been developed from the StatPack are:
- Caught at Work's Geocaching Graphs. This application is no longer available.
An Explanation and the Useage of the graphs can be found here
Cachers
The cachers.csv file contained records for each member at geocaching.com.au that had registered a country and state in their profile. At the time of writing, this was not 100% of all members.
The format was as follows
- Cacher name
- State
- ACT: Australian Capital Territory
- NSW: New South Wales
- NT: Northern Territory
- QLD: Queensland
- SA: South Australia
- TAS: Tasmania
- VIC: Victoria
- WA: Western Australia
- NI: North Island (New Zealand)
- SI: South Island (New Zealand)
- Number of geocaching.com.au caches Hidden
- Number of geocaching.com.au caches Found
Caches
The caches.csv file contained records for each cache that existed in the geocaching.com.au database.
The format was as follows
- Hidden date in YYYY-MM-DD format
- Waypoint
- Cache name
- Cache owner
- Terrain
- Difficulty
- Cache Type
- B: Moveable
- C: CITO
- E: Event
- L: Locationless
- M: Multi-cache
- O: Other
- R: Earthcache
- T: Traditional
- U: Unknown
- V: Virtual
- W: Webcam
- X: Letterbox
- Cache Container
- V: Virtual
- M: Micro
- S: Small
- R: Regular
- L: Large
- O: Other
- U: Unknown
- Status
- A: Available
- U: Unavailable
- V: Archived
- Recommended (number of people recommending the cache)
- Planning
- Watching
Logs
The logs.csv file contained records for each log that existed in the geocaching.com.au database.
- Log date in YYYY-MM-DD format
- Waypoint logged
- Cacher who made the log
- Log type, consisting of:
- A: Attended
- B: Published
- D: Didn't Find it
- E: Needs Archiving
- F: Found it
- I: Disabled
- L: Enabled
- N: Noted
- P: Photographed
- U: Unarchived
- V: Archived
- W: Will Attend