Skip to content

Instantly share code, notes, and snippets.

View bertt's full-sized avatar

Bert Temme bertt

View GitHub Profile
@bertt
bertt / duckdb-open-buildings-tutorial.md
Last active July 13, 2023 08:34 — forked from cholmes/duckdb-open-buildings-tutorial.md
Tutorial on using DuckDB with the Google Open Buildings geoparquet files on source.coop

DuckDB and GeoParquet Tutorial

This is a quick tutorial on how you can use DuckDB to easily access the cloud-native version of the Google Open Buildings data set from source.coop and transform it into your favorite GIS format. A big thanks to Mark Litwintschik's post on DuckDB's Spatial Extension for lots of the key information, it's highly recommended.

About DuckDB?

DuckDB is an awesome new tool for working with data. In some ways it's a next generation 'SQLite' (which is behind GeoPackage in the geo world) - but fundamentally designed for analysis workflows. TODO: more explanation.

To install it just follow the instructions at: https://duckdb.org/docs/installation/index. This tutorial uses the command line version

@bertt
bertt / connection.cs
Last active September 15, 2017 07:53 — forked from glennc/connection.cs
SignalRAnnouncement
var connection = new HubConnectionBuilder()
.WithUrl("http://localhost:5000/chat")
.WithConsoleLogger()
.Build();
connection.On<string>("Send", data =>
{
Console.WriteLine($"Received: {data}");
});