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:

UPDATE 2:

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.

Notch makes getting fit a little less po-faced

Getting fit and losing weight is a very serious subject. But it shouldn’t be. All the talk of burn and crunch and walls and plank and core and bootcamps and weigh-ins would put anyone off. No wonder so many people are obese.

I’ve been reading Scott Jurek’s book Eat & Run for the past while and it’s incredibly inspirational. Not in a happy-clappy sense but in the pure joy of running that leaps off the page. This guy runs 150 mile ultras all the time, including through Death Valley and is a vegan. When I’m running 12 miles slowly around Bandon and staring to fade, I just think about some of the stuff in his book and I recover quickly.

That’s why I found Notch.me so brilliant this week. It takes your Fitbit or RunKeeper info and turns it into a very funny infographic. I think RunKeeper should integrate it into the mobile app. It’s a damn sight more motivational than their robot voice at the end of the run saying “You ran 14 miles in 3 hours and 4 seconds. Your average pace was blah blah blah”.

We need to put joy back into exercise and fitness. I hope Notch.me is just a start.

Click through for the full infographic.

APIs, Web Services, Cloud, AWS – Slides from my talk yesterday at #OFFSITE2012

The first ever OFFSITE event in West Cork yesterday was a big success. I learned a lot from all the other speakers both about technology and business. The real stand-out for me was Ger Keohane‘s talk on eCommerce conversions. It was pretty stunning how you can seriously improve conversions to actual purchase with some very non-obvious changes.

I’m really pleased to see the West Cork Development Partnership get into the area of supporting local tech enterprises in addition to all the other areas they have supported over the years. If you are in West Cork and you are thinking about doing anything on the web or mobile, make sure to get in contact with David Tuohy there.

My talk on Web Services and moving to the cloud was a bit of a mish-mash. I was trying to cram a lot of info into 20 minutes. Unfortunately there is no video or audio so you’ll have to try and guess what some of my analogies mean e.g. Pig vs Waifos, FlyLo vs Butlins. Leave a comment if you get stuck :-)

Original on Google Docs:

Also on Slideshare:
Coming whenever conversion is complete. Now waiting 2 hours!

Harbour Hopping in West Cork – Apple uses Google Maps hand-me-downs

We’ve had much hilarity online today over the awfulness of Apple’s new iOS6 Maps. I finally just got it installed on the iPad and of course decided to check the local situation. Actually not disastrous. The golf club is not labelled as an airship landing strip for a start. But then I spotted something interesting.

Back about 6 years ago, Google Maps was completely useless in West Cork. At one point it seemed to think there was only one road down here, the N71. And bizarrely it wasn’t labelled as the N71, it was called “Harbour Hopping in South West Cork”. Seriously, that’s what Google thought the road was called. I never found out how such a ridiculous bug got into the data.

Eventually Google re-mapped the country itself and bought some better data. Their maps around here are now pretty fantastic and Streetview even went up tiny one-car-wide lanes locally.

So imagine my surprise when I saw this on the iPad:

Welcome to 2006 y’all.

 

I’m speaking at the OFFSITE Conference next week about AWS, APIs, SaaS etc

I mentioned the OFFSITE Conference over on Web2Ireland recently. It’s the frst time a major technology event is being held in West Cork and everyone in business in Munster and beyond should consider attending. It’s all happening next week, 27th September in Rosscarbery.

The title of my talk is “Building on The Shoulders of Giants: How Irish businesses can quickly deliver Enterprise-quality products through the smart use of software services

The bulk of the talk will be about all the lessons we have learned over the past few years in running the LouderVoice service on a cloud infrastructure and how you could do similar.

Some of the topics I’ll be covering include:

  • Building a SaaS business
  • Amazon Web Services (EC2, EBS, EIP, RDS, S3, CloudFront, CloudWatch)
  • IaaS vs PaaS (AWS vs Google vs Cloud Foundry vs Azure etc)
  • Tying it all together with APIs
  • Scaling
  • Pricing and Cost Monitoring
  • Robustness Cost-Benefit
  • Pitfalls
  • What’s Next?
  • Big Data Opportunities
  • Open Data Opportunities

This won’t be a geek-out session, it will be a business-centric talk where I hope those who are looking at the cloud get a lot of useful tips and cautions.

Let me know if there is anything in particular you would like to hear about.

 

Standing Desk Update

My standing desk experiments have been intermittent but I’ve put some renewed effort in recently due to some back twinges. I finally cleared out the tiny annex office off my main office and changed the standing desk over to my main laptop.

Overall it works brilliantly and is more stable than the previous set of cardboard boxes :-) The  floor mat is important to avoid getting sore heels. I either go barefoot or wear the Vibrams when standing.

The main lesson learned is that it’s not something you should do 12 hours a day. Mix it up and make sure to keep moving, don’t stay stationary for long periods. I generally take phone calls sitting down or when I have to read long technical documents. I think trying to read too much from a screen that is a few feet away whilst swaying slightly on your feet is just too hard.

Anyone else been trying it out? Any lessons learned you’d like to share?

 

How the hell did I miss the upcoming shutdown of FeedBurner? Another lesson in lock-in.

How the hell did I miss the fact that Google is shutting down FeedBurner in October?

I always remember Dave Winer warning all us bloggers back in 2007 that we were nuts to insert a single company between us and our readers. Most of us thought he was being a crank. It turns out he was right.

My big worry is that we will all lose all of our Blog Subscribers. In my case, built up over 11 years. I’ll be optimistic and assume some sort of skeleton FeedBurner service will exist which will 301 re-direct all the feeds to the original sources.

Great round-up piece on the problem by Neville Hobson. Two solutions offered by Dave.

How many times are we going to fall for this before we learn? We see a service that offers us some really nice benefits for free (FeedBurner, Facebook , Twitter, etc etc). Then we choose to ignore what will happen if they go away or change the rules or just break. We decide lock-in is a fair swap for free. Then they go away or change the rules or just break. And we’re left high and dry, swearing never again. Until the next time.

Luckily I’ve only got two blogs left using FeedBurner. Unluckily they are the two most trafficked. I’ll see if I can do the CNAME transition before D-Day and report back.

UPDATE: Someone left a comment on Google+ saying that it is just specific APIs that are getting shutdown, not the overall service. If I can confirm that, I’ll report back. Meanwhile, I’m still going to make the CNAME move.

 

Sugru + Old Mondeo = Yay

My ancient old Ford Mondeo (2001) is still going strong. In some ways I hate it for doing so. It’s an appliance and I don’t like appliances, I like things with character. Prior to it I only bought Citroens (BX, AX, Xantia) and I loved them dearly. But they were unreliable piles of junk assembled by drunks. Then, once we had kids, an appliance became necessary.

The “New” Mondeo was the second car in the renaissance of Ford. The first was the Focus in 1999. My wife had a  Focus and it was as close to perfect a car as you could get. Interesting shapes inside and out, totally reliable and not a generic over-priced BMW. Her sister drove it for a few years after her and loved it too. The Mondeo kept the reliability of the Focus but was dead boring to look at, inside and out.

In 11 years, the only problems it has had are a badly designed handbrake and grab handles which pop out of the ceiling. It also loses the gas in the aircon too quickly and it needed a suspension joint replaced a few years ago. It gets one service a year across the road for €100+ and that’s it.

120,000 miles later and it bombs up and down the M7/M8 like a new car.

But in all this time, one thing has bugged me every day. The dashboard has a stippled effect which is a magnet for dust but is also impossible to attach anything too. Particularly phone holders. So I’ve always had to attach them to the windscreen. The problem there is that the angle of the screen is so severe, it is always awkward, in landscape-mode, far away and murdered by glare. In France, on holidays in July, the HTC Sensation overheated so badly using Google Maps Navigation that a 2 Amp charger couldn’t keep the battery charged!

Then yesterday, 11 years later, I had a brainwave. Sugru:

And ye know what? It flippin works!

Here’s to another 120,000 miles.