Société canadienne d'hypothèques et de logement, loyers moyens pour les régions de 10 000 habitants et plus

Suivre :

Société canadienne d'hypothèques et de logement, loyers moyens pour les régions de 10 000 habitants et plus
Votez :
Nombre de votes : 57
Veuillez prendre note que les commentaires sont modérés. Les commentaires peuvent prendre un certain temps avant d’apparaître en ligne. Pour de plus amples renseignements, veuillez consulter nos règles de participation.

Commentaires d'utilisateurs

Is there a way to join this to a table provided by open.canada that will provide the coordinate location of the cities?

It's not clear what the "Vector" and "Coordinate" columns imply.

Sample data:

Vector Coordinate
v42135513 192.3.1
v42135513 192.3.1
v42135513 192.3.1
v42135513 192.3.1
v42135513 192.3.1

Is this somehow related to location?

Hi Vaughn,

A vector number is a unique identifier that has been assigned by the database to a time series of data.
Vectors are applied for each time series so if you have 10 different time periods the vector will include 10 data points. Vectors do not change and are unique within the database so they can be used to call data.

A coordinate is a unique numerical representation of the combinations of members from the table’s dimensions. It consists of a string of local IDs (also known as member IDs) separated by periods. (for example 1.2.1, 3.1.10), entered in the same order as the dimensions are loaded in a table. The coordinate is a unique number within a table but not within the database. They are used mostly for data loading purposes.

Why are there negative values for some rows? I see in the legend that "F" means unreliable data, and ".." means unavailable, that's fine. But I'm also seeing lots of entries like "-99", "-97", "-95". Those are clearly incorrect for rent values, are they some sort of internal code that should be explained in the legend?

Thank you for your comment. The following response has been posted on behalf of Canada Mortgage and Housing Corporation :

"The codes with negative values essentially mean that data is not available. Specific values can indicate that the data is suppressed either to protect the confidentiality of respondents or for reasons of data reliability. They can also indicate that there is no universe or sample. The actual codes used have changed over time; however, historical revisions were not made to existing data points to replace the older codes.

Users of our data will encounter the following codes:

-99 = data suppressed,
-98 = no universe,
-97 = No sample,
-96 = Not applicable,
-95 = data suppressed,
-94 = data suppressed,
-93 = Change in rent is not statistically different than zero (0)

When the CMHC Time Series system was originally developed it was done in conjunction with Statistics Canada and the system only allowed for one value to be associated with each date in the time series. More recently, Statistics Canada has changed their database to allow for individual data points to have a code to be associated with them to give further information about the individual data point. For example, a letter could be associated with the estimate to give information on the quality of the estimate. Because Statistics Canada is not our only secondary distributor of Time Series, this change was not implemented in our system because it would only apply to one distributor. Thus, we don't make use of this second code in CANSIM, which is the process we use to load data to the Open Data site.

In order to make the data more transparent to our users, all time series will be reviewed to ensure that the codes are explained in the notes associated with each of our series group. It is anticipated that this will be available later 2014".

Thank you.