StatPack

From GeoWiki
Revision as of 19:08, 20 September 2005 by 60.230.133.40 (talk)
Jump to: navigation, search

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.

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