Lecture 04 – Relational Models

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 Read more…

Tutorial 05 – PostGIS

Introduction Today we will be looking at doing GIS inside of the Enterprise Database using PostGIS. Now you may be wondering what is our motivation to using PostgreSQL and primarly it is due to its performance and concurrent access. When we talk about performance we are talking about how many Read more…