Difference between revisions of "StatPack"
Line 4: | Line 4: | ||
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]. | ||
− | + | All of the records in the file are double-quote encapsulated with the exception of the header record. Some special characters such as double quotes and single quotes are escaped with the UNIX \ character. | |
− | + | There is a header record contained in the file which describes the field names. This header record in not double-quote encapsulated. | |
− | |||
− | The logs.csv file contains records for each log that exists in the geocaching.com.au database. | + | * 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. | Read more below for the file layout. | ||
Line 40: | Line 41: | ||
The format is as follows | The format is as follows | ||
− | * Hidden date in | + | * Hidden date in YYYY-MM-DD format |
* Waypoint | * Waypoint | ||
* Cache name | * Cache name | ||
Line 78: | Line 79: | ||
The logs.csv file contains records for each log 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. | ||
− | * Log date in | + | * Log date in YYYY-MM-DD format |
* Waypoint logged | * Waypoint logged | ||
* Cacher who made the log | * Cacher who made the log |
Revision as of 20:08, 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.
All of the records in the file are double-quote encapsulated with the exception of the header record. Some special characters such as double quotes and single quotes are escaped with the UNIX \ character. There is a header record contained in the file which describes the field names. This header record in not double-quote encapsulated.
- 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 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 contains records for each log that exists 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
- I: Disabled
- L: Enabled
- N: Noted
- P: Photographed
- U: Unarchived
- V: Archived
- W: Will Attend