QGIS/C2/Importing-Spreadsheets/English - Revision history

Madhurig at 10:57, 21 January 2019

2019-01-21T10:57:28Z

Nancyvarkey at 09:41, 18 January 2019

2019-01-18T09:41:46Z

Show changes

Snehalathak at 11:13, 7 January 2019

2019-01-07T11:13:47Z

Snehalathak at 11:12, 7 January 2019

2019-01-07T11:12:42Z

Snehalathak: Created page with " {|border=1 ||'''Visual Cue''' ||'''Narration''' |- || '''Slide Number 1''' '''Title Slide''' || Welcome to this tutorial on '''Importing spreadsheets '''in '''QGIS'''. |-..."

2019-01-07T11:04:16Z

Created page with " {|border=1 ||'''Visual Cue''' ||'''Narration''' |- || '''Slide Number 1''' '''Title Slide''' || Welcome to this tutorial on '''Importing spreadsheets '''in '''QGIS'''. |-..."

New page

{|border=1
||'''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,

Import speadsheets in '''CSV''' format to create a '''Point Layer'''.

Convert '''Point Layer''' to a '''Polyline Layer'''. and

Load''' WMS''' (Web Map Service) layer in '''QGIS'''.

|-
|| '''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'''

'''https://spoken-tutorial.org/'''
|| To follow this tutorial you should be familiar with,

'''QGIS''' interface

If not for relevant tutorials please visit our website.

|-
|| '''Slide Number 5'''

'''GIS Data'''

|| Often '''GIS''' data is available in table or spreadsheet format (.txt or .csv files)

Data in the form of spreadsheet can be imported to QGIS.

The data file must have 2 columns which contain the X and Y coordinates.

|-
|| '''Slide Number 6'''

'''Example to Practise'''

'''https://www.qgistutorials.com'''
|| To practise this tutorial you need to,

download the folder given in code files link, located below the player.

Extract the contents of the downloaded zip file.

Locate '''Places.txt '''and '''Places.csv '''files in the extracted folder.

|-
|| 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.

A spreadsheet in '''CSV''' format opens.

|-
|| Point to the columns.

Close the CSV file.
|| It has names of cities with '''latitude''' and '''longitude''' data.

Close the '''CSV''' file.

|-
|| Double-click and open '''Places.txt''' file.

Point to the columns.
|| Double-click and open '''Places.txt''' file.

Here too we have names of cities, with '''longitude''' and '''latitude '''data.

|-
|| Click on red cross on the top-left corner.

Click on red cross on the top-left corner.

Click on '''QGIS''' icon on desktop.
|| Close the text file.

Close the '''Code-files''' folder and open '''QGIS''' interface.

|-
|| '''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'''.

From the sub-menu, select '''Add Delimited Text Layer'''.

|-
|| '''Create a Layer from a Delimited Text File '''dialog-box opens.

Click on''' browse'''
|| A dialog-box opens.

Click on '''Browse''' button next to '''File Name''' text box.

|-
|| Desktop>> Select''' Places.csv.'''

Click on '''Open''' button.
|| A dialog-box opens.

Navigate to the '''csv''' file you had downloaded and saved earlier.

Click on '''Open''' button.

|-
|| 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.

If not click on '''CSV''' radio button to select it.

When you use '''.txt''' file, select '''Custom Delimiters''' option.

|-
|| Cursor on '''Geometry definition''' section.

Point to '''Latitude '''and '''Longitude'''.
|| '''Geometry definition''' section,

will be auto-populated with''' Latitude '''and '''Longitude '''data.

|-
|| Point to '''Latitude '''and '''Longitude'''.
|| Please note x-coordinate is '''longitude''' and y-coordinate is '''latitude'''.

'''Longitude''' specifies the east-west position of a point.

'''Latitude''' specifies the north-south position of a point.

|-
|| Click on '''OK''' button.
|| Click on '''OK''' button.

|-
|| Cursor on''' Coordinate Reference System Selector '''dialog-box.

Click on '''OK''' button.
|| '''Coordinate Reference System Selector''' dialog-box opens.

Select '''WGS 84 EPSG 4326.'''

Click on '''OK''' button.

|-
|| Cursor on QGIS canvas.
|| The data is imported and displayed on QGIS canvas.

|-
|| Cursor on QGIS canvas.
|| A map of India opens with points.

These points correspond to different cities listed in the''' CSV''' file.

|-
|| Cursor on QGIS canvas.
|| The style and color of these point features can be changed.

This will be demonstrated in detail in upcoming tutorials.

|-
|| '''Slide Number 7'''

'''Assignmemt-1'''
|| As an assignment,

Import '''Places.txt''' file in '''QGIS'''.

'''Places.txt''' file is available in the folder downloaded from '''Code files''' link.

|-
|| 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.

The path connects southern most city to the northern most city

|-
|| Click on '''Processing''' menu on the menu bar.

From the drop-down select '''Toolbox''' option.
|| This is based on '''latitude''' data of each city.

Click on '''Processing''' menu on the menu bar.

From the drop-down select '''Toolbox'''.

|-
|| 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'''.

Click on the black triangle next to

'''Vector creation tools'''.
|| Expand '''QGIS geoalgorithm''' by clicking on the black triangle next to it.

From the displayed list, expand '''Vector creation tools '''option.

|-
|| 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.

Select '''Input point layer''' as '''Places'''.
|| '''Points to path''' dialog-box opens.

Select '''Input layer''' as '''Places'''.

|-
|| Select '''Group field''' as '''type,C,16.'''
|| From the '''Group field''' drop-down select '''type,C,16.'''

This field contains the names of the cities for all the features in the shapefile.

|-
|| Select '''Order field''' as '''Latitude,N,19,11'''.
|| From the '''Order field '''drop-down select '''Latitude,N,19,11'''.

This denotes the path will go in the ascending order of the latitude.

|-
|| 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.

Select '''Desktop''' location.

Type file name as '''Path-1'''.
|| '''Save file''' dialog-box opens.

Select a suitable location to save the file.

I will select '''Desktop'''.

Name the file as '''Path-1'''.

|-
|| Click on '''Save''' button.

Cursor on '''Paths''' field.
|| Click on '''Save''' button.

The path with file name appears on the '''Paths''' field.

|-
|| 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,

* Create a path between the cities from West to East.
* Hint: In the '''Points to path''' dialog-box, '''Order field''' drop-down use '''Longitude,N,19,11''' option.

|-
|| Cursor on the map.
|| Now let us add a '''WMS''' layer in '''QGIS'''.

|-
|| '''Slide Number 9'''

'''About WMS'''
|| About WMS

WMS stands for '''Web Map Services'''.

WMS is an Open GIS standard specification for interactive mapping.

This is based on requesting map images from a server over the Internet.

For this demonstration you must be connected to the internet.

|-
|| Click on web browser

Type bhuvan.nrsc.gov.in

|| Open any web browser.

In the address bar type bhuvan.nrsc.gov.in

Press enter.

|-
|| Cursor on '''Bhuvan''' home page.
|| '''Bhuvan''' home page opens.

|-
|| Click on '''Thematic Services''' tab.
|| Click on '''Thematic Services''' tab.

'''Thematic Services''' page opens in a new window.

|-
|| Under '''Search''' tab, '''Select Theme''' drop-down,

Click on '''Land Use Land Cover (50K) 2005-06'''
|| In the left panel, under '''Search''' tab, under '''Select Theme''' drop-down,

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

|-
|| Click on '''Select Geography''' dropdown, select '''Karnataka'''.
|| Under '''Select Geography''' drop-down, choose '''Karnataka'''.

|-
|| Click on '''Web services''' tab.

Point to '''Layer '''heading.

layer - "vector:KA_LULC50K_0506"
|| Click on the '''Web Services''' tab.

Under section, '''For QGIS, uDig, ArcGIS and Other Users, Web Map Service (WMS)URL'''

Note the Layer id for this layer.

'''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.

In the Layers menu, uncheck the '''Paths''' and '''Place''' layers to hide them.
|| Back to '''QGIS''' interface,

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

|-
|| 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.'''

From the sub-menu, Select '''Add WMS/WMTS layer.'''

|-
|| Point to '''Add Layers from WMS Server''' dialog-box.

Under '''Layers''' tab, Click on '''New''' button.
|| '''Add Layer '''dialog-box opens.

In the '''Layers''' tab click on '''New '''button.

'''Create a new WMS Connection '''dialog-box opens.

|-
|| Type '''Bhuvan''' in the '''Name''' field.

In the URL field, paste the copied link [http://bhuvan5.nrsc.gov.in/bhuvan/wms http://bhuvan5.nrsc.gov.in/bhuvan/wms]

<u>Click on '''OK''' button.</u>
|| In '''Name''' field type '''Bhuvan.'''

In the URL field, paste the copied URL link from the Bhuvan website.

[http://bhuvan5.nrsc.gov.in/bhuvan/wms h][http://bhuvan5.nrsc.gov.in/bhuvan/wms ttp://bhuvan5.nrsc.gov.in/bhuvan/wms]

Click on '''OK''' button at the bottom-right corner of the dialog-box.

|-
|| In the '''Save Connection''' dialog-box.

Click on '''OK''' button.
|| In the '''Save Connection''' dialog-box.

Click on '''OK''' button.

|-
|| 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.

This id corresponds to to the id layer of the WMS layer from Bhuvan website.

|-
|| 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

Import speadsheets in CSV format to create a Point Layer.

Convert Point Layer to a Polyline Layer. And,

Load '''WMS''' (Web Map Service) layer in '''QGIS.'''

|-
|| '''Slide Number 11'''

'''About Spoken Tutorial project'''
||* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide Number 12'''

'''Spoken Tutorial workshops'''
|| The Spoken Tutorial Project team:

* conducts workshops using spoken tutorials and

* gives certificates on passing online tests.

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.

|}

@@ Line 1: / Line 1: @@
 {|border=1
 ||'''Visual Cue'''
@@ Line 16: / Line 14: @@
 || In this tutorial, we will learn to,
-* Import speadsheets in '''CSV''' format to create a '''Point Layer'''.
+* Import spreadsheets 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'''.
@@ Line 50: / Line 48: @@
 '''GIS Data'''
 || Often '''GIS''' data is available in table or spreadsheet format (.txt or .csv files)
@@ Line 74: / Line 70: @@
-Locate '''Places.txt '''and '''Places.csv '''files in the extracted folder.
+Locate '''Places.txt''' and '''Places.csv''' files in the extracted folder.
 |-
@@ Line 86: / Line 82: @@
 |-
 || Point to the files.
-|| Here you will see 2 files '''Places.csv '''and''' Places.txt.'''
+|| Here you will see 2 files '''Places.csv ''' and '''Places.txt.'''
 |-
 || Double-click on '''Places.csv '''file.
 || Double-click on '''Places.csv''' file.
-−
-−
 || Double-click on '''Places.csv '''file.
-−
 A spreadsheet in '''CSV''' format opens.
@@ Line 109: / Line 101: @@
 |-
-|| Double-click and open '''Places.txt''' file.
+|| Double-click >> open '''Places.txt''' file.
@@ Line 127: / Line 119: @@
 Click on '''QGIS''' icon on '''Desktop'''.
 || Close the text file.
 Close the '''Code-files''' folder and open '''QGIS''' interface.
@@ Line 135: / Line 126: @@
 Click on '''Layers''' on menu bar.
-|| Click on '''Layer '''menu on the menu bar.
+|| Click on '''Layer ''' menu on the menu bar.
 |-
@@ Line 155: / Line 146: @@
 |-
-|| Desktop>> Select''' Places.csv.'''
+|| Desktop >> Select''' Places.csv.'''
-−
 Click on '''Open''' button.
 || A dialog-box opens.
@@ Line 186: / Line 177: @@
 Point to '''Latitude '''and '''Longitude'''.
-|| '''Geometry definition''' section will be auto-populated with''' Latitude '''and '''Longitude '''data.
+|| '''Geometry definition''' section will be auto-populated with '''Latitude''' and '''Longitude''' data.
 |-
-|| Point to '''Latitude '''and '''Longitude'''.
+|| Point to '''Latitude''' and '''Longitude'''.
 || Please note '''X-coordinate''' is '''longitude''' and '''Y-coordinate''' is '''latitude'''.
@@ Line 210: / Line 201: @@
-Select '''WGS 84 EPSG 4326.'''
+Select '''WGS 84 EPSG 4326'''.
@@ Line 224: / Line 215: @@
-These points correspond to different cities listed in the''' CSV''' file.
+These points correspond to different cities listed in the '''CSV''' file.
 |-
@@ Line 307: / Line 298: @@
-This field contains the names of the cities for all the features in the shapefile.
+This field contains the names of the cities for all the features in the shape file.
 |-
 || Select '''Order field''' as '''Latitude,N,19,11'''.
-|| From the '''Order field '''drop-down, select '''Latitude,N,19,11'''.
+|| From the '''Order field''' drop-down, select '''Latitude,N,19,11'''.
@@ Line 320: / Line 311: @@
 From the drop-down select '''Save to file''' option.
-|| Click on the button next to''' Paths''' field.
+|| Click on the button next to '''Paths''' field.
 From the sub-menu select '''Save to file''' option.
@@ Line 348: / Line 339: @@
-The path with filename, appears on the '''Paths''' field.
+The path with file-name, appears on the '''Paths''' field.
 |-
@@ Line 402: / Line 393: @@
 || Click on web browser
-Type bhuvan.nrsc.gov.in
+Type '''bhuvan.nrsc.gov.in'''
@@ Line 434: / Line 425: @@
 |-
-|| Click on '''Select Geography''' dropdown, select '''Karnataka'''.
+|| Click on '''Select Geography''' drop-down, select '''Karnataka'''.
 || Under '''Select Geography''' drop-down, choose '''Karnataka'''.
@@ Line 442: / Line 433: @@
 Point to '''Layer '''heading.
 layer - "vector:KA_LULC50K_0506"
@@ Line 460: / Line 450: @@
-Right-click and copy the '''URL'''.
+Right-click >> copy the '''URL'''.
 |-
@@ Line 522: / Line 512: @@
 || In the '''Add Layers from WMS Server''' dialog-box, Click '''Connect.'''
 || In the '''Add Layers''' dialog-box, click on '''Connect '''button.
 || In the '''Add Layers '''dialog-box, click on '''Connect '''button.
@@ Line 559: / Line 548: @@
 In this tutorial we have learnt to
-* Import speadsheets in '''CSV''' format to create a '''Point Layer'''
+* Import spreadsheets in '''CSV''' format to create a '''Point Layer'''
 * Convert '''Point Layer''' to a '''Polyline Layer''' and,
@@ Line 569: / Line 558: @@
 '''About Spoken Tutorial project'''
-||
+||* The video at the following link summarizes the Spoken Tutorial project.
 * The video at the following link summarizes the Spoken Tutorial project.
 * Please download and watch it.
@@ Line 604: / Line 592: @@
 Thank you for joining.
+|-
 |}

@@ Line 28: / Line 28: @@
 || To record this tutorial, I am using,
-'''Ubuntu Linux''' OS version 16.04.
+* '''Ubuntu Linux''' OS version 16.04.
-'''QGIS''' version 2.18.
+* '''QGIS''' version 2.18.
-And a Working internet connection.
+* And a Working internet connection.
 |-