GeoNotes Blog

Notes for myself and others

  • Convert Android .3GP movies to .MP4 on windows

     By John C. Zastrow

    Posted on May 25, 2012

    Hardly any software works well with .3GP movie files. So, with this collection of movies accumulating in my phone sync folder I needed something to convert them into formats that are more useful (like video editing software or upload sites). So, here’s a little quick and dirty solution for batch... [Read More]

  • ArcPy and Email – Living together

     By John C. Zastrow

    Posted on May 23, 2012

    The other day I needed to process some data for the whole country and I wanted to get the data out by the next morning. The processing was comprised of two steps in Python and ESRI’s ArcPy for ArcGIS 10 and each needed to run for several hours. So, instead... [Read More]

  • exif from pictures for GIS

     By John C. Zastrow

    Posted on April 19, 2012

    I’m going to do a little Open Street Mapping of my area – focusing on the many parks and landtrust areas around. So I’ve been thinking about options to document locations and such. Of course I have a rockin HTC EVO 4G with on-board GPS. So, I’m thinking that in... [Read More]

  • FOSS4g North America not for me

     By John C. Zastrow

    Posted on February 16, 2012

    After missing the International FOSS4G in Denver (one of my former homes and a great excuse to visit land and friend alike) I’m now likely going to miss FOSS4G North America in the territory of my home office in the greater DC area. Argg, this totally bums me out. Somebody... [Read More]

  • Dropping columns in sqlite/spatialite

     By John C. Zastrow

    Posted on January 28, 2012

    SQLite doesn’t have a nice ALTER TABLE DROP COLUMN command and neither does spatialite. Instead, you get to run a long sequence of commands like this. Here I wanted to drop all the extra columns from my huc12 layer for the country. [Read More]