Difference between revisions of "StatPack"
| Line 3: | Line 3: | ||
There are currently three files in the [[StatPack]]: cachers.csv, caches.csv and logs.csv. | There are currently 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 please keep this in mind and try not to download it more than once a day. The [[StatPack]] is located [http://geocaching.com.au/stats/statpack here]. | At the time of writing, the cachers.csv file was about 15kb, caches file was about 800kb and the logs file was 6mb, so please keep this in mind and try not to download it more than once a day. The [[StatPack]] is located [http://geocaching.com.au/stats/statpack here]. | ||
| + | |||
| + | The cachers.csv file contains records for each member at geocaching.com.au that have registered a country and state in their profile. At the time of writing, this was not 100% of all members. | ||
| + | |||
| + | The caches.csv file contains records for each cache that exists in the geocaching.com.au database. | ||
| + | |||
| + | The logs.csv file contains records for each log that exists in the geocaching.com.au database. | ||
| + | |||
| + | Read more below for the file layout. | ||
==Applications== | ==Applications== | ||
| Line 8: | Line 16: | ||
* [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] | ||
| + | |||
| + | ==Cachers== | ||
| + | The cachers.csv file contains records for each member at geocaching.com.au that have registered a country and state in their profile. At the time of writing, this was not 100% of all members. | ||
| + | |||
| + | The format is 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 caches.csv file contains records for each cache that exists in the geocaching.com.au database. | ||
| + | |||
The format is as follows | The format is as follows | ||
* Hidden date in yy-mm-dd format | * Hidden date in yy-mm-dd format | ||
| Line 47: | Line 76: | ||
==Logs== | ==Logs== | ||
| + | The logs.csv file contains records for each log that exists in the geocaching.com.au database. | ||
| + | |||
* Log date in yy-mm-dd format | * Log date in yy-mm-dd format | ||
* Waypoint logged | * Waypoint logged | ||
Revision as of 19:01, 20 September 2005
The Geocaching Australia StatPack is designed to allow you to create your own statistics.
There are currently 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 please keep this in mind and try not to download it more than once a day. The StatPack is located here.
The cachers.csv file contains records for each member at geocaching.com.au that have registered a country and state in their profile. At the time of writing, this was not 100% of all members.
The caches.csv file contains records for each cache that exists in the geocaching.com.au database.
The logs.csv file contains records for each log that exists in the geocaching.com.au database.
Read more below for the file layout.
Contents
Applications
Applications that have been developed from the StatPack are:
Cachers
The cachers.csv file contains records for each member at geocaching.com.au that have registered a country and state in their profile. At the time of writing, this was not 100% of all members.
The format is 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 contains records for each cache that exists in the geocaching.com.au database.
The format is as follows
- Hidden date in yy-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 contains records for each log that exists in the geocaching.com.au database.
- Log date in yy-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
- I: Disabled
- L: Enabled
- N: Noted
- P: Photographed
- U: Unarchived
- V: Archived
- W: Will Attend
