Get the Number Of Units in Each HDB Flat Within a Range of Postal Code in Singapore

hdb_num_flat.py

__author__ = 'yuan3y'

import xml.etree.ElementTree as ET
import urllib.request as re
import datetime

for post_code in range(510000,530000):
    current_time = datetime.datetime.now()
    unix_timestamp = str(int(current_time.timestamp() * 1000))
    postal_code = str(post_code)
    url = 'http://services2.hdb.gov.sg/webapp/BC16AWPropInfoXML/BC16SRetrieveResiUnitCountXML?systemID=BC16&programName=FI10&postalCode={0}&_={1}'.format(
        postal_code, unix_timestamp)
    headers = {
        'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.152 Safari/537.36'}
    req = re.Request(url, headers=headers)
    xml_string = re.urlopen(req).read()
    root = ET.fromstring(xml_string)

    error = root.find('ErrorCode')
    count = 0
    if error.text == '0000':
        for res_unit in root.findall('ResidentUnit'):
            count += int(res_unit.find('count').text)
        print(post_code, count)
        with open("tampines.csv", 'a') as f:
            print(post_code, count, sep=',', file=f)
    else:
        print(post_code, "err", error.text)
        pass
print("done")

tampines.csv