Towards the best Table Design for Addresses

Floor Reference or Flat No
Building Name or House Name
House/Building/Unit Number
Street Name
Through Street
Locality
Town or City
Country
Postcode

A designer knows he has achieved perfection not when there is nothing left to add, but when there is nothing left to take away.

Antoine de Saint-Exupery

OK so I didn’t know who he was either until I did a search on simplicity but I wanted to record my best field structure for the storage of addresses which although important is on a par with watching paint dry in terms of excitement. Despite this addresses are central to a heck of a lot of applications so it is important to get it right. This copes with pretty much most addresses. I mainly use locality in larger towns or cities to denote a sub area specifically for users as you can guarantee they will be unfamiliar with the majority of specific street names and particularly for users who are doing business in the same city they are located in it is very useful for them to have a quick understanding of where things are in relation to the assets of the operation involved. Such “context” can be added by using maps but will come for free with intelligent staff if you give them opportunity. I long ago dropped counties and districts but I could see if you were in a larger country such as Russia or America could be useful to note state / oblast etc.. Additionally in the UK town is really postal town – which is often not obvious at all – it can be overkill but you can organise addresses so that postal town is referenced from the town automatically. Probably overkill.

Information on BS7666
National Land and Property Gazeteer

In the beginning

Ok time to do something new – I’ve been writing a diary for years nothing particularly personal just notes mainly on the work that I am doing and how to get things done. Ordinarily it runs to detailed technical notes on practical items particurly about database design but there is the odd discussion about frustrating road blocks work related or otherwise. The internet really has been a revelation for me a fact I’ve come to more greatly appreciate recently, it has changed my work practices completely and in particular how I tackle problems. The majority of my best work has been achieved with support and help from complete random individuals often on a one off basis with either reference to their work listed on their own blogs or from direct discussion with talented individuals on forums. In addition I have been fortunate to work with a number of talented colleagues on some challenging projects who have both encouraged and collaborated with me in creating what I believe to be some useful outcomes. Ultimately I believe the future is software and I am enjoying trying to be part of that future this is the space for me to write about that.

So the name

Round up the usual suspects

It’s a line from Cassablanca – we had a discussion in the office the other day and someone mentioned a line from the film Where Eagles Dare “Broadsword calling Danny Boy” delivered by Richard Burton. Don’t know why but it struck as being very memorable – Come the blog I was looking for something memorable but not maybe so overtly focused on war – Cassablanca it was. Doubtless only a select few will view this site – who knows maybe one day I’ll meet some of you and it will be the beginning of a beautiful friendship.

I immediately liked it which seems like as good a reason as any for a name.