Street database of United Kingdom in Excel, SQL, CSV or XML download

Database of streets, addresses in United Kingdom

This type of database provides a list of streets for many types of projects. To help developers better understand the possibilities, here is a shortlist of possible applications of the database:

• Form entry.
• Development of applications requiring the use of postal data.
• Pre-fill in the street name more easily in a form requesting a postal address.
• Verify the correctness of an address entered by a user.
• Generate the postal address of a profile, based on real data.
• For an application that already has postal addresses, this database of addresses makes it easier to cross-reference the data and to group buildings, establishments, or customers more easily, based on their postal addresses.
• Autocomplete city and location entry using the best localities dataset
• Make various statistics to know the number of "blocks" or "driveway" for each area of United Kingdom. Same if they wish to know the number of the streets called "Rose Cottage"  in United Kingdom.

Did you know: in United Kingdom there are 2 183 026 streets / avenues / places / driveways / boulevards / roads... associated with the name of "Rose Cottage"!

Table of streets in United Kingdom:

• Iso: country code (INSEE code)
• Country: country wording
• Region: Name of the region
• Commune name: full name of the commune
• Postal code: postal code
• Street: full street name, with the type of lane
• Latitude: GPS coordinates
• Longitude: GPS coordinates
• Elevation: GPS coordinates

Table of communes in United Kingdom:

• Iso: country code (INSEE code)
• Country: country wording
• Region: Name of the region
• Commune name: full name of the commune, city, or locality
• Postal code: postal code or zip

Take note: for a more complete list, please use the more complete list of communes in United Kingdom. The INSEE code is used as a reference to link the data together in a unique dataset.

Table of departments/region in United Kingdom:

• Iso: country code (INSEE code)
• Country: country wording
• Region 1: main region
• Region 2: secondary region
• Region 3: Tertiary region
• Region 4: regional sub-division

Take note:

• The dataset contains 2 183 026 streets, spread over 1 717 888 towns and cities in United Kingdom, as well as postcodes.
• Every week, streets are added, modified, or deleted.