GPS to PostGIS data import pipeline

I have found an interesting OpenSource based system that should allow you to import GPS track/route/waypoint information from your GPS into the OpenSource spatial database PostGIS. Here are the steps and tools:

  1. Convert your GPS data to the GPX format using GPSBabel
  2. Use the GPX2SHP program to create a SHP (ESRI Shape File)
  3. Import the SHP file into PostGIS using shp2pgsql

With your GPS data in PostGIS, you should be able to do all sorts of cool things.

For PostGIS data import, the following tools are interesting:

3D mouse

If anyone wants to purchase me a “Geek Tool”, you could buy me one of these cool a 3D mice.

This mouse is integrated with Google Earth, and allows you to seamlessly pan and zoom around the world. Check out this video demonstration of the output:

Tech Support in the Middle Ages

ltteer oredr

Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn’t mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae.

Cuba


We just returned from an awesome week-long vacation to Cuba with Krista and Chris. Life was a beach, and reality was far-far away (making a great vacation).

Photos are online here!

WordPress Themes