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.