...
- Request for a database via topdesk call (assign to ICT-A&P), with the following remarks
- specify project number
- specify amount of data storage needed
- mention if you need the extension PostGIS
- specify the name of the database
- specify who (Deltares colleagues only!!) should have access
- Install pgAdmin (latest) from https://www.pgadmin.org/download/
- Install PostgreSQL/PostGIS on your local machine (without pgAdmin), follow the steps in this article
- Follow Get informed of the basics and application of PostgreSQL/PostGIS (check out within projects at Deltares via the e-learning platform of Deltares)
Why install it locally? It is good practice to separate development and production database (and tools in common).
From now on, the use case you are working on determines what the database will look like. Or in other words, data modelling for efficient storage and ease of extraction of data might be necessary. You can find all information on internet on the best approach to be taken.
| Info |
|---|
|
General PostgreSQL tutorials can be found at https://www.postgresql.org/docs/online-resources/ and at https://learnpostgres.dev/ (also checkout Coursera.org) PostGIS tutorials can be found Youtube and PostGIS.net. |
| Info |
|---|
|
| PostgreSQL and PostGIS are very well documented. Please visit PostgreSQL documentation respectively PostGIS Documentation. |
| Info |
|---|
| title | Automation with Python |
|---|
|
For automation and accessing PostgreSQL/PostGIS via Python you need at least the basic adapter psycopg2-binary (check) (it's important that the psycopg2-binary is installed, not the psycopg2 package).
Very helpfull are the packages sqlalchemy and geoalchemy. |
Related articles
| Content by Label |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | FAIR |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label in ("postgis","postgresql") and type = "page" and space in ("FAIR","OET") |
|---|
| labels | postgresql postgis |
|---|
|
...