QGIS/C2/Importing-Spreadsheets/English-timed

From Script | Spoken-Tutorial
Jump to: navigation, search
Time Narration
00:01 Welcome to this tutorial on Importing spreadsheets in QGIS.
00:07 In this tutorial, we will learn to,
00:10 Import spreadsheets in CSV format to create a Point Layer.
00:16 Convert Point Layer to a Polyline Layer and
00:20 Load WMS (Web Map Service) layer in QGIS.
00:25 To record this tutorial, I am using,

Ubuntu Linux OS version 16.04.

00:32 QGIS version 2.18.
00:36 And a Working internet connection.
00:39 To follow this tutorial you should be familiar with QGIS interface.
00:47 If not for relevant tutorials please visit our website.
00:52 Often GIS data is available in table or spreadsheet format
00:59 Data in the form of spreadsheet can be imported to QGIS.
01:05 Data file must have 2 columns which contain the X and Y coordinates.
01:12 To practise this tutorial you need to download the folder given in Code files link, located below the player.
01:21 Extract the contents of the downloaded zip file.
01:25 Locate Places.txt and Places.csv files in the extracted folder.
01:33 I have already downloaded the code file, extracted and saved it in a folder on Desktop.
01:41 I will double-click on Code files folder to view the contents.
01:46 Here you will see 2 files Places.csv and Places.txt.
01:54 Double-click on Places.csv file.
02:02 A spreadsheet in CSV format opens.
02:06 It has names of cities with latitude and longitude data.
02:14 Close the CSV file.
02:17 Double-click and open Places.txt file.
02:22 Here too, we have names of cities, with longitude and latitude data.
02:32 Close the text file.
02:35 Close the Code-files folder and open QGIS interface.
02:41 Click on Layer menu on the menu bar.
02:45 From the drop-down list, select Add layer.
02:49 From the sub-menu, select Add Delimited Text Layer.
02:54 A dialog-box opens.
02:57 Click on Browse button next to File Name text box.
03:02 A dialog-box opens.
03:05 Navigate to the csv file you had downloaded and saved earlier.
03:11 Click on Open button.
03:14 In the create a layer dialog-box, the file path is now seen in the File Name text box.
03:21 In the File format section, by default CSV option gets selected.
03:28 If not, click on CSV radio button to select it.
03:33 When you use .txt file, select Custom Delimiters option.
03:39 Geometry definition section will be auto-populated with Latitude and Longitude data.
03:47 Please note X-coordinate is longitude and Y-coordinate is latitude.
03:55 Longitude specifies the east-west position of a point.
04:01 And Latitude specifies the north-south position of a point.
04:06 Click on OK button.
04:09 Coordinate Reference System Selector dialog-box opens.
04:14 Select WGS 84 EPSG 4326.
04:21 Click on OK button.
04:24 The data is imported and displayed on QGIS canvas.
04:30 A map of India opens with points.
04:34 These points correspond to different cities listed in the CSV file.
04:40 The style and color of these point features can be changed.
04:45 This will be demonstrated in detail in the upcoming tutorials.
04:51 As an assignment,
04:53 Import Places.txt file in QGIS.
04:58 Places.txt file is available in the folder downloaded from Code files link.
05:06 Now let us convert this Point layer to Polyline layer.
05:12 Here we will connect all the cities with a path.
05:17 The path connects southern-most city to the northern-most city.
05:23 This is based on latitude data of each city.
05:28 Click on Processing menu on the menu bar.
05:32 From the drop-down select Toolbox.
05:36 Processing Toolbox panel opens on the right-side of the screen.
05:41 It shows the list of all available algorithms grouped in different blocks.
05:47 Expand QGIS geoalgorithm by clicking on the black triangle next to it.
05:55 From the displayed list, expand Vector creation tools option.
06:01 From the expanded menu, double click on Points to path tool to execute the algorithm.
06:08 Points to path dialog-box opens.
06:12 Select Input layer as Places.
06:16 From the Group field drop-down, select type comma C comma 16.
06:23 This field contains the names of the cities for all the features in the shape file.
06:29 From the Order field drop-down, select Latitude comma N comma 19 comma 11.
06:37 This denotes the path will go in the ascending order of the latitude.
06:42 Click on the button next to Paths field.
06:46 From the sub-menu select Save to file option.
06:51 Save file dialog-box opens.
06:55 Select a suitable location to save the file. I will select Desktop.
07:02 Name the file as Path-1.
07:06 Click on Save button.
07:09 The path with file-name, appears on the Paths field.
07:14 Click the check box for Open output file after running algorithm.
07:19 Click on Run button at the bottom right corner of the dialog-box.
07:24 Notice the map on the canvas.
07:27 The output path between the cities is shown.
07:31 Using this algorithm any two points on the map can be connected by a path.
07:38 As an Assignment, Create a path between the cities from West to East.
07:45 Hint: In the Points to path dialog-box, Order field drop-down use Longitude comma N comma 19 comma 11 option.
07:57 Now let us add a WMS layer in QGIS.
08:03 About WMS
08:06 WMS stands for Web Map Services.
08:11 WMS is an open GIS standard specification for interactive mapping.
08:17 This is based on requesting map images from a server over the Internet.
08:23 For this demonstration you must be connected to the Internet.
08:28 Open any web browser.
08:31 In the address bar type bhuvan.nrsc.gov.in

Press Enter.

08:41 Bhuvan home page opens.
08:44 Click on Thematic Services tab.
08:48 Thematic Services page opens in a new window.
08:52 In the left panel, under Search tab, under Select Theme drop-down,

choose Land Use Land Cover (50K):2005-06 .

09:06 Under Select Geography drop-down, choose Karnataka.
09:12 Click on the Web Services tab.
09:15 Under section For QGIS, uDig, ArcGIS and Other Users, Web Map Service (WMS)URL
09:25 Note the Layer id for this layer. And highlight the URL.
09:31 Right-click and copy the URL.
09:36 Back to QGIS interface,

In the Layers panel, uncheck the Paths and Place layers to hide them.

09:47 Click on Layer menu on the menu bar, from the drop-down, select Add Layer.
09:55 From the sub-menu, Select Add WMS/WMTS layer.
10:01 Add Layer dialog-box opens.
10:04 In the Layers tab click on New button.
10:08 Create a new WMS Connection dialog-box opens.
10:13 In Name field type Bhuvan.
10:16 In the URL field, paste the copied URL link from the Bhuvan website.
10:23 Click on OK button at the bottom-right corner of the dialog-box.
10:29 In the Save Connection dialog-box, click on OK button.
10:34 In the Add Layers dialog-box, click on Connect button.
10:40 In the id section, select id 971.
10:46 This id corresponds to to the id layer of the WMS layer from Bhuvan website.
10:53 Click on Add button at the bottom-right corner of the dialog-box.
10:59 Click on Close button.
11:02 On canvas, the Land Use Land Cover layer for Karnataka is displayed.
11:08 Similarly we can load any available layer of different themes.
11:15 Let us summarize,

In this tutorial we have learnt to

11:21 Import spreadsheets in CSV format to create a Point Layer
11:27 Convert Point Layer to a Polyline Layer and,
11:31 Load WMS (Web Map Service) layer from Bhuvan website in QGIS.
11:37 The video at the following link summarizes the Spoken Tutorial project.

Please download and watch it.

11:45 The Spoken Tutorial Project team: conducts workshops using spoken tutorials and gives certificates on passing online tests.

For more details, please write to us.

11:58 Please post your timed queries on this forum.
12:02 Spoken Tutorial Project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

12:14 This tutorial is contributed by Prajwal M from NIT Suratkal and Snehalatha from IIT Bombay.

Thank you for joining.

Contributors and Content Editors

PoojaMoolya, Sakinashaikh