Using pgRouting, a navigation functionality is implemented based on a spatial database of a fun fair, where the user can input his or her position and be routed to a nearest Point of Interest. A Python DB connector dynamically creates the SQL queries and visualizes the results.
Imagining a relational database for a public bus operator, conceptual and logical databases model are created. The goal is to visualize the entities and their relationships within this scenario.
In this exercise, some role managing and security operations are performed. Roles are created, given permissions and view queries created that allow managing the restriction of information within a database.
In this exercise, some basic GIS functionalities are performed with SQL/PostGIS commands, such as Union, Intersect and Buffer.
The DBMS PostgreSQL and the geospatial extension PostGIS are used to load Shapefiles into QGIS and perform SQL querries.
In this assignment, basic queries of SQL queries in PostgreSQL are applied.
