DuckDB and QGIS

Nov 27, 2023 | 911, address, Python, QGIS

I’ve not taken time over the last few months to “play” with geo. I’ve been hitting conferences and marketing and doing all the things I sort of don’t like that much. More talk of conferences coming.

One thing I’ve seen pop up more and more is duckdb. Wht is it? Basically a serverless database. It’s local. You use it for data analysis or data update locally. For everything I’ve been doing with a database lately duckdb won’t work – BUT – it’s interesting.

I downloaded it and ran it and basically after some hit or miss since I barely read the documentation I read in a shapefile. Basically after making a database and a table I did:

create table addresses as select * from st_read('../../temp/address_points.shp');

I did a little bit of SQL and had fun. DuckDB has a spatial extension so you can do things like load spatial data like a shapefile or Geopackage.

Why talk about it? This announcement from Oslandia:

So with a small amount of effort to install an experimental plugin (no I’m not telling you how to install an experimental plugin):

I can view the data and run processes – I just can’t edit it. Yet. At least I hope it’s a yet. I see much possibility in duckdb. Well – basically I see great possibility in anything where there is an open spec and a community growing around it. Plus this is pretty new and QGIS can already view the database.

The important part as taken from the blog post:

The following features are already identified. You can make them a reality through funding :

  • Layer editing (modify data, add/delete columns, create/delete entities, etc.)
  • Importing a spatial layer from QGIS directly into a DuckDB database
  • Better integration of DuckDB in QGIS
  • Support for tables with multiple geometry types
  • If you have any development requests, please don’t hesitate to contact us: contact@oslandia.com

You may also like

Type in the TN NG911 Database

Type in the TN NG911 Database

THE PLAN.....there was a plan. Oh yes - the plan is to make editing and creating data in TN for the 911 addressing system to be as easy as possible. Menus and Triggers abound and now as two counties are using this with a third on the horizon - HOW do I make this...

Photos in Mergin Maps

Photos in Mergin Maps

Not that this is new - Mergin has been doing this for a bit BUT I finally had the chance to sit down and use it. I have a client taking pics of houses to feed into the 911 dispatch system. Granted - not easy, not fun, and not his idea but he walked into this and has...

Fixing a problem

Yesterday was wild. Flash back to 6 years ago and I transferred a ESRI Process over to QGIS/PostGIS and it happened to be a 911 addressing database. As I was walking out the door, the client said "So how do we deliver the data to the state" and through a bunch of...