Collaborating on a QGIS Project saved in a PostgreSQL database
QGIS provides a couple of options when it comes to working with QGIS projects. All these formats have their strengths and weakness. When doing some work in QGIS we used to share around the QGIS projects but ever since storing the QGIS projects in a PostgreSQL database became an option we have been investigating using this as our primary method of collaboration.
PostgreSQL SSL setup in docker-postgis
Databases are the cornerstone of most web applications and also act as a central repository for the storage of data.
A step forward in Kartoza's QGIS and GeoNode Training
Learning online has become an essential part of education globally. Kartoza has answered the call for up-to-date, engaging and dynamic teaching material by updating our QGIS and GeoNode teaching platforms. Kartoza uses our open source 'changelog' platform, that allows for continual updates and customisation of material to deliver cutting-edge training.
The Kartoza Intern's journey creating a field survey with QGIS, Mergin and Input
Simple, powerful and efficient field data collection is vital for any project with a geospatial aspect. Input is a FOSS application created by Lutra consulting that brings the power of QGIS to a portable device for data collection. The Kartoza intern team was challenged to get to grips with Input. The team decided to keep it simple and create a project to collect data from local parks, including paths, trees and infrastructure. This blog follows the journey taken by the team and includes tips and tricks to help novice users.
QGIS Road to Nerdvana Episode 19 and 20
Today's blog shows the next two episodes in the Road to Nerdvana series. Episode 19 is a walk through using the Google Earth Engine Timeseries Explorer plugin for QGIS and in Episode 20 Tim shows off some of the work he has been doing to integrate QGIS Server and QGIS Atlas reports on his farm project.
Reading and Writing XLSX File with Openpyxl
Openpyxl is a Python library used for manipulating Excel files. I came across a ticket that required exporting data to XLSX format, and I used Openpyxl for that as it’s pretty straightforward.
Using geospatial technology to promote Clean Cooking
Access to clean cooking technology (such as gas or electric stoves) can greatly improve health outcomes. Approximately 3 million people depend on biomass fuels such as wood, coal, and dung for cooking to cook with (source: WHO article on household air pollution). The indoor air pollution generated whilst cooking indoors has serious, negative health impacts, with women and children in particular being affected. In fact the World Health Organisation (WHO) notes:
QGIS Road to Nerdvana Intern Edition
The interns took over the Nerdvana space, showing off their mapping skills using QGIS
QGIS Road to Nerdvana Episode 18: Introduction to PostgreSQL and PostGIS
This is a walk-through showing how PostgreSQL and PostGIS can be used as a geospatial data store and then the data in that store be consumed and created by geopandas.
Python is a dynamically-typed language, which means the interpreter does type-checking when the code is executed, and the variable type can change over its lifetime.
Making Django Custom Migrations
Working with Django, we must be familiar with
makemigrations and the
migrate command. We use
makemigrations to automatically generate migration files, and
migrate to apply them.
QGIS Road to Nerdvana Episode 14: Fun and games with QGIS Server
In this episode, Charles and Tim walk through setting up a QGIS server in docker with data and QGIS project files published in PostgreSQL / PostGIS. They have made a resource pack with the configuration files created and the sampled data etc., all of which are available at:
QGIS Road to Nerdvana Episode 12: Dashboards revisited!
In case you missed out on Episode 12 of our QGIS Road to Nerdvana, click on the link and enjoy the stream: QGIS Road to Nerdvana Episode 12
QGIS Style sharing repository
Woohoo! A new way to share styles in QGIS! Work sponsored by Kartoza.
Python Mocking Introduction
Mocking is a process in unit testing when the test has external dependencies. We isolate our code during the test, without having to worry about the unexpected behavior of the dependencies. For example, we create a routine to save something to Firebase which utilizes 3rd party library called Firestore. There could be problems when saving data to Firebase, like internet connections, wrong configuration, non-existing document, you name it. Instead of testing every possible scenario when saving to Firebase, we only test that Firestore is called with correct parameter, which represents our data. The tests for Firestore itself should have been done by Firestore developer. Hence, we can shift our focus towards the implementation of our code. It also reduces testing time because we don’t need to send our data to Firebase.
QGIS Road to Nerdvana Episode 11: Aggregate dashboards
Tim Sutton decided to change things up a bit, he was joined by Charles and Seabilwe from Kartoza and the three made aggregate dashboards in QGIS. It is just the first steps and a lot of bumbling around, but hey maybe you will learn something!
QGIS Road To Nerdvana Episode 10: Speed Map Making (part 2)
Why make just one map in the quickest time possible? Make more! In this video Tim Sutton will again try to go from Zero to a Nice Looking Map as quick as he can.
QGIS Road to Nerdvana Episode 10: Speed Map Making (part 1)
In this video Tim Sutton will be trying to go from Zero to Nice Looking Map as quick as he can. See how he goes about creating the map and see if you can't make a nice looking map in 30 minutes.
QGIS Road to Nerdvana Episode 9: Building a 3D scene from scratch
In this episode Tim Sutton will show you how to make a simple 3D scene in QGIS.
QGIS Road To Nerdvana Episode 8: It's all a big meshunderstanding
In this episode watch along as Tim Sutton explores some of the new mesh capabilities coming in QGIS 3.16!