Map resources

 

Resources for GIS maps and Census data

 

GIS desktop mapping software

Esri – ArcGIS for Desktop

http://www.esri.com/software/arcgis/arcgis-for-desktop

 

QGIS – free and open source

http://qgis.org/en/site/

 

QGIS plugins repository

https://plugins.qgis.org/plugins/

 

Base maps and data

U.S. Census geography

https://www.census.gov/geo/maps-data/data/tiger.html

 

U.S. Census TIGER shapefiles

https://www.census.gov/geo/maps-data/data/tiger-line.html

 

IRE 2010 U.S. Census data

http://census.ire.org/

 

Census Reporter

https://censusreporter.org/

 

American Community Survey

http://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml

 

Data.gov geospatial data

http://catalog.data.gov/dataset?metadata_type=geospatial

 

Esri Open Data

http://opendata.arcgis.com/

 

ArcGIS Online

https://www.arcgis.com/home/index.html

 

National Historical GIS (1700-2014)

https://www.nhgis.org/

 

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

http://sedac.ciesin.columbia.edu/

 

State GIS data links from University of Arkansas

http://libinfo.uark.edu/gis/us.asp

 

The National Map

http://nationalmap.gov/

 

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

 

National States Geographic Information Council

https://www.nsgic.org/

 

Esri User Groups

http://www.esri.com/events/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.

Initializing...

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.

Initializing...

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.