C.V.s for Visit-Expenditures by Duration of Visit, Main Trip Purpose and Country or Region of Expenditures, Q3 2019 in Thousands of Dollars (x 1,000)
Table summary
This table displays the results of C.V.s for Visit-Expenditures by Duration of Visit, Main Trip Purpose and Country or Region of Expenditures. The information is grouped by Duration of trip (appearing as row headers), Main Trip Purpose, Country or Region of Expenditures (Total, Canada, United States, Overseas) calculated using Visit-Expenditures in Thousands of Dollars (x 1,000) and c.v. as units of measure (appearing as column headers).
Duration of Visit
Main Trip Purpose
Country or Region of Expenditures
Total
Canada
United States
Overseas
$ '000
C.V.
$ '000
C.V.
$ '000
C.V.
$ '000
C.V.
Total Duration
Total Main Trip Purpose
27,521,742
A
17,683,076
A
4,839,752
B
4,998,914
B
Holiday, leisure or recreation
16,327,462
A
9,824,816
A
3,365,144
B
3,137,502
B
Visit friends or relatives
6,477,084
A
4,585,518
A
613,497
B
1,278,069
C
Personal conference, convention or trade show
357,441
B
247,563
C
95,198
D
14,680
E
Shopping, non-routine
763,620
B
616,190
B
147,430
C
..
Other personal reasons
1,221,365
B
888,535
B
183,224
E
149,606
E
Business conference, convention or trade show
926,902
B
546,367
B
247,906
C
132,629
D
Other business
1,447,868
B
974,087
B
187,353
C
286,428
E
Same-Day
Total Main Trip Purpose
5,013,925
A
4,614,295
A
347,927
B
51,703
E
Holiday, leisure or recreation
2,335,908
B
2,124,745
B
159,461
C
51,703
E
Visit friends or relatives
1,255,164
B
1,198,787
B
56,377
D
..
Personal conference, convention or trade show
66,346
C
63,112
C
3,234
E
..
Shopping, non-routine
624,822
B
521,532
B
103,291
C
..
Other personal reasons
322,718
B
315,858
B
6,860
E
..
Business conference, convention or trade show
71,933
D
61,464
D
10,469
E
..
Other business
337,033
C
328,797
C
8,235
E
..
Overnight
Total Main Trip Purpose
22,507,816
A
13,068,781
A
4,491,825
B
4,947,211
B
Holiday, leisure or recreation
13,991,554
A
7,700,072
A
3,205,683
B
3,085,799
B
Visit friends or relatives
5,221,920
B
3,386,731
A
557,120
B
1,278,069
C
Personal conference, convention or trade show
291,095
C
184,451
C
91,964
D
14,680
E
Shopping, non-routine
138,797
C
94,658
C
44,139
D
..
Other personal reasons
898,647
B
572,677
B
176,364
E
149,606
E
Business conference, convention or trade show
854,969
B
484,903
B
237,437
C
132,629
D
Other business
1,110,835
B
645,289
B
179,118
C
286,428
E
..
data not available
Estimates contained in this table have been assigned a letter to indicate their coefficient of variation (c.v.) (expressed as a percentage). The letter grades represent the following coefficients of variation:
A
c.v. between or equal to 0.00% and 5.00% and means Excellent.
B
c.v. between or equal to 5.01% and 15.00% and means Very good.
C
c.v. between or equal to 15.01% and 25.00% and means Good.
D
c.v. between or equal to 25.01% and 35.00% and means Acceptable.
E
c.v. greater than 35.00% and means Use with caution.
C.V.s for Person-Trips by Duration of Trip, Main Trip Purpose and Country or Region of Trip Q3 2019
Table summary
This table displays the results of C.V.s for Person-Trips by Duration of Trip, Main Trip Purpose and Country or Region of Trip Destination. The information is grouped by Duration of trip (appearing as row headers), Main Trip Purpose, Country or Region of Trip Destination (Total, Canada, United States, Overseas) calculated using Person-Trips in Thousands (× 1,000) and C.V. as a units of measure (appearing as column headers).
Duration of Trip
Main Trip Purpose
Country or Region of Trip Destination
Total
Canada
United States
Overseas
Person-Trips (x 1,000)
C.V.
Person-Trips (x 1,000)
C.V.
Person-Trips (x 1,000)
C.V.
Person-Trips (x 1,000)
C.V.
Total Duration
Total Main Trip Purpose
101,520
A
91,523
A
7,514
A
2,482
A
Holiday, leisure or recreation
46,551
A
41,114
A
4,055
A
1,382
B
Visit friends or relatives
36,220
A
33,848
A
1,558
B
814
B
Personal conference, convention or trade show
1,683
C
1,505
C
158
C
21
E
Shopping, non-routine
5,060
B
4,136
B
924
B
..
Other personal reasons
5,827
B
5,440
B
314
D
73
D
Business conference, convention or trade show
1,713
B
1,370
B
279
D
65
D
Other business
4,465
B
4,111
B
227
C
127
D
Same-Day
Total Main Trip Purpose
59,108
A
55,946
A
3,161
B
..
Holiday, leisure or recreation
24,199
A
22,851
A
1,348
B
..
Visit friends or relatives
21,064
A
20,490
A
574
C
..
Personal conference, convention or trade show
1,040
C
1,016
C
24
E
..
Shopping, non-routine
4,688
B
3,845
B
844
C
..
Other personal reasons
4,254
B
4,030
B
224
E
..
Business conference, convention or trade show
719
C
640
C
79
E
..
Other business
3,143
B
3,075
B
68
E
..
Overnight
Total Main Trip Purpose
42,412
A
35,577
A
4,353
A
2,482
A
Holiday, leisure or recreation
22,352
A
18,263
A
2,707
A
1,382
B
Visit friends or relatives
15,156
A
13,358
A
983
B
814
B
Personal conference, convention or trade show
643
C
489
C
134
C
21
E
Shopping, non-routine
371
C
292
C
80
D
..
Other personal reasons
1,573
B
1,410
B
90
D
73
D
Business conference, convention or trade show
994
B
730
B
200
C
65
D
Other business
1,322
B
1,036
B
159
C
127
D
..
data not available
Estimates contained in this table have been assigned a letter to indicate their coefficient of variation (c.v.) (expressed as a percentage). The letter grades represent the following coefficients of variation:
A
c.v. between or equal to 0.00% and 5.00% and means Excellent.
B
c.v. between or equal to 5.01% and 15.00% and means Very good.
C
c.v. between or equal to 15.01% and 25.00% and means Good.
D
c.v. between or equal to 25.01% and 35.00% and means Acceptable.
E
c.v. greater than 35.00% and means Use with caution.
Weighted Asset Response Rate
Table summary
This table displays the results of Weighted Asset Response Rate. The information is grouped by Release date (appearing as row headers), 2018 Q3 and Q4, and 2019 Q1, Q2 and Q3 calculated using percentage units of measure (appearing as column headers).
Release date
2018
2019
Q4
Q1
Q2
Q3
Q4
Quarterly (percentage)
February 25, 2020
83.5
85.2
81.9
75.4
62.4
November 26, 2019
83.5
84.6
80.1
64.9
..
August 23, 2019
83.5
81.9
65.2
..
..
May 24, 2019
83.5
67.5
..
..
..
February 26, 2019
60.0
..
..
..
..
.. not available for a specific reference period Source: Quarterly Survey of Financial Statements (2501)
Statistics Canada is modernizing its methods of data access to improve its service to users of Statistics Canada data. The goal of modernization is to fully realize the potential of the data holdings created for the public good and increase collaboration and partnerships between data users and providers while ensuring that all data assets are protected against unauthorized use and disclosure.
Objective
This privacy impact assessment identifies and explores privacy, confidentiality and security issues associated with the use of video surveillance monitoring (camera monitoring) in secure facilities designed for the purposes of data access and makes recommendations for issue resolution or mitigation.
Description
Statistics Canada is planning on expanding controlled access to anonymized microdata for statistical research projects, by establishing Secure Access Points on the premises of federal, provincial, territorial, and municipal governments, universities, and other organizations. Each Secure Access Point is a secure Statistics Canada facility that meets Statistics Canada's departmental security standards for data access, including controlled access monitoring. Any data stored on these premises remain under the care and control of Statistics Canada and subject to the confidentiality provisions of the Statistics Act.
In each Secure Access Point, video surveillance cameras will be used to monitor activity and access. Only Statistics Canada employees and deemed employees (individuals providing statistical services to Statistics Canada under contract or written arrangement) will have access to the microdata within Secure Access Points.
Statistics Canada's use of the camera monitoring includes making recordings of activities in the secure designated room to offer enhanced protection of employees and assets.
Risk Area Identification and Categorization
The PIA also identifies the risk areas and categorizes the level of potential risk (level 1 representing the lowest level of potential risk and level 4, the highest) associated with the collection and use of personal information of employees.
Type of program or activity – Level 2: Administration of program or activity and services.
Type of personal information involved and context – Level 1: Only personal information, with no contextual sensitivities, collected directly from the individual or provided with the consent of the individual for disclosure under an authorized program.
Program or activity partners and private sector involvement – Level 3: With other institutions or a combination of federal, provincial or territorial, and municipal governments.
Duration of the program or activity – Level 3: Long-term (ongoing) program.
Program population – Level 1: The program's use of personal information for internal administrative purposes affects certain employees (or deemed employees).
Personal information transmission – Level 3: The personal information is transferred to a portable device (i.e., USB key, diskette, laptop computer), transferred to a different medium or is printed.
Technology and privacy: The new project involves the implementation of a new electronic system to support the program but does not involve the implementation of new technologies.
Privacy breach: There is a very low risk of a breach of some of the personal information being disclosed:
a) The impact on the employee would be minimal as it would only divulge a digital recording of the individual taken in the Secure Access Point.
b) The impact on the institution would be minimal due to the low sensitivity of the information.
Conclusion
This assessment concludes that, with the existing Statistics Canada safeguards, any remaining risks are either negligible or are such that Statistics Canada is prepared to accept and manage the risk.
Statement outlining results, risks and significant changes in operations, personnel and program
A) Introduction
Statistics Canada's mandate
Statistics Canada ("the agency") is a member of the Innovation, Science and Industry portfolio.
Statistics Canada's role is to ensure that Canadians have access to a trusted source of statistics on Canada that meets their highest priority needs.
The agency's mandate derives primarily from the Statistics Act. The Act requires that the agency collect, compile, analyze and publish statistical information on the economic, social, and general conditions of the country and its people. It also requires that Statistics Canada conduct the census of population and the census of agriculture every fifth year, and that it protect the confidentiality of the information with which it is entrusted.
Statistics Canada also has a mandate to co-ordinate and lead the national statistical system. The agency is considered a leader, among statistical agencies around the world, in co–ordinating statistical activities to reduce duplication and reporting burden.
has been prepared by management, as required by Section 65.1 of the Financial Administration Act, and in the form and manner prescribed by Treasury Board of Canada Secretariat;
has not been subject to an external audit or review.
Statistics Canada has the authority to collect and spend revenue from other federal government departments and agencies, as well as from external clients, for statistical services and products.
Basis of presentation
This quarterly report has been prepared by management using an expenditure basis of accounting. The accompanying Statement of Authorities includes the agency's spending authorities granted by Parliament and those used by the agency consistent with the Main Estimates for the 2019–2020 fiscal year. This quarterly report has been prepared using a special purpose financial reporting framework designed to meet financial information needs with respect to the use of spending authorities.
The authority of Parliament is required before moneys can be spent by the Government. Approvals are given in the form of annually approved limits through appropriation acts or through legislation in the form of statutory spending authority for specific purposes.
The agency uses the full accrual method of accounting to prepare and present its annual departmental financial statements that are part of the departmental results reporting process. However, the spending authorities voted by Parliament remain on an expenditure basis.
B) Highlights of fiscal quarter and fiscal year-to-date results
This section highlights the significant items that contributed to the net increase in resources available for the year, as well as actual expenditures for the quarter ended December 31.
Description for Chart 1: Comparison of gross budgetary authorities and expenditures as of December 31, 2018, and December 31, 2019, in thousands of dollars
This bar graph shows Statistics Canada's budgetary authorities and expenditures, in thousands of dollars, as of December 31, 2018 and 2019:
As at December 31, 2018
Net budgetary authorities: $524,082
Vote netting authority: $120,000
Total authority: $644,082
Net expenditures for the period ending December 31: $390,990
Year-to-date revenues spent from vote netting authority for the period ending December 31: $60,963
Total expenditures: $451,953
As at December 31, 2019
Net budgetary authorities: $562,031
Vote netting authority: $120,000
Total authority: $682,031
Net expenditures for the period ending December 31: $426,482
Year-to-date revenues spent from vote netting authority for the period ending December 31: $59,228
Total expenditures: $485,710
Chart 1 outlines the gross budgetary authorities, which represent the resources available for use for the year as of December 31.
Significant changes to authorities
Total authorities available for 2019–2020 have increased by $37.9 million, or 5.9%, from the previous year, from $644.1 million to $682.0 million (Chart 1). This net increase is mostly the result of the following:
An increase of $22.4 million for the 2021 Census of Population program and $3.8 million for the 2021 Census of Agriculture program for new cyclical funding received to cover planning and developmental activities;
An increase of $13.0 million for negotiated salary adjustments;
An increase of $11.7 million for Renewing and Modernizing Statistics Canada, an initiative approved in 2018–2019 which will change the way the federal government collects, uses and shares data while ensuring the privacy of Canadians remains protected;
An increase of $6.3 million for Workload Migration, an initiative approved in 2018–2019 which will migrate the information technology infrastructure and applications to the Cloud;
An increase of $3.2 million for the Survey of Financial Security and Annual Household Wealth Tables;
A decrease of $9.8 million for the Statistical Survey Operations pay equity settlement, marking the near completion of the pay equity settlement;
A decrease of $6.2 million for the 2016 Census of Population program and $2.2 million for the 2016 Census of Agriculture program due to the cyclical nature of funding that is winding down;
A decrease of $4.2 million for the reimbursement of eligible paylist expenditures.
The variance is also explained by the reception of authorities at different quarters throughout the year.
In addition to the appropriations allocated to the agency through the Main Estimates, Statistics Canada also has vote net authority within Vote 1, which entitles the agency to spend revenues collected from other federal government departments, agencies, and external clients to provide statistical services. The vote netting authority is stable at $120 million when comparing the third quarter of fiscal years 2018–2019 and 2019–2020.
Significant changes to expenditures
Year-to-date net expenditures recorded to the end of the third quarter increased by $35.5 million, or 9.1% from the previous year, from $391.0 million to $426.5 million (see Table A: Variation in Departmental Expenditures by Standard Object).
Statistics Canada spent approximately 75.9% of its authorities by the end of the third quarter, compared with 74.6% in the same quarter of 2018–2019.
Table A: Variation in Departmental Expenditures by Standard Object (unaudited) Table summary: This table displays the variance of departmental expenditures by standard object between fiscal 2018-2019 and 2019-2020. The variance is calculated for year to date expenditures as at the end of the third quarter. The row headers provide information by standard object. The column headers provide information in thousands of dollars and percentage variance for the year to date variation.
Departmental Expenditures Variation by Standard Object:
Q3 year-to-date variation between fiscal year 2018–2019 and 2019–2020
$'000
%
(01) Personnel
31,546
7.9
(02) Transportation and communications
400
3.7
(03) Information
727
16.7
(04) Professional and special services
-307
-1.6
(05) Rentals
4,976
47.4
(06) Repair and maintenance
315
137.0
(07) Utilities, materials and supplies
-172
-21.8
(08) Acquisition of land, buildings and works
-468
-87.0
(09) Acquisition of machinery and equipment
1,059
47.8
(10) Transfer payments
-
-
(12) Other subsidies and payments
-4,319
-94.0
Total gross budgetary expenditures
33,757
7.5
Less revenues netted against expenditures:
Revenues
-1,735
-2.9
Total net budgetary expenditures
35,492
9.1
Note: Explanations are provided for variances of more than $1 million.
Personnel: The increase is mainly due to the ratification of collective agreements, retroactive salary payments and an overall increase in the agency's activities.
Rentals: The increase is mainly due to timing differences in the payment of various software licences and maintenance fees, new annual software renewal costs, and a fee for the use of additional software licences.
Acquisition of machinery and equipment: The increase is mainly due to the purchase of telecommunication equipment and furniture, as well as interviewer collection tablets.
Other subsidies and payments: The decrease is mainly due to the majority of non-salary payments related to the Statistical Survey Operations pay equity settlement having been paid last fiscal year.
Revenues: The decrease is primarily the result of timing differences in the receipt of funds for scheduled key deliverables.
The variance is also explained by timing differences of payments in this period compared to last fiscal year.
C) Risks and uncertainties
Statistics Canada is currently expending significant effort in modernizing its business processes and tools, in order to maintain its relevance and maximize the value it provides to Canadians. As a foundation piece for some of these efforts, the agency is working in collaboration with Shared Services Canada and Treasury Board of Canada Secretariat, Office of the Chief Information Officer, to ensure the agency has access to adequate information technology services and support to attain its modernization objectives and successfully transition its infrastructure and applications to the cloud. Activities and related costs are projected based on various assumptions that can change, depending on the nature and degree of work required to accomplish the initiatives. Risks and uncertainties are being mitigated by the agency's strong financial planning management practices and business architecture.
D) Significant changes to operations, personnel and programs
There was an important reorganization at the agency, where two new fields, Strategic Engagement and Communications Field and the Digital Solutions Field have been created. This reorganization will help the agency better meet data user needs and expectations, augment efficiencies, enhance integration between subject matters, and increase our value as a world-leading National Statistical Organization. These changes are significant, and will be approached with a phased implementation strategy.
Other minor changes in program activities with financial implications include:
The Census program is ramping down operations from the 2016 Census while ramping up for the 2021 Census which is in the advanced planning and testing phase. As such, expenditures for this program are increasing.
New initiatives announced in the Budget 2018 are ramping up and activities related to those initiatives are on track.
Approval by senior officials
Approved by:
Anil Arora, Chief Statistician
Kathleen Mitchell, Acting Chief Financial Officer
Ottawa, Ontario
Signed on: February 26, 2020
Appendix
Statement of Authorities (unaudited) Table summary: This table displays the departmental expenditures by standard object for the fiscal year 2019-2020. The row headers provide information by standard object for expenditures and revenues. The column headers provide information in thousands of dollars for planned expenditures for the year ending March 31; expended during the quarter ended December 31; and year to date used at quarter-end 2019-2020.
Fiscal year 2019–2020
Fiscal year 2018–2019
Total available for use for the year ending March 31, 2020Tablenote 1
Used during the quarter ended December 31, 2019
Year-to-date used at quarter-end
Total available for use for the year ending March 31, 2019Tablenote 1
Used during the quarter ended December 31, 2018
Year-to-date used at quarter-end
in thousands of dollars
Vote 1 — Net operating expenditures
489,280
127,985
372,887
453,837
104,847
343,869
Statutory authority — Contribution to employee benefit plans
72,751
17,865
53,595
70,245
15,707
47,121
Total budgetary authorities
562,031
145,850
426,482
524,082
120,554
390,990
Tablenote 1
Includes only Authorities available for use and granted by Parliament at quarter-end.
Departmental Budgetary Expenditures by Standard Object (unaudited) Table summary: This table displays the departmental expenditures by standard object for the fiscal year 2018-2019. The row headers provide information by standard object for expenditures and revenues. The column headers provide information in thousands of dollars for planned expenditures for the year ending March 31; expended during the quarter ended December 31; and year to date used at quarter-end 2018-2019.
Fiscal year 2019–2020
Fiscal year 2018–2019
Planned expenditures for the year ending March 31, 2020
Expended during the quarter ended December 31, 2019
Year-to-date used at quarter-end
Planned expenditures for the year ending March 31, 2019
Expended during the quarter ended December 31, 2018
CVs for Total Sales by Geography
Table summary
This table displays the results of CVs for Total Sales by Geography. The information is grouped by geography (appearing as row headers), Month, 2018012, 201901, 201902, 201903, 201904, 201905, 201906, 201907, 201908, 201909, 201910, 201911 and 201912 (appearing as column headers), calculated using percentage unit of measure (appearing as column headers).
Annual Retail Trade Survey: CVs for operating revenue - 2018
Table summary
This table displays the results of Annual Retail Trade Survey: CVs for operating revenue - 2018. The information is grouped by Geography (appearing as row headers), CVs for operating revenue and percent (appearing as column headers).
Adding Fields and Editing Feature Attributes with the Field Calculator - Video transcript
(The Statistics Canada symbol and Canada wordmark appear on screen with the title: "Adding Fields and Editing Feature Attributes with the Field Calculator")
So in today's demo we'll use the Field Calculator to edit fields and feature attributes, including those storing geometric, numeric and text information. The Field Calculator is used to add and update fields or edit attributes of selected features. Like the Select by Expression tool, introduced in the previous demo, it uses expression syntax. Today we'll use the two tools in conjunction to select and update large selections of features.
So let's start by adding some spatial measures to our subset and created datasets.
So we can select them in the Layers Panel, and click the Field Calculator icon on the Attribute Toolbar. Since we are adding a new field, much like when we added the Fields to our AOI layer, we need to specify a field name, the field type as well as provide the parameters for the number of characters it stores. The same drop-downs from the Select by Expression tool are also found in the Field Calculator which we can use to help create our expressions. In the Geometry drop-down we can see the general expression syntax, which tends to be dollar sign followed by the measure of interest. So if we wanted to add coordinate information to a point dataset we could use $x or $y or for our polygons $perimeter and $area.
The Preview shows the output, which is calculated in Map units making the projected coordinate system with units in meters applied to these layers helpful in adding these measures.
To alter the units just apply an appropriate conversion factor, in this case divided by 10000 for area in hectares. We'll also copy the Expression and now repeating with our AOI layer- we can also opt to Update Existing Fields – selecting the field to update from the drop-down – meaning we can finally populate the area in hectares field we added when we first created the AOI layer – pasting the expression and clicking OK.
It is important to note that these measures are not automatically updated if the geometry of a layer is edited. So if we split a polygon or clipped it we would have to update these fields using the Field Calculator and once again paste in the appropriate expression. We can then Save the Edits and turn the toggle editor off.
Now let's take a look at updating large feature selections using the road_segment_1 layer. First we'll change the projection using the Reproject Layer tool. Much like the Save Vector Layer As box it can be used to transform a layer to a new projection, and can be applied as a batch process to multiple layers. So we'll change the coordinate reference system to UTM Zone 14N and use a temporary file for the output.
Then using our Interactive Selection tool, with our AOI layer highlighted, we'll select the merged Census Division feature, which we'll use to clip the reprojected road segments. So within the tool Reprojected is selected as the Input and the Overlay layer is the AOI. The Overlay layer is restricted to polygon vectors. And we'll also check Selected Features Only, so that only the road segments overlapping with the selected AOI feature are retained. This can be used to standardize the extent of analysis for multiple layers, and in this case, reduce processing times with editing the attributes of our road features. I saved the file in our Intro Demo folder, and called it CPRoads for Clipped Projected Roads.
So now we'll use the Select by Expression and Field Calculator sequentially to isolate and update the attributes for large selections of features in the Road Segments layer. So the road classes were interpreted using the CanVEC catalogue and Road Class field shown in the downloading data from the Federal Geospatial Platform demo.
We'll enter three expressions together and the remaining expressions are found in the video description. The first we'll enter is road classes greater than 309 AND less than 312 – for selecting within a value range which corresponds with our Highway features. Clicking select - 10000 features are returned.
Since this is the first selection we have to create a New Field, which we'll call Class, specifying it as a Text field type with a length of 50. As seen, when there are selected features by default the Only Update Selected Features box is checked. To update all features we could simply uncheck the box.
Remembering our syntax rules from the Selecting by Attributes demo we need to apply a single quotes around text-based entries.
Back in the Select by Expression tool let's populate another class, changing values to greater than 311 and less than 315. So 25000 features were selected. Since we have already created our field we will use Update Existing field and scroll down to the bottom of the list and selecting our Class field. Our current selection corresponds to local classes.
Now let's create one final selection - changing to road_class to = 309, which corresponds with Collector roads. Once again in the Field Calculator, we'll select the field to update and enter the corresponding attribute. The remaining expressions are provided in the video description – which can be used to populate the remainder of the field.
So now we'll use fields in the CP_Roads layer to update the Speed Limit field which is currently empty. The first one is simple entering "is_trans_c" = 11 – meaning is TransCanada Highway is TRUE. In the Calculator click Update and find the Speed_Rest Field. So the limit for the TransCanada in Manitoba is 110 kilometres an hour and we recall numbers can be entered as is.
The next few expressions are slightly more complex, since we are using a variety of fields to approximate speed restrictions. So we can use the Official S field, which contains the full name and type of the road, and add LIKE wildcard way to isolate Highways, Freeways and Expressways. But we want to avoid selecting other roads containing WAY - like Stoneway or Wallford Way - so we will also specify of_street_6 which is the Road Type and use the IN operator so to avoid repeating the field for each attribute. We'll scroll through the unique entries and add Highway, comma Freeway. Had we left the Road Segments unclipped we would also need to add Expressway. And finally to avoid overwriting the Speed Limits we've already populated with previous expressions we'll use AND "speed_rest" IS NULL in all subsequent expressions. In the Field Calculator we'll add the corresponding speed limit, defaulting to 100 kilometres an hour.
Now we can remove the components except Speed Rest IS NULL from our previous expression, and use the Official 2 field which provides a general indication of the road settings. Once again we'll use the IN operator and add Unorganized, Reserve and Rural Municipality. Then we'll use the road_class field, specifying greater than 307 and less than 310, to isolate non-urban roads that are collector or arterial. Once the selection is created, we'll enter an average speed limit of 80 kilometres per hour in the Field Calculator.
As with our Class field, the remaining expressions and associated speed limits to update in the Field Calculator are found in the video description, along with an explanation of the expressions.
The final thing I'd like to show is adding two final fields. The first is the length of the road segments in kilometers. I recommend populating both these fields fully prior to applying these calculations to avoid repeating these procedures later, as we are only currently updating the selected features. So applying the skills from earlier in the video the syntax is $length, and divided by 1000 for units in kilometres.
Now we'll add a field called TimeMin, which we will use the Length and Speed Limit fields to calculate. Speed equals distance over time, so time equals distance over speed, dividing our Length KM field by the speed_rest field. And left as-is the output is currently in hours, so we will just multiply by 60 to calculate the time to traverse each road segment in Minutes. Now ensure to Save Edits and Toggle the Editor off.
Congratulations! You should now feel confident using the Field Calculator to add and update fields and edit attributes for large feature selections in vector datasets. You should also feel comfortable applying expression syntax to perform these procedures – such as applying the appropriate operators and syntax for different attributes, and using multiple fields to isolate features by criteria of interest. We'll continue expanding these syntax skills throughout the tutorials. Additionally you should feel comfortable adding geometric, numeric and text attributes, and derive new information using the Field Calculator. Apply these skills to datasets of interest to you.
In the next demo we will discuss procedures for visualizing vector data specifically focusing on the Symbology and Labels tabs in the Layer Properties box to visualize different fields. We'll use the CPRoads layer from this tutorial to demonstrate rule-based visualizations as well.
Management, scientific and technical consulting services: CVs for operating revenue - 2018
Table summary
This table displays the results of Management, scientific and technical consulting services: CVs for operating revenue - 2018. The information is grouped by Geography (appearing as row headers), CVs for operating revenue and percent (appearing as column headers).