Update:
For the CCHS 2015-2016 PUMF—released in January— a new geographic classification variable (ALECLASS) based on open source data was added to the file. This variable is a categorical measure of the favourability of active living environment of each respondent based on their dissemination area and its intersection/dwelling density, as well as points of interest. Due to the addition of this variable, further data suppression was applied on the 2015-2016 PUMF to avoid disclosure risks. We are looking for any feedback you may have on the usefulness of the ALECLASS variable to help us determine if it should be added to the 2017-2018 PUMF. For the 2017-2018 PUMF there will be data on both physical activity and sedentary behaviors, so we see a potential usefulness, but would like to get a sense of how much the concept has been used so far.
Wednesday, July 24, 2019
Tuesday, July 23, 2019
Census data for Canadians of Bangladeshi origin
Question:
I have a faculty member looking for all census data (income, education, work, housing, etc) for people of Bangladeshi origin for Edmonton, Calgary, Alberta, and Canada. Does this require a custom tabulation?
Answer:
I’ve received the following reply from subject matter:
“We have the following 2016 data table available. Your client can use the filters to select their desired Geography and Ethnic origin at the top of the page.”
If this is not sufficient, we will have to go the custom tab route.
I have a faculty member looking for all census data (income, education, work, housing, etc) for people of Bangladeshi origin for Edmonton, Calgary, Alberta, and Canada. Does this require a custom tabulation?
Answer:
I’ve received the following reply from subject matter:
“We have the following 2016 data table available. Your client can use the filters to select their desired Geography and Ethnic origin at the top of the page.”
If this is not sufficient, we will have to go the custom tab route.
Labels:
Census
Thursday, July 18, 2019
ADAs and DAs correspondence files pre-census 2016
Question:
A researcher at Dalhousie has expressed interest in using the ADA as her unit of analysis. Since ADA is a new dissemination geography created for census 2016 and her research included pre-census 2016 time period, she would like to know if it is possible for Stat Can to provide
A researcher at Dalhousie has expressed interest in using the ADA as her unit of analysis. Since ADA is a new dissemination geography created for census 2016 and her research included pre-census 2016 time period, she would like to know if it is possible for Stat Can to provide
- DAs and ADAs correspondence for each census year pre-census 2016. Using GeoSuite 2016 it is possible to generate DAuid corresponding to ADAcode. This is not possible pre-census 2016.
- correspondence file that describe the ADAs between two censuses. For examples
- census 2016 ADAs corresponding to census 2011 ADAs
- census 2011 ADAs corresponding to census 2006 ADAs
- and so on
Answer:
I’ve received the following response from subject matter:
“As noted, there are no ADAs prior to 2016. Correspondences could be created between different census years, since a link is maintained on the geoframe between current census and previous census, at the lowest levels of geography. So, what could be created would be:
2011 DA — 2016 ADA
2006 DA — 2016 ADA
2001 DA — 2016 ADA
Etc.
Because there is no such thing as an ADA prior to 2016, the concept of 2011 ADA — 2016 ADA does not really exist. All that could be provided is groupings of previous DAs that are close to equivalent to the current ADAs.”
This would all need to be done through a custom tabulation however.
We do also produce correspondence files between the DAs for each census and its previous census. Those files are available on the Geography website, or I could see about the potential of having them added to the EFT (if they are not already there).
Labels:
Census
Friday, July 12, 2019
a different PCCF+ question: collaboration btwn 2 institutions, each with a PCCF+ license
Question:
I’ve been contacted by a researcher at [the university] who is collaborating with the regional government on a project. Both [the university] and the government group have PCCF+ licenses that forbid access to the data by anyone outside the institution named in the license. Do they each have to work in parallel with separate copies of the PCCF+ and essentially produce two separate but equal copies of the results, or can common sense prevail here since both groups have licensed access?
Answer:
Since both parties have valid end use licences and are collaborating on the same project, they can produce the results together
I’ve been contacted by a researcher at [the university] who is collaborating with the regional government on a project. Both [the university] and the government group have PCCF+ licenses that forbid access to the data by anyone outside the institution named in the license. Do they each have to work in parallel with separate copies of the PCCF+ and essentially produce two separate but equal copies of the results, or can common sense prevail here since both groups have licensed access?
Answer:
Since both parties have valid end use licences and are collaborating on the same project, they can produce the results together
Labels:
DLI Access,
PCCF/PCCF+
PCCF+ Question about Residential Postal Code File
Question:
I’m looking at the November 2018 (V 7b) files and the file labeled ‘Residential postal code file’ does not appear to contain residential postal codes. Is this a mistake?
I don’t use PCCF+ very often and would like to know where I can find the list of national residential postal codes. There is a file called “Unique postal codes from PCCF” which appears to be what I’m looking for but I can’t find documentation to support this. Also—why is it called ‘unique postal codes’
Answer:
I apologize but I don’t seem to see the “Residential postal code file”?
I’ve double checked with the PCCF team and they’ve said the following:
“As per our agreement with Canada Post, we are not able to share a list of all residential postal codes in Canada – the data are proprietary. The purpose of the PCCF+ is to match USER lists of postal codes with our census geography. The client needs to have their own list of postal codes in order to use PCCF+.
The file indicating “unique postal codes” is a list of unique matches to the PCCF – so it is not a full list of residential postal codes either.
I apologize, but we do not provide a master list. The client may wish to approach Canada Post for access to these data.”
I’m looking at the November 2018 (V 7b) files and the file labeled ‘Residential postal code file’ does not appear to contain residential postal codes. Is this a mistake?
I don’t use PCCF+ very often and would like to know where I can find the list of national residential postal codes. There is a file called “Unique postal codes from PCCF” which appears to be what I’m looking for but I can’t find documentation to support this. Also—why is it called ‘unique postal codes’
Answer:
I apologize but I don’t seem to see the “Residential postal code file”?
I’ve double checked with the PCCF team and they’ve said the following:
“As per our agreement with Canada Post, we are not able to share a list of all residential postal codes in Canada – the data are proprietary. The purpose of the PCCF+ is to match USER lists of postal codes with our census geography. The client needs to have their own list of postal codes in order to use PCCF+.
The file indicating “unique postal codes” is a list of unique matches to the PCCF – so it is not a full list of residential postal codes either.
I apologize, but we do not provide a master list. The client may wish to approach Canada Post for access to these data.”
Labels:
PCCF/PCCF+
Thursday, July 11, 2019
CCHS PUMFs and Sexual Orientation
Question:
I have a researcher wanting to use the CCHS PUMFs to look at the sexual identity variable, but even though the question has been asked in the Socio-Demographic portion of the questionnaire since Cycle 2.1 and reports have been published citing the data (such as https://www150.statcan.gc.ca/n1/daily-quotidien/040615/dq040615b-eng.htm) neither of us can find this variable in any file other than the 2015-16 cycle. I hope we are not just missing something, but perhaps there is a reason this information was not made part of the PUMF files?
Answer:
I’ve received the following response from subject matter:
“In the past, the subject matter team preparing the PUMFs for release considered the sexual orientation concept as an indirect identifier and chose not to include it with the file. In 2015-2016, our team requested to the Microdata Release Committee to allow us to add the variable to our 2015-2016 PUMF. They agreed that the risk of disclosure was low and approved the addition of the variable. We will continue to assess the risk, but I imagine we will continue with the release of that variable going forward.”
I have a researcher wanting to use the CCHS PUMFs to look at the sexual identity variable, but even though the question has been asked in the Socio-Demographic portion of the questionnaire since Cycle 2.1 and reports have been published citing the data (such as https://www150.statcan.gc.ca/n1/daily-quotidien/040615/dq040615b-eng.htm) neither of us can find this variable in any file other than the 2015-16 cycle. I hope we are not just missing something, but perhaps there is a reason this information was not made part of the PUMF files?
Answer:
I’ve received the following response from subject matter:
“In the past, the subject matter team preparing the PUMFs for release considered the sexual orientation concept as an indirect identifier and chose not to include it with the file. In 2015-2016, our team requested to the Microdata Release Committee to allow us to add the variable to our 2015-2016 PUMF. They agreed that the risk of disclosure was low and approved the addition of the variable. We will continue to assess the risk, but I imagine we will continue with the release of that variable going forward.”
Tuesday, July 9, 2019
Financial Data for Specific Industries at the Provincial Level
Question:
A researcher here is looking for some data for specific NAICS codes. We’ve found some information at the national level, and some provincial information at higher NAICS groupings, but nothing with both the level of industry and geographic detail he wants. He’s willing to purchase a custom tabulation if necessary.
Specifically he is asking for:
Annual, (total capital expenditures) for (NAICS 22111, 22112, 23713) for each province/territory, from 2007 to the most current date;
Annual, (total federal taxes, total provincial taxes) for (NAICS 22111, 22112, 23713) for each province/territory, from 2007 to the most current date.
Table 34-10-0035-01 gives capital expenditures at the provincial level, but at the two digit level only. 33-10-0007-01 has taxation but is also at the two-digit level. Am I missing an available source? Would this level of detail be available from a custom tabulation?
Answer:
I’ve received the following response from subject matter:
“We have data on taxes on production and products for NAICS 2211 and 23, but the data is not broken down by level of government. We have data on capital expenditures, but only for NAICS 221 and 23. This data would be available from 2007 to 2015, by province and territory.”
A researcher here is looking for some data for specific NAICS codes. We’ve found some information at the national level, and some provincial information at higher NAICS groupings, but nothing with both the level of industry and geographic detail he wants. He’s willing to purchase a custom tabulation if necessary.
Specifically he is asking for:
Annual, (total capital expenditures) for (NAICS 22111, 22112, 23713) for each province/territory, from 2007 to the most current date;
Annual, (total federal taxes, total provincial taxes) for (NAICS 22111, 22112, 23713) for each province/territory, from 2007 to the most current date.
Table 34-10-0035-01 gives capital expenditures at the provincial level, but at the two digit level only. 33-10-0007-01 has taxation but is also at the two-digit level. Am I missing an available source? Would this level of detail be available from a custom tabulation?
Answer:
I’ve received the following response from subject matter:
“We have data on taxes on production and products for NAICS 2211 and 23, but the data is not broken down by level of government. We have data on capital expenditures, but only for NAICS 221 and 23. This data would be available from 2007 to 2015, by province and territory.”
Subscribe to:
Posts (Atom)