Difference between revisions of "StatPack"

From GeoWiki
Jump to: navigation, search
 
 
(16 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
The Geocaching Australia StatPack is designed to allow you to create your own statistics. 
+
{{GCA}}
  
−
There are currently two files in the StatPack: caches.csv and logs.csv.
+
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 caches file was about 400kb and the logs file was 4mb, so please keep this in mind and try not to download it more than once a day.
+
 
 +
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 that have been developed from the StatPack are:
 +
 
 +
* [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 is as follows
+
The caches.csv file contained records for each cache that existed in the geocaching.com.au database.
−
* Hidden date in yy-mm-dd format
+
 
 +
The format was as follows
 +
* Hidden date in YYYY-MM-DD format
 
* Waypoint
 
* Waypoint
 
* Cache name
 
* Cache name
 
* Cache owner
 
* 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==
 
==Logs==
−
* Log date in yy-mm-dd format
+
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 20: 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 27: Line 101:
 
** V: Archived
 
** V: Archived
 
** W: Will Attend
 
** W: Will Attend
 +
 +
 +
== See Also ==
 +
* [[Statistics]]

Latest revision as of 12:30, 15 July 2016

Geocaching Australia
 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.

Applications

Applications that have been developed from the StatPack are:

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


See Also

Retrieved from ‘http://wiki.geocaching.com.au/index.php?title=StatPack&oldid=6700’