Archive for March, 2013

Resetting the Edge 500’s battery meter

If your Edge 500’s battery meter gets stuck at 100% just disable the auto shutoff feature and let the battery drain. The next time you charge it up the battery meter will reflect the actual amount of charge you have remaining.

Rotating a QuickTime movie

I was handed a QuickTime movie that was recorded with an iPad that was held upside down.  Luckily ffmpeg makes this easy.

ffmpeg -i <input_file> -strict -2 \
-vf "transpose=1, transpose=1" <output_file>

The -strict -2 allows ffmpeg to use the experimental aac codec, and -vf “transpose=1, transpose=1” rotates the video by 90 degrees twice.

Installing Postgis 2.1.0SVN on Arch

I wanted to try the new Tiger geocoder extension that’s coming with PostGIS 2.1.0.  I set up a PKGBUILD to upgrade the 2.0.2 that’s in Arch’s repository.

Since this is a major version upgrade a hard upgrade is required.  The upgrade went smoothly except the spatial_ref_sys table wasn’t populated.  Running the spatial_ref_sys.sql script found at /usr/share/postgresql/contrib/postgis-2.1 solved that problem.

Changes to building QGIS 1.9 on Arch

Recently Arch added QT5 to their repositories and renamed the old QT package to QT4.  This causes a little confusion for the qgis-git PKGBUILD since it lists the old qt package as a dependency.  It’s an easy fix, just change qt to qt4 and add


to the ./configure options.

Once 1.9 is compiled and built you can see how far along this beta version has come.  The new loader built into the DB Manager plugin works flawlessly.  This is my favorite new feature in 1.9 / 2.0.  It makes it so if you can add a dataset to a QGIS map, it only takes a few clicks to import that data into a new PostGIS layer.  It really comes in handy with layers created by ad-hoc queries.

Plugin developers have been hard at work adjusting their plugins to work with the new API.  OpenLayers has been updated, just upgrade through the Fetch Python Plugins menu and you can once again display your Google, Bing, etc maps in QGIS.