Malaysia Postcode Database

I've just updated the Malaysia Postcode Database. The data is written in CSV format and you can dump it into any database you are currently using.

Here is the sample of the content of CSV file:

"30020","Taman Meru Fasa 4","Ipoh","PRK","4.660017","101.070292"
"30020","Taman Meru Height","Ipoh","PRK","4.61175","101.113506"
"30020","Taman Meru Impiana","Ipoh","PRK","4.604263","101.05764"
"30020","Taman Meru Jaya","Ipoh","PRK","4.663615","101.073297"
"30020","Taman Meru Perdana","Ipoh","PRK","4.640724","101.09432"
"30020","Taman Meru Permai","Ipoh","PRK","4.646262","101.06778"
"30020","Taman Meru Raya","Ipoh","PRK","4.61175","101.113506"

If you need the MySQL statements to create your database table, here is it:

CREATE TABLE malaysia_postcode (
  postcode CHAR(5) NOT NULL,
  location VARCHAR(80) NOT NULL,
  post_office VARCHAR(30) NOT NULL,
  state_code CHAR(3) NOT NULL,
  latitude DOUBLE NOT NULL,
  longitude DOUBLE NOT NULL
)
ENGINE = MyISAM;

Meanwhile, you can use following statement to load the data into your database table.

LOAD DATA LOCAL INFILE 'malaysia_postcode.csv' INTO TABLE malaysia_postcode FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;
I have made a dedicated website for this project. Future updates will available at http://malaysiapostcode.com/

21 Comments

  1. Nicholas Ng

    Good Job!!

  1. Mark

    Hi, thanks for this. What is the projection for the Long/Lat coordinates?

  1. Kiklopes

    Thanks you... nice work :D

  1. kelly

    Thank you. You did a great work.

  1. WH

    Hi Seikan, nice work! Can i known how you get this list? or are you intrested to work in KL? contact me pls. Thx.

  1. sasuke

    Cool!

  1. BP

    hi Seikan,
    would you have the latest post code for malaysia... appreciate if you can help to reply at the earliest
    thanks, BP

  1. Josh

    Useful, Thanks a lot~

  1. sayed

    Good day

    I am interested in establishing and operating a viable business as a means of investment in your country.

  1. jayani

    what is the postal code of Highton? this is urgent

  1. Ahmad Izzuddin

    thank you for the list. :-)

  1. Intan

    Makasih kode pos laysianya, izin download.

  1. Ir Che Din

    Sir, Can I get your contact no?

  1. Azman

    terima kasih for the hardwork

Leave a Comment

Your email address will not be published. Required fields are marked *