Solved

How many Lat/Long for a single UK Postcode

Posted on 2016-11-29
5
12 Views
Last Modified: 2016-11-29
Hi guys,

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

regards,
0
Comment
Question by:shah36
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
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

by:shah36
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

by:Lee Savidge
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

by:
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

by:shah36
ID: 41905926
Thanks a lot for your help. This answers my question.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now