SQL Server & BI Blog by Andreas Wolter - Category: "Geospatial" https://www.insidesql.org/blogs/andreaswolter/ InsideSQL.org Blogs - Blogs über SQL Server en-EU http://blogs.law.harvard.edu/tech/rss 60 Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/ https://www.insidesql.org/blogs/andreaswolter/2017/09/blog-umgezogen-this-blog-moved-andreas-wolter-com Wed, 20 Sep 2017 10:41:00 +0000 Andreas Wolter Seminare SQLPASS Tracing & Monitoring Analysis Services Extended Events Conferences Oracle Security Locking & Blocking SQL Trace & Profiler SQL Server 2014 Indexing Columnstore Index APS/Parallel Data Warehouse Reporting Services Integration Services Miscellaneous Geospatial Certification, MCM & MCSM, MVP In-Memory OLTP / XTP, HTAP Surveys / Umfragen Scripts HADR, AlwaysOn MDW Storage Engine Trivia Azure Performance SQL Server 2016 Patching 3918@https://www.insidesql.org/blogs/ <p><a href="http://andreas-wolter.com/blog/">http://andreas-wolter.com/blog/</a></p> <table> <tbody> <tr> <td width="302"> <p>Liebe Leser<br /> dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt.<br /> Seit August 2017 finden sich neue Artikel ausschließlich unter der <strong>neuen URL:<br /> <a href="http://andreas-wolter.com/blog/">http://andreas-wolter.com/blog/</a></strong></p> </td> <td width="302"> <p>Dear Readers<br /> this blog is now merely an „archive“ and no longer being updated.<br /> Since August 2017 new articles are exclusively available under the <strong>new URL:<br /> <a href="http://andreas-wolter.com/en/blog/">http://andreas-wolter.com/en/blog/</a></strong></p> </td> </tr> <tr> <td width="302"> <p>Die aufwändige Mehrsprachigkeit (Deutsch und Englisch professionell manuell übersetzt) wird beibehalten – aber Layout-technisch anders gelöst. Damit dürfte ich immer noch den einzigen mehrsprachigen IT-Blog weltweit betreiben.<br /> Ich hoffe, das neue Design gefällt Ihnen.</p> </td> <td width="302"> <p>The complex multilingualism (German and English professionally manually translated) is being continued – but solved differently in terms of layout. With that I most likely still operate the only multilingual IT-Blog worldwide.<br /> I hope you like the new design.</p> </td> </tr> </tbody> </table> <p> </p> <div class="image_block"><a href="http://andreas-wolter.com/blog/"><img class="loadimg" src="http://www.insidesql.org/blogs/media/blogs/andreaswolter/quick-uploads/p3918/170918_website_blog.jpg?mtime=1505903940" alt="" width="800" height="552" /></a></div> <p> </p> <table> <tbody> <tr> <td width="302"> <p>Mein aktueller Artikel, der erstmalig ausschließlich auf der neuen Website zu finden ist, lautet: <strong><a href="http://andreas-wolter.com/optimierung-von-workflows-mit-inmemory-objekten/">Optimieren von Workflows mit In-Memory und nativ kompilierten Objekten - oder wie es nicht funktioniert</a></strong></p> </td> <td width="302"> <p>My currently last article, which is exclusively available at the new website for the first time, is <strong><a href="http://andreas-wolter.com/en/optimizing-workflows/">Optimizing workflows with In-Memory and Natively Compiled Objects - or how it does not work</a></strong></p> </td> </tr> </tbody> </table> <p> </p> <p>Cu at my new Blog</p> <p>Andreas</p> http://andreas-wolter.com/blog/

Liebe Leser
dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt.
Seit August 2017 finden sich neue Artikel ausschließlich unter der neuen URL:
http://andreas-wolter.com/blog/

Dear Readers
this blog is now merely an „archive“ and no longer being updated.
Since August 2017 new articles are exclusively available under the new URL:
http://andreas-wolter.com/en/blog/

Die aufwändige Mehrsprachigkeit (Deutsch und Englisch professionell manuell übersetzt) wird beibehalten – aber Layout-technisch anders gelöst. Damit dürfte ich immer noch den einzigen mehrsprachigen IT-Blog weltweit betreiben.
Ich hoffe, das neue Design gefällt Ihnen.

The complex multilingualism (German and English professionally manually translated) is being continued – but solved differently in terms of layout. With that I most likely still operate the only multilingual IT-Blog worldwide.
I hope you like the new design.

 

 

Mein aktueller Artikel, der erstmalig ausschließlich auf der neuen Website zu finden ist, lautet: Optimieren von Workflows mit In-Memory und nativ kompilierten Objekten - oder wie es nicht funktioniert

My currently last article, which is exclusively available at the new website for the first time, is Optimizing workflows with In-Memory and Natively Compiled Objects - or how it does not work

 

Cu at my new Blog

Andreas

]]> https://www.insidesql.org/blogs/andreaswolter/2017/09/blog-umgezogen-this-blog-moved-andreas-wolter-com#comments https://www.insidesql.org/blogs/andreaswolter/?tempskin=_rss2&disp=comments&p=3918 Addresses for geographical Data, ESRI-Shapefiles and other SQL Server geographical related stuff https://www.insidesql.org/blogs/andreaswolter/2010/06/addresses-for-geographical-data-esri Thu, 10 Jun 2010 11:00:00 +0000 Andreas Wolter Reporting Services Geospatial 3568@https://www.insidesql.org/blogs/ <p>SQL Server 2008 R2 Reporting Services supports the visualization of geographical data in 3 ways.</p> <ul> <li>Datasets, based on the built-in .Net System-datatypes “geography” and “geometry”, which have been around since SQL Server 2008</li> <li>via built-in maps – but only for the United States</li> <li>via ESRI-Shapefiles, which one has to provide on his own</li> </ul> <p>Now, where can you get those Shape-files?</p> <p>Other, than in the USA where gathered data belongs to the people, with no cost (<a href="http://www.census.gov/geo/www/maps/" target="_blank">Census Bureau Geography</a>), in other countries, such as in Germany, it is by far not easy, to even get such datat all.</p> <p>In the following, I am collecting internet-sites, where one can find geographical data. I'd be happy to include more URLs, if you found a good one, to share.</p> <table border="0" cellspacing="0" cellpadding="0"> <tbody> <tr> <td> <p>Spatial Data at MIT <br /> <a href="http://libraries.mit.edu/gis/data/index.html" target="_blank">libraries.mit.edu/gis/data/index.html</a></p> </td> <td> <p>several links to other map-data, even outside US</p> </td> </tr> <tr> <td> <p>MapCruzin.com <br /> <a href="http://www.mapcruzin.com/download-free-arcgis-shapefiles.htm" target="_blank">www.mapcruzin.com/...</a></p> </td> <td> <p>free maps from around the world. political as well as physical, some even down to street-/building-level</p> </td> </tr> <tr> <td> <p>Natural Earth <br /> <a href="http://www.naturalearthdata.com/downloads/" target="_blank">www.naturalearthdata.com/downloads/</a></p> </td> <td> <p>several maps of the world with borders and physical structure</p> </td> </tr> <tr> <td> <p>Bundeswahlleiter <br /> <a href="http://www.bundeswahlleiter.de/de/bundestagswahlen/BTW_BUND_09/wahlkreiseinteilung/kartogaphische_darstellung.html" target="_blank">www.bundeswahlleiter.de/...</a></p> </td> <td> <p>maps of German "Wahlkreise", nice to play around with. They even include votes per area</p> </td> </tr> <tr> <td> <p><a href="http://www.datendieter.de/" target="_blank">www.datendieter.de</a></p> </td> <td> <p>various kinds of  datasets, also geographical, mainly German – mostly for a fee, but some is also free</p> </td> </tr> <tr> <td> <p><a href="http://drupal.org/node/19983">drupal.org/node/19983</a></p> </td> <td> <p>Cities of the world database donated by MaxMind.com</p> </td> </tr> <tr> <td> <p><a href="http://dev.maxmind.com/geoip/legacy/geolite/">dev.maxmind.com/geoip/legacy/geolite/</a></p> </td> <td> <p>GeoLite Free Downloadable Databases</p> </td> </tr> <tr> <td> <p><a href="http://efele.net/maps/tz/world/">efele.net/maps/tz/world/</a></p> </td> <td> <p>A shapefile of the TZ timezones of the world</p> </td> </tr> <tr> <td> <p><a href="http://www.earthtools.org/webservices.htm#timezone">www.earthtools.org/webservices.htm#timezone</a></p> </td> <td> <p>Time Zone and Local Time - This service responds with the time zone and local time at the given latitude and longitude.</p> </td> </tr> </tbody> </table> <p>Miscellaneous:</p> <ul> <li>Map Projection <br /> <a href="http://www.anychart.com/products/anychart/docs/users-guide/map-projections.html" target="_blank">www.anychart.com/products/anychart/docs/users-guide/map-projections.html</a> <br /> An overview over map projection types</li> </ul> <p>Other:</p> <table border="0" cellspacing="0" cellpadding="0"> <tbody> <tr> <td> <p>MsSQLSpatial</p> </td> <td> <p><a href="http://mssqlspatial.codeplex.com/" target="_blank">mssqlspatial.codeplex.com/</a></p> </td> <td> <p>spatial datatype-extension for SQL Server 2005</p> </td> </tr> <tr> <td> <p>Spatial Tools with Shapefile Uploader</p> </td> <td> <p><a href="http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx" target="_blank">www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx</a></p> </td> <td> <p>Tools for importing ESRI-Shapefiles into SQL Server as well as for looking at the data</p> </td> </tr> </tbody> </table> <p><strong>Geocoding</strong></p> <p>The other option to show geospatial data in Reports, is to just use plain geometry/geography data. Here are some resources that help in getting access to such and/or converting/”geocoding” data:</p> <p>The Google Geocoding API</p> <p><a href="https://developers.google.com/maps/documentation/geocoding/">developers.google.com/maps/documentation/geocoding/</a></p> <p>Rob Farley shows how you can geocode you address-data using bing-maps and powershell:</p> <p><a href="http://sqlblog.com/blogs/rob_farley/archive/2010/05/23/fetching-latitude-and-longitude-co-ordinates-for-addresses-using-powershell.aspx" target="_blank">sqlblog.com/blogs/rob_farley/archive/2010/05/23/fetching-latitude-and-longitude-co-ordinates-for-addresses-using-powershell.aspx</a></p> <p>A nice walk-through in geocoding using SSIS and Google Geocoding API by Jeffrey Verheul:</p> <p><a href="http://devjef.wordpress.com/2013/02/05/enriching-your-dataset-the-ssis-way/">devjef.wordpress.com/2013/02/05/enriching-your-dataset-the-ssis-way/</a></p> <p>Discussion on Mapping From City Name to Latitude and Longitude &amp; Mapping From Latitude and Longitude to City with further links: <a href="http://stackoverflow.com/questions/23572/latitude-longitude-database">stackoverflow.com/questions/23572/latitude-longitude-database</a></p> <p> </p> <p> </p> <p><strong>Further good articles</strong> concerning geographical data and SQL Server:</p> <p>Creating your own SSRS map using Visio</p> <p><a href="http://blog.oraylis.de/2010/07/creating-your-own-ssrs-map-using-visio/" target="_blank">blog.oraylis.de/2010/07/creating-your-own-ssrs-map-using-visio/</a></p> <p>Using Visio and SSRS Map Reports for Store Layouts etc.</p> <p><a href="http://blog.oraylis.de/2010/06/using-visio-and-ssrs-map-reports-for-store-layouts-etc/" target="_blank">blog.oraylis.de/2010/06/using-visio-and-ssrs-map-reports-for-store-layouts-etc/</a></p> <p>Using ESRI ShapeFiles with SSI</p> <p><a href="http://ssis-components.net/post/2010/04/11/ESRI-ShapeFiles-verarbeiten.aspx" target="_blank">ssis-components.net/post/2010/04/11/ESRI-ShapeFiles-verarbeiten.aspx</a></p> <p>For importing shape-files into SQL Server, see this blog-post at MSDN: <a href="http://blogs.msdn.com/seanboon/archive/2009/11/17/sql-server-2008-r2-map-tips-how-to-import-shapefiles-into-sql-server-and-aggregate-spatial-data.aspx" target="_blank">blogs.msdn.com/seanboon/archive/2009/11/17/sql-server-2008-r2-map-tips-how-to-import-shapefiles-into-sql-server-and-aggregate-spatial-data.aspx</a></p> <p>Achieve Spatial Data Support in SSIS: <br /> <span style="text-decoration: underline;"><a href="http://www.sql-server-performance.com/articles/biz/spatial_data_support_ssis_p1.aspx">www.sql-server-performance.com/articles/biz/spatial_data_support_ssis_p1.aspx</a></span></p> <p>Bridge The Gap between Bing and Google Maps using SSIS <br /> <span style="text-decoration: underline;"><a href="http://www.sql-server-performance.com/articles/biz/bing_google_maps_p1.aspx">www.sql-server-performance.com/articles/biz/bing_google_maps_p1.aspx</a></span> </p> <p>Heat Maps as Reports</p> <p><a href="http://prologika.com/CS/blogs/blog/archive/2009/08/30/heat-maps-as-reports.aspx" target="_blank">prologika.com/CS/blogs/blog/archive/2009/08/30/heat-maps-as-reports.aspx</a></p> <p>Stacia Misner shows in her blog, how to include your maps in the Map-Gallery for the Map-Builder-Wizard:</p> <p><a href="http://blog.datainspirations.com/2010/08/31/do-it-yourself-map-gallery-in-sql-server-2008-r2-reporting-services/" target="_blank">blog.datainspirations.com/2010/08/31/do-it-yourself-map-gallery-in-sql-server-2008-r2-reporting-services/ </a></p> <p>If you are working with Polygons &amp; Multpolygons, you should know how to check and correct an instance of geometry data for validity with .STValid() and .MakeValid() ad Jeffrey Verheul is showing is his post here:</p> <p><a href="http://devjef.wordpress.com/2012/06/29/strange-behavior-of-spatial-data/">devjef.wordpress.com/2012/06/29/strange-behavior-of-spatial-data/</a></p> <p>Have fun with Reporting Services 2008 R2</p> <p>Andreas</p> <p> </p> <p><a href="http://www.sarpedonqualitylab.com/" target="_blank">Sarpedon Quality Lab</a></p> SQL Server 2008 R2 Reporting Services supports the visualization of geographical data in 3 ways.

  • Datasets, based on the built-in .Net System-datatypes “geography” and “geometry”, which have been around since SQL Server 2008
  • via built-in maps – but only for the United States
  • via ESRI-Shapefiles, which one has to provide on his own

Now, where can you get those Shape-files?

Other, than in the USA where gathered data belongs to the people, with no cost (Census Bureau Geography), in other countries, such as in Germany, it is by far not easy, to even get such datat all.

In the following, I am collecting internet-sites, where one can find geographical data. I'd be happy to include more URLs, if you found a good one, to share.

Spatial Data at MIT
libraries.mit.edu/gis/data/index.html

several links to other map-data, even outside US

MapCruzin.com
www.mapcruzin.com/...

free maps from around the world. political as well as physical, some even down to street-/building-level

Natural Earth
www.naturalearthdata.com/downloads/

several maps of the world with borders and physical structure

Bundeswahlleiter
www.bundeswahlleiter.de/...

maps of German "Wahlkreise", nice to play around with. They even include votes per area

www.datendieter.de

various kinds of  datasets, also geographical, mainly German – mostly for a fee, but some is also free

drupal.org/node/19983

Cities of the world database donated by MaxMind.com

dev.maxmind.com/geoip/legacy/geolite/

GeoLite Free Downloadable Databases

efele.net/maps/tz/world/

A shapefile of the TZ timezones of the world

www.earthtools.org/webservices.htm#timezone

Time Zone and Local Time - This service responds with the time zone and local time at the given latitude and longitude.

Miscellaneous:

Other:

MsSQLSpatial

mssqlspatial.codeplex.com/

spatial datatype-extension for SQL Server 2005

Spatial Tools with Shapefile Uploader

www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx

Tools for importing ESRI-Shapefiles into SQL Server as well as for looking at the data

Geocoding

The other option to show geospatial data in Reports, is to just use plain geometry/geography data. Here are some resources that help in getting access to such and/or converting/”geocoding” data:

The Google Geocoding API

developers.google.com/maps/documentation/geocoding/

Rob Farley shows how you can geocode you address-data using bing-maps and powershell:

sqlblog.com/blogs/rob_farley/archive/2010/05/23/fetching-latitude-and-longitude-co-ordinates-for-addresses-using-powershell.aspx

A nice walk-through in geocoding using SSIS and Google Geocoding API by Jeffrey Verheul:

devjef.wordpress.com/2013/02/05/enriching-your-dataset-the-ssis-way/

Discussion on Mapping From City Name to Latitude and Longitude & Mapping From Latitude and Longitude to City with further links: stackoverflow.com/questions/23572/latitude-longitude-database

 

 

Further good articles concerning geographical data and SQL Server:

Creating your own SSRS map using Visio

blog.oraylis.de/2010/07/creating-your-own-ssrs-map-using-visio/

Using Visio and SSRS Map Reports for Store Layouts etc.

blog.oraylis.de/2010/06/using-visio-and-ssrs-map-reports-for-store-layouts-etc/

Using ESRI ShapeFiles with SSI

ssis-components.net/post/2010/04/11/ESRI-ShapeFiles-verarbeiten.aspx

For importing shape-files into SQL Server, see this blog-post at MSDN: blogs.msdn.com/seanboon/archive/2009/11/17/sql-server-2008-r2-map-tips-how-to-import-shapefiles-into-sql-server-and-aggregate-spatial-data.aspx

Achieve Spatial Data Support in SSIS:
www.sql-server-performance.com/articles/biz/spatial_data_support_ssis_p1.aspx

Bridge The Gap between Bing and Google Maps using SSIS
www.sql-server-performance.com/articles/biz/bing_google_maps_p1.aspx 

Heat Maps as Reports

prologika.com/CS/blogs/blog/archive/2009/08/30/heat-maps-as-reports.aspx

Stacia Misner shows in her blog, how to include your maps in the Map-Gallery for the Map-Builder-Wizard:

blog.datainspirations.com/2010/08/31/do-it-yourself-map-gallery-in-sql-server-2008-r2-reporting-services/

If you are working with Polygons & Multpolygons, you should know how to check and correct an instance of geometry data for validity with .STValid() and .MakeValid() ad Jeffrey Verheul is showing is his post here:

devjef.wordpress.com/2012/06/29/strange-behavior-of-spatial-data/

Have fun with Reporting Services 2008 R2

Andreas

 

Sarpedon Quality Lab

]]> https://www.insidesql.org/blogs/andreaswolter/2010/06/addresses-for-geographical-data-esri#comments https://www.insidesql.org/blogs/andreaswolter/?tempskin=_rss2&disp=comments&p=3568 SQLCon Session “Anspruchsvollere Berichte mit Reporting Services 2008” https://www.insidesql.org/blogs/andreaswolter/2009/09/sqlcon-session-anspruchsvollere-berichte-mit-reporting-services-2008 Sat, 26 Sep 2009 19:30:00 +0000 Andreas Wolter Conferences Reporting Services Geospatial 3558@https://www.insidesql.org/blogs/ <p>Auf der diesjährigen SQLCon in Mainz hielt ich die Session<em><strong> Anspruchsvollere Berichte mit Reporting Services 2008</strong></em>.</p> <p>Link: <a href="http://it-republik.de/dotnet/sqlcon09/sessions/?tid=1259#session-10624" target="_blank">http://it-republik.de/dotnet/sqlcon09/sessions/?tid=1259#session-10624 </a></p> <p>Themen waren:</p> <p><strong>Tablix</strong></p> <p>–Mehrere Gruppen auf einer Achse <br />–Static Header – wie geht das jetzt? <br />–Listen (gruppieren)</p> <p><a href="http://www.vb-magazin.de/forums/blogs/andreaswolter/Tablix_with_multiple_Groups_12389AE0.jpg" target="_blank"><img style="border: 0px none; width: 624px; display: inline; height: 121px;" title="Tablix_with_multiple_Groups" src="http://www.vb-magazin.de/forums/blogs/andreaswolter/Tablix_with_multiple_Groups_thumb_661B9DEE.jpg" alt="Tablix_with_multiple_Groups" width="644" height="141" border="0" /></a></p> <p><strong>Charts</strong></p> <p>–Dynamisches Wachstum <br />–Trendlines einbauen, Pareto-Charts <br />–Multiple Charts</p> <p><a href="http://www.vb-magazin.de/forums/blogs/andreaswolter/dynamic_chart_size_06FEC09A.jpg" target="_blank"><img style="border: 0px none; display: inline;" title="dynamic_chart_size" src="http://www.vb-magazin.de/forums/blogs/andreaswolter/dynamic_chart_size_thumb_7F071E37.jpg" alt="dynamic_chart_size" width="244" height="209" border="0" /></a></p> <p><a href="http://www.vb-magazin.de/forums/blogs/andreaswolter/chart_calculates_series_659F1AFD.jpg" target="_blank"><img style="border: 0px none; display: inline;" title="chart_calculates_series" src="http://www.vb-magazin.de/forums/blogs/andreaswolter/chart_calculates_series_thumb_12B407CC.jpg" alt="chart_calculates_series" width="246" height="142" border="0" /></a></p> <p><strong>Gauges</strong></p> <p>–Varianten und Customizing</p> <p><a href="http://www.vb-magazin.de/forums/blogs/andreaswolter/Gauges_04758EDC.jpg" target="_blank"><img style="border: 0px none; display: inline;" title="Gauges" src="http://www.vb-magazin.de/forums/blogs/andreaswolter/Gauges_thumb_039D28F2.jpg" alt="Gauges" width="244" height="195" border="0" /></a></p> <p><strong>Kombinationen</strong></p> <p>–Charts und Gauges innerhalb von Tablix (Microcharts)</p> <p><a href="http://www.vb-magazin.de/forums/blogs/andreaswolter/Microcharts_2AB81263.jpg" target="_blank"><img style="border: 0px none; display: inline;" title="Microcharts" src="http://www.vb-magazin.de/forums/blogs/andreaswolter/Microcharts_thumb_03119639.jpg" alt="Microcharts" width="200" height="244" border="0" /></a></p> <p>Weitere „Angenehmlichkeiten“</p> <p>–Felder in Page Header &amp; Footer <br />–Placeholder</p> <p>Hinweise auf <strong>Weitere interessante Neuerungen</strong></p> <p><strong>Ausblick SQL Server 2008 R2</strong></p> <p>–Map Control <br />–Componentizing Reports</p> <p><a href="http://www.vb-magazin.de/forums/blogs/andreaswolter/Map_383D852D.jpg" target="_blank"><img style="border: 0px none; display: inline;" title="Map" src="http://www.vb-magazin.de/forums/blogs/andreaswolter/Map_thumb_0977CC8B.jpg" alt="Map" width="244" height="155" border="0" /></a></p> <p> </p> <p>bis zum Nächsten mal,</p> <p> </p> <p>Andreas Wolter</p> <p> </p> <p><a href="http://www.sarpedonqualitylab.com/" target="_blank">Sarpedon Quality Lab</a></p> Auf der diesjährigen SQLCon in Mainz hielt ich die Session Anspruchsvollere Berichte mit Reporting Services 2008.

Link: http://it-republik.de/dotnet/sqlcon09/sessions/?tid=1259#session-10624

Themen waren:

Tablix

–Mehrere Gruppen auf einer Achse
–Static Header – wie geht das jetzt?
–Listen (gruppieren)

Tablix_with_multiple_Groups

Charts

–Dynamisches Wachstum
–Trendlines einbauen, Pareto-Charts
–Multiple Charts

dynamic_chart_size

chart_calculates_series

Gauges

–Varianten und Customizing

Gauges

Kombinationen

–Charts und Gauges innerhalb von Tablix (Microcharts)

Microcharts

Weitere „Angenehmlichkeiten“

–Felder in Page Header & Footer
–Placeholder

Hinweise auf Weitere interessante Neuerungen

Ausblick SQL Server 2008 R2

–Map Control
–Componentizing Reports

Map

 

bis zum Nächsten mal,

 

Andreas Wolter

 

Sarpedon Quality Lab

]]> https://www.insidesql.org/blogs/andreaswolter/2009/09/sqlcon-session-anspruchsvollere-berichte-mit-reporting-services-2008#comments https://www.insidesql.org/blogs/andreaswolter/?tempskin=_rss2&disp=comments&p=3558