Custom SQL query

centadatabuildings

buildingcode, region, buildingname, buildingaddress, buildingaddresschinese, dateofcompletion, numberofunits, numberoffloors, flatsperfloor...

43,880 rows

centadatalatlong

buildingcode, latitude, longitude

Many rows

centadatanewtransactions

type1, code1, name1, name1e, type2, code2, name2, name2e, type3...

Many rows

centadatatransactions

buildingcode, unitcode, unitaddress, saleablearea, grossarea, txdate, price

Many rows

centadatatransactionsunits

buildingcode, unitcode, floorPlan, header, transRecords

Many rows