The posts here are written by Dror Bogin and are not to be used commercially without explicit, and case specific written authorization (which will probably be given, but I like to know where my stuff is going).

Until I get around to moving all of the posts here you can find my blog at

https://bogind.blogspot.com/

The posts that have already moved, should apper below.

• Beyond Expressions: What To Do When QGIS Expressions Go Too Far And Get Too Complex?

  By Dror Bogin

  Posted on January 31, 2021

  

  

  I got to writing this after having tried grouping points in polygons with expressions for too long, even with aggregate. so what do you do when expressions fail you? [Read More]

  Tags:

  • Views
  • QGIS
  • Expressions
  • SQL

• Exploring The QGIS Expression Engine, Part 3: Writing Custom Expression Functions

  By Dror Bogin

  Posted on January 19, 2021

  

  

  Jump ahead to the new stuff Jump ahead to the part about writing the function help [Read More]

  Tags:

  • QGIS Custom Expression Functions
  • QGIS
  • Expressions
  • Python

• Exploring The QGIS Expression Engine, Part 2: What's Missing From Select By Location

  By Dror Bogin

  Posted on December 3, 2020

  

  

  How To Select Within Distance [Read More]

  Tags:

  • QGIS
  • Expressions
  • Select Within Distance
  • aggregate

• Exploring The QGIS Expression Engine, Part 1: Getting Values From JSON & HSTORE

  By Dror Bogin

  Posted on November 25, 2020

  

  

  This will be the first post of as many as I get around to write about using the QGIS expression engine for selection, geometry generation and calculations to speed up and automate some analysis. [Read More]

  Tags:

  • OpenStreetMap
  • QGIS
  • JSON
  • Expressions
  • HSTORE

• Using Polygons As Markers

  By Dror Bogin

  Posted on November 17, 2020

  

  

  How I Got Into This [Read More]

  Tags:

  • MapBox GL JS
  • JavaScript
  • Turf.js
  • MapLibre

• Using URL Parameters in GeoServer Views

  By Dror Bogin

  Posted on November 9, 2020

  

  

   This method is great when trying to serve a layer with a lot of detailed features that covers a large area, like land parcels. Instead of getting the full layer for your web map, you can just limit visibility of the layer for specific zoom levels and query the view... [Read More]

  Tags:

  • Views
  • PostGIS
  • GeoServer
  • SQL

• Creating A Static Cache of XYZ tiles with GeoServer

  By Dror Bogin

  Posted on November 3, 2020

  

  

  TL;DR : skip to the guide, follow the pretty pictures, create static cache for image or vector tiles in any format.  This one is more of a virtual post-it note than anything else.The first time I had to create a static cache of tiles (vector or image) from GeoServer I... [Read More]

  Tags:

  • XYZ tiles
  • GeoServer
  • tiling
  • cache
  • caching

• How To Overwrite A GeoPackage Raster

  By Dror Bogin

  Posted on November 2, 2020

  

  

  This came to me as somewhat of a shock, I was bounty hunting at gis.stackexchangewhen I came across this question and took a look at the GDAL formats docs.Apparently, you can't overwrite a raster stored inside a GeoPackage. It's simply not one of the options. But you can however overwrite... [Read More]

  Tags:

  • Raster
  • GDAL
  • GeoPackage
  • Python