Creating a data structure for your data in a Scratch layer, a GeoPackage, or PostgreSQL using QGIS
Channel: Geoinformatics
Date: 13/09/2022

In this this video I will Demonstrate how to create a Data structure to store your geospatial data using QGIS. I will demonstrate both the spatial and non-spatial data types available in Temporary scratch layers, a GeoPackage and a PostgreSQL database.

Chapters
0:00 Introduction
0:36 Managing a Geospatial Database
2:22 The data formats covered in the video
2:55 GeoPackage 
3:14 Temporary Scratch Layer
3:44 PosrgreSQL
3:55 PostgreSQL Vs. GeoPackage
5:00 The Geometry Types 
7:02 The CRS (Coordinate Reference System)
11:00 the CRS waning in QGIS
11:50 Attribute data types
12:00 Numbers (integers and real numbers)
12:33 Boolean 
12:46 Text (Strings)
13:20 Time and Data
13:31 BLOB (Binary Large Object)
13:47 Structural data (JSON)
14:47 Comparing the implementation of Text
15:08 Comparing the implementation of numbers
16:38 Comparing the implementation of Boolean and time data types
17:13 Comparing the implementation of Complex data types
18:53 Creating a Temporary scratch layer in QGIS
19:32 Setting the CRS (Coordinate Reference System)
21:27 PostgreSQL and GeoPackage (Use the Browser)
21:52 GeoPackage
23:12 PostgreSQL