Question
We have a researcher looking for data sources on:"enrollment numbers of international graduate (not undergraduate) students in each province in Canada (preferably over a number of years). "
This report has some background information on the survey used to provide some output data that is available from CANSIM:
http://www.statcan.gc.ca/daily-quotidien/080207/dq080207a-eng.htm
But the data within the CANSIM table does not provide any information on non-resident students. Perhaps some of the variables have not been included in the CANSIM table? Does anyone know of other data sources?
Would a custom table request be able to produce the information?
Answer
These data would be available as a custom tabulation from the Postsecondary Student Information System (PSIS). The base price for this type of tabulation is $150 with the cost increasing for additional variables and years of data.
Monday, November 30, 2009
Social Housing
Question
I am having a tough time locating the number of people on waiting lists for social housing in Canada. It appears as though there has been a diminishing federal involvement over time and at the present, because most social housing is either provincially or municipally handled, there is no single central group overseeing it all. As such, I suspect that the researcher will have to use the data collected by each provincial housing authority. Am I missing something?
Answer
Statistics Canada does not collect information on the number of people on waiting lists for social housing in Canada. I suspect that these data may be collected at a local or provincial level or perhaps by other federal organizations (CMHC for example).
Additional Information
Social housing for the most part was downloaded from the Federal Government to Provinces who in turn downloaded to municipalities. There are a few Federal Cooperatives left but not many.
The Federation of Canadian Municipalities has worked with 24 municipalities across the country on the collecting of data for social housing which included a survey of social housing waiting lists, social housing inventories, absolute homelessness and the risk of homelessness.
Social housing waiting list data are not collected in all cities, are not collected in the same way when they are, while social housing is not uniformly defined. Data on social housing waiting lists at the moment is not comparable across time and jurisdictions in Canada. There is no Federal agency responsible for collecting these types of data. Sometimes it is the city who collects, sometimes it is housing authorities, sometimes it is community groups. I have not yet seen provinces collect these data.
There is also no Federal Agency which keeps an inventory of non market rental units in Canada, and that includes social housing. At the latest CMHC National Housing Research Committee there was a request from the western municipal representative that this be conducted as part of the work of CMHC. I do not know the outcome of that discussion.
If you are looking for FCM QoLRS data on this topic, it can be found here - http://www.fcm.ca/english/View.asp?mp=1166&x=1115.
I am having a tough time locating the number of people on waiting lists for social housing in Canada. It appears as though there has been a diminishing federal involvement over time and at the present, because most social housing is either provincially or municipally handled, there is no single central group overseeing it all. As such, I suspect that the researcher will have to use the data collected by each provincial housing authority. Am I missing something?
Answer
Statistics Canada does not collect information on the number of people on waiting lists for social housing in Canada. I suspect that these data may be collected at a local or provincial level or perhaps by other federal organizations (CMHC for example).
Additional Information
Social housing for the most part was downloaded from the Federal Government to Provinces who in turn downloaded to municipalities. There are a few Federal Cooperatives left but not many.
The Federation of Canadian Municipalities has worked with 24 municipalities across the country on the collecting of data for social housing which included a survey of social housing waiting lists, social housing inventories, absolute homelessness and the risk of homelessness.
Social housing waiting list data are not collected in all cities, are not collected in the same way when they are, while social housing is not uniformly defined. Data on social housing waiting lists at the moment is not comparable across time and jurisdictions in Canada. There is no Federal agency responsible for collecting these types of data. Sometimes it is the city who collects, sometimes it is housing authorities, sometimes it is community groups. I have not yet seen provinces collect these data.
There is also no Federal Agency which keeps an inventory of non market rental units in Canada, and that includes social housing. At the latest CMHC National Housing Research Committee there was a request from the western municipal representative that this be conducted as part of the work of CMHC. I do not know the outcome of that discussion.
If you are looking for FCM QoLRS data on this topic, it can be found here - http://www.fcm.ca/english/View.asp?mp=1166&x=1115.
Aboriginal Justice Stats
Question
Does anyone know of a source of youth crime/justice data at the city level? I have a grad student who's looking at Aboriginal youth representation in the justice system, specifically in Saskatoon and on reserves near the city. The resources we've found (YCS, YCCS, etc.) go no deeper than the provincial level.
Answer
Usually, for a question such as this, I would scour the municipal police Annual Reports or the local RCMP sites for any reference to numbers, stats or data collected. Perhaps local Aboriginal organizations or help centers may have some insights on numbers??
Also, would any of the sources (or their authors) as listed below, collect the data -- or part of it -- that you're after?
[1] Young Offender Programs
Telephone: (306) 787-5699
Fax: (306) 787-0676
Mailing Address: 710 - 1874 Scarth Street, Regina, SK S4P 4B3
URL: http://www.cpsp.gov.sk.ca/YO
[2] 08-09 ANNUAL REPORT Ministry of Corrections, Public Safety and
Policing < http://www.finance.gov.sk.ca/annreport/200809CPSPAnnualReport.pdf >
- lots of occurrences of the word(s) "database" or "data";
- p.39: "Saskatchewan Young Offender Case Activity Management System (SYOCAMS): The computerized system used by Young Offenders to input and monitor young offenders? sentence information."
- p.39: "Criminal Justice Information Management System (CJIMS): A new integrated information system to support Saskatchewan?s criminal justice system. This system will replace the stand-alone court system used by Justice, and the old systems used by Corrections and Young Offenders."
Appendix D: Contact Information
" For further information on the programs and services provided by the Ministry of Corrections, Public Safety and Policing described in this document, please contact the following:
Adult Corrections 787-8958
Young Offender Programs 787-5699
Policing Services 787-6518
Licensing and Inspections 787-1443
Protection and Emergency Services 787-8568
Communications and Public Education 787-7872
Corporate Services 787-8633
Information Management 787-9512
Strategic Policy 787-6585
Human Resources 787-8901"
- p.34: "This report provides information about both our accomplishments and our future plans. If you have any questions or comments, or would like additional copies of this report, we invite you to call (306) 787-7872.
Or contact:
Ministry of Corrections, Public Safety and Policing
Communications and Public Education Branch
1000-1874 Scarth Street
REGINA, SK S4P 4B3
Or send us an email through the Ministry of
Corrections, Public Safety and Policing website:
www.cpsp.gov.sk.ca "
Additional Information
The Uniform Crime Reporting (UCR) files in the DLI collection include detachment-level data but they do not include information on aboriginal status.
The reporting guide for the UCR2 Incident-Based Survey lists an aboriginal indicator (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getInstrumentDocLink&SurvId=3302&SurvVer=0&InstaId=15093&InstaVer=10?=en&db=imdb&adm=8&dis=2) so UCR data with aboriginal status information may be available for a fee on a custom basis from the Canadian Centre for Justice Statistics. If this custom service interests your grad student, I will be happy to refer you to an Account-Executive who can confirm if these data are available and provide a cost estimate.
Does anyone know of a source of youth crime/justice data at the city level? I have a grad student who's looking at Aboriginal youth representation in the justice system, specifically in Saskatoon and on reserves near the city. The resources we've found (YCS, YCCS, etc.) go no deeper than the provincial level.
Answer
Usually, for a question such as this, I would scour the municipal police Annual Reports or the local RCMP sites for any reference to numbers, stats or data collected. Perhaps local Aboriginal organizations or help centers may have some insights on numbers??
Also, would any of the sources (or their authors) as listed below, collect the data -- or part of it -- that you're after?
[1] Young Offender Programs
Telephone: (306) 787-5699
Fax: (306) 787-0676
Mailing Address: 710 - 1874 Scarth Street, Regina, SK S4P 4B3
URL: http://www.cpsp.gov.sk.ca/YO
[2] 08-09 ANNUAL REPORT Ministry of Corrections, Public Safety and
Policing < http://www.finance.gov.sk.ca/annreport/200809CPSPAnnualReport.pdf >
- lots of occurrences of the word(s) "database" or "data";
- p.39: "Saskatchewan Young Offender Case Activity Management System (SYOCAMS): The computerized system used by Young Offenders to input and monitor young offenders? sentence information."
- p.39: "Criminal Justice Information Management System (CJIMS): A new integrated information system to support Saskatchewan?s criminal justice system. This system will replace the stand-alone court system used by Justice, and the old systems used by Corrections and Young Offenders."
Appendix D: Contact Information
" For further information on the programs and services provided by the Ministry of Corrections, Public Safety and Policing described in this document, please contact the following:
Adult Corrections 787-8958
Young Offender Programs 787-5699
Policing Services 787-6518
Licensing and Inspections 787-1443
Protection and Emergency Services 787-8568
Communications and Public Education 787-7872
Corporate Services 787-8633
Information Management 787-9512
Strategic Policy 787-6585
Human Resources 787-8901"
- p.34: "This report provides information about both our accomplishments and our future plans. If you have any questions or comments, or would like additional copies of this report, we invite you to call (306) 787-7872.
Or contact:
Ministry of Corrections, Public Safety and Policing
Communications and Public Education Branch
1000-1874 Scarth Street
REGINA, SK S4P 4B3
Or send us an email through the Ministry of
Corrections, Public Safety and Policing website:
www.cpsp.gov.sk.ca "
Additional Information
The Uniform Crime Reporting (UCR) files in the DLI collection include detachment-level data but they do not include information on aboriginal status.
The reporting guide for the UCR2 Incident-Based Survey lists an aboriginal indicator (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getInstrumentDocLink&SurvId=3302&SurvVer=0&InstaId=15093&InstaVer=10?=en&db=imdb&adm=8&dis=2) so UCR data with aboriginal status information may be available for a fee on a custom basis from the Canadian Centre for Justice Statistics. If this custom service interests your grad student, I will be happy to refer you to an Account-Executive who can confirm if these data are available and provide a cost estimate.
Monday, November 23, 2009
Occupation By Gender
Question
I have a faculty member looking for updated numbers of total and female workers by occupation in Canada. (He has 1991 and 1996). He is looking for all 713 categories of the National Occupational Classification. I know I can find this information in the Census for the main occupation categories, but he needs it broken down further.
I am hoping someone may know of a source ... since I am not at work today and am unable to spend time searching.
Answer
I think that the following topic-based tabulation from the 2006 Census will meet the faculty member's needs:
Occupation - National Occupational Classification for Statistics 2006 (720), Class of Worker (6) and Sex (3) for the Labour Force 15 Years and Over. Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations - Cat. No. 97-559-X2006011.
You can download it from the StatCan website at: http://www12.statcan.gc.ca/english/census06/data/topics/RetrieveProductTable.cfm?TPL=RETR&ALEVEL=3&APATH=3&CATNO=&DETAIL=0&DIM=&DS=99&FL=0&FREE=0&GAL=0&GC=99&GK=NA&GRP=1&IPS=&METH=0&ORDER=1&PID=92104&PTYPE=88971,97154&RL=0&S=1&ShowAll=No&StartRow=1&SUB=743&Temporal=2006&Theme=74&VID=0&VNAMEE=&VNAMEF=
I have a faculty member looking for updated numbers of total and female workers by occupation in Canada. (He has 1991 and 1996). He is looking for all 713 categories of the National Occupational Classification. I know I can find this information in the Census for the main occupation categories, but he needs it broken down further.
I am hoping someone may know of a source ... since I am not at work today and am unable to spend time searching.
Answer
I think that the following topic-based tabulation from the 2006 Census will meet the faculty member's needs:
Occupation - National Occupational Classification for Statistics 2006 (720), Class of Worker (6) and Sex (3) for the Labour Force 15 Years and Over. Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations - Cat. No. 97-559-X2006011.
You can download it from the StatCan website at: http://www12.statcan.gc.ca/english/census06/data/topics/RetrieveProductTable.cfm?TPL=RETR&ALEVEL=3&APATH=3&CATNO=&DETAIL=0&DIM=&DS=99&FL=0&FREE=0&GAL=0&GC=99&GK=NA&GRP=1&IPS=&METH=0&ORDER=1&PID=92104&PTYPE=88971,97154&RL=0&S=1&ShowAll=No&StartRow=1&SUB=743&Temporal=2006&Theme=74&VID=0&VNAMEE=&VNAMEF=
Childhood Immunization Breakdown By Province
Question
I am looking for a breakdown by province of the percentage of children immunized against measles, mumps, rubella, etc. I have found the national statistics on this topic, but am wondering where to find the same breakdown by province.
Answer
I have not located data on childhood immunization rates in our surveys but I will ask our Health Statistics Division to confirm that we do not collect these and will follow up with their answer. Provincial data may be available through the Public Health Agency of Canada (PHAC - http://www.phac-aspc.gc.ca/im/is-vc-eng.php) or from provincial/territorial governments.
Data on flu immunizations, but not childhood immunizations, by province for various age groups are available from the Canadian Community Health Survey (CCHS) (12 years of age and over, see CANSIM table 105-0445 for example) or in our CCHS public use microdata files and GSS 1991.
Additional information
Our Health Statistics Division has confirmed that Statistics Canada does not collect data on childhood immunizations. They indicated that it may be available through Health Canada or the Public Health Agency of Canada and, as I mentioned in my last message, it may be available from provincial sources as well.
I am looking for a breakdown by province of the percentage of children immunized against measles, mumps, rubella, etc. I have found the national statistics on this topic, but am wondering where to find the same breakdown by province.
Answer
I have not located data on childhood immunization rates in our surveys but I will ask our Health Statistics Division to confirm that we do not collect these and will follow up with their answer. Provincial data may be available through the Public Health Agency of Canada (PHAC - http://www.phac-aspc.gc.ca/im/is-vc-eng.php) or from provincial/territorial governments.
Data on flu immunizations, but not childhood immunizations, by province for various age groups are available from the Canadian Community Health Survey (CCHS) (12 years of age and over, see CANSIM table 105-0445 for example) or in our CCHS public use microdata files and GSS 1991.
Additional information
Our Health Statistics Division has confirmed that Statistics Canada does not collect data on childhood immunizations. They indicated that it may be available through Health Canada or the Public Health Agency of Canada and, as I mentioned in my last message, it may be available from provincial sources as well.
Air Pollution Data
Question
I've got a student who's looking for 2006 air pollution data (PM10, carbon monoxide, etc.) at the health region level. Something tells me that kind of information probably isn't collected by health region. I've found a few sites that have region data available, the Ontario Air Quality Index and CASA Data (Alberta) for example, but nothing national.
Does anyone know of other possible sources?
Answer
Our contacts in our Environment Accounts and Statistics Division have provided the following suggestions in response to your question:
"Health Canada has done a lot of work linking ambient air quality data to different geographies. We have also been involved in the Canadian Environmental Sustainability Indicators (CESI) inititative for the national ambient air qualtiy indicators, but these are not specifically linked to health regions.
The approach I suggest is to use the National Air Pollution Surveillance (NAPS) data (available for download from the Environment Canada website). This can be combined via the Lat-Long coordinates for the sites with the health region geography in a geographical information systems (GIS) application. This would work for ambient air quality analysis.
If it is emissions that are the focus, then the National Pollutant Release Inventory (NPRI) is the main source of information. Since 2002, emissions of criteria air contaminants have been included in the NPRI. The inventory has emissions by facility, and the facilities are geo coded. This too could be coded to health regions with the appropriate GIS application. "
I've got a student who's looking for 2006 air pollution data (PM10, carbon monoxide, etc.) at the health region level. Something tells me that kind of information probably isn't collected by health region. I've found a few sites that have region data available, the Ontario Air Quality Index and CASA Data (Alberta) for example, but nothing national.
Does anyone know of other possible sources?
Answer
Our contacts in our Environment Accounts and Statistics Division have provided the following suggestions in response to your question:
"Health Canada has done a lot of work linking ambient air quality data to different geographies. We have also been involved in the Canadian Environmental Sustainability Indicators (CESI) inititative for the national ambient air qualtiy indicators, but these are not specifically linked to health regions.
The approach I suggest is to use the National Air Pollution Surveillance (NAPS) data (available for download from the Environment Canada website). This can be combined via the Lat-Long coordinates for the sites with the health region geography in a geographical information systems (GIS) application. This would work for ambient air quality analysis.
If it is emissions that are the focus, then the National Pollutant Release Inventory (NPRI) is the main source of information. Since 2002, emissions of criteria air contaminants have been included in the NPRI. The inventory has emissions by facility, and the facilities are geo coded. This too could be coded to health regions with the appropriate GIS application. "
Air Pollution Data
Question
I've got a student who's looking for 2006 air pollution data (PM10, carbon monoxide, etc.) at the health region level. Something tells me that kind of information probably isn't collected by health region. I've found a few sites that have region data available, the Ontario Air Quality Index and CASA Data (Alberta) for example, but nothing national.
Does anyone know of other possible sources?
Answer
Our contacts in our Environment Accounts and Statistics Division have provided the following suggestions in response to your question:
"Health Canada has done a lot of work linking ambient air quality data to different geographies. We have also been involved in the Canadian Environmental Sustainability Indicators (CESI) inititative for the national ambient air quality indicators, but these are not specifically linked to health regions.
The approach I suggest is to use the National Air Pollution Surveillance (NAPS) data (available for download from the Environment Canada website). This can be combined via the Lat-Long coordinates for the sites with the health region geography in a geographical information systems (GIS) application. This would work for ambient air quality analysis.
If it is emissions that are the focus, then the National Pollutant Release Inventory (NPRI) is the main source of information. Since 2002, emissions of criteria air contaminants have been included in the NPRI. The inventory has emissions by facility, and the facilities are geo coded. This too could be coded to health regions with the appropriate GIS application. "
I've got a student who's looking for 2006 air pollution data (PM10, carbon monoxide, etc.) at the health region level. Something tells me that kind of information probably isn't collected by health region. I've found a few sites that have region data available, the Ontario Air Quality Index and CASA Data (Alberta) for example, but nothing national.
Does anyone know of other possible sources?
Answer
Our contacts in our Environment Accounts and Statistics Division have provided the following suggestions in response to your question:
"Health Canada has done a lot of work linking ambient air quality data to different geographies. We have also been involved in the Canadian Environmental Sustainability Indicators (CESI) inititative for the national ambient air quality indicators, but these are not specifically linked to health regions.
The approach I suggest is to use the National Air Pollution Surveillance (NAPS) data (available for download from the Environment Canada website). This can be combined via the Lat-Long coordinates for the sites with the health region geography in a geographical information systems (GIS) application. This would work for ambient air quality analysis.
If it is emissions that are the focus, then the National Pollutant Release Inventory (NPRI) is the main source of information. Since 2002, emissions of criteria air contaminants have been included in the NPRI. The inventory has emissions by facility, and the facilities are geo coded. This too could be coded to health regions with the appropriate GIS application. "
Friday, November 13, 2009
Urban/ Rural?
Question
I've got a researcher who wants to know how to determine what's urban, what's rural within the Gr. Sudbury CMA. Is this possible? The census geography is, well, rather complex!
Answer
I am forwarding an off-list reply to your question to the dlilist as I am sure that others will be interested in the suggestions.
If you run the Geosuite 2006 application, and go to chart search, select 'CMA/CA and non CMA/CA' box and
select 'Sudbury' from the resulting list, then click on the 'UA/RA' box you will get a listing of the communities (CSDs, sort of) that make up Greater Sudbury. The UARA type tells you whether each is urban, rural, etc. If you then want to get a list of the blocks that make up each one.
Another alternative is to use the PCCF. At: http://www.chass.utoronto.ca/datalib/cc06/fsa_sep08.csv
I have a list of FSAs and the CMAs (SAC codes) that each belongs to, extracted from the PCCF. If an FSA has a '0' as the second digit, eg 'P0M' then Canada Post considers it rural. If you sort the file in excel, the list of FSAs will indicate which CSDs in Greater Sudbury are urban and which are rural.
I also have a file at: http://prod.library.utoronto.ca:8090/datalib/codebooks/cstdli/pccf/pccf_08sep/postcode_by_ct_08sep.csv.Z
which shows CMA/CA code and census tracts names for each postal code. Find the Sudbury cts, and again the postal code FSA will tell you if its rural or urban.
Yet another option is to use the full PCCF, which you should be able to access at: http://dc1.chass.utoronto.ca/census/pccf.html and do the same thing at the postal code level.
Yet another option, which I find easier than the Geosuite product, is the to use the Geography attribute file for the 2006 census. This will give you Stats Can's rural/urban classification, rather than Canada Posts. The UAtype variable in that will do the same thing as Geosuite, in a less cumbersome manner. You will find the user guide, and a set of SPSS syntax at: http://chass.utoronto.ca/datalib/cc06/georef06.htm#gaf
I've got a researcher who wants to know how to determine what's urban, what's rural within the Gr. Sudbury CMA. Is this possible? The census geography is, well, rather complex!
Answer
I am forwarding an off-list reply to your question to the dlilist as I am sure that others will be interested in the suggestions.
If you run the Geosuite 2006 application, and go to chart search, select 'CMA/CA and non CMA/CA' box and
select 'Sudbury' from the resulting list, then click on the 'UA/RA' box you will get a listing of the communities (CSDs, sort of) that make up Greater Sudbury. The UARA type tells you whether each is urban, rural, etc. If you then want to get a list of the blocks that make up each one.
Another alternative is to use the PCCF. At: http://www.chass.utoronto.ca/datalib/cc06/fsa_sep08.csv
I have a list of FSAs and the CMAs (SAC codes) that each belongs to, extracted from the PCCF. If an FSA has a '0' as the second digit, eg 'P0M' then Canada Post considers it rural. If you sort the file in excel, the list of FSAs will indicate which CSDs in Greater Sudbury are urban and which are rural.
I also have a file at: http://prod.library.utoronto.ca:8090/datalib/codebooks/cstdli/pccf/pccf_08sep/postcode_by_ct_08sep.csv.Z
which shows CMA/CA code and census tracts names for each postal code. Find the Sudbury cts, and again the postal code FSA will tell you if its rural or urban.
Yet another option is to use the full PCCF, which you should be able to access at: http://dc1.chass.utoronto.ca/census/pccf.html and do the same thing at the postal code level.
Yet another option, which I find easier than the Geosuite product, is the to use the Geography attribute file for the 2006 census. This will give you Stats Can's rural/urban classification, rather than Canada Posts. The UAtype variable in that will do the same thing as Geosuite, in a less cumbersome manner. You will find the user guide, and a set of SPSS syntax at: http://chass.utoronto.ca/datalib/cc06/georef06.htm#gaf
E-STAT: Census of Agriculture
Question
We are assisting a local non-profit heritage conservancy group with a GIS project. This group works closely with a number of researchers at Trent University and hopes to eventually publish a map which would provide data about our local region. At the moment, they are particularly interested in information about Number of Farms and Average age of Farmers (by county and district) over time. Though most data required is in the public domain; there are a few exceptions where the data seems most readily available in ESTAT rather than our DSP collection or the STC web site.
Can we supply ESTAT Census of Agriculture data broken down by age and county to a non-profit group?
For example:
ESTAT - 1996 Census of Agriculture - Characteristics of Farm Operators - 1996 Ont. ( 49 Counties, regional municipalities, etc) :
Average age of Operators by County and District.
Peterborough County: 51.7
Haliburton County: 51.4
If I need to redirect this question to ESTAT, please let me know.
Answer
Anyone can now access E-STAT since there is no more password required. Staff from the local non-profit heritage conservancy group could pull out the data from E-STAT themselves. The password has been removed but no formal announcement has been done. I had mentioned it at the last Ontario DLI training as well as to the last EAC meeting.
This will make your life easier otherwise you would not have been able to provide that non-profit organization these data.
Question
Could you clarify just a bit more re: E-STAT. Does this mean that we do not have to authenticate for off-campus users -- at all? We can leave it wide open?
Answer
I have to retract what I said yesterday for the use of ESTAT because the license that you accept provides the authorization to use the data for educational purposes only. Although there are no password, there are restrictions in terms of use when you accept the license.
On the other hand, I am checking what agreement DSP has with StatCan concerning the access to ESTAT. Usually, when data is accessed through DSP, the objective is to service the general public.
No better luck on the DSP side. The license is the same and it is restricted to educational purposes only. Hopefully, in a not too far future, this product will be open to everyone. Sorry for the false feeling of joy I may have created.
We are assisting a local non-profit heritage conservancy group with a GIS project. This group works closely with a number of researchers at Trent University and hopes to eventually publish a map which would provide data about our local region. At the moment, they are particularly interested in information about Number of Farms and Average age of Farmers (by county and district) over time. Though most data required is in the public domain; there are a few exceptions where the data seems most readily available in ESTAT rather than our DSP collection or the STC web site.
Can we supply ESTAT Census of Agriculture data broken down by age and county to a non-profit group?
For example:
ESTAT - 1996 Census of Agriculture - Characteristics of Farm Operators - 1996 Ont. ( 49 Counties, regional municipalities, etc) :
Average age of Operators by County and District.
Peterborough County: 51.7
Haliburton County: 51.4
If I need to redirect this question to ESTAT, please let me know.
Answer
Anyone can now access E-STAT since there is no more password required. Staff from the local non-profit heritage conservancy group could pull out the data from E-STAT themselves. The password has been removed but no formal announcement has been done. I had mentioned it at the last Ontario DLI training as well as to the last EAC meeting.
This will make your life easier otherwise you would not have been able to provide that non-profit organization these data.
Question
Could you clarify just a bit more re: E-STAT. Does this mean that we do not have to authenticate for off-campus users -- at all? We can leave it wide open?
Answer
I have to retract what I said yesterday for the use of ESTAT because the license that you accept provides the authorization to use the data for educational purposes only. Although there are no password, there are restrictions in terms of use when you accept the license.
On the other hand, I am checking what agreement DSP has with StatCan concerning the access to ESTAT. Usually, when data is accessed through DSP, the objective is to service the general public.
No better luck on the DSP side. The license is the same and it is restricted to educational purposes only. Hopefully, in a not too far future, this product will be open to everyone. Sorry for the false feeling of joy I may have created.
Unemployment Rates and 3 Month Moving Average
Question
A professor here is looking for monthly unemployment rates for census metropolitan areas back to 1990 that do not say "3 -month moving average" on the table ( for example CANSIM Table 2820090)." He just wants the monthly rates. Are any unemployment rates available without the "3-month moving average" at the census metropolitan area level and if not is there a reason why not? The professor is looking for statistics for Thunder Bay.
Answer
We received the following answer from the author division in response to your question below:
"Sorry but no the CMA data is not available monthly due to the sample size. The data would not be as reliable."
A professor here is looking for monthly unemployment rates for census metropolitan areas back to 1990 that do not say "3 -month moving average" on the table ( for example CANSIM Table 2820090)." He just wants the monthly rates. Are any unemployment rates available without the "3-month moving average" at the census metropolitan area level and if not is there a reason why not? The professor is looking for statistics for Thunder Bay.
Answer
We received the following answer from the author division in response to your question below:
"Sorry but no the CMA data is not available monthly due to the sample size. The data would not be as reliable."
Creating and Displaying 2006 Census DA Level Maps On the Internet
Question
As part of an assignment, students are asked to pretend they are ‘consultants’, and to generate maps using 2006 Census data for inclusion in a larger report. They would like to have the option of working at the DA level, but could step back to CT’s if necessary.
Ultimately, this report will be posted to the school's web site, or to our institutional repository. In either case, the report would be broadly and publicly available. No data is being posted – just images of maps. Tables and charts may be included as well.
For the record, there is up-front interest in this report from local groups in our community, who will have access to the report through the publicly available web site mentioned above.
Does this meet DLI licensing requirements? I’ve already flagged the need to cite Statistics Canada appropriately.
Answer
The students are authorised users and they may use the DLI Census data at the DA level for this project as they only plan on producing a few static maps that will accompany a report. The static maps may be included with the report in your training repository or posted on the school's website and accessed by external users in the community.
For your reference, here are the licensing guidelines for displaying 2001 and 2006 Census data in map format on the Internet by DLI institutions: http://www.statcan.gc.ca/dli-ild/doc/sitemap-plandusite-eng.pdf (we also have a link to this document in the reference materials section of our website).
As part of an assignment, students are asked to pretend they are ‘consultants’, and to generate maps using 2006 Census data for inclusion in a larger report. They would like to have the option of working at the DA level, but could step back to CT’s if necessary.
Ultimately, this report will be posted to the school's web site, or to our institutional repository. In either case, the report would be broadly and publicly available. No data is being posted – just images of maps. Tables and charts may be included as well.
For the record, there is up-front interest in this report from local groups in our community, who will have access to the report through the publicly available web site mentioned above.
Does this meet DLI licensing requirements? I’ve already flagged the need to cite Statistics Canada appropriately.
Answer
The students are authorised users and they may use the DLI Census data at the DA level for this project as they only plan on producing a few static maps that will accompany a report. The static maps may be included with the report in your training repository or posted on the school's website and accessed by external users in the community.
For your reference, here are the licensing guidelines for displaying 2001 and 2006 Census data in map format on the Internet by DLI institutions: http://www.statcan.gc.ca/dli-ild/doc/sitemap-plandusite-eng.pdf (we also have a link to this document in the reference materials section of our website).
Asian Women and Domestic Violence
Question
I have a student who is trying to locate a dataset that links Asian women and domestic violence. We’ve gotten close with the GSS and the VAWS, but the best we can do is visible minority categorized into broad groups (I think too broad to link his concepts). Just wanted to throw it out there in case anyone has come across a dataset that might help….I’m going to check ICPSR, but not sure how successful that will be!
Answer
I do not know of other Statistics Canada surveys that would provide these data. GSS cycle 18 - Victimization (2004) asked respondents to provide specific information about their visible minority status (see p.294 of the questionnaire: http://www.statcan.gc.ca/imdb-bmdi/instrument/4504_Q1_V4-eng.pdf) but, as you have correctly noted, this level of detail is not available in the public use microdata file (PUMF). If the student would like to look into obtaining this information as a fee based custom tabulation, I will be pleased to refer you to an Account-Executive in our Toronto office.
I have a student who is trying to locate a dataset that links Asian women and domestic violence. We’ve gotten close with the GSS and the VAWS, but the best we can do is visible minority categorized into broad groups (I think too broad to link his concepts). Just wanted to throw it out there in case anyone has come across a dataset that might help….I’m going to check ICPSR, but not sure how successful that will be!
Answer
I do not know of other Statistics Canada surveys that would provide these data. GSS cycle 18 - Victimization (2004) asked respondents to provide specific information about their visible minority status (see p.294 of the questionnaire: http://www.statcan.gc.ca/imdb-bmdi/instrument/4504_Q1_V4-eng.pdf) but, as you have correctly noted, this level of detail is not available in the public use microdata file (PUMF). If the student would like to look into obtaining this information as a fee based custom tabulation, I will be pleased to refer you to an Account-Executive in our Toronto office.
Land Area of Saskatoon CMA from 1996 - 2001
Question
(...) the area of the Saskatoon CMA from 1996-2001 went from 5322.09km in 96 to 5192.22km in 01. What caused this decline? We have thrown around many ideas and rationalisations, however we did not have a definitive answer.
Answer
I received the following information from our geography consultants in response to your question:
"The methodology for calculating land area underwent substantial change between the 1996 Census and the 2001 Census:
(...) the area of the Saskatoon CMA from 1996-2001 went from 5322.09km in 96 to 5192.22km in 01. What caused this decline? We have thrown around many ideas and rationalisations, however we did not have a definitive answer.
Answer
I received the following information from our geography consultants in response to your question:
"The methodology for calculating land area underwent substantial change between the 1996 Census and the 2001 Census:
- for the 1996 Census, land area was manually calculated using a planimeter on paper topographic maps. In general, manual calculations are subject to a number of discrepancies, including propagation errors over time and logical inconsistencies.
- for the 2001 Census, land area was computer generated for the first time using the Geography Division's new digital database (NGB)."
Boundary Files
Question
I have what I think is a very simple question. I have a student doing an assignment – she already has population data for 2006 census and she needs the boundary files in either ArcGIS or MapInfo formats at the CT level for the CMA of St. John’s. Will the Road Network files do this or is there another product I should be providing?
Answer
I believe the RNF does not actually include the boundaries; therefore, if you go to the geography/2006/spatial-info-products/ directory/sub-directories, you'll find options for downloading both arcinfo and mapinfo format. Depending on whether or not you want shoreline, you'll go choose cbf (with shoreline) or dbf (without shoreline). In this case, I don't think it makes a *huge* difference if you select dbf or cbf, although I tend to default to cbf unless I have reason not to do so (which is sometimes the case). Within each of these sub-directories are national and provincial directories. Choose national, and you'll see a further sub-directory for CT geography.
I have what I think is a very simple question. I have a student doing an assignment – she already has population data for 2006 census and she needs the boundary files in either ArcGIS or MapInfo formats at the CT level for the CMA of St. John’s. Will the Road Network files do this or is there another product I should be providing?
Answer
I believe the RNF does not actually include the boundaries; therefore, if you go to the geography/2006/spatial-info-products/ directory/sub-directories, you'll find options for downloading both arcinfo and mapinfo format. Depending on whether or not you want shoreline, you'll go choose cbf (with shoreline) or dbf (without shoreline). In this case, I don't think it makes a *huge* difference if you select dbf or cbf, although I tend to default to cbf unless I have reason not to do so (which is sometimes the case). Within each of these sub-directories are national and provincial directories. Choose national, and you'll see a further sub-directory for CT geography.
Ontario Immigrant Literacy Survey
Question
According to the publication Literacy Profile of Ontario's Immigrants (http://www.edu.gov.on.ca/eng/training/literacy/immigrant/immige.pdf), the Ontario Immigrant Literacy Survey “was commissioned by the province of Ontario and carried out by Statistics Canada”. Is a microdata file available for the product, or is it available through the RDC program, or are summary data available?
It would seem that there was a pumf made of this data set! W Scott Murray of Special Surveys, is acknowledged as having provided these data toFerrar, Green and Riddle for their 2004/05 paper:
http://www.econ.ubc.ca/ine/papers/wp011.pdf
So, of course we want the pumf.......... 8-)
Answer
I consulted our Special Surveys Division and we think that the authors of the publication are referring to the Ontario Adult Literacy Survey (OALS).
A detailed description of OALS is available in the Definitions, data sources and methods section of the StatCan website (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4433&lang=en&db=imdb&adm=8&dis=2) and in the OALS Survey Guide (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4433&lang=en&db=imdb&adm=8&dis=2). The timing, objectives and target population of OALS seem to match those of the Ontario Immigrant Literacy Survey (OILS) described in the Literacy Profile of Ontario's Immigrants publication.
We have the OALS PUMF in the DLI collection: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/oals-eaao-eng.htm
Response
Wonderful! Same 'book', two different titles 8-) Of course, you are right. Just another example of when citations standards would have
been useful! The lack of a title page on the pdf version of the user guide
means anyone can make up their own title for it, I suppose.
According to the publication Literacy Profile of Ontario's Immigrants (http://www.edu.gov.on.ca/eng/training/literacy/immigrant/immige.pdf), the Ontario Immigrant Literacy Survey “was commissioned by the province of Ontario and carried out by Statistics Canada”. Is a microdata file available for the product, or is it available through the RDC program, or are summary data available?
It would seem that there was a pumf made of this data set! W Scott Murray of Special Surveys, is acknowledged as having provided these data toFerrar, Green and Riddle for their 2004/05 paper:
http://www.econ.ubc.ca/ine/papers/wp011.pdf
So, of course we want the pumf.......... 8-)
Answer
I consulted our Special Surveys Division and we think that the authors of the publication are referring to the Ontario Adult Literacy Survey (OALS).
A detailed description of OALS is available in the Definitions, data sources and methods section of the StatCan website (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4433&lang=en&db=imdb&adm=8&dis=2) and in the OALS Survey Guide (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4433&lang=en&db=imdb&adm=8&dis=2). The timing, objectives and target population of OALS seem to match those of the Ontario Immigrant Literacy Survey (OILS) described in the Literacy Profile of Ontario's Immigrants publication.
We have the OALS PUMF in the DLI collection: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/oals-eaao-eng.htm
Response
Wonderful! Same 'book', two different titles 8-) Of course, you are right. Just another example of when citations standards would have
been useful! The lack of a title page on the pdf version of the user guide
means anyone can make up their own title for it, I suppose.
Money Spent on Research By Firms
Question
I have a faculty member looking for data on how much Canadian firms spend on research. She's hoping to get the data by company size and sector.
There seemed to be data of interest from Research and Development in Canadian Industry (RDCI) (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4201&lang=en&db=imdb&adm=8&dis=2) through CANSIM 358-0024, various publications, and the Summary Table at http://www40.statcan.gc.ca/l01/cst01/econ151a-eng.htm.
The publication at http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=88-001-X200900410909&lang=eng seems to get close to what she seems to want, but she needs more granularity for the industry sectors.
Is there any chance of getting more current, detailed data through the DLI? If not, is custom data an option, and could we get some idea of price based on number of industry sectors, company size breakdown, and geography (i.e., number of provinces).
If anyone has an idea of another place to get this data, we'd be interested. She also seems to want the figures by company (within a sector). I was able to search OSIRIS by country and industry sector (up to 6-digit NAICS) and get a list of companies. I was then able to view R&D amounts for each company in the financials -- one company at a time. Although it was possible to export a dataset for broader financials, it didn't seem possible to include the more detailed financials (i.e., R&D figures) in the export file.
Answer
Company-level R&D expenditures are available in the Financial Post Corporate database, as well as in the Compustat Canadian file.
I have a faculty member looking for data on how much Canadian firms spend on research. She's hoping to get the data by company size and sector.
There seemed to be data of interest from Research and Development in Canadian Industry (RDCI) (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4201&lang=en&db=imdb&adm=8&dis=2) through CANSIM 358-0024, various publications, and the Summary Table at http://www40.statcan.gc.ca/l01/cst01/econ151a-eng.htm.
The publication at http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=88-001-X200900410909&lang=eng seems to get close to what she seems to want, but she needs more granularity for the industry sectors.
Is there any chance of getting more current, detailed data through the DLI? If not, is custom data an option, and could we get some idea of price based on number of industry sectors, company size breakdown, and geography (i.e., number of provinces).
If anyone has an idea of another place to get this data, we'd be interested. She also seems to want the figures by company (within a sector). I was able to search OSIRIS by country and industry sector (up to 6-digit NAICS) and get a list of companies. I was then able to view R&D amounts for each company in the financials -- one company at a time. Although it was possible to export a dataset for broader financials, it didn't seem possible to include the more detailed financials (i.e., R&D figures) in the export file.
Answer
Company-level R&D expenditures are available in the Financial Post Corporate database, as well as in the Compustat Canadian file.
Accessing the Digital Boundary Files
Question
Am I correct in saying that the Digital Boundary Files (DBFs) are not available via the DLI website and that their only mode of access (from Stats Can DLI) is via the DLI’s ftp site?
Answer
You are correct. Geography products that are part of the DLI collection (including boundary files) are not available through the DLI website. They are however available through the DLI FTP site.
Some boundary files, which are freely available to all users, can also be downloaded from the StatCan website: http://www12.statcan.gc.ca/census-recensement/2006/geo/bound-limit-eng.cfm The other boundary files which are listed as being for sale ($) on that web page are available on the DLI FTP site.
Am I correct in saying that the Digital Boundary Files (DBFs) are not available via the DLI website and that their only mode of access (from Stats Can DLI) is via the DLI’s ftp site?
Answer
You are correct. Geography products that are part of the DLI collection (including boundary files) are not available through the DLI website. They are however available through the DLI FTP site.
Some boundary files, which are freely available to all users, can also be downloaded from the StatCan website: http://www12.statcan.gc.ca/census-recensement/2006/geo/bound-limit-eng.cfm The other boundary files which are listed as being for sale ($) on that web page are available on the DLI FTP site.
Number of Farms (Vancouver Island) 1971 - 2006
Question
I have a research needing to know the number of farms in North Saanich, Central Saanich, and Saanich, from 1976 – 2006. ESTAT provides this information for the 2006 Census of Agriculture using the Provinces by Census Consolidated Subdivision geography option.
How do I get the same data back to 1976?
Question: Updated
I think I managed to figure this out and get this data (Farm counts from 1976 – 2006 for North Saanich, Central Saanich, and Saanich) from the excel tables located in the /census/agricultural/ folders on the DLI FTP site.
The CCS codes for these three named CCS’s seem to have changed over time. Do I need to worry about that in terms of the geographic area for each of these 3 CCS’s.
Answer
Our contacts in the Agriculture Division have looked into your question and sent us the following response:
"I checked and found the following:
- North Saanich, Central Saanich and Saanich did not change between 1976-2006
- Victoria was combined with Saanich in 1976
- Victoria was combined with Subdivision B in 1981 and 1986
- Victoria (as a CCS) was amalgamated with Saanich in 1991 to 2006.
- Capital Subdivision A (islands) was split in 2001 and 2006 into Capital F and Capital G
- Capital Subdivision B and C (D in 1991 and 1996) were combined in 2001 and 2006 into Capital H part 2"
I am still waiting to hear back from them about your offlist question regarding the provenance of the CCS codes used in the 1976 files.
I have a research needing to know the number of farms in North Saanich, Central Saanich, and Saanich, from 1976 – 2006. ESTAT provides this information for the 2006 Census of Agriculture using the Provinces by Census Consolidated Subdivision geography option.
How do I get the same data back to 1976?
Question: Updated
I think I managed to figure this out and get this data (Farm counts from 1976 – 2006 for North Saanich, Central Saanich, and Saanich) from the excel tables located in the /census/agricultural/ folders on the DLI FTP site.
The CCS codes for these three named CCS’s seem to have changed over time. Do I need to worry about that in terms of the geographic area for each of these 3 CCS’s.
Answer
Our contacts in the Agriculture Division have looked into your question and sent us the following response:
"I checked and found the following:
- North Saanich, Central Saanich and Saanich did not change between 1976-2006
- Victoria was combined with Saanich in 1976
- Victoria was combined with Subdivision B in 1981 and 1986
- Victoria (as a CCS) was amalgamated with Saanich in 1991 to 2006.
- Capital Subdivision A (islands) was split in 2001 and 2006 into Capital F and Capital G
- Capital Subdivision B and C (D in 1991 and 1996) were combined in 2001 and 2006 into Capital H part 2"
I am still waiting to hear back from them about your offlist question regarding the provenance of the CCS codes used in the 1976 files.
Music Grads and Employment
Question
Can the DLI resources answer the following question: "the number of music majors who get jobs when they graduate?"
Answer
This may be available as a custom extraction (for a fee) from the National graduates Survey (NGS). The variables in the NGS survey PUMFs unfortunately wouldn't allow you to answer the question as the industry and instructional program groupings are too large. Visual and performing arts, and communications technologies instructional programs seem to be grouped together as are Occupations in art, culture, recreation and sport.
The music department at UVic or an industry association may have statistics on this subject. Other DLI Contacts may have some helpful suggestions for your as well.
Can the DLI resources answer the following question: "the number of music majors who get jobs when they graduate?"
Answer
This may be available as a custom extraction (for a fee) from the National graduates Survey (NGS). The variables in the NGS survey PUMFs unfortunately wouldn't allow you to answer the question as the industry and instructional program groupings are too large. Visual and performing arts, and communications technologies instructional programs seem to be grouped together as are Occupations in art, culture, recreation and sport.
The music department at UVic or an industry association may have statistics on this subject. Other DLI Contacts may have some helpful suggestions for your as well.
Friday, November 6, 2009
License and File Export
Question
One our students is studying abroad:
"I am a Killam Fellow at American University in DC for the fall semester, so I
cannot get to the library... I am back after Christmas."
Two questions:
1. There is any problem with giving him access to DLI content. He wants three cycles of the GSS: 2000, 2004, and 2006 International Youth Survey 2000 National Survey of Giving, Volunteering and Participation
2. Any advice on how to get these files over to him... I already have them on
a server here at MTA.
Answer
If the student is currently registered at Mount Allison he is an authorised user and is eligible to use DLI data if he intends to use it for academic research and publishing, teaching, or planning of educational services.
Please note that he can not however share the data with other students, researchers or faculty at the American University. Only he can have access and work on the data.
You could send him the files on a CD or put them on an server he can access remotely. Other DLI Contacts may have some helpful suggestions for you as well.
One our students is studying abroad:
"I am a Killam Fellow at American University in DC for the fall semester, so I
cannot get to the library... I am back after Christmas."
Two questions:
1. There is any problem with giving him access to DLI content. He wants three cycles of the GSS: 2000, 2004, and 2006 International Youth Survey 2000 National Survey of Giving, Volunteering and Participation
2. Any advice on how to get these files over to him... I already have them on
a server here at MTA.
Answer
If the student is currently registered at Mount Allison he is an authorised user and is eligible to use DLI data if he intends to use it for academic research and publishing, teaching, or planning of educational services.
Please note that he can not however share the data with other students, researchers or faculty at the American University. Only he can have access and work on the data.
You could send him the files on a CD or put them on an server he can access remotely. Other DLI Contacts may have some helpful suggestions for you as well.
Levels of Geography for Agricultural Data
Question
What is the smallest level of geography for which one can obtain data on (a) number of livestock (preferably, but not necessarily broken down by species), with no regard for the number of farms they come from, and (b) the number of farms (of any kind, not just livestock farms)?
Two researchers here at York are interested in getting data for an area that, as closely as possible, conforms to the area of a watershed that straddles the border between Perth and Wellington counties in Western Ontario. The closest they can get from DLI data is the North Perth CCS, contains about 60% of the watershed, but is actually at least twice its size. The other portion is not within any of the CCS in Wellington County. Can they get the numbers they want (via a custom tabulation) for each of the CSDs in the relevant area, or is the DLI data the best they can hope for?
Answer
Our Agriculture Division can produce data for custom, user-defined, geographies for a fee. If the researchers wish to look into this, I will be pleased to refer you to an Account-Executive in our Toronto Office who can provide costs estimates and production timelines for such a product.
Our contacts in the Agriculture Division also mentioned that they have provided AAFC (Agriculture and Agri-Food Canada) with Census of Agriculture data at the Soil Landscapes of Canada (SLC) level for all of Canada. They suggested that you consult this resource before requesting a custom data extraction:
Interpolated Census of Agriculture to Soil Landscapes, Ecological Frameworks and Drainage Areas of Canada
http://www4.agr.gc.ca/AAFC-AAC/display-afficher.do?id=1227624499292?=eng (See the Access Data section at the very bottom of that page. The links in this section appear to provide access to the Census of Agriculture data (1971-2006).)
What is the smallest level of geography for which one can obtain data on (a) number of livestock (preferably, but not necessarily broken down by species), with no regard for the number of farms they come from, and (b) the number of farms (of any kind, not just livestock farms)?
Two researchers here at York are interested in getting data for an area that, as closely as possible, conforms to the area of a watershed that straddles the border between Perth and Wellington counties in Western Ontario. The closest they can get from DLI data is the North Perth CCS, contains about 60% of the watershed, but is actually at least twice its size. The other portion is not within any of the CCS in Wellington County. Can they get the numbers they want (via a custom tabulation) for each of the CSDs in the relevant area, or is the DLI data the best they can hope for?
Answer
Our Agriculture Division can produce data for custom, user-defined, geographies for a fee. If the researchers wish to look into this, I will be pleased to refer you to an Account-Executive in our Toronto Office who can provide costs estimates and production timelines for such a product.
Our contacts in the Agriculture Division also mentioned that they have provided AAFC (Agriculture and Agri-Food Canada) with Census of Agriculture data at the Soil Landscapes of Canada (SLC) level for all of Canada. They suggested that you consult this resource before requesting a custom data extraction:
Interpolated Census of Agriculture to Soil Landscapes, Ecological Frameworks and Drainage Areas of Canada
http://www4.agr.gc.ca/AAFC-AAC/display-afficher.do?id=1227624499292?=eng (See the Access Data section at the very bottom of that page. The links in this section appear to provide access to the Census of Agriculture data (1971-2006).)
Subscribe to:
Posts (Atom)