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.
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.
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.
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.