« 20.07.2007
MS-SQL - List trigger in your db. »

Duplicate postcode in Malaysia National Postcode System.

Hi guys,

I know something new today. Do you know that we have a duplicate data in malaysia postcode ? What i mean is that, there is one postcode tagged to two states in Malaysia.

I don’t know this until today when I do my extraction query to give a pool of data to user and I cannot get the data as per what I expected because of this thing. It take me hours to figure this out.grrrrr….

I did a search in Pos Malaysia website and guess what ?

I found out that,postcode 39000 is tagged to two states – Pahang and Perak. I don’t know if there is other case like this.

This data is taken from Pos Malaysia website using Location Finder :

postcode 1postcode 2

Well, that’s all I want to tell you guys today.

List of postal codes in Malaysia

Till then….adios

p/s : Honey, I will try to improve my writing skills.

This is because my wife complaint about my writing skills in this blog.ehehe..the truth is, I don’t have idea how to write my blog with ‘flower-flower’ language and also It is because of my limitation in english vocabulary.

[Ask] [Bloglines] [del.icio.us] [Digg] [Furl] [StumbleUpon] [Technorati] More »

If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !

Related Post:
  • PHP Programmer Malaysia group
  • Life is an Open Secret
  • SQL: Union And Union ALL
  • Extract, Transform and Load (ETL) - Part 2
  • Extract, Transform and Load (ETL)



    • Can't find what you are looking for? Go Gooogle...
    Google

    2 Responses to “Duplicate postcode in Malaysia National Postcode System.”

    1. C H on April 18th, 2008 at 9:50 am Using Internet Explorer Internet Explorer 7.0 on Windows Windows Vista

      Friend,

      Eventhough the state is publish as Pahang and Perak, but they are located in the same area - Tanah Rata - Cameron Highlands.

      Physically, they did not allocate the postcode to 2 states, but only to one unique location, Tanah Rata.

    2. arejae on April 18th, 2008 at 11:26 am Using Internet Explorer Internet Explorer 7.0 on Windows Windows XP

      Friend, thanks for comment.

      yeah…i can see it is assign to one unique location. but still, my state statistic is not correct if i were to lookup using postcode for my customer database . the total number will be slightly differ.

    Leave a Reply

    AWSOM Powered