Alfredo Covaleda,
Bogota, Colombia
Stephen Guerin,
Santa Fe, New Mexico, USA
James A. Trostle,
Trinity College, Hartford, Connecticut, USA
We're not wild about using “image” as a verb, but the conference looks promising and certainly appropriate for those journalists who understand that we have to learn to tell stories with more than just words and pictures. Yup, “HCI” is where it's at, or where it's going to be at.
Imaging the City:
Recent technological developments mark the city as a central and perhaps special space for human-computer interaction research and practice. Visions of ubiquitous computing, the resonance of the ‘urban probe’, and the proliferation of interactive mapping services speak to the significance of the urban landscape to studies of Human-Computer Interaction. But such visions and technologies require, produce and reproduce images of urban space that influence what these systems, and our interactions with them, are and might be. Developing and employing technologies for the urban environment requires visualization techniques that both reflect and challenge how we image, and consequently imagine, the city.
A former student of colleague Steve Ross sends this interesting report on how simulation models can/are being used in the real world:
I’m the communications officer for the International Research Institute for Climate and Society at Columbia University. The IRI specializes in making forecasts of climate for every part of the world by using data from satellites, meteorological stations and proxy records (tree rings, corals, etc) to run models. The models tell us, with varying degrees of certainty, how much off the “norm” rainfall, temperature and humidity will be for a given place in the world. We’re not so much interested in long-term climate change (global warming, sea level rise, etc) as we are in season-to-season changes (e.g. monsoonal patterns, drought, flooding, etc.). And the IRI isn’t a purely academic institution — its main objective is to use the forecasts and climate monitoring to develop and undertake projects that mitigate the effects of climate change in developing countries. We never do this alone: all of our efforts are in collaboration with scientists, policymakers and NGOs in these countries.
Here’s a brief description of some projects we’re currently working on:
*Climate and malaria:* The IRI collects an enormous amount of temperature, rainfall and humidity data for southern Africa. As it it turns out, the presence or absence of malaria in a given region depends strongly on these three climate factors, so scientists here developed a mapping tool that shows the risk of a malaria epidemic for every month of the year in every part of sub-Saharan Africa. We train health workers from countries in this area on how to use the information to adequately prepare for epidemics. (see /http://tinyurl.com/yxzp7t/ )
*Climate and fire-management* Fires in Indonesia damage unique and delicate ecosystems, increase carbon dioxide emissions, and produce noxious smoke and haze that leads to thousands of hospitalizations every year. Since the intensity and duration of these fires depend on the amount of rainfall the region receives every season, the IRI is using its rainfall forecasts to develop an early-warning system that policymakers and NGOs can use for planning purposes. For example, if our models tell us there is a strong chance of drought conditions in the next 3-month period there, our Indonesian partners can take specific actions, such as conserving irrigation water so that the fields where these fires occur aren’t drained completely and therefore aren’t as susceptible to burning. (see /http://tinyurl.com/yjehn6/)
*Index-based weather insurance for farmers*The IRI and the Commodity Risk Management Group at the World Bank are involved in a project to develop insurance contracts that protect Malawi farmers against periodic, crop-destroying droughts. Traditionally, farmers would take out loans to buy seeds at the start of every season. If a drought occurred, the farmers’ crops would die, and they wouldn’t be able to pay back the banks. But under this new program the farmers can purchase an insurance (a very small percentage of the price of the seeds) against crop loss when they buy seeds. If a drought occurs, the farmers get a full or partial payout and can use the money to repay their loans. IRI’s role in this is to use its weather monitoring data for the region to help the local insurance companies develop reliable contracts. The fascinating aspect of this program is that it is completely subsidized by the farmers. (no link available yet)
My role in all this is to make these and other projects known to the public at large. Many of you receiving this email are journalists of one species or another. If you are developing stories or graphics that have to do with climate or earth science, think of me. I’ll put you in touch with experts or send you bucketfuls of GIS and other data.
Francesco FiondellaCommunications Officer International Research Institute for Climate and Society Lamont-Doherty Earth Observatory 61 Route 9W Palisades, NY 10964francesco [at] iri.columbia.edu 1.845.680.4476
Mike Stucka stucka@whitedoggies.com today provided a rich set of links during a discussion of mapping on NICAR-L. If you're interested in Minard's map/chart/info graphic of Napeoleon's march to Russia — and especially if you use it as a teaching tool — check out the links below.
Click here to see the SAS code (zoomed-in view)Charles Minard is a famous map-creator from the late 1800's.Perhaps his most famous map is the following showing Napoleon's March on Moscow in 1812.I looked at several other people's version of Minard's map on the following webpage and devised an idea for my own version, using SAS/Graph's "proc gmap".I used longitude/latitude, troop number, and city data from the following webpagein combination with the temperature data from the following translation of Minard's Map.I'm somewhat "geographically challenged" when it comes to europe, especiallywith the city names on the Minard map (and I'm probalby not alone?) Therefore I decided to plot Napoleon's path on *modern* maps, with thecountry names labeled. Also, I wanted to give a "50,000-mile" view ofthe map, so people could see where this area was in relation to otherareas of europe (such as France).******************************************************************* Here's my 50,000-mile map.** Which drills-down to this Zoomed-in map.** Here is the SAS code used to generate the maps.*****************************************************************Here are some details about how I created my map(s) in SAS/Graph...For both of these maps, I used a combination of the sas maps.europe and maps.asia as the base map. I created custom/subsetted/clippedversions of these maps using SAS' "proc gproject", and specifyingthe latmax/latmin/longmax/longmin for the area I wanted in my map.To get the blue ocean/sea water to appear only in the map area I usean annotated rectangular polygon with corners at the exact samelong/lat coordinates as the corners of my map, and annotate it 'behind' the map. (If I had used "goptions cback=blue" that wouldhave filled the entire background of the page with blue, not justthe wanter area in the map.)In the 50,000-mile map, I annotate country names at long/latpositions of my choosing, and I annotate a dashed-line box aroundthe area that will be shown for the drilldown. In this dashed-boxarea, I use annotate's "html" variable to encode a drilldown, so that when you click inside this rectangle it drills-down to the zoomed-in map. I also annotate a dot at the city locations (andI annotate city labels in the zoomed-in map).I use the same technique in both maps to show Napoleon's path.I take the long/lat values, and use them as vertices for a line,and connect the dots with line segments (using annotate move/drawfunctions). The size/width of the line is calculated based on the number of troops (ie, men) still alive during that leg of the trip.One problem with this technique was that it produced big/jaggedgaps/transitions at the line vertices (especially where the lineschanged directions sharply). To smoothe this out, I annotated a 'pie' (filled circle) at each vertex, with the diameter of the pie being the same as the width of the line. With this annotation(as with most all of the lat/long-based annotation in this map)I combine the annotation with the map, use "proc gproject" to dothe map projection, and then separate the annotate from the map(this guarantees that things line up in the correct position).On the zoomed-in map, notice that when you hover your mouse over the city names, you see the city name (and additional info, if available)for that city. If you click on the city names, that launches a google search for information about that city (including the words'Napoleon' and '1812' in the search).When you hover your mouse over the vertex points of Napoleon's path,you'll get a html charttip/flyover-text showing the number of troopsat that point during the march. At first I made these hotspots theexact same size as the visual vertex dots, but the small ones were too small -- therfore I annotate a larger dot 'behind' the map for each vertex, and the charttip is based on the size of those 'invisible'vertex points :)Surprisingly the toughest part of the map was the temperature plot.After trying a few different approaches, I decided to base the positionof the temperature dots and the axes & gridlines & labels all using long/lat coordinates. The distance from the minimum gridline to themaximum gridline is 1 degree of latitude (not to be confused with degrees celcius or degrees farenheit! ;). And for the horizontal positions, I use he position of the cities/battles corresponding tothe temperatures. I color the temperature dots an 'ice cold' lightblue, since they represent cold temperatures./* Written by Robert Allison (Robert.Allison@sas.com) */
The NYTimes Michael Gordon broke a fine story on Nov. 1, 2006 — “U.S. Central Command Charts Sharp Movement of the Civil Conflict in Iraq Toward Chaos.” The grabber in the story was a single PowerPoint slide some unnamed source slipped to Gordon that illustrated where the U.S. was on the “continuum of chaos” in Iraq. The story is a good and insightful read, but the important lesson to take away is how what might seem to be random events — in this case violent events — and be understood and communicated as the visual aggregate of a complex phenomenon. Journalists might give some thought to how can we (a) visually present both static and dynamic events in our towns and (b) what do we first have to learn and understand to do so?
Only then will we be able to ask the right and pertinent questions of the military, corporations and public officials — who are all using these and similar techniques.
All we can say is that we were out of the country when this package of stories first appeared in early September, and we missed it. (Yeah, so much of the all-the-time-anywhere of the Internet.) But do take a look at what the graduate journalism students at Northwestern University served up. Good research coupled with good presentations on a topic most serious and under-reported.
Northwestern University's News21 fellows look at America's new system of surveillance, developed by the government with the help of private data mining firms after 9/11. One story uncovers new details about a secretive program in which the Education Department shared personal information on hundreds of student loan applicants with the FBI. Two immersive interactive presentations explore the digital trails we leave behind us in our daily lives and show you government data-mining initiatives that might incorporate information about you.
A fine piece of work on the NYTimes web site following the crash of the small plane into an East Side hi-rise apartment building on Wednesday (11 Oct. 2006). Check out “Small Plane Hits Building in Manhattan“
Eric Lipton has a piece in Wedneday's (4 Oct. 2006) NYTimes about some “new” research efforts to come up with software “that would let the [U.S.] government monitor negative opinions of the United States or its leaders in newspapers and other publications overseas.” (See “Software Being Developed to Monitor Opinions of U.S.“) Surely this is an interesting problem, and one made especially difficult when the translation factor kicks in.
This is not, however, the first attempt to gin-up such software. We have long admired the work done some years ago at the Pacific Northwest National Laboratory in the ThemeRiver™ visualization.
We hope the PNNL will continue by giving us more of this intriguing tool.
The 2006 Knight-Batten Awards given by J-Lab are out. All are worth looking at, but one caught our eye, one of the “Niche News” awards in the “Notable Entries” category. Clearly, a lot of legwork on the streets of Boston went into this well-designed project. Now the only question is: Who will keep it updated and how?bostonchinatown.org Emerson College Journalism (Boston, MA)
“Quintessential visualization of civic mapping … Tell us more about these people.” -2006 Knight-Batten Advisory Board Judges
Sixteen Emerson journalism graduate students put in a combined 500 hours of original reporting to develop this web chart. The chart displays connections between more than 100 newsmakers, organization leaders and activists in Boston’s Chinatown based on who talks with whom about local news. The map also acts as a directory with personal profiles available to help people connect.
Friend Steve Guerin tips us to “Cabspotting,” a fascinating site created by San Francisco's Exploratorium. It's about georgraphy, traffic flow, and complexity. Give a look to “Cabspotting”
Cabspotting traces San Francisco's taxi cabs as they travel throughout the Bay Area. The patterns traced by each cab create a living and always-changing map of city life. This map hints at economic, social, and cultural trends that are otherwise invisible. The Exploratorium has invited artists and researchers to use this information to reveal these “Invisible Dynamics.”
The core of this project is the Cab Tracker. The Tracker averages the last four hours of cab routes into a ghostly image, and then draws the routes of ten in-progress cab rides over it.
The Time Lapse area of the project reveals time-varying patterns such as rush hour, traffic jams, holidays and unusual events. New projects are produced by the Exploratorium's visiting artists and also created by the larger Cabspotting community.
OK, OK. Maybe we've crossed over some line social acceptability, but this is neat addition to the analytic journalist's toolbox. My friend Mike Collins tips us off to:http://www.juiceanalytics.com/weblog/?p=236
Lifehacker, delicious folks! This post generated a ton of great community ideas. Check out our followup post to see some more ideas and to download a spreadsheet with demos. Thanks.
We often are given a chunk of data in Excel that we need to explore. Of course, the first tool you should pull out of your toolbox in cases like this is the trusty PivotTable (it slices, it dices!). But at times we have to dig a little deeper into the toolbox and pull out the in-cell bar chart. Here’s what it looks like.
This picture shows some Major League Baseball data. I’m graphing the number of walks each player has taken. The bar graphs are built using the Excel REPT function which lets you repeat text a certain number of times. REPT looks like this:
=REPT(text,number_of_times)
For instance, REPT(”X”,10) gives you “XXXXXXXXXX”. REPT can also repeat a phrase; REPT(”Oh my goodness! “,3) gives “Oh my goodness! Oh my goodness! Oh my goodness! ” (my daughter’s an Annie fan).
For in-cell bar charts, the trick is to repeat a single bar “|”. When formatted in 8 point Arial font, single bars look like bar graphs. Here’s the formula behind the bars:
What are some practical uses of in-cell bar graphs? For starters, they offer a good way to profile a dataset that has hundreds or thousands of rows. Here’s a picture of in-cell bars compared to a standard excel bar graph for a dataset with about 500 rows. It can be a lot easier to scan the results when they’re in-cell.
Another usage is lightweight dashboards. The report below compares a number of metrics for players using both in-cell bar graphs as well as conditional formatting. The conditional formatting highlights the top 25% of each metric in green and the bottom 25% in red but that is a story for another day.
This entry was posted on Monday, July 31st, 2006 at 2:30 pm and is filed under analysis, excel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.