Creating a data structure for your data in a Scratch layer, a GeoPackage, or PostgreSQL using QGIS

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