GeoNotes Blog

Notes for myself and others

  • First ever LOL

     By John C. Zastrow

    Posted on June 18, 2012

    I’ve never used the acronym LOL in a message to anyone before. But I did LOL when I read this (and still am LOLing) and so I sent this link to a few selected colleagues. This won’t make sense to you unless you use ESRI products or are a GISer.... [Read More]

  • List my files

     By John C. Zastrow

    Posted on June 15, 2012

    About three times a year I need to make a listing of files in a directory. Usually this is because I need to do something to them and I need a checklist. Or I just need to tell someone what files are there. [Read More]

  • Recent Spatialite News May 2012

     By John C. Zastrow

    Posted on June 3, 2012

    The primary outlet for spatialite news and changes is the Google Groups Spatialite user mailing list. This is a low-barrier place to announce things. But it can be a little tough to use to understand the trajectory of the project. So, I might take some time every now and then... [Read More]

  • 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]