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:

From the link you will need:


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:

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.