vgi

VGI (Vector Gateway Interface) — DuckDB extension for extending DuckDB in any language over Apache Arrow IPC. No C++/compilation required.

Python SDK for the VGI (Vector Gateway Interface) protocol — host DuckDB scalar, table, aggregate, and table-in-out functions in an external worker over Arrow IPC.

Row pattern matching in DuckDB with SQL — SQL:2016 MATCH_RECOGNIZE (PARTITION/ORDER/PATTERN/DEFINE/MEASURES) for sequences: V-shapes, funnels, sessionization, event patterns. A VGI worker.

Research data on crowd-mapping project Wikimapia: Wikimapia is a major privately-owned volunteered geographic information (VGI) project to collect information about places. Over the past ten years, Wikimapia has attracted hundreds of thousands of contributors and collected millions of data points, including towns, restaurants, lakes, and tourist…

The web portal for OpenGeoResearch.

Option pricing+Greeks, bond pricing/yield & day-counts for DuckDB (Python, QuantLib)

Detecting and Correcting Spatial Bias in VGI Using Remote Sensing — OSM evaluated against USGS 3DEP LiDAR (DGCNN segmentation) and NAIP over the UIUC campus, scaling to an urban→rural gradient.

The image classifier api for OpenGeoResearch.

The smartphone app for OpenGeoResearch.

Read and write fixed-width / flat-file / mainframe data in DuckDB with SQL — Perl unpack / Python struct / COBOL copybooks (COMP-3, EBCDIC, OCCURS, REDEFINES). A VGI worker.

TypeScript server & client library for the VGI-RPC framework — Apache Arrow IPC over stdin/stdout and HTTP

Model, method and tools for building a knowledge base from the OpenStreetMap folksonomy: the OF4OSM ontology.

Physical unit conversion & dimensional analysis (14 dimensions) for DuckDB (Rust)

Video/audio/container metadata via ffprobe in DuckDB (Go)

Decode ASN.1 / BER / DER in DuckDB with SQL — generic TLV plus SNMP, LDAP, CMS, PKCS, Kerberos and OCSP decoders. A VGI worker.

Scholarly search across OpenAlex/arXiv/Crossref for DuckDB (Python)

XSLT 3.0 / XQuery 3.1 / XPath 3.1 over XML for DuckDB (Python, SaxonC-HE)

BM25 full-text search with stemming & tokenization for DuckDB (Rust, tantivy)

Parse ISO 20022 (pacs/camt/pain) and SWIFT MT payment messages in DuckDB with SQL — no egress. A VGI worker.

Java SDK for the VGI (Vector Gateway Interface) protocol — host DuckDB scalar, table, aggregate, and table-in-out functions in an external worker over Arrow IPC.