Update: PluginLoadTimes 2.0.5 for QGIS

Recently I released a minor update for PluginLoadTimes for QGIS. You can download the most recent version of this plugin from within QGIS, because it is available in the official QGIS Plugin Repository.

If QGIS takes long to start, it is probably because some of the plugins you installed take a long time to load at startup. This plugin shows the latest load time of each plugin (QGIS startup, plugin installation,…). It does not give you information about the speed of plugins when they are used. With the information provided by this plugin you can easily decide which plugins to disable, to make QGIS start faster.

Continue reading “Update: PluginLoadTimes 2.0.5 for QGIS”

Copy WFS data to PostGIS using ogr2ogr (PART 1): installation of ogr2ogr

Sometimes a web service you use in your GIS application is offline and that results in a GIS application that doesn’t work as it should or doesn’t show the correct data. To avoid these problems you should have a local copy of the data of that web service. For a WFS service the data can be copied to a PostGIS database. This can be done using the command line utility ogr2ogr. This isn’t too hard but some people might be afraid to use the command line. So I wrote this guide about how to handle this from installation to automating the import procedure. Because this guide became pretty long I divided it up into 3 parts. Part 1 is about the installation of GDAL and ogr2ogr. Part 2 is about the use of ogr2ogr in a Windows batch file and part 3 is about automating the import procedure.

PART 1: installing GDAL and ogr2ogr

The utility ogr2ogr is part of the conversion library¬† GDAL and is used to convert simple vector data from one file format to another. Since version 2.0 ogr2ogr also supports PostGIS data. The advantage of GDAL is that it’s available for many different operating systems and distro’s and that commands work similar on these different systems.

Continue reading “Copy WFS data to PostGIS using ogr2ogr (PART 1): installation of ogr2ogr”

ZoomToBelgium v1.1 for QGIS released

I released version 1.1 of ZoomToBelgium for QGIS today. This QGIS plugin creates a button to zoom to any of the Belgian Municipalities or Districts. In this new release districts were added.

Recently this project migrated from Github to GitLab. From now on it can be found on https://gitlab.com/GIS-projects/ZoomToBelgium.

You can download this new version of ZoomToBelgium from within QGIS, because this plugin is available in the official QGIS plugin repository.

phpQGISrepository v1.3 released

I released version 1.3 of phpQGISrepository today. This is a simple PHP script to create a repository for QGIS Python plugins on your own server. In this new release the browser version of the repository got a brand new layout based on Bootstrap.

Recently this project migrated from Github to GitLab. From now on it can be found on https://gitlab.com/GIS-projects/phpQGISrepository.

You can download this new version of phpQGISrepository from that GitLab project.

Continue reading “phpQGISrepository v1.3 released”

Obscurify privacy sensitive data with PostGIS

If you want to show data in your GIS or webmap that is privacy sensitive, you should obscure the data to avoid privacy related problems. With PostGIS it’s easy to do by creating an altered table of the original data.

Example data

For this example I created a PostGIS table with points in a 100m x 100m grid. This makes it easier to show how the data is obscured. Of course your own data will probably be a table with address points or something like that. If you want to obscure your own data always make sure the table itself doesn’t contain privacy sensitive data. Continue reading “Obscurify privacy sensitive data with PostGIS”