Bert Temme bertt

## duckdb-open-buildings-tutorial.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                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

  
## connection.cs
var connection = new HubConnectionBuilder()
                .WithUrl("http://localhost:5000/chat")
                .WithConsoleLogger()
                .Build();

connection.On<string>("Send", data =>
{
    Console.WriteLine($"Received: {data}");
});
	var connection = new HubConnectionBuilder()
	.WithUrl("http://localhost:5000/chat")
	.WithConsoleLogger()
	.Build();

	connection.On<string>("Send", data =>
	{
	Console.WriteLine($"Received: {data}");
	});