Archive for August, 2013

A nice explainer for PostgreSQL’s EXPLAIN output

This site does  a great job of analyzing the output of PostgreSQL EXPLAIN queries.  It will show you which steps of a query are slowing you down giving you the chance to rewrite your query, change indexing, or reorganize tables in order to speed things up.  It’s very helpful!

Improved Polygon Capture plugin makes QGIS Digitizing easier

A new plugin showed up in the QGIS 2.0 repository recently, Improved Polygon Capture allows you to specify a line segment’s length and/or angle as you digitize a polygon.  The plugin is easy to use, when you start an edit session with a polygon layer it puts a dialog box below your table of contents window.  It has two fields, one for angle and another for distance with a checkbox for each.  When you enter a value and check the box that value is locked in and the line segment you create will match those values.  The length field’s units will be in your project’s projection’s units.

Awesome QGIS Tutorial

Here’s a great QGIS Tutorial put together by Frank Donnelly at City University of New York.  It covers QGIS 1.8, and not only teaches the software but teaches basic GIS concepts as well.  It is a great way to introduce someone to the world of GIS.

Thank you Garmin!

I bought a brand new Edge 500 off of eBay last May.  It has been great, except the lap / reset button has been getting progressively harder and harder to press.  I’d press it and it wouldn’t register which sucked because in order to record a ride so that its data can be exported you have to press and hold the button for 3 seconds.  It finally got to the point where I was unable to record my last ride last week.

I was prepared to pay $89 in order to RMA my device because even if I wasn’t a few months past the end of the warranty period, since I bought it off eBay the warranty was never valid.  I called the RMA line and explained my problem.  The operator was nice enough to extend the warranty to me!  All I had to do was mail in my broken Edge and they sent me a refurbished model that is as good as a new unit.  Thanks Garmin!