Question
A lab instructor for a large Research Methods class has inquired about possibly using DLI data for their labs. It is a large class, with 6 sections, and a total of about 180 students. Given the large size of the class, the instructor would like to try to use small subsets of the GSS, 10-15 variables, to correspond to specific research methods. The instructor would post these subsets onto WebCT for the students to use during the labs. The instructor could put these files up before the classes and take them down at the end of the week, or right after the classes if required. The students would complete small assignments during class tie and submit them at the end of the class period. Only students registered in the class would have access to the files. Would this be allowed under the DLI license? The "use" would of course be educational. However, would this be viewed as "redistribution" of the data?
Answer
This is a wonderful example of the teaching value of DLI data. Yes, this is definitely an acceptable use of the data licensed under DLI. In addition, WebCT adds another level of authentication to gaining access since students are required by WebCT to use an ID and password to enter this instructional webspace. The experiences of this lab use would make a great DLI Update article.
Monday, October 24, 2005
Thursday, October 13, 2005
NLSCY Cycle 5 - Download Problems
Question
I have downloaded from the ftp site the files for NLSCY Cycle 5. The Coefficient of Variation Interface works fine from my pc, but when I loaded onto our website (using the same file structure and file name), I get the following errors:
Children 0-5 years - Run time error '1004' Method 'Sheets' of object'_Global' failed Children and Youth 8-19 years - Run time error '9' Subscript out of Range (same error for French or English version). Any suggestions?
Answer
I just met with an individual of Special Surveys Division to see if there was a simple answer to your question. We reviewed the files on the FTP and as the product is installing properly on your PC, which is the intended use of the product, there is no support for using the files as you describe. However, they suggested that perhaps not all files were being transferred over? Please ensure that all files listed on the FTP are transferred to the web. Also, they suggest that you create two folders (0-5 and 8-19) and follow the same reporting structure and demonstrated on the FTP. It could be that the program is looking for a file in a certain folder but it is found elsewhere - thus causing the trouble. Apologies for not being able to completely resolve the problem, but I hope the suggestions bring you one step closer.
I have downloaded from the ftp site the files for NLSCY Cycle 5. The Coefficient of Variation Interface works fine from my pc, but when I loaded onto our website (using the same file structure and file name), I get the following errors:
Children 0-5 years - Run time error '1004' Method 'Sheets' of object'_Global' failed Children and Youth 8-19 years - Run time error '9' Subscript out of Range (same error for French or English version). Any suggestions?
Answer
I just met with an individual of Special Surveys Division to see if there was a simple answer to your question. We reviewed the files on the FTP and as the product is installing properly on your PC, which is the intended use of the product, there is no support for using the files as you describe. However, they suggested that perhaps not all files were being transferred over? Please ensure that all files listed on the FTP are transferred to the web. Also, they suggest that you create two folders (0-5 and 8-19) and follow the same reporting structure and demonstrated on the FTP. It could be that the program is looking for a file in a certain folder but it is found elsewhere - thus causing the trouble. Apologies for not being able to completely resolve the problem, but I hope the suggestions bring you one step closer.
Low Income Lone Mothers
Question
Is it possible to find a number or percentage of poor (low income or "LICO" status) lone mothers in Vancouver, Toronto and Halifax by Census Tract, or at least, an area smaller than just a CMA?
Answers
1. The lowest geography I found crossing incidence of low income and family type was at the CMA level. I did not see any standard tables with this information at a lower level. The Census PUMF would not be an alternative as the lowest level of geography is the CMA. Unless someone out there knows another source for this information, I would say cost-recovery is your only option for STC stuff.
2. This would be far too detailed a table with income in it. I am quite sure that CMA is the lowest for which standard data would be available. I am not sure about a custom table but one must remember that income is a sensitive varaible.
Is it possible to find a number or percentage of poor (low income or "LICO" status) lone mothers in Vancouver, Toronto and Halifax by Census Tract, or at least, an area smaller than just a CMA?
Answers
1. The lowest geography I found crossing incidence of low income and family type was at the CMA level. I did not see any standard tables with this information at a lower level. The Census PUMF would not be an alternative as the lowest level of geography is the CMA. Unless someone out there knows another source for this information, I would say cost-recovery is your only option for STC stuff.
2. This would be far too detailed a table with income in it. I am quite sure that CMA is the lowest for which standard data would be available. I am not sure about a custom table but one must remember that income is a sensitive varaible.
Number of Jobs by Census Tracts
Last August, I had a special request from a professor working in the Transportation Department of Ecole Polytechnique and I would like to share results of my request with you.
The professor wanted the number of jobs by census tracts in Montreal related to place of work and not residential location. The only documents that answered that request are the following:
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0036
Place of Work Status (3), Industry - 1997 North American Industry Classification System (21) and Work Activity (4) for Employed Labour Force 15 Years and Over Having a Usual Place of Work or Working at Home, for Census Metropolitan Areas, Census Agglomerations and Census Tracts of Work, 2001 Census - 20% Sample Data
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0037
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0038
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0039
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0040
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0041
These files are available in the ftp dli collection. I used the file Dirlist.txt with the command "CTRL F" to find the documents.
Census/2001/B2020/Topic-Based-Tabulations/place-of-work-b2020/ct-sr/workplace_travail:
total 13684
dr-xr-x--- 2 dli dli 512 Jun 17 11:31 ./
dr-xr-x--- 4 dli dli 512 Jun 17 11:31 ../
-r-xr-x--- 1 dli dli 2140777 Jun 17 11:31 97c0036.ivt*
-r-xr-x--- 1 dli dli 796517 Jun 17 11:31 97c0037.ivt*
-r-xr-x--- 1 dli dli 1608198 Jun 17 11:31 97c0038.ivt*
-r-xr-x--- 1 dli dli 1142969 Jun 17 11:31 97c0039.ivt*
-r-xr-x--- 1 dli dli 778060 Jun 17 11:31 97c0040.ivt*
-r-xr-x--- 1 dli dli 463295 Jun 17 11:31 97c0041.ivt*
N.B. The professor will contact the Census Division for Montréal to obtain the data for 1996.
The professor wanted the number of jobs by census tracts in Montreal related to place of work and not residential location. The only documents that answered that request are the following:
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0036
Place of Work Status (3), Industry - 1997 North American Industry Classification System (21) and Work Activity (4) for Employed Labour Force 15 Years and Over Having a Usual Place of Work or Working at Home, for Census Metropolitan Areas, Census Agglomerations and Census Tracts of Work, 2001 Census - 20% Sample Data
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0037
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0038
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0039
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0040
http://www.statcan.ca:8096/bsolc/english/bsolc?catno=97C0041
These files are available in the ftp dli collection. I used the file Dirlist.txt with the command "CTRL F" to find the documents.
Census/2001/B2020/Topic-Based-Tabulations/place-of-work-b2020/ct-sr/workplace_travail:
total 13684
dr-xr-x--- 2 dli dli 512 Jun 17 11:31 ./
dr-xr-x--- 4 dli dli 512 Jun 17 11:31 ../
-r-xr-x--- 1 dli dli 2140777 Jun 17 11:31 97c0036.ivt*
-r-xr-x--- 1 dli dli 796517 Jun 17 11:31 97c0037.ivt*
-r-xr-x--- 1 dli dli 1608198 Jun 17 11:31 97c0038.ivt*
-r-xr-x--- 1 dli dli 1142969 Jun 17 11:31 97c0039.ivt*
-r-xr-x--- 1 dli dli 778060 Jun 17 11:31 97c0040.ivt*
-r-xr-x--- 1 dli dli 463295 Jun 17 11:31 97c0041.ivt*
N.B. The professor will contact the Census Division for Montréal to obtain the data for 1996.
Survey Names and Acronyms
Introduction of a new WEB page for the DLI Community:
http://www.statcan.ca/english/Dli/dli-collection.htm
http://www.statcan.ca/english/Dli/dli-collection.htm
Personal income per capita (and more!)
Question
A patron is looking for any/all of the following:
Market income per capita
Disposable income per capita
Personal income per capita
Most importantly, he is looking for these variables from 1957-present (annually up to 5 year intervals) and he wants to compare provinces to the national average.
I think I can find some of these if I dig hard enough, but I was hoping someone might have a source at the tips of their
fingers. It could be a data or statistical source.
Answer
CANSIM table 380-0050 has personal income, personal disposable income, and income per capita, by province, annually from 1926-1990.
384-0012 has personal income and personal disposable income from 1980-2004, by province.
Any series that are totals can be divided by the estimated population for the same year, to produce per capita figures, no? The economists on this list will, I am sure, correct me if I am wrong here.
202-0201 has market income, from 1980-2003, for different economic family types, by province.
Since Stats Can defines market income as: Average market income is the sum of earnings (from employment and self-employment), investment income, (private) retirement income, and items under "Other income". It is equivalent to total income minus government transfers. see:
http://www40.statcan.ca/l01/cst01/famil22a.htm
You should therefore be able to derive market income from 1961-1991 from appropriate series in CANSIM table 384-0034, and earlier numbers from the print volumes of the National income and expenditure accounts (13-531).
A patron is looking for any/all of the following:
Market income per capita
Disposable income per capita
Personal income per capita
Most importantly, he is looking for these variables from 1957-present (annually up to 5 year intervals) and he wants to compare provinces to the national average.
I think I can find some of these if I dig hard enough, but I was hoping someone might have a source at the tips of their
fingers. It could be a data or statistical source.
Answer
CANSIM table 380-0050 has personal income, personal disposable income, and income per capita, by province, annually from 1926-1990.
384-0012 has personal income and personal disposable income from 1980-2004, by province.
Any series that are totals can be divided by the estimated population for the same year, to produce per capita figures, no? The economists on this list will, I am sure, correct me if I am wrong here.
202-0201 has market income, from 1980-2003, for different economic family types, by province.
Since Stats Can defines market income as: Average market income is the sum of earnings (from employment and self-employment), investment income, (private) retirement income, and items under "Other income". It is equivalent to total income minus government transfers. see:
http://www40.statcan.ca/l01/cst01/famil22a.htm
You should therefore be able to derive market income from 1961-1991 from appropriate series in CANSIM table 384-0034, and earlier numbers from the print volumes of the National income and expenditure accounts (13-531).
International Trade Classification
Question
Students here are looking at the prospect of analyzing trade statistics for renewable energy technologies (e.g., windmills and components). Are these components explicitly identified in the SITC (and if so, where)?
Answers
1. The classification system of goods does not define whether the commodities are used for specific reasons (eg. energy). I did visit the Canadian International Merchandise Trade page
http://www.statcan.ca/trade/scripts/trade_search.cgi
and performed a keyword search for "windmills." I got some results and the codes that accompany the commodity. You can maybe use that code to access data through the Stats Can trade databases.
I always find this to be a useful tool to find commodity codes.
2. There's an outline of the SITC (4-digit) at:
http://pacific.commerce.ubc.ca/trade/sitc3-4.html
Code 7189 contains: Power generating machinery and parts thereof, n.e.s.: Engines and motors, n.e.s. (e.g., wind engines and hot air engines) and parts thereof, including parts of reaction engines (other than turbo jet parts).
Students here are looking at the prospect of analyzing trade statistics for renewable energy technologies (e.g., windmills and components). Are these components explicitly identified in the SITC (and if so, where)?
Answers
1. The classification system of goods does not define whether the commodities are used for specific reasons (eg. energy). I did visit the Canadian International Merchandise Trade page
http://www.statcan.ca/trade/scripts/trade_search.cgi
and performed a keyword search for "windmills." I got some results and the codes that accompany the commodity. You can maybe use that code to access data through the Stats Can trade databases.
I always find this to be a useful tool to find commodity codes.
2. There's an outline of the SITC (4-digit) at:
http://pacific.commerce.ubc.ca/trade/sitc3-4.html
Code 7189 contains: Power generating machinery and parts thereof, n.e.s.: Engines and motors, n.e.s. (e.g., wind engines and hot air engines) and parts thereof, including parts of reaction engines (other than turbo jet parts).
Subscribe to:
Posts (Atom)