GeoNotes Blog

Notes for myself and others

  • Spatialite and Triggers to Update Data

     By John C. Zastrow

    Posted on October 19, 2012

    I finally decided to do a little demo here of a common feature I need on a lot of projects. We often have systems that maintain point locations of things (create, update, delete, view them) and having attributes of spatial relationship automatically applied to them is often quite handy. For... [Read More]

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