A geospatial career journey
It's amazing what you can find when you plug in an old external hard drive. I recently rearranged my desk and realized that one of the external drives on top of my desktop Linux machine had apparently been unplugged for a while. I plugged it in to see what it held, and there were a … Continue reading A Geospatial Time Capsule
For the past two years, have been working with a fiber-to-the-home (FTTH) provider supporting various data architecture and geospatial activities. This is a classic infrastructure business that cycles through phases of design, construction, and maintenance as the built environment changes. This leads to a lot classic GIS editing over time - which can mean the … Continue reading GeoParquet Backup and Restore
I recently had a project requirement to export the contents of a delta table in Databricks to several formats, including shapefile and file geodatabase, with the output being placed in object storage mounted to DBFS. I set up the logic in a notebook, with the intent to use geopandas, which provides an easy wrapper around … Continue reading Exporting Data with GeoPandas in Databricks
As a consultant, I have always placed a premium on the maturity of the technologies I recommend and deploy for my customers. While staying current with innovations, especially in the geospatial space, is a critical part of my work, I believe in letting new technologies develop and stabilize before introducing them into customer workflows. This … Continue reading Cloud, Ready
I've recently spent a lot of time doing various forms of business analytics in BigQuery. As discussed in a previous post, I've been using BigQuery as the data integration environment for several business systems. I've found integration at the data level via an ETL/ELT/IPaaS pipeline to be a lot more stable than system-level integrations that … Continue reading Analyzing Location Change Over Time in BigQuery
