-
Notifications
You must be signed in to change notification settings - Fork 1
/
index.Rmd
93 lines (64 loc) · 2.5 KB
/
index.Rmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
---
title: "Building an Enterprise GIS Workflow with QGIS and PostGIS"
author: "Gispo Ltd."
date: "`r Sys.Date()`"
site: "bookdown::bookdown_site"
abstract: "Workshop delivered in FOSS4G Prizren 2023."
output:
bookdown::html_book:
toc: true
theme: null
template: custom.html
css: custom.css
split_by: rmd
documentclass: book
---
# Introduction
Welcome to the workshop on "Building an Enterprise GIS Workflow with QGIS and PostGIS" originally presented at FOSS4G 2023 Prizren (Kosovo). This workshop combines informative slides and hands-on exercises designed to guide you through the process of setting up a powerful GIS environment using QGIS and PostGIS. You can access the workshop slides through the following [link](https://drive.google.com/file/d/1AAZrR3EQcrioT99CG66VNiS1S6sZ5W1I/view?usp=sharing), and the exercises are available on this website for your reference and practice.
![QGIS is a robust environment for building PostGIS-enabled Enterprise GIS workflows](img/p1/sample_data.png){width="517"}
# Workshop Objectives:
- Create an enterprise GIS workflow using QGIS and PostGIS.
- Explore the benefits of spatial databases and their role in GIS data management.
- Set up QGIS projects to optimize GIS data management.
# Reading instructions
The commands executed in the web browser are indicated as follows:
::: note-box
<http://localhost:8080/geoserver>
:::
The commands executed on the command line are indicated as follows:
::: commandline-box
sudo lsb_release -a
:::
The contents of the files are presented as follows:
::: file-content-box
#IPv4 local connections: #host all all 127.0.0.1/32 md5
:::
The HTML and CSS codes, SQL commands, and Python scripts are presented as follows:
::: code-box
``` sql
SELECT version();
```
:::
The questions, additional information, and hints are presented as follows:
::: hint-box
Where can you find information about GeoServer?
GeoServer has its own website.
Psst! You can find information about GeoServer on the internet.
:::
## Software in question and further information
::: note-box
<http://www.qgis.org/>
:::
::: note-box
<http://docs.qgis.org/>
:::
::: note-box
<https://www.postgis.net/>
:::
::: note-box
<https://postgis.net/documentation//>
:::
## Errors
If you notice any errors in the material, please inform the trainer/workshop facilitator.
## License and user rights
These materials are developed by Gispo Ltd. Materials are licensed under: [CC BY-ND 4.0](https://creativecommons.org/licenses/by-nd/4.0/)