thanks NWL) showing the addresses of properties subject to enforcement action. Unfortunately as is often the case with public authorities they released the data in PDF table format, rather than as a spreadsheet. Asking for a KML file probably would have been expecting too much.
With that in mind I converted the PDF back to a spreadsheet, combined the address columns into one column, and then geocoded using the excellent Google Fusion Tables. The result is NOT 100% accurate, I still have to clean up some rows, but generally the information is geographically correct. Here is the result. Click on a red dot to get the associated information.
Continue reading “NAMA enforcement properties – mapped”
Irish Times today. Quickly plotted, pin-the-tail-on-the-donkey style.
View Fine Gael Leadership Election in a larger map]]>
CORRECTION: One of the headings was incorrect. It is travel and subsistence not mobile phones that the most money was spent on. Somehow the headings got shifted across in the totals column. Apologies.
I’ve been messing with Gav’s spreadsheets. Here’s
two one quick visualisationish (try saying that one out loud, radio students) thingy. This is TDs only, expenses claimed between 2005 and 2008.
The Dáil posse spend a lot on phones, it appears. Wonder if they’ve started billing State for the bills on those unofficial Blackberrys certain TDs have started using. Texts sent or data downloaded from those would not be FOIable, remember. Nice way of circumventing FOI law, that.
Next time you see a Government minister with a second phone, you’ll know the score.
Oh, I’ve got an average figure a TD spent in each category per year. So you can how sort the data per heading and if your TD is above the bolded figure (the average amount spent per year per TD in that category) in any of the few years… well, it may interest you. Please download or copy the file before sorting the data for your own purposes. Each time you sort it, it gets resorted for everyone.
Note: I used the figure of 200 as the number of people who sat in the Dáil on average per year. The election meant one year there were 220 claimants, all the other years there were around 166. 200 is probably too high an average figure but I was feeling generous.
Sheet 2 at this link.
Move sheets by clicking the names across the bottom of the file. Download by clicking File > Download. If you use Gmail, click File > Copy.
Have a good long weekend.]]>
Most of the images are pinned on the Google Map below. Will Panoramio them soon so they’ll be available on Google Earth. Also on Gav’s Flickr account.
View Dublin docklands/quays developments and empty properties in a larger map
Music is Dietro Casa by Ludivico Einaudi.
And yes, you did see that correctly, the Financial Regulator does have an office right beside Irish Nationwide in a building owned by Treasury Holdings, which will be going into NAMA. Oh, what a web.]]>
Geographic.ie have kindly mapped CAP 2009 payments on a per farmer basis by county, based on 2006 census data and the farmsubsidy.org dataset of 137k+ payments totaling €1.9bn.
The spreadsheet used to produce the map is here. ]]>
Irish milk export subsidy data from 2001 to 2009. I’ve created a pivot chart of the data here:
Most of the milk export subsidy claims related to Morocco, at 11% or €51m.
Georgia (Republic of) has been changed to its capital, Tbilisi. This will make it easier to map later, as Google thinks Georgia is the US state. ]]>
Continue reading “Analysis and visualisation of tax default list 2009”