Solved

# How many Lat/Long for a single UK Postcode

Posted on 2016-11-29
12 Views
Hi guys,

How many number of Lat/Long a single UK Postcode can have?

regards,
0
Question by:shah36
• 3
• 2

LVL 25

Expert Comment

ID: 41905726
Postcode areas are not a set size. They're a division that holds a "number of addresses". Population density in a built up area could be very high for a given postcode, so the postcode area could be very small, whereas rural areas will be bigger.
0

Author Comment

ID: 41905871
Thanks for your answer Lee, I understand that each postcode can have number of addresses. Does the same applies to the Lat/Longs?
Can a postcode have number of Lat/Longs or is it one-to-one relationship between postcodes and lat/longs?
0

LVL 25

Assisted Solution

Lee Savidge earned 500 total points
ID: 41905895
There is no direct relationship between lat/long and a postcode. Lat/long points exist across the entire globe. If you pick a lat/long point on the UK map, there will be a postcode there. Check the map here:

https://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom

You can see each postcode area for the UK but there could be more than one lat/long point in it.

Every lat/long point in the UK will have a postcode under it, but not every postcode is a single lat/long point. They aren't related.
0

LVL 25

Accepted Solution

Lee Savidge earned 500 total points
ID: 41905896
If you're looking to do a postcode lookup, you need access to the PAF database from the Royal Mail or use a webservice on the Internet that can do the lookup for you.
0

Author Closing Comment

ID: 41905926
0

## Featured Post

### Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.