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
0
votes
1 answer

How to filter UK postcodes

I'm trying to match the first part of a UK postcode to those that I have held in a JSON file. I'm doing this in Vue. At the moment I have managed to match the postcode if it has 2 letters that match, but some UK postcodes do not start with 2…
Ash Bryant
  • 15
  • 4
0
votes
1 answer

Does postal code makes sense as partition key in CosmosDB for a global solution?

I have a CosmosDB collection for storing some places information that is using the postal code as partition key. The issue that I'm facing is that for some countries I'm not getting a postal code from google's reverse geocoding api response. Doing a…
0
votes
0 answers

How to get a post code & lat/lng coordinates in Google Sheets with an app script?

I want to get the postcode of a UK address (e.g 9 Mallinson Road, London) inside Google Sheets (e.g B1). I am using the below code in C1 =mapAddress(B1) to get the full postal address from Google (39 Mallinson Road, London, SW11 3BW). It works well.…
zakl
  • 1
  • 2
0
votes
1 answer

Using uk-postcode-utils in a python form

I am creating a form for the user to enter a valid UK postcode. I currently have the following code for the form: class RegisterForm(Form): first_name = StringField('First Name', validators=[DataRequired(), validators.Length(min=1, max=50)]) …
fg2210
  • 61
  • 1
  • 7
0
votes
1 answer

Get Indian postal codes from address string with other numbers

I am working on an Address parsing project where, I need to detect various components of the address, such as city, state, postal_code, street_no etc. I wrote a regular expression to filter out the postal codes handling all user inputs. sample_add =…
Piyush
  • 1
  • 3
0
votes
1 answer

Google Geocoding API Returning Wrong Zip/City

The address I am attempting to geocode is 1030 Pops Way, Bogart, GA 30622. Google seems to think this address is located in Watkinsville, GA 30677 and so returns Watkinsville and 30677. This is incorrect. Literally every other site listing…
0
votes
2 answers

Append data from table one to another - Syntax error?

I have two tables of zip code information, one without city and state fields (2016_Zips), the other is just a list (USZips_V1) of zip codes, the “Zip_Code” field is common in both tables. I'd like to match the more complete data (with fields for…
Phil C
  • 25
  • 1
  • 9
0
votes
6 answers

MySQL query to match UK postcodes regardless of the number of spaces

I have the simplest table in the world, for looking up lat/lng values for a UK postcode (loaded with full UK postcode data): CREATE TABLE postcodes ( postcode char(7) NOT NULL, lat double(10,6) NOT NULL, lng double(10,6) NOT NULL, KEY…
Jonny Nott
  • 328
  • 3
  • 14
0
votes
1 answer

PHP and Mysql not echoing my variable

Not sure if I have coded this incorrectly or if it is just because I have a very large database that I am trying to pull from. I'm not receiving any errors but there is just nothing being displayed on the page. Is having a large database an issue…
Dimsquid
  • 480
  • 1
  • 7
  • 21
0
votes
1 answer

Where to get worldwide City name, State/Province name, Postal/Zip code, Country, Latitude, Longitude data for free

For this site "http://download.geonames.org/export/zip/" I cant get only 85 countries. I referred "www.maxmind.com" they not provide postal/zip code.
Lavanya
  • 65
  • 1
  • 12
0
votes
2 answers

Postal code and Address

How to get an address based on the postal code? Which api should I call? I didn't find the answer from google map platform。 Geocoder can't get the detail address
zhu.px
  • 11
  • 1
0
votes
0 answers

UK Postcode - Sort by Distance

My database has a list of Pet Stores in UK as follows: ID: 1, Name: Store A, Location: Manchester, Postcode: ABC123, Phone: 1234567890 ID: 2, Name: Store B, Location: London, Postcode: XYZ123, Phone: 1234567890 ID: 3, Name: Store C, Location:…
0
votes
1 answer

Postcode url rewrite using IIS7 URL Rewrite not working

I have just started using IIS7 and am setting up various URL rewrites. I am new to this so I may be making a novice mistake. I am trying to rewrite a postcode so that I can have /KA71DR rewrite to /gis/property.asp?postcode=KA71DR I have the…
0
votes
1 answer

Error when excluding postcode

I've had an error come up with my regex in Ruby - The postcode BT9 6NZ managed to slip through written as BT96NZ - is there any way to edit this to make it foolproof to that? The code as I have it is…
0
votes
2 answers

C# - UK Postcode Regex Expression not working as expected?

I looked at many questions on this website such as this one for Regex Expression to validate UK Postcodes: I have the following examples: FA4 5SC [Valid] FA45SC [Valid] 1FA4 5SC [Invalid] I have the following code: static void Main(string[]…
Mr Nobody
  • 359
  • 3
  • 9
  • 23