Thursday, April 6, 2006

DA population counts for South Vancouver Island

Question

A student is wanting population counts that he can join to a 2001 arcinfo file for British Columbia (gda_059b02a_e.exe). We loaded this file into ArcView but this file does not appear to have population counts included as attribute data.

I am remembering from our 2005 ACCOLEDS workshop that we did some data joining exercises. But I do not know how to find the 2001 Census file that has population data at the DA level that can be joined to gda_059b02a_e.exe

The student is interested specifically in the population counts for the DA's on South Vancouver Island, but he needs this data in a
format that he can use with ArcView.

Answers

1. The file is on the DLI ftp site in
/census/2001/B2020/Topic-Based-Tabulations/pop-dwelling-b2020

For DA level, you want file 93f0050xcb01010-ivt.zip

2. Do you have access to the Canadian Census Analyser through CHASS? The data is available there at the DA level. The DA code will be included with the data and you can ask for the CD code as well. The student will need to clean the data to merge the CD and DA code in the right order. Just reverse them in Excel, add a column in the middle, and then open the file in WordPad to do a search and replace for the double commas to get rid of them (which merges the columns).

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.