#“Visualisation of Irish Property Price Register Data using Interactive Map from Google Fusion Tables”
UPDATE: Second attempt at this:
I just grabbed the three CSV files from the Residential Property Price Register site (why is a Captcha needed for that?). I merged some address columns in Excel and added “Ireland” to all of the addresses. I then just imported into Google Fusion Tables and told it to Geo-Code the data.
Note that zero data validation has been done. Everything on this map may be completely wrong. I’m sure some of the more obscure addresses (or non-unique ones) are missing.
Aha! There are daily limits on Geo-coding so I’ll have to do this over a few days before the full map of points appears. But this is a decent start:
2011 Fusion Table. 2011 Map (this will populate properly over next few days too):
2012 Fusion Table. 2012 Map (this will populate properly over next few days too):
UPDATE 3: Replacement 2010 Fusion Table and Map with Euro symbol correctly encoded:
UPDATE 4: Of course I should have pointed out earlier that the Fusion tables themselves are very useful. You can filter on location, date, price etc without having to fill-out a silly captcha.
Anyone interested in one aggregated Table/Map with all the data from all years in it?
UPDATE 5: As of 16:09 on Oct 1st, the 2012 and 2011 data is 100% geo-coded and 2010 is at 63%. However, based on Brendan’s comments below, we may be missing a lot of data points because Google can’t geo-code them. Once the process is complete, I’ll see if we can extract the missing ones and manually adjust the addresses so that they work. There are also plenty of errors from what I can see.
UPDATE 6: As of 9am Oct 2nd, the final data from 2010 is now geo-coded. Short follow-up post to come on how Google could do far more intelligent and less error-prone geo-coding on Irish addresses without post-codes.