postcode

Whats the best way to store and retrive postal addresses using a sql server database and the .NET framework?

I'm looking for a common pattern that will store and access global addresses in database. Components or other technologies can be used. The following criteria must be adheard to... Every line of the address is saved for every country Postal codes are tested with a regular expression before being saved Country of original is saved in ...

Good examples of UK postcode lookup flow

I'm looking for a good, well designed flow of a UK postcode lookup process as part of registration for an eCommerce account. We're redesigning ours and want to see what is out there and how I can make it as friendly as possible. --Update-- Basically our current design was a manual entry form (worked pretty well) which a less than expe...

UK Postcode Regex (Comprehensive)

I'm after a regex that will validate a full complex UK postcode only within an input string. All of the uncommon postcode forms must be covered as well as the usual. For instance: Matches CW3 9SS SE5 0EG SE50EG se5 0eg WC2H 7LT No Match aWC2H 7LT WC2H 7LTa WC2H Are there any official or even semi-official regexes in use for this...

UK Suburb Database

This is not a really technical question but is required for a system I am building. I am after a UK suburb/postcode database. I haven't been able to find this anywhere and wonder if it is available (freely). I know in Australia is is freely downloadable from Australia Post. Also a US suburb/zip database is required as a secondary concern...

Python, Regular Expression Postcode search

Hi Guys, I am trying to use regular expressions to find a UK postcode within a string. I have got the regular expression working inside RegexBuddy, see below: \b[A-Z]{1,2}[0-9][A-Z0-9]? [0-9][ABD-HJLNP-UW-Z]{2}\b I have a bunch of addresses and want to grab the postcode from them, example below: 123 Some Road Name Town, City County...

Address Validation API

I have a task to validate addresses entered into a system I am currently creating. The system requires that address entered are validated against a valid data source. In the UK the dataset comes from the Royal Mail and is expensive to access. The data needed is post code info for the whold of europe to start with accessed by an API in...

Post code API Lookup

Hi Has anyone had experience with the post code anywhere lookup API. The service appears to be a bargain - through experience - when something is too good to be true it often is. I have reservations about the countries that are being offered, there seem to be some missing. Has anyone had any good experiences with post code lookup A...

Sort Postcode for menu/list

I need to sort a list of UK postcodes in to order. Is there a simple way to do it? UK postcodes are made up of letters and numbers: see for full info of the format: http://en.wikipedia.org/wiki/UK_postcodes But my problem is this a simple alpha sort doesn't work because each code starts with 1 or two letters letters and then is imme...

Auto-selection of <option> based on input field, with some caveats

I have a SELECT element in which I need to auto-select the appropriate option based on the first half of a postcode entered in a text field. British postcodes are of the form AB12 3CD, where the first section consists of 1-2 letters representing the county and a number representing the area within the county. The last 3 characters are ir...

Best method for working out locations within a radius of starting point

I'm aiming to create a feature in my latest project preferably using PHP. When each user signs up they are going to input their postcode. Then hopefully I will be converting this to lat/long using Open Street Map. Anyway, I want to be able to find out other users located near the current user. I have seen a lot of people using the Have...

What is the Royal Mail's PAF Address Database?

Hi, I'm struggling to understand what you would get from the Royal Mail if you bought their PAF file dataset of UK addresses. I was expecting that PAF was some form of database which you would host yourself, and the Royal Mail provide APIs into that database. However, after reading this, I'm presuming that all you get is a series of f...

Physical Address to GeoLocation UK

Is there a good physical address to GeoLocation conversion database in the UK? I am trying to use this to build a globrix style search box http://www.globrix.com/ for a web application. Any pointers will be nice. I have been searching for hours. I have found several that convert UK Postcodes into Geolocation. But I need the addresses lis...

How do I utilise longitude/latitude values efficiently in Mysql ?

Thanks to Wikileaks, here in the UK we can now access our longitude and latitude co-ordinates for each post code wikileaks postcodes uk IMPORTANT. Do not use this data in public applications - There's concern that the data has been deliberately corrupted and you could be held as being in breach of copyright law. Try using data from an op...

Where can I find a list of all UK _full_ postcodes including street name and their precise coordinates?

Where can I find a list of all UK full postcodes including street name and their precise coordinates? They should be not like AB1, AB23 etc but AB1 2AA, AB23 5ZZ etc. Preferably for free :) Thanks ...

How to get post codes with given postcode and distance in miles or km?

Hi, My site needs postcodes display with given post code and distance (miles or km). I have to implement it using google api. Is it possible to do so? The country for which i need to use this is Australia. I am trying to find out the solution for two days. Can anyone help me out. Thanks in advance ...

format string (postcode) in ruby

I need to re-format a list of UK postcodes and have started with the following to strip whitespace and capitalize: postcode.upcase.gsub(/\s/,'') I now need to change the postcode so the new postcode will be in a format that will match the following regexp: ^([A-PR-UWYZ0-9][A-HK-Y0-9][AEHMNPRTVXY0-9]?[ABEHMNPRVWXY0-9]? {1,2}[0-9][ABD-...

Need to find latitude and longitude of postcodes and store into my database

Hey guys, Ive got a database full of UK Postcodes, now i'd like to be able to store the latitude and longitude of these specific postcodes along with the record with the database. Is there anyway that i can obtain this data free without violating any T&C's? I know i could do this using google maps api for each postcode, but i have wa...

Postcode and radius lookup recommendations

I look after a number of divisional websites for a uk based membership organisation and what we want to do is provide, as well as other address functions, is a closest member lookup to a web user from the websites themselves. A few use cases that I want to fill: Case 1: The user puts in their post code and wants to see all the members ...

UK Royal Mail PAF address finder via postcode alternatives?

Hello Guys, We need an address finder (premise level) based on postcode. We have a budget of 40k for this. But I have been assigned to find some cheaper alternatives for Royal mail PAF database. Is Google any good to find premise level address when you send full postcode. Any recommendation over Royal Mail PAF file. Any web services out...

Where is the now free UK postcode data to be found?

By all accounts the UK postcode address file (PAF) - a list of postcode with the matching addresses - is free now. I've had a good old nosey on the OS OpenData site (http://www.ordnancesurvey.co.uk/oswebsite/opendata/) but can't seem to find it. I can find geocoding stuff for each postcode BUT I want the addresses for each postcode. Or...