Difference between revisions of "QGIS/C2/Importing-Spreadsheets/English"
Snehalathak (Talk | contribs) (Created page with " {|border=1 ||'''Visual Cue''' ||'''Narration''' |- || '''Slide Number 1''' '''Title Slide''' || Welcome to this tutorial on '''Importing spreadsheets '''in '''QGIS'''. |-...") |
Snehalathak (Talk | contribs) |
||
Line 16: | Line 16: | ||
|| In this tutorial, we will learn to, | || In this tutorial, we will learn to, | ||
− | Import speadsheets in '''CSV''' format to create a '''Point Layer'''. | + | * Import speadsheets in '''CSV''' format to create a '''Point Layer'''. |
− | Convert '''Point Layer''' to a '''Polyline Layer'''. and | + | * Convert '''Point Layer''' to a '''Polyline Layer'''. and |
− | Load''' WMS''' (Web Map Service) layer in '''QGIS'''. | + | * Load''' WMS''' (Web Map Service) layer in '''QGIS'''. |
|- | |- | ||
Line 586: | Line 586: | ||
In this tutorial we have learnt to | In this tutorial we have learnt to | ||
− | Import speadsheets in CSV format to create a Point Layer. | + | * Import speadsheets in CSV format to create a Point Layer. |
− | Convert Point Layer to a Polyline Layer. And, | + | * Convert Point Layer to a Polyline Layer. And, |
− | Load '''WMS''' (Web Map Service) layer in '''QGIS.''' | + | * Load '''WMS''' (Web Map Service) layer in '''QGIS.''' |
|- | |- |
Revision as of 16:42, 7 January 2019
Visual Cue | Narration |
Slide Number 1
Title Slide |
Welcome to this tutorial on Importing spreadsheets in QGIS. |
Slide Number 2
Learning Objectives |
In this tutorial, we will learn to,
|
Slide Number 3
System Requirement |
To record this tutorial, I am using,
Ubuntu Linux OS version 16.04. QGIS version 2.18. And a Working internet connection. |
Slide Number 4
Pre-requisites |
To follow this tutorial you should be familiar with,
|
Slide Number 5
GIS Data
|
Often GIS data is available in table or spreadsheet format (.txt or .csv files)
|
Slide Number 6
Example to Practise |
To practise this tutorial you need to,
|
Click on the folder Code-files to open, point to the text files. | I have already download the code file, extracted and saved it in a folder on desktop. |
Double-click on Code-file folder. | I will double-click on Code-files folder to view the contents. |
Point to the files. | Here you will see 2 files Places.csv and Places.txt. |
Double-click on Places.csv file.
|
Double-click on Places.csv file.
|
Point to the columns.
|
It has names of cities with latitude and longitude data.
|
Double-click and open Places.txt file.
|
Double-click and open Places.txt file.
|
Click on red cross on the top-left corner.
|
Close the text file.
|
Double Click on the QGIS icon
Click on Layers on menu bar.
|
Click on Layer menu on the menu bar. |
Select Add layers and then select Add Delimited Text Layer. | From the drop-down list, select Add layer.
|
Create a Layer from a Delimited Text File dialog-box opens.
|
A dialog-box opens.
|
Desktop>> Select Places.csv.
|
A dialog-box opens.
|
Point to the file path in File Name text box. | In the create a layer dialog-box,
File path is now seen in the File Name text box. |
In the File format section, click on CSV radio button. | In the File format section, by default CSV option gets selected.
|
Cursor on Geometry definition section.
|
Geometry definition section,
|
Point to Latitude and Longitude. | Please note x-coordinate is longitude and y-coordinate is latitude.
|
Click on OK button. | Click on OK button. |
Cursor on Coordinate Reference System Selector dialog-box.
|
Coordinate Reference System Selector dialog-box opens.
|
Cursor on QGIS canvas. | The data is imported and displayed on QGIS canvas. |
Cursor on QGIS canvas. | A map of India opens with points.
|
Cursor on QGIS canvas. | The style and color of these point features can be changed.
|
Slide Number 7
Assignmemt-1 |
As an assignment,
|
Cursor on the map. | Now let us convert this Point layer to Polyline layer. |
Cursor on the map. | Here we will connect all the cities with a path.
|
Click on Processing menu on the menu bar.
|
This is based on latitude data of each city.
|
Cursor on Toolbox. | Processing Toolbox panel opens on the right-side of the screen. |
Cursor on the list. | It shows the list of all available algorithms grouped in different blocks. |
Click on the black triangle next to QGIS geoalgorithms.
Vector creation tools. |
Expand QGIS geoalgorithm by clicking on the black triangle next to it.
|
Double click on Points to path tool. | From the expanded menu, double click on Points to path tool to execute the algorithm. |
Cursor on Points to path dialog-box.
|
Points to path dialog-box opens.
|
Select Group field as type,C,16. | From the Group field drop-down select type,C,16.
|
Select Order field as Latitude,N,19,11. | From the Order field drop-down select Latitude,N,19,11.
|
Click on the button next to Paths field.
From the drop-down select Save to file option. |
Click on the button next to Paths field, from the sub-menu select, Save to file option. |
Cursor on Save file dialog-box.
|
Save file dialog-box opens.
I will select Desktop.
|
Click on Save button.
|
Click on Save button.
|
Click the check box for Open output file after running algorithm. | Click the check box for Open output file after running algorithm. |
Click on Run button. | Click on Run button at the bottom right corner of the dialog-box. |
Cursor on the map on canvas. | Notice the map on the canvas.
The output path between the cities is shown. |
Cursor on the map on canvas. | Using this algorithm any two points on the map can be connected by a path. |
Slide Number 8
Assignment-2 |
As an Assignment,
|
Cursor on the map. | Now let us add a WMS layer in QGIS. |
Slide Number 9
About WMS |
About WMS
|
Click on web browser
Type bhuvan.nrsc.gov.in
|
Open any web browser.
|
Cursor on Bhuvan home page. | Bhuvan home page opens. |
Click on Thematic Services tab. | Click on Thematic Services tab.
|
Under Search tab, Select Theme drop-down,
|
In the left panel, under Search tab, under Select Theme drop-down,
|
Click on Select Geography dropdown, select Karnataka. | Under Select Geography drop-down, choose Karnataka. |
Click on Web services tab.
|
Click on the Web Services tab.
Under section, For QGIS, uDig, ArcGIS and Other Users, Web Map Service (WMS)URL
layer - "vector:KA_LULC50K_0506" |
Highlight the URL.
URL - "http://bhuvan5.nrsc.gov.in/bhuvan/wms" Right click and copy the URL |
Highlight the URL.
Right click and copy the URL. http://bhuvan5.nrsc.gov.in/bhuvan/wms |
Cursor on QGIS interface.
|
Back to QGIS interface,
|
Click Add Layer from the Layer menu.
From the sub-menu, click on WMS/WMTS layer.
|
Click on Layer menu on the menu bar, from the drop-down, select Add Layer.
|
Point to Add Layers from WMS Server dialog-box.
|
Add Layer dialog-box opens.
|
Type Bhuvan in the Name field.
|
In Name field type Bhuvan.
Click on OK button at the bottom-right corner of the dialog-box. |
In the Save Connection dialog-box.
|
In the Save Connection dialog-box.
|
In the Add Layers from WMS Server dialog-box, Click Connect.
|
In the Add Layers dialog-box, click on Connect button.
|
In the id section,
Select id 971 with the name. vector:KA_LULC50K_0506. |
In the id section,
Select id 971.
|
Click on Add button.
Click on Close button. |
Click on Add button at the bottom-right corner of the dialog-box.
Click on Close button. |
Cursor on canvas. | On canvas, the Land Use Land Cover layer for Karnataka is displayed. |
Cursor on canvas. | Similarly we can load any available layer of different themes. |
Slide Number 10
Summary |
Let us summarize,
In this tutorial we have learnt to
|
Slide Number 11
About Spoken Tutorial project |
* The video at the following link summarizes the Spoken Tutorial project.
|
Slide Number 12
Spoken Tutorial workshops |
The Spoken Tutorial Project team:
For more details, please write to us. |
Slide number 13
Forum for specific questions: |
Please post your timed queries on this forum. |
Slide Number 14:
Acknowledgement |
Spoken Tutorial Project is funded by NMEICT, MHRD, Government of India.
More information on this mission is available at this link. |
This tutorial is contributed by Prajwal M from NIT Suratkal and Snehalatha from IIT Bombay.
Thank you for joining. |