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
American Community Survey
Data.gov geospatial data
Esri Open Data
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 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.
Every semester, I put together an updated look at web tools that data journalists can use. Here’s the latest version, now with Overview from the AP and Texas A&M’s geocoding service.
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.