Sunlight Foundation

U.S. PIRG's State Spending Transparency Scorecard

A map of the transparency grades from the US PIRG's Following the Money 2011 study.Last week the U.S. Public Interest Research Group published a transparency scorecard for every state in the country that assessed their ability to publish their spending online. The scorecard map operates on the belief that there is a new standard for accountability and accessibility, one where spending records are searchable and detailed online.

The 'Following the Money 2011' study [pdf link] classified nine states as "leading states" that published detailed information on grants and economic activities of the government online, even publicizing tax expenditures. Most fell into the "emerging states" category where basic steps were taken to supply residents with less granular information or did not make the data searchable. Finally, the "lagging states" section highlighted the ten least transparent states who did not populate their websites with relevant spending information and Maine doesn't even allow public access to their data. The study notes that there is no partisan leaning between states that excel or fail to provide citizens with this data.

As the press clamors to champion or chide their governments, we hope the states continue to study up on this subject and improve their standings next year. It also couldn't hurt to move the goals posts a little farther too - putting your checkbooks online is a pretty obvious homework assignment for this year kids.

Be sure to look up how your state ranks on the Following the Money map and encourage them to continue the work.

Services, Resources and Tools for Mapping Data

Services, Resources and Tools for Mapping DataLong ago, putting together a map of data points would be the sole domain of a skilled GIS practitioner employing an application like ArcView. These days, particularly with the advent of Google Maps, Yahoo Maps and OpenStreetMap, et al., there are a multitude of options for an individual to employ in displaying data geographically. Of course, there are, and will always be, technical options that require some level of programming chops. Fortunately, the pool of drop dead easy implementations that anyone can throw together with ease has grown a lot over the last few years. Then, there is the growing middle ground, lying somewhere between easy but rigid and difficult but flexible. Personally, I tend to hover in this netherworld, leveraging existing code, services or tutorials when possible but occasionally finding myself diving into the more technical areas when necessary and learning a lot in the process.

For those of you out there who might be interested in mapping data, I've put together a collection of links to a variety of services, code samples, resources and tutorials I've found useful in the past. These links range from new services that barely require anything more than a spreadsheet to complicated frameworks that require a great deal of technical knowledge. This is by no means all encompassing and if you happen to have additional links you'd like to share, feel free to leave them in the comments. Services

  • Spatial Key "SpatialKey gives decision makers quick, easy, and cost-effective access to location intelligence so they can better achieve their objectives."
  • Many Eyes Many Eyes displays data associated with geographic regions using either colors or bubbles.
  • Maker "Anyone can build complex, data-rich maps."
  • Tableau "With Tableau Public you can create interactive graphs, dashboards, maps and tables from virtually any data and embed them on your website or blog in minutes."
  • Mapspread "Import your data, geocode it, share it with coworkers and friends, create thematic maps, create interactive applications."
  • Zeemaps Custom maps from lists.

<img src="http://assets.sunlightfoundation.com/images/blog/posts/mapping_coding.jpg" alt="Some Coding Required" class="aligncenter">
<ul id="nobullets">
<li><a href="http://cartographer.visualmotive.com/">Cartographer.js</a> (javascript)

A great javascript library that lets you create thematic maps by leveraging Google Maps.

  • Protovis (javascript) "A graphical toolkit for visualization" that can be used in conjunction with Google Maps.
  • MapBox "MapBox is a suite of open source tools to create beautiful custom maps in Amazon's cloud. "
  • ModestMaps (python, actionscript) "Modest Maps is a BSD-licensed display and interaction library for tile-based maps in Flash and Python."
  • ClearMaps (new, from SunlightLabs) "An action script mapping framework"
  • Mapfluence "Mapfluence is a suite of easy to use web mapping, visualization, and analytic APIs..."
  • Mapnik "Mapnik is a Free Toolkit for developing mapping applications."
  • TileCache "TileCache provides a Python-based WMS-C/TMS server, with pluggable caching mechanisms and rendering backends."
  • <li><a href="http://code.google.com/p/gheat/">gheat</a>
    

    "A map tile server for a heatmap layer" on top of Google Maps.

    <img src="http://assets.sunlightfoundation.com/images/blog/posts/mapping_resources.jpg" alt="Resources" class="aligncenter">
    <ul id="nobullets">
    <li><a href="http://openlayers.org/">OpenLayers</a>
    

    "OpenLayers makes it easy to put a dynamic map in any web page. It can display map tiles and markers loaded from any source."

  • Raphael (javascript) "Raphaël is a small JavaScript library that should simplify your work with vector graphics on the web."
  • ColorBrewer "Color advice for Cartography"
  • Geocoder "Convert multiple addresses to GPS coordinates"
  • Google's Geocoding service
  • <li><a href="http://www.batchgeocode.com/">BatchGeoCode</a>
    

    Batch geocode addresses in a spreadsheet with ease.

  • Mapstraction "Mapstraction is a library that provides a common API for various javascript mapping APIs to enable switching from one to another as smoothly as possible."
  • </ul>
    
    <img src="http://assets.sunlightfoundation.com/images/blog/posts/mapping_tutorials.jpg" alt="Tutorials" class="aligncenter">
    <ul id="nobullets">
    <li><a href="http://flowingdata.com/2009/11/12/how-to-make-a-us-county-thematic-map-using-free-tools/">Flowing Data: Thematic Maps</a> (choropleth with Python, SVG)</li>
    <li><a href="http://geography.uoregon.edu/GeogR/topics/maps.htm">Maps in R</a></li>
    <li><a href="http://blog.blprnt.com/blog/blprnt/7-days-of-source-day-1-goodmorning">GoodMorning</a> (processing based)</li>
    <li><a href="http://flowingdata.com/2009/11/05/make-thematic-maps-with-cartographer-js/">Thematic Maps with Cartographer.js</a></li>
    <li><a href="http://mapbox.com/documentation/adding-tiles-your-site/using-mapbox-tiles-google-maps-api/">Using MapBox tiles with Google Maps</a></li>
    <li><a href="http://vis.stanford.edu/protovis/ex/oakland.html">Recreating Oakland Crimespotting with Protovis</a> (See: <a href="http://oakland.crimespotting.org/">Oakland.Crimespotting</a>)</li>
    <li><a href="http://econym.org.uk/gmap/">Google Maps API Tutorial</a></li>
    <li><a href="http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsmapwizard/makecustommap.htm">Generate a Google Map from a spreadsheet</a></li>
    

  • Quickly visualize and map a data set using Google Fusion Tables
  • This TED 2010 talk is also worth watching to see the future of online mapping.

    Congressional Transparency on a Map

    punchclockery
    "We can never understand [a House member’s] Washington activity without also understating his perception of his various constituencies and the home style he uses to cultivate their support…" states Richard Fenno in Home Style: House Members in Their Districts. Fenno understands that the work of members of Congress is more than committee meetings and votes but is also people they meet with from the district. The work in the district builds trust constituents need to send them to Washington and to accept the decisions they make there. Fenno’s makes the point that the work of lawmakers done in the district is not an exhibition but the yang to Washington’s Ying.

    This trust that lawmakers create in the district extends to who they meet with in Washington. The Punch Clock motto has always been “Members of Congress work for us, and we should know what they do every day.” Fenno made this point a different way, “Trust is, however, a fragile relationship. It is not an overnight or one-time thing. It is hard to win; and it must be constantly renewed and rewon. "

    In this spirit, Sunlight has decided to help out by creating a trust-building tool. This tool, the Punch Clock Map, is a Google map mashup with corresponding RSS feeds that lets citizens see for themselves just how elected officials spend their time and how they serve their district’s needs.

    Read more