Archive for March, 2010

 

links for 2010-03-30

 
 

http://www.adoptioncurve.net/archives/2010/03/links-for-2010-03-30.php

links for 2010-03-28

 
 

Rewired Culture

 
 

I took a trip down to London yesterday to go to Rewired Culture, part of the series of Rewired State events. Basically these are gatherings of assorted hackers and geeks who get provided with access to government data, beer and pizza and left to see what they come up with.

The premise is that most government bodies don’t know what to do with their data, either because they don’t have the technical expertise or because they don’t care, or because they don’t see doing interesting things with their data as being part of their remit. Hackers by their very nature DO know what to do with it, so by letting them loose with the data means that interesting things tend to happen.

Rewired Culture was about data originating from the culture, media and sport sectors and took place at the Guardian. There were about 25 hackers – ranging in age from 15 to me – who took over an office in the Grauniad building (sorry about adjusting your chair, whoever’s desk it was I sat at) and spent the day coding. From what I could see it was a pretty mixed bunch – although Macs were in the ascendence, there was a web focus to it, and the tools were generally open source.

There were various outcomes of the day – my favourite being Rupert Redington‘s Awesometer. This is an antidote to the Asborometer, which to me sums up everything that’s wrong and negative about the reuse of goverment data. The Asborometer focusses on everything that’s negative – how many ASBOs are there in your area, and exactly how afraid should you be? Needless to say, it was inevitably picked up and praised by Gordon Brown as he “launched” the government’s latest “put-it-all-online” efforts last week.

The Awesometer is completely different. It picks up your location, scrapes a whole series of data sources to see what positive things are going in your area, gives you a score which includes +1 for *you* being there, and then tells you to relax and get on with things.

If it could further ram home the point that violent crime is very rare – and its prevalence is something that’s continually hyped-up by those with a vested interest in accentuating negativity for the furtherance of their own agendas – it would be perfect.

The whole event was only for the day, which isn’t a great deal of time to actually *make* something by my standards. However I did manage to come up with something that works as a cobbled-together prototype, more about which is over here.

A listed buildings app for the iPhone

 
 

English Heritage is a non-Departmental Public Body that exists to protect and promote England’s historic environment. One of the tools at their disposal is listing, which applies protection to a building or site through the planning system. Crudely, it stops you putting plastic double glazing into your historic thatched cottage; or demolishing a factory designed by that world-famous architect.

There are a lot of listed buildings – about 374,081 of them – and they’re listed in a database which English Heritage made available to the Rewired Culture event. It appears to have been a dump of some kind of GIS system – it’s in a dBase format and has eastings, northings and polygons for the structures. There’s no information about the buildings other than a name and a very truncated street address (there’s no town data, for example), but you can at least identify them geographically.

Job #1 is converting the eastings and northings to latitude and longitude. That’s painful maths, but a one-off process and thankfully doable through some PHP functions which someone else previously written.   So a quick PHP script runs the conversion on the fly to convert from the supplied lat/long to the eastings/northings needed to interrogate the database.

Job #2 is being able to find out where the listed buildings around you are. This is another web service with a PHP backend that accepts a pair of lat/lon coordinates and a radius, and spits back a list of lat/lon coordinates of the buildings within the radius together with their names and street address.

I managed to get that pair of services more-or-less working during the day after a fair amount of tweaking, which just left the front-end piece – you can access the webservice at listedbuildings.adoptioncurve.net – it should be fairly self-explanatory.

Job #3 was entirely due to needing something to do on the 2-hour train ride back to Sheffield. This is a simple iPhone client which pick up your location from GPS and pings the aforementioned web service to grab a list of buildings in the locale. It then plots them as pins on the map to show what’s around you.

Because the resolution of the grid reference allows pretty accurate map placement, in theory it should be possible to go one step further and overlay the pins onto an augmented reality-style display. The idea would be to whip out your iPhone / Android device, point in the direction of the building in front of you and know at a glance whether it was listed or not. Then with another level of access into the back-end data (which English Heritage don’t appear to offer though any kind of API, yet) you could easily display the information that they hold about the structure.

I’m going to continue to polish up the various rough edges over the next few days, and then post the results up. I haven’t dug into the data’s usage conditions enough to know whether it would be possible to offer an iPhone app via the App Store, but assuming there’s no roadblocks to this I might give it a go. And it’ll be available for anyone who wants to try it in a beta form.

links for 2010-03-27

 
 

http://www.adoptioncurve.net/archives/2010/03/links-for-2010-03-27.php

Getting OpenOffice to talk to MAMP and MySQL

 
 

For reasons that are too dull to go into, I needed to convert from a Dbase database to a MySQL database.   OpenOffice can read both types, which means that you can create a new MySQL database, open the DBF version and then drag the records across.

The prerequisite to this is being able to get OpenOffice to connect to the MySQL database.  There are instructions here, and tucked away at the bottom is a note about forcing MySQL to use TCP/IP rather than sockets.  If you miss this out, you’ll get a persistent “connection failed” error.

If – like me – you’re a coward and using MAMP or MAMP Pro, this gets tricky.  The answer is to drill into the MAMP Pro application by right-clicking and the Show Package contents option; then scroll down until you find the my.cnf file and edit this.   Restart MAMP, and things should work.

links for 2010-03-25

 
 

http://www.adoptioncurve.net/archives/2010/03/links-for-2010-03-25.php

links for 2010-03-23

 
 

Demand that the DEB gets scrutinised

 
 

On Thursday the Leader of the House of Commons, Harriet Harman, will outline how the Government is going to deal with the Digital Economy Bill.

I believe this is a fundamentally-flawed piece of legislation, written largely by lobbyists from entrenched corporate interests, and if passed will cause incalculable damage not just to the *real* digital economy but also to freedom of expression and speech.

You might not agree with me.  That’s not really important at this stage.

What is important is that a Bill this controversial and with such potentially far-reaching effects shouldn’t be rammed through the legislative process without the chance for our elected representatives to scrutinise it.

Whether it’s the Digital Economy Bill, or a law to regulate the maximum permissible length of a sausage roll – good laws are considered, scrutinised and debated.  Bad laws are made in the shadows.

Regardless of whether you think the DEB is right or wrong, take 2 minutes to go to 38 Degrees and write to Harriet Harman to demand that this law is debated and scruitinised. They’re *our* elected representatives, making laws on *our* behalf. It’s time they knew where they stand.

The Digital Economy Bill might not affect you, but the next law could.   And if the Government get away with rushing this bill through, it’ll happen with others.

Last chance to sink the Digital Economy Bill

 
 

Yes, it’s another Digital Economy Bill rant.

It’s passed the Lords, and is on the way to the Commons, where it *could* be rammed through with minimum scrutiny once the General Election is called.  That’s what the corporate interests that have drafted it want:

In this leaked, six-page email, Richard Mollet, the Director of Public Affairs for the British Phonographic Institute (the UK’s record-industry lobbyists), sets out the BPI’s strategy for ramming through the Digital Economy Bill, a sweeping, backwards reform to UK copyright law that will further sacrifice privacy and due process in the name of preserving copyright, without actually preserving copyright.

<snip>

On the other hand, he identifies Members of Parliament as being “resigned” to the fact that they will not be allowed to debate the bill or give it “detailed scrutiny” (heck of a job, MPs!). He cites an expert on legislation as saying that the bill will likely die if MPs insist on their right and responsibility to examine this legislation in detail before voting on it.

There’s still one last chance to prevent this, if MPs do what MPs are supposed to do and hold the legislation up to some kind of scrutiny.   Time to hit WriteToThem – especially if you have a LibDem MP – and tell that’s what they should be doing.

This is my contribution, aimed at Nick Clegg.  Feel free to use something similar yourself :

Dear Mr Clegg,

I was heartened to see that the resolution regarding the Digital Economy Bill was overwhelmingly passed at the Spring Conference.  But despite the fact that the Liberal Democrats have woken up to the implications, the Bill is still a deeply flawed piece of legislation that is utterly skewed to the interests of big corporations, and will do irreparable damage to the real digital economy in the UK:

  • The Joint Committee on Human Rights has said that it is unable to rule on whether the Bill would be compatible with the European Convention on Human Rights without more detailed scrutiny. [1]
  • Speaking in the Lords, Lord Puttnam said “I am absolutely convinced that, within the next two or three years, there will be another bill before this house which will be created to deal with the deficiencies of the present bill.” [2]
  • According to a leaked memo, the BPI are relying on a lack of Parliamentary review to ensure that clauses which were drafted word-for-word by them become law. [3]
  • The statistics which form a central plank of the lobbyist arguments are demonstrably misleading. [4]

This Bill will do nothing for the digital economy, as it’s written entirely from the perspective of media conglomerates who are seeking to shore up outmoded business models that are rapidly being rendered obsolete by technology.  If their approach was taken back 100 years, the telegraph industry would be attempting to pass legislation that effectively outlawed the telephone.  It threatens the livelihoods of thousands of people like me who are making the most of new opportunities to make a healthy, legal and creative living through the internet.

That’s the view of everyone – and I really mean *everyone* – I know who works in the IT and internet industry, and there’s a growing groundswell of public opinion that shares this.

People’s faith in politics in the UK is an an all-time low, and it would be a travesty of the legislative process if a Bill this flawed was allowed to become law without scrutiny in a mad rush to clear the decks before the General Election.

I’m writing to ask that you and your fellow Liberal Democrats do not allow this Bill to pass without detailed scrutiny, and that Danny Alexander’s promise to do so [5] is kept.

Yours sincerely,

Tim Duckett

[1] http://www.out-law.com/page-10754
[2] http://www.guardian.co.uk/technology/2010/mar/02/digital-economy-puttnam
[3] http://www.boingboing.net/2010/03/12/leaked-uk-record-ind.html
[4] http://www.guardian.co.uk/commentisfree/2009/jun/05/ben-goldacre-bad-science-music-downloads
[5] http://www.libdemvoice.org/danny-alexander-digital-economy-bill-18321.html

 
 

About

Hello, I'm Tim. I'm a geek who builds online and mobile software and also takes photographs and messes around with technology. This is my personal website.

You can find out more about me and browse through the full archives. I also take photographs, and hack around with things. You can find me elsewhere on the interwebs, get in touch, or subscribe to a feed from this site.

Creative Commons License
The site's content is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales License, unless indicated otherwise. Please don't steal it :-)

About this site

This site is powered by Wordpress, and hosted by the nice people at Linode. The template is custom-built and based on 960bc and the 960 grid.