Jeff Pries

Business Intelligence, SQL Server, and other assorted IT miscellany

Month: February 2014

Digging Out of the Snowstorm (Again)

Digging Out of the Snowstorm (Again)

Living in Georgia, snow is a pretty rare thing.  Even rarer is snow that actually sticks to the ground for more than one day.  Twice now within the last month, we’ve had major snow and/or ice events and even been the subject of some pretty funny news coverage.

We’ve had comparisons to the Walking Dead:

Source:  http://i.imgur.com/TMCSBfo.jpg

Due to people literally abandoning their cars on the roads and interstate due to them being impassable:

Source:  http://imgur.com/a/uREXR

Continue reading

Geocaching Analytics – Part 3: GCInsight Data Preparation

Geocaching Analytics – Part 3: GCInsight Data Preparation

At this point, we’ve gotten our data downloaded from the Geocaching.com website and we’re sitting on a local treasure trove of data…but the data is contained within a proprietary program (GSAK) which limits our ability to make use of the data.  So, it’s time to work on extracting the data and getting it into a usable format.

The GSAK application will be our primary data source for acquiring Geocaching data as well as future updates to the data.  That being said, the data is not particularly easy to work with in its GSAK format.  Fortunately, GSAK stores its geocache data in a SQLite database, which is a compact database which runs as an application on command rather than a service.

In order to fully utilize the data, we’ll be building a process to export the GSAK data from SQLite into a SQL Server database.  Once the data is exported to SQL Server, we can perform any number of transformations and summarizations.

Continue reading

© 2017 Jeff Pries

Theme by Anders NorenUp ↑