SIDEBAR
»
S
I
D
E
B
A
R
«
Imaging the City: Call for Papers
Dec 15th, 2006 by Tom Johnson

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:

Call for Participation:

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.

This one-day workshop will explore the practices and and technologies of imaging the urban environment, bringing together
an interdisciplinary array of designers, HCI experts, urban planners
and technologists to investigate such issues as:
  • How do we represent the city in HCI, and how do these representations inform HCI research and practice?
  • What
    kinds of technological devices, services, and platforms support imaging
    the city now and might be created in the near future?
  • How are and might these new representations of the city and urban imaging technologies be used for social and political ends?
  • What new methods are required for developing technologies that image the city in new ways?
  • What can we learn from the urban experience to design stronger representations and interfaces within HCI research and practice?



Science and simulation for the greater good
Nov 5th, 2006 by JTJ

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 Fiondella
Communications Officer
International Research Institute for Climate and Society
Lamont-Doherty Earth Observatory
61 Route 9W
Palisades, NY 10964
francesco [at] iri.columbia.edu
1.845.680.4476



English translation of Minard's classic chart of Napoleon's March
Nov 4th, 2006 by JTJ

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 webpage
in combination with the temperature data from the following translation of Minard's Map.

I'm somewhat "geographically challenged" when it comes to europe, especially
with 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 the
country names labeled. Also, I wanted to give a "50,000-mile" view of
the map, so people could see where this area was in relation to other
areas 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/clipped
versions of these maps using SAS' "proc gproject", and specifying
the 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 use
an annotated rectangular polygon with corners at the exact same
long/lat coordinates as the corners of my map, and annotate it
'behind' the map. (If I had used "goptions cback=blue" that would
have filled the entire background of the page with blue, not just
the wanter area in the map.)

In the 50,000-mile map, I annotate country names at long/lat
positions of my choosing, and I annotate a dashed-line box around
the area that will be shown for the drilldown. In this dashed-box
area, 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 (and
I 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/draw
functions). 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/jagged
gaps/transitions at the line vertices (especially where the lines
changed 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 do
the 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 troops
at that point during the march. At first I made these hotspots the
exact 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 position
of the temperature dots and the axes & gridlines & labels all using
long/lat coordinates. The distance from the minimum gridline to the
maximum 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 to
the temperatures. I color the temperature dots an 'ice cold' light
blue, since they represent cold temperatures.

/* Written by Robert Allison (Robert.Allison@sas.com) */


Analysis tied to making the "story" visual
Nov 3rd, 2006 by JTJ

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.





Some fine work by the students
Oct 15th, 2006 by JTJ

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 Data Dilemma

Data Dilemma: Privacy in an Age of Security


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.




Using Flash to illustrate the Crash
Oct 12th, 2006 by JTJ

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


Teasing out attitudes from text
Oct 5th, 2006 by JTJ

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.

It “…helps users identify time-related
patterns, trends, and relationships across a large collection of
documents. The themes in the collection are represented by a 'river'
that flows left to right through time. The river widens or narrows to
depict changes in the collective
strength of selected themes in the
underlying documents. Individual themes are represented as colored 'currents' flowing within the river. The theme currents narrow or widen
to indicate changes in individual theme strength at any point in time.
  Status: An interactive proof of concept prototype has been developed. Download a QuickTime video about ThemeRiver (20MB)


We hope the PNNL will continue by giving us more of this intriguing tool.



Social Network Analysis in Boston's Chinatown
Sep 19th, 2006 by JTJ

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.



Watching the ebb and flow on city streets
Sep 6th, 2006 by Tom Johnson

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”

About 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.



Something cool for the Excel day-trippers
Aug 18th, 2006 by JTJ

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

Lightweight data exploration in Excel

del.icio.us:Lightweight data exploration in Excel digg:Lightweight data exploration in Excel reddit:Lightweight data exploration in Excel Y!:Lightweight data exploration in Excel

,

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.

In cell bar charts in Excel

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:

The formula behind the bar

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.

Exploring tall data with in-cell bar graphsExploring the same data with an Excel bar graph

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.

The formula behind the bar


»  Substance:WordPress   »  Style:Ahren Ahimsa