Goal

This series of articles aims to make the complex world of spatial SQL and databases make sense to you.

Objectives

• Conduct thorough research on each topic to ensure the quality of content.

• Write the article in clear and concise language that is easy to understand.

• Use of illustrations, GIFs, videos and high-quality graphics to explain complex concepts.

Topics covered

• Database and spatial databases.

• SQL and spatial SQL.

• Using PostGIS with other tools.

Delivery mode

The articles in this series will be long and detailed, some in the form of tutorials. I encourage you to follow through.

Frequency

I will publish at least one article per month.

Table of Contents

Note: This table of content is subject to change, I will update it with the links to each article as I publish them.

1. Spatial data, and formats

2. Databases vs. spatial database

3. SQL vs spatial SQL

4. Introduction to PostGIS

5. Working with PostGIS

6. Spatial indexes in PostGIS

7. Working with OpenStreetMap (OSM) data in PostGIS

8. Loading raster data into PostGIS

9. PostGIS and QGIS

10. PostGIS and STAC

11. PgRouting and PostGIS

12. Working with Mabox Vector Tiles in PostGIS

13. PostGIS and Geoserver

14. Deploying PostGIS on AWS

15. Deploying PostGIS on Digital Ocean

16. GeoDjango and PostGIS

17. PostGIS and the command line

Feedback

Please comment below if you have any topics you would like me to cover.

Stay Tuned!