generated from jtr13/bookdown-template
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path04-Setup.Rmd
145 lines (102 loc) · 2.38 KB
/
04-Setup.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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
# Getting started
## Installing packages
If you have installed the below packages already, you can jump to the next step.
```{r,eval=FALSE}
install.packages("data.table")
install.packages("dplyr")
install.packages("RPostgreSQL")
install.packages("profvis")
```
## Loading packages
Load the packages for today's talk
```{r}
library(data.table)
library(RPostgreSQL)
library(dplyr)
library(profvis)
```
## Install PostGIS and Alteryx software
### Install PostGIS
+ Step 1: download the [PostgreSQL](https://www.postgresql.org/)
<center>
</center>
+ Step 2: select the right version for your system
<center>
</center>
+ Step 3: download the installer
<center>
</center>
+ Step 4: download the software
<center>
</center>
+ Step 5: install the PostgreSQL
<center>
</center>
+ Step 6: set the password
<center>
</center>
+ Step 7: select the port number
<center>
</center>
+ Step 8: click the Stack Builder
<center>
</center>
+ Step 9: choose the PostgreSQL for additional installation
<center>
</center>
+ Step 10: install the spatial extension
<center>
</center>
+ Step 11: create a postGIS database
<center>
</center>
+ Step 12: Enter the password
<center>
</center>
+ Step 13: set the database name
<center>
</center>
+ Step 14: Finish
<center>
</center>
***
You will find a PostGIS database names as casa in your postgreSQL
<center>
</center>
**The second approach:** create a database in PostgreSQL + extent it to PostGIS database ([Enabling PostGIS](https://postgis.net/install/))
<center>
</center>
### Install Alteryx
For academics, students, nonprofits institutes, you can install the Alteryx for free through [Alteryx for Good](https://www.alteryx.com/why-alteryx/alteryx-for-good).
(1) Step 1: Apply the Alteryx For Good License
<center>
</center>
(2) Step 2: Click the Alteryx Designer in Product Downloads
<center>
</center>
(3) Step 3: click the Alteryx Designer (2021.1)
<center>
</center>
(4) Step 4: download the Alteryx Designer and Alteryx Predictive Tools
<center>
</center>