MapPiloteGeopackageHelper 1.2.0

MapPiloteGeopackageHelper

Modern .NET library for creating, reading, and bulk-loading GeoPackage (GPKG) data using SQLite and NetTopologySuite. Note that in version 1.2.0 I have split the repository on github into two, hope it simplifies understanding:

• MapPiloteGeopackageHelper The core library with tests.
• MapPiloteGeopackageHelperExamples Example projects that uses the latest published Nuget package.

Quick Start - Modern Fluent API

// Create/open GeoPackage with fluent API
using var geoPackage = await GeoPackage.OpenAsync("data.gpkg", srid: 3006);

// Create layer with schema
var layer = await geoPackage.EnsureLayerAsync("cities", new Dictionary<string, string>
{
    ["name"] = "TEXT",
    ["population"] = "INTEGER",
    ["area_km2"] = "REAL"
});

// Bulk insert with progress
var progress = new Progress<BulkProgress>(p => 
    Console.WriteLine($"Progress: {p.PercentComplete:F1}%"));

await layer.BulkInsertAsync(features, 
    new BulkInsertOptions(BatchSize: 1000, CreateSpatialIndex: true),
    progress);

// Query with async streaming
await foreach (var city in layer.ReadFeaturesAsync(
    new ReadOptions(WhereClause: "population > 100000", Limit: 10)))
{
    Console.WriteLine($"City: {city.Attributes["name"]} - {city.Attributes["population"]} people");
}

// Count and delete operations
var count = await layer.CountAsync("population < 50000");
var deleted = await layer.DeleteAsync("population < 10000");

Modern Features

API Comparison

Modern API (Recommended)

// One-liner with progress and options
using var gp = await GeoPackage.OpenAsync("data.gpkg");
var layer = await gp.EnsureLayerAsync("places", schema);
await layer.BulkInsertAsync(features, options, progress);

Traditional API (Still Supported)

// Multi-step process
CMPGeopackageCreateHelper.CreateGeoPackage(path, srid);
GeopackageLayerCreateHelper.CreateGeopackageLayer(path, name, schema);
CGeopackageAddDataHelper.BulkInsertFeatures(path, name, features);

Sample Projects

Reference Links (GeoPackage Specification)

• GeoPackage Encoding Standard - https://www.geopackage.org/spec/
• OGC Standard page - https://www.ogc.org/standard/geopackage/
• Core tables (spec sections)
  • gpkg_contents: https://www.geopackage.org/spec/#_contents
  • gpkg_spatial_ref_sys: https://www.geopackage.org/spec/#_spatial_ref_sys
  • gpkg_geometry_columns: https://www.geopackage.org/spec/#_geometry_columns
• Binary geometry format - https://www.geopackage.org/spec/#gpb_format

What This Library Does

• Creates GeoPackages with required core tables
• Creates layers (tables) with geometry + custom attribute columns
• Bulk writes features with validation and progress tracking
• Streams features back with filtering and paging
• Modern async patterns with cancellation support
• Schema inspection and validation

Getting Started

1. Install: dotnet add package MapPiloteGeopackageHelper
2. Explore: Check out FluentApiExample project
3. Inspect: Use MapPiloteGeopackageHelperSchemaBrowser for unknown files
4. Learn: Traditional patterns in MapPiloteGeopackageHelperHelloWorld

Open the generated .gpkg files in QGIS, ArcGIS, or any GIS software!