The recording of this lecture can veiwed at:
Video Link
Looking at some of our relational databases
Install some software and get some data
To view some of the database information, install browser for sqlite and download some files from our download link at:
https://fileshare.gis.unbc.ca/index.php/s/NmT5iDW4awTezfp
From the link you will need:
software/dbvis…
geopaparazzi_examples/geopap…
Hopefully you have installed dbbrowser for sqlite, but installing the DBVisualizer by:
Find the package you downloaded and run –
dpkg -i dbvis_liunux_11_0_5.deb
Looking at Stats Can Data
Let’s have a look a the hierarchical chart of census boundary files:
https://www12.statcan.gc.ca/census-recensement/2016/ref/dict/figures/f1_1-eng.cfm
What did we see in the stats can data. If we look at the attribure table of the block or DA layers from Stats Can, we can see the nested relationship to the data.