...
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 |
|---|
|
...