QGIS/C3/Table-Joins-and-Spatial-Joins/English - Revision history

PoojaMoolya at 10:43, 28 October 2020

2020-10-28T10:43:01Z

Snehalathak at 06:30, 18 October 2019

2019-10-18T06:30:51Z

Snehalathak at 06:28, 18 October 2019

2019-10-18T06:28:47Z

Madhurig at 12:43, 17 October 2019

2019-10-17T12:43:24Z

Karwanjehimanshi95 at 09:33, 15 October 2019

2019-10-15T09:33:04Z

Karwanjehimanshi95 at 06:39, 15 October 2019

2019-10-15T06:39:28Z

Karwanjehimanshi95 at 06:27, 15 October 2019

2019-10-15T06:27:46Z

Karwanjehimanshi95 at 05:53, 15 October 2019

2019-10-15T05:53:08Z

Karwanjehimanshi95 at 05:02, 15 October 2019

2019-10-15T05:02:11Z

Nancyvarkey at 10:37, 14 October 2019

2019-10-14T10:37:11Z

Show changes

@@ Line 120: / Line 120: @@
 |-
-|| '''Add vector Layer dialogue''' box will open.
+|| '''Add vector Layer dialog''' box will open.
 Click on '''Open.'''
@@ Line 193: / Line 193: @@
 |-
-|| Cursor on '''Delimited Text File '''dialogue''' '''box.
+|| Cursor on '''Delimited Text File '''dialog''' '''box.
 Select '''CSV '''as''' File Format'''.

@@ Line 439: / Line 439: @@
 Scroll down the menu and click on '''Data Management Tools'''.
-From the sub-menu select  '''Join attributes by location.'''
+From the sub-menu select '''Join attributes by location'''.
 |-

@@ Line 439: / Line 439: @@
 Scroll down the menu and click on '''Data Management Tools'''.
-From the sub-menu select '''Join attributes by location.'''
+From the sub-menu select  '''Join attributes by location.'''
 |-

@@ Line 1: / Line 1: @@
 {|border=1
 || '''Visual Cue'''
@@ Line 8: / Line 6: @@
 '''Title Slide'''
-||Welcome to this tutorial on '''Table Joins''' and '''Spatial Joins '''in '''QGIS'''.
+||Welcome to this tutorial on '''Table Joins''' and '''Spatial Joins''' in '''QGIS'''.
 |-
@@ Line 26: / Line 24: @@
 || Here I am using
-'''Ubuntu Linux '''OS version. 16.04
+'''Ubuntu Linux''' OS version. 16.04
 '''QGIS '''version 2.18
@@ Line 54: / Line 52: @@
 |-
-|| Double click on code files folder.
+|| Double click on '''Code files''' folder.
 Point to '''Stations.shp'''.
@@ Line 114: / Line 112: @@
 A dialog-box opens.
-Navigate to '''Stations.shp''' file from the code files folder on the '''Desktop'''.
 |-
@@ Line 140: / Line 139: @@
 Let us open the '''attribute table''' for this '''layer'''.
-In the '''Layers Panel''', right-click on '''Stations.shp''' .
+In the '''Layers Panel''', right-click on '''Stations.shp'''.
 |-
 || Click on '''Open Attribute Table''' option.
@@ Line 149: / Line 148: @@
 || '''Attribute table '''opens.
-Notice that '''data''' for only one attribute '''District '''is available.
+Notice that '''data''' for only one attribute '''District ''' is available.
 |-
@@ Line 159: / Line 158: @@
 || Now we will add another''' data-set''' which is a spreadsheet to the '''Layers Panel'''.
-This dataset is in '''CSV''' '''format'''.
+This data set is in '''CSV''' '''format'''.
 |-
@@ Line 189: / Line 188: @@
 || A dialog box opens.
-Navigate to '''Rainfall.csv''' file from the code files folder on the '''Desktop'''.
+Navigate to '''Rainfall.csv''' file from the '''Code files''' folder on the '''Desktop'''.
 Click on '''Open''' button.
@@ Line 197: / Line 196: @@
 Select '''CSV '''as''' File Format'''.
-|| In the '''Delimited Text File '''dialog box, select''' CSV '''as''' File Format.'''
+|| In the '''Delimited Text File '''dialog box, select ''' CSV''' as''' File Format.'''
-−
 |-
 || Click on the '''No geometry (attribute only table)'''.
@@ Line 291: / Line 289: @@
 |-
 || Cursor on the options.
-|| Here we have options to choose for '''Join layer, Join field''' and '''Target field'''.
+|| Here we have options to choose for '''Join layer''', '''Join field''' and '''Target field'''.
 |-
@@ Line 315: / Line 313: @@
 || '''Target field''' is the field to be joined in the '''Stations table'''.
-In the '''Target field, District '''is already selected.
+In the '''Target field''', '''District''' is already selected.
 This field is common to both the '''tables'''.
@@ Line 334: / Line 332: @@
 || Check the boxes for the columns '''January''' to '''Annual Average '''in the text box.
-Click on ''' OK''' button to close the''' Add vector join '''dialog box.
+Click on ''' OK''' button to close the '''Add vector join ''' dialog box.
 |-

@@ Line 81: / Line 81: @@
 '''https://www.gislounge.com/working-with-tables-mastering-qgis/'''
-|| There are two ways to '''join table''',
+|| There are two ways to join a table,
 . '''Table Join''' that is, joining '''tables''' having one or more common column '''data'''.

@@ Line 305: / Line 305: @@
 Select '''Districts.'''
-|| '''Join field''' is the field or '''attribute''' in the '''Rainfall table''' to be '''joined'''.
+|| '''Join field''' is the field or '''attribute''' in the '''Rainfall table''' to be joined.
 In the '''Join field''', select '''District''' from the drop-down.
@@ Line 313: / Line 313: @@
 Cursor on the '''District'''.
-|| '''Target field''' is the field to be '''joined''' in the '''Stations table'''.
+|| '''Target field''' is the field to be joined in the '''Stations table'''.
 In the '''Target field, District '''is already selected.
@@ Line 340: / Line 340: @@
 Click on '''Apply''' button >>'''OK'''.
-|| In''' Layer Properties '''dialog box, information about layer and columns '''joined''' are indicated at the top.
+|| In''' Layer Properties '''dialog box, information about layer and columns joined are indicated at the top.
 Click on '''Apply''' button, then '''OK '''button.

@@ Line 51: / Line 51: @@
 |-
 ||Show the map '''Stations.shp''' on '''Desktop'''.
-|| I have already downloaded the '''Code file''', extracted and saved in a folder on the '''Desktop'''.
+|| I have already downloaded the '''Code files''', extracted and saved in a folder on the '''Desktop'''.
 |-
-|| Double click on code file folder.
+|| Double click on code files folder.
 Point to '''Stations.shp'''.
@@ Line 127: / Line 127: @@
 |-
-|| Cursor on '''Layer panel'''.
+|| Cursor on '''Layers panel'''.
 Cursor on the map.
@@ Line 146: / Line 146: @@
 |-
-|| Cursor on the Attribute table window.
+|| Cursor on the '''Attribute''' table window.
 || '''Attribute table '''opens.
@@ Line 156: / Line 156: @@
 |-
-||Click on Layer menu from the menu bar.
+||Click on '''Layers''' menu from the menu bar.
 || Now we will add another''' data-set''' which is a spreadsheet to the '''Layers Panel'''.
-This dataset is in CSV format.
+This dataset is in '''CSV''' '''format'''.
 |-
@@ Line 211: / Line 211: @@
 |-
-||Cursor on '''Layer panel'''.
+||Cursor on '''Layers panel'''.
 ||On '''QGIS''' canvas, '''Rainfall layer''' will be added in the '''Layers Panel'''.
@@ Line 223: / Line 223: @@
 |-
-||Point towards the attribute table columns.
+||Point towards the '''attribute''' table columns.
 || '''Attribute table''' opens.
@@ Line 347: / Line 347: @@
 || Cursor on '''QGIS ''' Interface.
-Cursor on the '''Layer Panels'''.
+Cursor on the '''Layers Panels'''.
 Right Click on '''Stations layer'''.
@@ Line 388: / Line 388: @@
 || Click on '''Open '''button in '''Add Vector Layer''' dialog box.
-Point to the '''Admin''' layer in the '''Layer panel'''.
+Point to the '''Admin''' layer in the '''Layers panel'''.
 || Again click on '''Open''' button in the '''Add Vector Layer''' dialog box.
@@ Line 399: / Line 399: @@
 |-
-|| Click the '''Admin layer''' in the '''Layer panel'''.
+|| Click the '''Admin layer''' in the '''Layers panel'''.
 Drag and bring it below station layer.
@@ Line 504: / Line 504: @@
 |-
-|| Cursor on the '''Layer panel'''.
+|| Cursor on the '''Layers panel'''.
 ||On the canvas, a new '''layer''', '''Joined layer''' is added in the '''Layers Panel'''.
@@ Line 519: / Line 519: @@
 |-
-|| Close the attribute table.
+|| Close the '''attribute table'''.
 ||Close the '''attribute table'''.

@@ Line 483: / Line 483: @@
 We are interested to find the meteorological stations located in various states.
-So under '''Geometric predicate''', we will select '''within''' option.
+So under '''Geometric predicate''', we will select '''within''' check-box.
 Scroll down.