How to make a map with the most recent Streetview capture dates per street with Python and GeoJSON

In the past I have created a map of Antwerp, Kontich and Edegem that shows when the most recent Google Streetview images were taken. To do so I use a MySQL database and some PHP scripts. I created multiple blog posts on how I make these maps:

As a comment on the Dutch version of that last blog post, I got the question if it was possible to do the same with a GeoJSON or a Geopackage file and something else than PHP. So I translated my MySQL – PHP combo to GeoJSON and Python 3.

Continue reading “How to make a map with the most recent Streetview capture dates per street with Python and GeoJSON”

A map with the most recent Streetview capture dates per street: the PHP and SQL scripts I use

A couple of years ago I wrote a blog post about my way of creating overview maps of the availability of the most recent Google Streetview images per municipality. I still do these checks these days for Antwerp, Kontich and Edegem, so that way I always have up-to-date information about the availability of these images. Recently I got the asked (in Dutch) to share my scripts I use for this task. I wanted to do so, but these PHP scripts I use, were a bit messy, because I was the only one using them. That’s why I updated them a little, so they can be used by more people.

Continue reading “A map with the most recent Streetview capture dates per street: the PHP and SQL scripts I use”

Two styles added to my Geometry Generator examples

I have added two new styles to my QGIS Geometry Generator examples:

  • Graph charts with labels: This style creates a bar chart with two bars for each point and adds a label with the value for each bar above the bar, similar like graph charts in spreadsheets.
  • Chaos lines: If you prefer your maps chaotic, this is your style. The example creates a curly line between the center of your screen and each point.

The examples (including data, project files and QML files) can be found on https://gitlab.com/GIS-projects/qgis-geometry-generator-examples/.

Continue reading “Two styles added to my Geometry Generator examples”

A “Halftone Edge” style for QGIS

I added a new “Halftone Edge” style for QGIS to my GitLab repository that contains some of my use cases of Geometry Generators.

All info on this new QGIS style, including example files, can be found on https://gitlab.com/GIS-projects/qgis-geometry-generator-examples/tree/master/QML-files/halftone_edge.

You can download the entire repository with all my Geometry Generator examples at once: https://gitlab.com/GIS-projects/qgis-geometry-generator-examples/-/archive/master/qgis-geometry-generator-examples-master.zip

Copy WFS data to PostGIS using ogr2ogr (PART 3): automating the import procedure

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 was about the installation of GDAL and ogr2ogr. Part 2 was about the use of ogr2ogr in a Windows batch file and part 3 is about automating the import procedure.

Continue reading “Copy WFS data to PostGIS using ogr2ogr (PART 3): automating the import procedure”