Archive for August, 2010


Thursday, August 26th, 2010

Great script (in CSS and Javascript) which makes it really easy to display boxplots on a website. Great!

Excel: Concatenate Multiple Fields

Tuesday, August 24th, 2010

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


.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]) & "' />"

ArcMap: Convert a value to NoData (IsNull)

Tuesday, August 24th, 2010

Easy, easy… In Spatial Analyst -> Raster Calculator do:

isnull([My Raster] <= 0, [My Raster])

ArcMap: Raster Data

Tuesday, August 17th, 2010

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.

Debugging AJAX

Monday, August 16th, 2010

Need to debug AJAX? Beside some tips I found on the Net, here is one I found particularly useful, at least in my current case. Just use a

tail -f /private/var/log/apache2/access_log


tail -f /private/var/log/apache2/error_log

which displays the latest log entries… which can help to solve some major issues.


Monday, August 16th, 2010

Great project. Traveling around the world with solar energy. Wow!

Air Traffic Visualization

Sunday, August 15th, 2010

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!

Nightlights of the Earth

Sunday, August 15th, 2010

Population Distribution

Friday, August 13th, 2010

Attractive and interesting way to sum up the global population.


Tuesday, August 3rd, 2010

Gush, sometimes feeling as we’re still living in the 80ies. How do you get data from ArcGIS to GeoServer, classes & colors including?! No easy task. Here is a small lib which makes the export from ArcGIS to SLD possible (with some additional explanations here). Thanks a lot!

Export to Mapserver

Tuesday, August 3rd, 2010

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

Interactive Map

Tuesday, August 3rd, 2010

Like that one. Lightweight, easy, supply of additional information by mouseover. Really neat.