Blog

2020

From the Ashes of Shapefiles

A Presentation for the 2020 Virtual Ohio GIS Conference

Posted

From the Ashes of Shapefiles

This talk describes the slow and painful migration from a legacy GIS data structure of hundreds of shapefiles to a modern setup using a mix of Postgres, QGIS and ArcPro. Many small organizations and municipalities face this issue and it is one that is sure to resonate even with those supporting a large enterprise GIS. From shapefiles to File Geodatabases to SQL Server Express and beyond, I detail my quest including lessons learned, achievements made, issues encountered along the way, and what we have planned for the future.

Continue Reading...

GIS and Remote Work

An Exploration of a GIS Remote Work Toolkit

Posted

GIS and Remote Work

In the aftermath of the Coronavirus pandemic, remote work may well be come the new normal, as businesses and government agencies discover that productivity can be maintained or even increased when implementing remote work options. And the tools to implement this transition at the employee level are neither complicated or expensive. In my case, even without a high-end laptop, a VPN connection, a remotely accessible central database, or even a cloud-based file sync service, remote GIS work was a painless transition from the traditional office setting.

Continue Reading...

Exporting AGOL Feature Services to GeoJSON

Using NodeJS and Batches to Transform an ArcGIS Online Feature Service to GeoJSON

Posted

Exporting AGOL Feature Services to GeoJSON

Recently I had the need to pull data from ArcGIS Online into a Mapbox GL JS web map. While it would be possible to use the WMS publishing feature in AGOL to display this layer, what would be ideal is to have access to the raw data. The data also needs updated on a regular basis, so manually downloading a copy from AGOL is not an option.

Continue Reading...

Ohio COVID-19 Dashboard

A Simple, Client Side Tracking Dashboard for COVID-19 in Ohio

Posted | Updated

Ohio COVID-19 Dashboard

Update: This visualization is no longer being updated. There are a wide variety of authoritative COVID-19 trackers on the internet, including ones from Bing, Google, National Geographic, the New York Times, asl well as the sites liseted at the bottom of this post. Please refer to these for the latest updates. What follows below is my take on a COVID-19 tracker using open source tools.

Continue Reading...