Questions tagged [postal-code]

A postal code is a series of letters and/or digits which is useful to identify the a particular region within a postal address. Once postal codes were introduced, other applications became possible.

A postal code is a series of letters and/or digits which is useful to identify the a particular region within a postal address. Once postal codes were introduced, other applications became possible.

In February 2005, 117 of the 190 member countries of the Universal Postal Union had postal code systems. Countries that do not have national systems include Ireland and Panama. Although Hong Kong and Macau are now Special Administrative Regions of China, each maintains its own long-established postal system, which does not utilize postal codes for domestic mail, and no postal codes are assigned to Hong Kong and Macau. Mail between Hong Kong, Macau and mainland China is treated as international.

399 questions
1
vote
1 answer

Matching long string (full postcode) agains short string (start of postcode) in mysql

I have a table that contains a list of the starting letters in a post code e.g. LS for Leeds and SO for Southampton. I want to match these against a user entered full postcode e.g. LS19 1AB. I've looked into using LIKE and some regexp stuff in my…
1
vote
3 answers

How to find candian postal code between low and High by SQL Server or c#

I just want to know how to find Canada or UK postal between low and High Postal code. For Example: Low postal code: A0A0A0 and High is: A0Z9Z9 How to find postal code between these postal A0A0A0 and A0Z9Z9?
Shishant
  • 69
  • 6
1
vote
1 answer

Postcode Radius Search

Ok, so I was asked to create a postcode search script. I'm still quite new to the more advanced php/mysql. All i'm needing is help simplifying this script. The Postcode database is the entire UK postcode sql database 1.3m rows. So when I'm using the…
1
vote
2 answers

Select records based on the postal code and it's radius in MySQL

Below is my postal table with a few records. In fact this table contains all cities and all postal codes. id city postalcode latitude longitude 1 Drogteropslagen 7705 PA 52.61666700 6.50000000 2 …
O Connor
  • 4,236
  • 15
  • 50
  • 91
1
vote
0 answers

I want to retrieve Postal_Code/ ZipCode specifically in Pakistan using google Api or any other one

I have gone through the different question here on Stackoverflow but none of them helped me out yet. I am using google API in my app and needs to retrieve the zipcode. Currently I am getting all the other parameters but zipcode. Any…
1
vote
1 answer

How do I look up a UK address based on house number and postcode?

Given a house number and postcode in the UK, how can I translate this into a full mailing address?
Emil Borconi
  • 3,326
  • 2
  • 24
  • 40
1
vote
2 answers

How to concatenate multiple solr tokens into one

In Solr, when merging tokens using solr.ShingleFilterFactory, it may generate multiple Shingles depending on the min/maxShingleSize and tokens to merged. Due to this, search fails. How can I merge multiple tokens into one so that my search works.…
1
vote
1 answer

get postcode from latitude,longitude

I have downloaded the UK postcode list from http://www.ordnancesurvey.co.uk/oswebsite/opendata/index.html and installed it in a MSSQL 2005 database. The table consists of postcode, latitude and longitude. I need an efficient method to get the…
Pierce
  • 11
  • 4
1
vote
1 answer

UK postcode regex validation

I was looking for a valid UK postcode regex pattern, but seems that any of them work as a traditional or normal regex. I test all patterns using this tool: https://regex101.com/ The regex I found in this document…
Pablo Ezequiel Leone
  • 1,337
  • 17
  • 22
1
vote
2 answers

Get first part of UK postcode only

I'm trying to get the first part of a UK postcode from a string that may have only the first part of the postcode or the full postcode in it. I'm struggling to make it work. I've got it working if the full postcode is entered by using a look-ahead,…
Styphon
  • 10,304
  • 9
  • 52
  • 86
1
vote
2 answers

How to get Geo-Locations using Postal Code

Writing a program in which i have to show near by places using postal code so for that first of all i have to get geo locations by using user's postal code (postal code accepted by user) and then need to show near by locations from that…
Sun
  • 6,768
  • 25
  • 76
  • 131
1
vote
1 answer

Check if postal code is in a range

this might be a dumb question but I'm new to iOS programming and I just couldn't think of anything. for my app I need to check if a certain postal code is in a range. It's easy to do for German or US codes which are plain numbers, but now I have to…
user3347446
  • 133
  • 2
  • 9
1
vote
1 answer

SQL Server 2008 UK postcode text manipulation - Exact to district or suffix level

I have some data like below: W2 2JP W14 9NF W1K 5PE W1K 5PE SW7 5EU W1K 5PE N2 9QB I would like to have output like: W2 W14 W1 W1 SW7 W1 N2 Any help or direction appreciated, I can find and replace to where I get everthing to left of ' ' but…
finngeraghty
  • 107
  • 1
  • 8
1
vote
2 answers

City, Province/State, Country to Postal Code

I need to programmatically find approximate postal/zip code for a given city. When I use this link: http://maps.googleapis.com/maps/api/geocode/xmladdress=vancouver,BC,Canada&components=country:CA it brings me all location information except postal…
Aslan
  • 148
  • 7
1
vote
1 answer

Postal-code validator for all countries in the world in Java

Want solution in Java which does the following: Input : Locale code (Example: "en_US") Postal code(Example: "NH 3301") --> Valid Similarly for any other country in the World, it should validate the corresponding Postal code. Is there any…
xtras
  • 116
  • 4
  • 15