Thursday, July 31, 2014

SLID 2011 Release

Question

I am helping a PhD student who would like the most recent version (2011) release of the SLID PUMF. The latest info on the website calls for a Spring 2014 release. This information was last updated on October 2013, is there now more precise information a release date?

Answer

The SLID was released on the EFT on July 31, 2014.

Wednesday, July 30, 2014

Manipulating NESSTAR Data

Question

What was said at ACCOLEDS as to who can get a password and user ID to manipulate the NESSTAR data -- is it only the DLI contacts and designates?

Answer

You are correct, these are in the plans and we are working with our IT services to put it in place. At the moment, only DLI Contacts and Designates are provided with a username and password, but our plans are to open it by restricting to IP for DLI Institutions.

In regards to linking to specific entries, see: <http://www.statcan.gc.ca/dli-ild/products-eng.htm>

Tuesday, July 29, 2014

2011 Census PUMF

Question

When will there be a PUMF produced based on 2011 Census data?

Answer

The Individuals File, 2011 NHS PUMF is to be released today. We are still waiting to receive the file, but the PUMF will soon be available on the DLI EFT.

Monday, July 28, 2014

PUMF Access to Foreign-Based Researchers

Question

I have received a request from a foreign-based researcher to access PUMF. I wanted to know if Stat Can has developed any arrangement for foreign-based researchers to access PUMFs. If there’s such an arrangement, could you please direct me to the web page or other source of information on the application process.

Answer

They can contact Statistics Canada to acquire a PUMF. If you know the exact PUMF they are looking for, we can direct them to the appropriate PUMF page where there is an order form. If they are interested in accessing multiple PUMFs, there is the Public Use Microdata File (PUMF) Collection program: <http://www.statcan.gc.ca/pub/11-625-x/11-625-x2010000-eng.htm>

Alternatively, they can contact Advisory services: <http://www.statcan.gc.ca/eng/reference /refcentre-centreref/index-eng?MM>

Sunday, July 27, 2014

Alcohol/Drug Use and Crime Stats at the CSD Level or Lower

Question

I have a researcher who’s looking for alcohol/drug use and crime stats at the CSD level or lower. Do the RDC files contain data at that level?

Answer


For Alcohol/Drug use alone, you might want to contact the Health Division. 

For accused of criminal charges by offenders under the influence of Alcohol/Drug, I can refer you to two specific crimes:

1) Homicide: In the Juristat Homicide in Canada, 2012, there is a chapter named Alcohol and/or drug consumption common in homicide <http://www.statcan.gc.ca/pub/85-002-x/2013001/article/11882-eng.htm#a14>. It includes the following tables:

Table 1a Number of homicides, by province or territory, 1982 to 2012
Table 1b Rate of homicides, by province or territory, 1982 to 2012
Table 3 Homicides, by census metropolitan area, 2011 and 2012
Table 4 Homicides, by type of method, Canada, 2002 to 2012
Table 5 Homicides, by shootings and stabbings, by selected census metropolitan areas, 2012
Table 7 Number of gang-related homicides, by region, 2002 to 2012
Table 8 Gang-related homicides, by selected census metropolitan areas, 2012

2) Impaired Driving: In CANSIM table 252-0051 Incident-based crime statistics, by detailed violations, annual (Number), 1998 to 2012, there are several offences involving alcohol/drug use:
- Offences related to Impaired driving: Total impaired driving, Impaired operation causing death, Impaired operation (drugs) causing death, Impaired operation causing bodily harm, Impaired operation (drugs) causing bodily harm, Impaired operation of motor vehicle, vessel or aircraft, Impaired operation (drugs) vehicle, vessel, aircraft, Failure to provide breath sample, Failure to comply or refusal (drugs), Failure to provide blood sample.

- Offences related to drugs (but not “use of drug” in case you are interested): Total drug violations, Possession cannabis, Possession cocaine, Total possession other Controlled Drugs and Substances Act drugs, Heroin possession, Other Controlled Drugs and Substances Act possession, Methamphetamines (crystal meth) possession, Methylenedioxyamphetamine (ecstasy) possession, Total cannabis trafficking, production or distribution Cannabis, trafficking Cannabis, importation and exportation Cannabis, production, Total cocaine trafficking, production or distribution, Cocaine trafficking Cocaine importation and exportation, Cocaine production, Total other Controlled Drugs and Substances Act drugs, trafficking, production or distribution, Heroin trafficking, Other Controlled Drugs and Substances Act trafficking, Methamphetamines (crystal meth), trafficking, Methylenedioxyamphetamine (ecstasy) trafficking, Heroin importation and exportation, Other Controlled Drugs and Substances Act, importation and exportation, Methamphetamines (crystal meth) importation and exportation, Methylenedioxyamphetamine (ecstasy) importation and exportation, Heroin production, Other Controlled Drugs and Substances Act production, Methamphetamines (crystal meth), production, Methylenedioxyamphetamine (ecstasy) production, Precursor or equipment (crystal meth, ecstasy)

****************************************

In regards to the RDC files, the minimum level of geography available for urban areas will be the census tract (CT) and the census subdivision (CSD) is the minimum level for rural areas.

The RDC data files have geography at the CT or CSD level where CT is not available (e.g., rural areas)

Friday, July 25, 2014

Landfills

Question

I am trying to help someone find the number of landfills in Canada, Nova Scotia, Ontario and Quebec. I think I may have found numbers for NS and Ontario but not  Quebec. Incidentally, I have found that SK has more than 700 but she doesn't need that number. This seems to become quite complicated. There are large landfills and there are small landfills. Some are public and some are private. I am thinking that maybe they are in one of the DMTI layers (Enhanced point of interest?) but I haven't managed to locate the information there, yet, either. If you can help point me in the right directions, I would be very grateful.

Answer

Infostats  responded: "Information about the waste management industry is available in the CANSIM tables listed on this page of our website.

- Tables 153-0044 and 153-0045 may be of particular interest to the client.

- Table 153-0044 shows the total number of businesses in the waste management industry, by province. The same information is however not available for the public sector (153-0045).

Furthermore, information on business location counts by industry, by employment size and by province is available in CANSIM table 551-0005.

Data for the following industries can be found in this table:
Waste collection [562110]
Waste treatment and disposal [562210]
All other waste management services [562990]

The number of landfills by province is not available as a standard product on our website, but may be available through a custom request.

The client can send Infostats an e-mail with her detailed data requirements (variables, time frame, geography, etc.) as well as his/her complete contact information and Infostats will forward her request to the Advisory Services.

An agent will contact him/her back to inform him/her if the data he is seeking is available and to provide him/her with a free time and cost estimate, would any charges apply.

Finally, the client may want to contact Environment Canada as they might have more information on this subject: <www.ec.gc.ca or http://ec.gc.ca/gdd-mw/default.asp?lang=En&n=6F92E701-1>

Population Used to Calculate Income Deciles for the NHS

Question
A researcher is analysing income decile distribution by Census Tracts across Canada, and wants to know what the population is that was used to classify people by income deciles? Is it just one population as we think: anada, or some other level of geography?

We found this definition:
All people have been classified into 10 equal income groups according to the adjusted after-tax income of their economic family. In the first decile group the median individuals' total income was $7,400, in the fifth decile group it was $33,000, and in the top decile group it was $80,600. … in the analytic document on Income composition in Canada <http://www12.statcan.gc.ca/nhs-enm/2011/as-sa/99-014-x/99-014-x2011001-eng.pdf>

Answer

In consultation with the author division, please see response below:

Income deciles can be calculated for different geographic areas. In the analytical document mentioned below Income Composition in Canada <http://www12.statcan.gc.ca/nhs-enm/2011/as-sa/99-014-x/99-014-x2011001-eng.cfm#a2> the decile information provided is at the Canada level.

We have these data tables from the 2011 NHS have the decile breakdowns for Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations:

For example, for Ontario:

- Selected Demographic, Income and Sociocultural Characteristics (109), Income Statistics in 2010 (3) and Income Sources (16) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2011 National Household Survey <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/dt-td/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM =0&FL=A&FREE=0&GC=0&GID=1118302&GK=0&GRP=0&O=D&PID=106736&PRID=0&PTYPE=105277&S=0&SHOWALL=0&SUB=0&Temporal=2013&THEME=98&VID=0&VNAMEE=&VNAMEF=&D1=2&D2=0&D3=0&D4=0&D5=0&D6=0>

- Selected Economic Family and Persons not in Economic Family Characteristics (55), Income Statistics in 2010 (4A) and Income Sources (16) for the Economic Families and Persons not in Economic Families Aged 15 Years and Over in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2011 National Household Survey <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/dt-td/Rp-eng.cfmLANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FRE=0&GC=0&GID =0&GK=0&GRP=0& PID= 107004&PRID=0&PTYPE=105277&S=0&SHOWALL =0&SUB=0&Temporal=2013&THEME=98&VID=0&VNAMEE=&VNAMEF=>

- Selected Demographic, Income and Sociocultural Characteristics (109) and Number Reporting and Aggregate Amount Reported from Each Source in 2010 (35) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2011 National Household Survey <http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/dt-td/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=0&PID=106732&PRID=0&PTYPE=105277&S=0&SHOWALL=0&SUB=0&Temporal=2013&THEME=98&VID=0&VNAMEE=&VNAMEF=>

For the Census Tract level data the only standard product that has the decile breakdown is the NHS Profile:

For example, for the CT 9150001.00 here is the NHS Profile which gives Total population by decile of adjusted after-tax family income: NHS Profile, 0001.00, British Columbia, 2011 <http://www12.statcan.gc.ca /nhs-enm/2011/dp-pd/prof/details/page.cfm?Lang=E&Geo1=CT&Code1=3826&Data=Count&SearchText=9150001.00&SearchType=Begins&SearchPR=01&A1=All&B1=All&Custom=&TABID=3>

If you would like any other decile breakdowns for the CT level of geography then a custom data tabulation would need to be ordered through the nearest regional office.