Solved

How many Lat/Long for a single UK Postcode

Posted on 2016-11-29
5
31 Views
Last Modified: 2017-01-17
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

776 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