Ship to Gaza 2

I have hijacked my own blog to write some updates of what is happening in Mediterranean sea right now.

From what I have understood from media, what has happened is that Israeli military has boarded all the ships, killed 19 (now they talk about “only”  9 killed) and wounded 60 persons on International water. Boats coming with humanitarian aid and supply.

It looks from pictures on internet like there might have been activists on the ships that started to hit the Israel soldiers when the boarded from helicopter but at the other hand Israel had no right what so ever to board the boats on international water.

Ship to Gaza

This is not a blog post within my usual area, but since I think this initiative Ship to Gaza seems like an truly humanitarian project I would like to do what I can to put the light on what is happening right now in the Mediterranean sea. On board the ships are besides supplies like medical equipment and building material,  many hundreds of people supporting the sake like parliamentarians, and activists, both Muslims and Jewish among others.

There is a lot of blogs out there following what is happening, but I don’t know which of the English blogs to consider trustworthy so do a search yourself to get more information.

What is happening right now is that Israeli military are following the ships and have promised to stop them. That I have read on a Swedish blog post from one of the boats, but the same blog also send posts in English. A lot of things are happening right now.

Fast nearest neighbour in PostGIS

A common task when using GIS is to solve nearest neighbour queries, for example to find closest lake or closest school to a table of households. If the table to search for the closest neighbour is large with thousands or even millions of records, it will be a very heavy and costly to do the search by computing and comparing the distance to every feature. A common solution is to narrow the search by first applying an indexed based search with ST_Dwithin. Different methods to do this is discussed at