Boxplot
Thursday, August 26th, 2010
Great script (in CSS and Javascript) which makes it really easy to display boxplots on a website. Great!
Great script (in CSS and Javascript) which makes it really easy to display boxplots on a website. Great!
Wonna concatenate numerous fields to obtain all values in a single cell? Here’s the script:
Sub ConcatenateAll()
Dim x As String, rng As Range, cel As Range, v_new As Integer, v_old As Integer
With ActiveSheet
Set rng = .Range("F2:F2736")
For Each cel In rng
v_new = Int(cel.Value)
If (v_new <> v_old) Then
x = x & "," & Int(cel.Value)
End If
v_old = v_new
Next
.Range("G2").Value = x
End With
End Sub
And in order to insert a little bit more complicated string in ArcGIS’s Field Calculator, you need to do this:
"<img src='http://localhost/graph.php?data=36,36,37," & Int([wohnfl_per]) & "' />"
Easy, easy… In Spatial Analyst -> Raster Calculator do:
isnull([My Raster] <= 0, [My Raster])
Just working with some extensive raster data sets. And running into a problem – that is, the values of the raster, although integer, are not being displayed. Here is a solution:
Use the “Build Raster Attribute Table”. And if an error is coming up concerning the reaching of a limit, then use the advanced settings utility has an option to set maximum number of attribute entries.
The utility should be in your install location in the Utilities folder (by default – C:\Program Files\ArcGIS\Utilities). Run the AdvancedArcMapSettings executable and select the Raster tab.
Great visualization of 24 hours of air traffic. Shows well, similar to the Nightlights of the Earth, which regions of the globe are not connected. Impressive!
Attractive and interesting way to sum up the global population.
Gix, this extension helps GIS developers to migrate ESRI ArcView projects to the most popular Free and Open Source alternatives for Geographic Information Systems (GIS).
Like that one. Lightweight, easy, supply of additional information by mouseover. Really neat.
Nice mapserver, enabling vector display as well. Based on GeoExt.
If you need to calculate the area of a polygon layer in ArcGIS, you can do so in ArcMap.
Use ArcGIS Desktop Help (available from the ArcMap interface) to get basic directions – under the Index, search for “area” – you should then see “Calculating for Polygons”
These directions have been tested and they work well. However, before you do this, there are some things you need to check.
A note about coordinate systems and area calculations
First, make sure that your data layer is in a defined projected coordinate system, like State Plane or UTM. You need to know what the map units of the data layer are (usually feet or meters), because once you calculate area, the area calculation will be in those map units.
If your data is not projected (e.g., it is in a Geographic Coordinate System, meaning decimal degrees) it would be wise to project it first. In the Data Frame Properties, change the coordinate system to a projected coordinate system (e.g., State Plane NAD83 (feet) Texas Central. Then right click on the data layer and choose Export Data. In the dialog box that follows, choose to create the new data set in the Data Frame’s coordiante system (now set to a projected system). This will create a new projected data layer, that you can then add to the Data Frame. From that point, you can follow the directions in ArcGIS Desktop Help for calculating area. If the data frame units were in feet, the area calculation will be square feet.
To convert square feet into square miles or acres or hectares, you need to add a new field to the attribute table (e.g., sq_mile), then use the Calculate Values tool to have that field = the area field x the conversion factor. To get the conversion factor, see Peter Wallin’s the Conversion Table for changing measurement units.
Creating an “area” field in your attribute table if you don’t already have one
If your attribute table does not already have an “area” field, you need to create one before doing the area calculations. You can create the new field in ArcCatalog or ArcMap. Note you can add an acres field using these same directions.
To create a new attribute field for “area” in ArcMap, follow these directions – note you cannot be in an editing session to do this (don’t ask me why):
Calculating area for polygons (from ArcGIS Desktop Help)
It seems like 99 percent of the mail we send is electronic these days. The other 1 percent is letters and postcards that we want to postmark with our (usually enviable) location for the recipient. That’s why we dig these uber-accurate Google Maps envelopes.
Source
Natural Earth is a public domain map dataset available at 1:10m, 1:50m, and 1:110m scales. Featuring tightly integrated vector and raster data, with Natural Earth you can make a variety of visually pleasing, well-crafted maps with cartography or GIS software. Natural Earth Browser here.
Combination of (statistical) data and GoogleMaps Mashup from the New York Times.
ColorSchemer Studio 2 is a professional color-matching application for your Mac that will help you build beautiful color schemes quickly and easily. Use ColorSchemer Studio to identify color harmonies for the web (RGB) or print (CMYK), create palettes from photos, search over a million existing color schemes, mix colors, create gradient blends, and much more!

Different – innovative and attractive – way of displaying CO2 emission data, as ISO country codes. And very useful to see both per capita and total values displayed next to each other. PDFs available here.

The good, the bad and the ugly?! Wouldn’t say so. But this way, on can really see very well which countries have indeed succeeded in reducing their emissions, and which not. But be aware: Many countries have not reached or even surpassed the goal by “their own effort”; it is much more due to the breakdown of their economies and, more recently, the use of, in comparaison to before, cleaner technologies.
In order to view or download a high resolution version of the poster, just (right) click on the image.
Nicely designed poster.