GeoNotes Blog

Notes for myself and others

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