Get 2001 and 2006 Census Data

[hxu]

See this project from the JMSC. They have the census data in Fusion Tables. However, the tables are kind of hard to get to. You have to read this JS file, extract the Fusion Table IDs, and paste them into the browser

https://www.google.com/fusiontables/data?docid=<ID GOES HERE>

The data is apparently on the Census CD-ROM, which would suggest that the 2006 data is probably on a CD-ROM somewhere too.

@2blam @hupili or anyone else at a University, could you maybe check if your library has these CD-ROMs?

[hupili]

We have 2001. First time library come useful...

--update

Can not find 2006 CD. There are printed versions.

[clacanzo]

guys, the graphical interface that this has is REALLY good. instead of going CA by CA, you can visualize by colours the whole map of hong kong and grasp an overall situation. if you do this, for example, setting the layer for "median" salary, you can see where richer people live and poorer people live... it's very user friendly! are you thinking to integrate some of this in ours as well?

[lvryc]

Hi,

I went though and extracted the ftencids (with the help of a little scripting). The following links point to csv versions of all the tables from that js file: https://www.google.com/fusiontables/exporttable?query=select+*+from+1DrdOtEJbOIWPWHlKMUiwJqNFR06zABvbMaDUzvw https://www.google.com/fusiontables/exporttable?query=select+*+from+1lkBqhOTkLBDlKIXkcl2-NL1txaAY1Sc1nJ0dKwE https://www.google.com/fusiontables/exporttable?query=select+*+from+1jdVQLXT6gtPXYgT9blaY1VZsgWLV9YObcP05dlI https://www.google.com/fusiontables/exporttable?query=select+*+from+1Uon4dw_ykTlBye1ZlSLSW7Aw2iz74ZOimRrnnDo https://www.google.com/fusiontables/exporttable?query=select+*+from+16qPupkV1sRAc3p4vKg34KvdVPlBEc3TlrAhhlQs https://www.google.com/fusiontables/exporttable?query=select+*+from+16uby-2UhhK0Z8RJhcgcTGRHghkvpmQVUu7g9Yl4 https://www.google.com/fusiontables/exporttable?query=select+*+from+1ElMQdby9BMxbLQbs91hU0xDDKBwO45-bAM11y4I https://www.google.com/fusiontables/exporttable?query=select+*+from+1yYRSo9uEF1Yy_cNril1S-UeWvU_yX5kxuGu-QVw https://www.google.com/fusiontables/exporttable?query=select+*+from+1v7RF7lffB2XPcSkDe0gzufh_a3k1Y5rTRyW9UaI https://www.google.com/fusiontables/exporttable?query=select+*+from+1gDVQDRfGUzijbZNa5zW9AfRo1xx7V7_PIalEs1E

The last two don't seem to work, though, for some reason. :/