Bluff Next: Processing Survey Data In Gcs With Qgis 3.4.X

Learn to process survey data, plotting in QGIS, creating spatial models and designing multi-layouts.

What you'll learn

Introduction to the Geopackage format (.gpkg) in QGIS 3.34.x

Comparison of Shapefile and Geopackage formats

Export SHP data to GPKG in Geographic Coordinate System (GCS)

Process Survey data in XLS and export to CSV

Plotting survey point distribution in Decimal Degree from CSV and exporting to GPKG

Creating spatial modeling

Creating Multi-Layouts

Requirements

Require basic knowledge of QGIS operation

Require basic knowledge of data processing operations in Microsoft Windows (File Explorer)

Description

1. Introduction to Geopackage (.gpkg),GPKG is a proprietary format from QGIS. Although this format is relatively new, its popularity is rapidly increasing because many things offered by this format far surpass the Shapefile/SHP format. GPKG not only accommodates vector data but also raster data, spreadsheets, tile data and can even store QGIS Project Document (QGS/QGZ) so that GPKG is truly able to create an isolated environment for a project. GPKG can do this because GPKG is supported by the SQLite database so GPKG is not just a format but also a database.2. Geopackage VS Shapefile.SHP has been the de facto standard vector data format in the GIS industry for 40 years. When SHP was first launched, this format was supported by the most advanced technology at that time, for example DBF database support. Currently, DBF is no longer used because there are many weaknesses here and there. The vector data storage format was then developed again by still using database technology as the backbone of data storage but with much better adjustments. One of the data storage formats developed by QGIS is Geopackage/GPKG. GPKG is supported by a sophisticated, lightweight and easy-to-use SQLite database. We will go head to head to compare the advantages and disadvantages of the SHP and GPKG formats.3. Export SHP to GPKGGPKG is able to create new features but on this occasion we will export existing SHP data to GPKG, besides saving time, we can also practice. There are many formats that can be read by QGIS and all of them can be exported to GPKG. besides SHP, other popular data formats are KML and geoJSON.4. Processing field survey data in XLS format, editing and cleaning dataBefore being processed in QGIS, field data in XLS format is first cleaned/cleaned such as column names that must not have spaces.5. Export XLS to CSVAfter being cleaned, the XLS data is exported to CSV.6. Plotting survey point distribution data CSV to QGIS, XY data in Geographic Coordinate System (GCS) in decimal degree (DD) formatThe CSV data is then added and plotted to QGIS. Plotting or displaying the distribution of survey points on the QGIS canvas is done using 2 (two) columns/fields, a combination of X/Longitude/Longitude and Y/Latitude/Latitude as the coordinate points of the earth where the survey respondents are located. The coordinate system used in this course is the Geographic Coordinate System (GCS) with degrees (Degree) and in Decimal Degree/DD format7. Export plotting data to GPKGThe distribution of survey points that have been added to the QGIS canvas is temporarily stored in memory (temporary layer), to make it permanent we will export this point distribution data to GPKG8. Creating a spatial modelWe will create a spatial model from the distribution of survey points that have been stored in GPKG. This spatial model can be in the form of thematic, choropleth, clustering and heatmap. The spatial model will provide a clearer picture of how this data is distributed based on the attribute data obtained such as the age spatial model, the monthly turnover spatial model, the annual turnover spatial model and others.9. Designing multi-Layout in one QGIS project document (QGS/QGZ).The advantage of creating a layout in QGIS is multi-Layout. We can create many layouts/multi-layouts from just one QGS. We are able to create layouts for each of the spatial models above from just one QGS/QGZ.

Overview

Section 1: Introduction

Lecture 1 Courses Big Picture

Lecture 2 Geopackage (GPKG) VS Shapefile (SHP)

Section 2: Processing SHP into GPKG

Lecture 3 2.1. Create new GPKG and export SHP into GPKG

Lecture 4 2.2. Change/rename attribute/field names in GPKG and SHP

Section 3: Processing Survey Data

Lecture 5 3.1. Processing XLS Data into GPKG

Lecture 6 3.2. Cleaning data with Geocoding techniques

Lecture 7 3.3.Comparing field names in SHP and GPKG

Section 4: Spatial Modelling

Lecture 8 4.1. Fix wrong data type in an attribute table

Lecture 9 4.2. Create thematic maps

Lecture 10 4.3. Create choropleth maps

Lecture 11 4.4. Add thousand separator

Lecture 12 4.5. Separate each spatial modelling into different Project QGZ

Section 5: Designing Multi-Layout Thematic Maps

Lecture 13 5.1. Designing layout for Gender Thematic

Lecture 14 5.2. Designing layout for business type Thematic

Lecture 15 5.3. Designing layout for business duration Thematic

Lecture 16 5.4. Designing layout for business asset Thematic

Lecture 17 5.5. Export thematic layout to JPG

Lecture 18 5.6. Export Layout to PDF and save template

Section 6: Designing Multi-Layout Choropleth Maps

Lecture 19 6.1. Designing layout for Age Graduated Choropleth

Lecture 20 6.2. Designing layout for Age Cluster Choropleth

Lecture 21 6.3. Designing layout for Age HeatMap Choropleth

Lecture 22 6.4. Designing layout for Monthly Income Graduated Choropleth

Lecture 23 6.5. Designing layout for Monthly Income Cluster Choropleth

Lecture 24 6.6. Designing layout for Monthly Income HeatMap Choropleth

Lecture 25 6.7. Designing layout for Annual Income Graduated Choropleth

Lecture 26 6.8. Designing layout for Annual Income Cluster Choropleth

Lecture 27 6.9. Designing layout for Annual Income HeatMap Choropleth

Lecture 28 6.10. Export Layout into JPG and PDF

Beginning users who already understand the basics of QGIS operation