Question
If I recall properly, the census numbers used to be perturbed during rounding - is this the case with the 2006 Census?
Answer
Below is the description of how random rounding is used and how it applies to data for the 2006 Census. The information was provided by our Census Consultants and comes from pages 6 and 7 of "Data Quality and Confidentiality Standards and Guidelines" for the 2006 Census
(http://www12.statcan.ca/english/census06/reference/notes/DQguidelines/PDF/2006-DQ-Public-Guide-E.pdf).
From pages 6-7
2.2. Random rounding
All counts in census tabulations are subjected to a process called random rounding. Random rounding transforms all raw counts to random rounded counts. This reduces the possibility of identifying individuals within the tabulations. For 2A (100%) data, all counts are rounded to a base
of 5. This means that all 2A counts will end in either 0 or 5. The random rounding algorithm employed controls the results and rounds the unit value
of the count according to a pre-determined frequency.
2B (20%) data require a slightly different random rounding algorithm. All counts greater than 10 are rounded to base 5, as is done for 2A data. Counts less than 10 are rounded to base 10. This means that any 2B counts less than 10 will always be changed to 0 or 10. The table below shows the effect of rounding on 2B counts with a value less than 10.
The random rounding algorithm uses a random seed value to initiate the rounding pattern for tables. In these routines, the method used to seed the
pattern can result in the same count in the same table being rounded up in one execution and rounded down in the next.
Wednesday, January 16, 2008
FED Land Area & Population
Question
A researcher at McMaster is looking for population density data of Canadian Federal Electoral Districts from 1972 to present. So the researcher needs land areas and populations for each FED. Does anyone know where this data might be available?
Answer
The Geography Division recommends that your client use the 1991 - 2006 GeoSuite products to get the population data for FEDs. Beyond 1991, the Geography Division suggests that you use the Geographic Attribute File (GAF) files, which go back to 1971, to get the population data. The GAF, their user guides and record layouts are available in the Geography folder on the DLI FTP site. (Please note that there is no user guide for the 1996 GAF, only a record layout.)
Geosuite 2006 and 2001 will also provide you with land area for FEDs. GeoSuite1996 and GeoSuite1991 do not have land area for FEDs however, nor do the GAF files. You may need to refer to print publications or other sources to find FED land areas for 1996 and previous years.
A researcher at McMaster is looking for population density data of Canadian Federal Electoral Districts from 1972 to present. So the researcher needs land areas and populations for each FED. Does anyone know where this data might be available?
Answer
The Geography Division recommends that your client use the 1991 - 2006 GeoSuite products to get the population data for FEDs. Beyond 1991, the Geography Division suggests that you use the Geographic Attribute File (GAF) files, which go back to 1971, to get the population data. The GAF, their user guides and record layouts are available in the Geography folder on the DLI FTP site. (Please note that there is no user guide for the 1996 GAF, only a record layout.)
Geosuite 2006 and 2001 will also provide you with land area for FEDs. GeoSuite1996 and GeoSuite1991 do not have land area for FEDs however, nor do the GAF files. You may need to refer to print publications or other sources to find FED land areas for 1996 and previous years.
Monday, January 14, 2008
Publication of Beyond 20/20 Tables in Textbook
Question
I know part of the answer to this question, but I was hoping for a bit more clarification. A professor here is writing a textbook and wants to generate tables in Beyond 20/20 (I think using homicide/victim/crime data) and wants to know if she can use them in her book. Now, I'm pretty sure that if she is getting the B2020 tables from DLI, the answer is NO and that she would need to seek permission directly. However, what if she is getting them from E-Stat? I suspect the answer is still no because E-Stat is for educational use? AND, what if she generates them on the Stat-Can website and then pays for the time series that way? Any help/clarification you can provide is much appreciated.
Answer
Publishing Statistics Canada products in textbooks falls outside the DLI license. The Regional Office should help your professor get the approval she needs.
The DLI Licensing database on the DLI website says, "Faculty are referred to the Marketing Division of Statistics Canada for discussions on textbook licensing."
I know part of the answer to this question, but I was hoping for a bit more clarification. A professor here is writing a textbook and wants to generate tables in Beyond 20/20 (I think using homicide/victim/crime data) and wants to know if she can use them in her book. Now, I'm pretty sure that if she is getting the B2020 tables from DLI, the answer is NO and that she would need to seek permission directly. However, what if she is getting them from E-Stat? I suspect the answer is still no because E-Stat is for educational use? AND, what if she generates them on the Stat-Can website and then pays for the time series that way? Any help/clarification you can provide is much appreciated.
Answer
Publishing Statistics Canada products in textbooks falls outside the DLI license. The Regional Office should help your professor get the approval she needs.
The DLI Licensing database on the DLI website says, "Faculty are referred to the Marketing Division of Statistics Canada for discussions on textbook licensing."
Wednesday, December 19, 2007
Kitimat CA / CSD
Question
I am a little baffled about something that's probably obvious. I just printed off two DAuid lists from GeoSuite: one for the CSD of Kitimat (the DM) and one for the Kitimat CA . I got the same list of 15 DAuids for both. I thought this was kind of strange, so I brought up the 2006 Community Profiles for each of these areas. The land area and population is exactly the same for both. GeoSuite confirmed this. Somehow I would have thought that the CSD would be a smaller area than the CA.
Answer
This is the definition of a CA:
A census agglomeration must have an urban core population of at least 10,000. A census agglomeration (CA) is formed by one or more adjacent municipalities centred on a large urban area (known as the urban core). A CA must have an urban core population of at least 10,000. To be included in the CMA or CA, other adjacent municipalities must have a high degree of integration with the central urban area, as measured by commuting flows derived from census place of work data.
It not often, but it happens that a CA is one equivalent to one CSD in which you find the appropriate urban core of at least 10,000 population and that the total population for that CSD is at least 10,000
For Kitimat, the CA is based on the population of the previous census, that is 2001, and the population was 10,285 with an urban core of at least 10,000. It may not be a CA in 2011 since the population is now below 10,000, thus the urban core is now lower than the treshold of 10,000 people.
And yes, the CA is equal to the CSD in this case and beware that it may not be a CA when Geography Division do their revision for the 2011 Census.
I am a little baffled about something that's probably obvious. I just printed off two DAuid lists from GeoSuite: one for the CSD of Kitimat (the DM) and one for the Kitimat CA . I got the same list of 15 DAuids for both. I thought this was kind of strange, so I brought up the 2006 Community Profiles for each of these areas. The land area and population is exactly the same for both. GeoSuite confirmed this. Somehow I would have thought that the CSD would be a smaller area than the CA.
Answer
This is the definition of a CA:
A census agglomeration must have an urban core population of at least 10,000. A census agglomeration (CA) is formed by one or more adjacent municipalities centred on a large urban area (known as the urban core). A CA must have an urban core population of at least 10,000. To be included in the CMA or CA, other adjacent municipalities must have a high degree of integration with the central urban area, as measured by commuting flows derived from census place of work data.
It not often, but it happens that a CA is one equivalent to one CSD in which you find the appropriate urban core of at least 10,000 population and that the total population for that CSD is at least 10,000
For Kitimat, the CA is based on the population of the previous census, that is 2001, and the population was 10,285 with an urban core of at least 10,000. It may not be a CA in 2011 since the population is now below 10,000, thus the urban core is now lower than the treshold of 10,000 people.
And yes, the CA is equal to the CSD in this case and beware that it may not be a CA when Geography Division do their revision for the 2011 Census.
Tuesday, December 18, 2007
Updated Products - PEA (Provincial Economic Accounts)
Provincial Economic Accounts (PEA)
The following files have been added:
13-001 - National Income and Expenditure Accounts - Quarterly Estimates -Third Quarter 2007
13-014 - Financial Flow Accounts - Quarterly Estimates -Third Quarter 2007
13-214 - National Balance Sheet Accounts, Quarterly Estimates - Third Quarter 2007
13f0016 - Estimates of Labour Income - Monthly Estimates - September 2007
Web: http://www.statcan.ca/english/Dli/Data/Ftp/pea.htm
FTP: /ftp/dli/pea
The following files have been added:
13-001 - National Income and Expenditure Accounts - Quarterly Estimates -Third Quarter 2007
13-014 - Financial Flow Accounts - Quarterly Estimates -Third Quarter 2007
13-214 - National Balance Sheet Accounts, Quarterly Estimates - Third Quarter 2007
13f0016 - Estimates of Labour Income - Monthly Estimates - September 2007
Web: http://www.statcan.ca/english/Dli/Data/Ftp/pea.htm
FTP: /ftp/dli/pea
Census Tract Crime Statistics
Question
I have a researcher looking for any available crime data for a census tract in Prince George (actually, he's looking for the data for a neighbourhood, but this Census Tract comes pretty close to covering it). I don't think we have access to anything at that geography, but I thought I'd better check to be sure. If not, are custom tabulations possible?
Answer
I checked with the Canadian Centre for Justice Statistics and census tract level crime data isn't available. The lowest geographical area for which they can provide crime data is the police service level. They told me that Prince George has 2 respondents, an RCMP Municipal Force (59710 respondent code) and a RCMP Rural Detachment (59831 respondent code). Both of these forces send them crime data for their respective jurisdictions (areas of responsibility).
We have this data in the DLI collection the Crime Statistics "All Police services, 1977-2006" (ps_all.zip) file
(http://www.statcan.ca/english/Dli/Data/Ftp/justice.htm).
You can open the ps_all.zip file and search for Prince George or the respondent code.
I have a researcher looking for any available crime data for a census tract in Prince George (actually, he's looking for the data for a neighbourhood, but this Census Tract comes pretty close to covering it). I don't think we have access to anything at that geography, but I thought I'd better check to be sure. If not, are custom tabulations possible?
Answer
I checked with the Canadian Centre for Justice Statistics and census tract level crime data isn't available. The lowest geographical area for which they can provide crime data is the police service level. They told me that Prince George has 2 respondents, an RCMP Municipal Force (59710 respondent code) and a RCMP Rural Detachment (59831 respondent code). Both of these forces send them crime data for their respective jurisdictions (areas of responsibility).
We have this data in the DLI collection the Crime Statistics "All Police services, 1977-2006" (ps_all.zip) file
(http://www.statcan.ca/english/Dli/Data/Ftp/justice.htm).
You can open the ps_all.zip file and search for Prince George or the respondent code.
Tuesday, December 11, 2007
First Nations Reserves in Ontario
Question
A faculty member here needs a list of all the reserves in Ontario with their population figures. I thought I had seen this somewhere once, but now I can't locate it anywhere. If it exists, I'd like to know where; if not, how can I generate one?
Answer
Applicable information can be found in the First Nations profiles, at
http://sdiprod2.inac.gc.ca/FNProfiles
and the 2001 Census Aboriginal Population Profiles available at
http://www12.statcan.ca/english/Profil01/AP01/Search/List/Page.cfm?Lang=E&GeoCode=35
A faculty member here needs a list of all the reserves in Ontario with their population figures. I thought I had seen this somewhere once, but now I can't locate it anywhere. If it exists, I'd like to know where; if not, how can I generate one?
Answer
Applicable information can be found in the First Nations profiles, at
http://sdiprod2.inac.gc.ca/FNProfiles
and the 2001 Census Aboriginal Population Profiles available at
http://www12.statcan.ca/english/Profil01/AP01/Search/List/Page.cfm?Lang=E&GeoCode=35
Subscribe to:
Posts (Atom)