Getting started with Spatial Database using Quantum GIS + PostgreSQL + PostGIS

SGHG 4653 (Advance Database)
Assignment #01 Walk-through

Getting started with Spatial Database using Quantum GIS + PostgreSQL + PostGIS

Chapters:
0:00 Intro
0:03 Data preparation
0:21 Database creation and creating
PostGIS extensions
2:23 Importing Shapefiles into PostgreSQL
database using PostGIS Shapefiles and DBF Loader Exporter tool
5:10 View data in QGIS software
5:23 Add new PostGIS connection
7:22 Changing the map view's coordinate system to RSO (old)
8:08 Perform SQL to identify the imported layer's coordinate system
9:17 Set the layer's coordinate system to RSO (old) using EPSG code 3168
16:12 Importing attribute table (in DBF format) into PostgreSQL database via QGIS DB Manager tool
19:45 View the imported attribute table using QGIS DB Manager tool
20:34 Join both map and attribute table from PostgreSQL
21:42 Create thematic map in QGIS
33:36 Export the joined data (from PostgreSQL) to Shapefile