Extract Excel Attributes to CSV – Python

Posted by in Data, Design, GIS
Extract Excel Attributes to CSV – Python

This is a python solution to pull specific cells from a bunch of excel files into one CSV file. The excel files have a consistent format – that is, a given cell in every excel file contains the same information. Ultimately, I needed one table with all project information that I could geocode and work […]

Arrow Cartographics – Mountain Contour Woodcuts

Posted by in Data, Design
Arrow Cartographics – Mountain Contour Woodcuts

I create these desktop sculptures by picking a peak, then downloading NED elevation data and processing it into templates that I cut out of solid 1/4″ wood on my scroll saw. Then I assemble the 8 layers into these miniature sculptures. The size varies but generally they measure around 7″x8″ and about 2″ tall. I […]

Scale, color balance, and seam-blend trench photo-mosaic

Posted by in ArcMap, Data, GIS
Scale, color balance, and seam-blend trench photo-mosaic

This workflow describes the process to export geologic exploration trench log photo-mosaics at scale, then color balance across the segments, and blend seams. This is a followup to the post on rectifying a trench wall photomosaic. This process assumes that all parts of the total trench photo-mosaic have been rectified to a measured grid. This […]

Rectifying a trench wall photo-mosaic to a measured grid

Posted by in ArcMap, Data, GIS
Rectifying a trench wall photo-mosaic to a measured grid

One of the more behemoth tasks I tackle at my current position is digitizing geologic trench logs. The first step in creating the log is to create the background image of the trench wall. This starts with the geologists in the field taking a series of overlapping photos covering the wall of the trench. These […]

Zip all shapefiles in directory individually

Posted by in ArcMap, Data, GIS
Zip all shapefiles in directory individually

This script zips individual shapefiles within a defined directory. The zipfiles are named identical to the shapefile itself. This is useful for platforms like CartoDB and MapBox, especially if you are in an Esri workflow. If you are usging a geodatabase, it can be converted to shapefiles, then those shapefiles can be passed through this […]