eolab:openhype:start
Differences
This shows you the differences between two versions of the page.
eolab:openhype:start [2022/10/17 11:01] – [2.3.3 Anaconda] sina001 | eolab:openhype:start [2023/01/05 14:38] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | /* | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
- | ====== | + | */ |
- | + | ====== | |
- | ===== NRW Groundwater Data – OpenHygrisC Data Processing for Education (OpenHyPE) ===== | + | |
- | + | ||
- | * Gefördert durch das [[https:// | + | |
- | * Laufzeit: 15.12.2021 - 31.12.2022 | + | |
+ | * Gefördert durch das [[https:// | ||
+ | * Laufzeit: 15.12.2021 - 30.06.2023 | ||
+ | /* | ||
=====Table of Contents===== | =====Table of Contents===== | ||
Line 39: | Line 39: | ||
5. Project Codes | 5. Project Codes | ||
+ | */ | ||
Line 97: | Line 97: | ||
===== 2.2 PostgreSQL/ | ===== 2.2 PostgreSQL/ | ||
- | PostgreSQL | + | PostgreSQL, also known as Postgres, is a free and open-source |
- | **PostGIS: | + | **PostGIS: |
The below image shows the PGadmin tool. | The below image shows the PGadmin tool. | ||
Line 142: | Line 142: | ||
* Programming applications | * Programming applications | ||
- | In this project, we have used Python for data engineering, | + | In this project, we have used Python for data engineering, |
| {{ : | | {{ : | ||
Line 276: | Line 276: | ||
- | In the previous section, we have downloaded the data, cleaned and imported them to the database successfully and now it's time to see the data in the database. as we know, the SQL command is valid in the Postgres | + | In the previous section, we downloaded the data, cleaned and imported them to the database successfully and now it's time to see the data in the database. as we know, the SQL command is valid in the PostgresSQL |
First, we want to see our tables, with the below code, we are selecting all the columns (***** means all the columns) from our schema which is consist of our table (in this case is **sina**) and with the name of the table. and then because the size of the table is huge and we want only to see the first 100 rows then we just limit it to 100. | First, we want to see our tables, with the below code, we are selecting all the columns (***** means all the columns) from our schema which is consist of our table (in this case is **sina**) and with the name of the table. and then because the size of the table is huge and we want only to see the first 100 rows then we just limit it to 100. | ||
Line 536: | Line 536: | ||
\\ | \\ | ||
- | All the codes are available in below link. | + | All the codes are available in the below link. |
[[ https:// | [[ https:// |
eolab/openhype/start.1665997312.txt.gz · Last modified: 2023/01/05 14:38 (external edit)