Difference between revisions of "StatPack"
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{GCA}} | {{GCA}} | ||
| − | The Geocaching Australia [[StatPack]] | + | 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 | + | 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 | + | 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 | + | 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 | + | 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 | + | 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 | + | * 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 | + | * The caches.csv file contained records for each cache that existed in the geocaching.com.au database. |
| − | * The logs.csv file | + | * The logs.csv file contained records for each log that existed in the geocaching.com.au database. |
Read more below for the file layout. | Read more below for the file layout. | ||
| Line 21: | Line 21: | ||
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] | An Explanation and the Useage of the graphs can be found [http://www.caughtatwork.net/geocaching/graphs/explain.php here] | ||
==Cachers== | ==Cachers== | ||
| − | The cachers.csv file | + | 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 | + | The format was as follows |
* Cacher name | * Cacher name | ||
* State | * State | ||
| Line 44: | Line 44: | ||
==Caches== | ==Caches== | ||
| − | The caches.csv file | + | The caches.csv file contained records for each cache that existed in the geocaching.com.au database. |
| − | The format | + | The format was as follows |
* Hidden date in YYYY-MM-DD format | * Hidden date in YYYY-MM-DD format | ||
* Waypoint | * Waypoint | ||
| Line 83: | Line 83: | ||
==Logs== | ==Logs== | ||
| − | The logs.csv file | + | The logs.csv file contained records for each log that existed in the geocaching.com.au database. |
* Log date in YYYY-MM-DD format | * Log date in YYYY-MM-DD format | ||
| Line 101: | 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
