Map resources


Resources for GIS maps and Census data


GIS desktop mapping software

Esri – ArcGIS for Desktop


QGIS – free and open source


QGIS plugins repository


Base maps and data

U.S. Census geography


U.S. Census TIGER shapefiles


IRE 2010 U.S. Census data


Census Reporter


American Community Survey geospatial data


Esri Open Data


ArcGIS Online


National Historical GIS (1700-2014)


Center for International Earth Science Information Network Archive of Census related GIS products and other resources


State GIS data links from University of Arkansas


The National Map


Meeting other mapping experts (a.k.a nerd bonding)


National States Geographic Information Council


Esri User Groups







SQLite client alternatives

SQLite Manager add-on for Firefox browsers has its quirks and shortcomings as a front-end program for SQLite databases. So I asked my students to find alternatives and write short first looks at those programs. They found:

  • RazorSQL, a commercial program for Macs, Windows and Linux machines
  • SQLPro, a commercial program for Macs
  • SQLiteStudio, a free and open source program for Macs, Windows and Linux machines
  • Navicat for SQLite, a commercial program for Macs and Windows machines
  • MesaSQLite, a commercial program for Macs

In the coming days, I’ll post their reviews here.

Tableau Desktop for journalism instructors

Tableau Desktop is a great tool for creating and sharing interactive data visualizations. It’s simple enough that you can teach students who have just a little experience working with spreadsheet or other data files how to get started in just one lesson.

Journalists have been using Tableau Desktop to help tell stories with data for a few years. The Seattle Times was one of the first to use it extensively. In 2011, the newspaper reported howpoor patients on the state’s Medicaid program had died as doctors prescribed more methadone, an inexpensive and unpredictable painkiller. To help tell the story, the Times’ data journalists created this Tableau visualization.


In this more recent example, the Austin American-Statesman used Tableau to let its audience explore teacher turnover rates at local public schools. The interactive accompanied a story about how some Austin schools continued to struggle with high turnover rates, even as the district offered incentives to entice teachers to stay.


At its heart, Tableau is business-intelligence software that’s used by corporate customers to make decisions. But don’t let that or its $2,000 price tag scare you. With a raft of training videos available online,  Tableau makes it easy to dive in and learn anything from the basics to more advanced tricks. And, under its Tableau for Teaching program, the company offers free desktop licenses to instructors and students. Members of Investigative Reporters and Editors also qualify for free licenses.