PostGIS

GeoLens is a self-hosted geospatial data catalog for collecting, indexing, previewing, and sharing GIS datasets on infrastructure controlled by one organization. It ingests uploaded and created datasets, database tables, service snapshots, and remote STAC assets, including Shapefile, GeoPackage, GeoJSON, GeoParquet, FlatGeobuf, KML/KMZ, CSV, XLSX, GeoTIFF, Cloud-Optimized GeoTIFF, and VRT raster mosaics. The catalog records dataset provenance and source state, supports pg_trgm fuzzy search and optional pgvector semantic ranking, and provides spatial analysis operations such as buffer, centroid, clip, dissolve, spatial join, and intersection. Its browser-based map builder composes and styles multi-layer maps and publishes them through links or embeddable iframes. GeoLens exposes OGC API Features and Records, STAC API 1.0, JSON-LD catalog formats, direct tile URLs, and vector tiles for use with QGIS, ArcGIS, MapLibre, and other OGC clients. The stack uses a React and MapLibre frontend, a FastAPI API, a GDAL/ogr2ogr ingestion worker, Titiler for raster tiles, PostgreSQL with PostGIS, pgvector, and pg_trgm, plus object storage and Valkey caching. The project is deployed with Docker Compose or prebuilt container images and also publishes Python, TypeScript/JavaScript, CLI, and read-only MCP packages. Optional AI features use an OpenAI-compatible endpoint or Anthropic key for natural-language dataset and map interactions. GeoLens is licensed under Apache License 2.0; its own REST API may change between minor releases, while its OGC and STAC standards surfaces are intended for client integration.

GeoLibre is a free, open-source, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data. It supports GeoParquet, GeoPackage, and shapefile layers, with live styling, attribute tables, saved projects, plugins, and an optional Python package for use in Jupyter notebooks. The same workspace runs in web browsers, native desktop apps, mobile apps, and Jupyter notebooks while keeping data local. Its browser-based geoprocessing tools run through WebAssembly without a server or data leaving the machine. The project is built with Tauri v2, React, TypeScript, MapLibre GL JS, DuckDB-WASM Spatial, and deck.gl, and also provides R and Python packages plus installers and mobile distribution.

PostgreSQL is an open-source relational database management system maintained by the PostgreSQL Global Development Group. It provides SQL-compliant, ACID transactions, MVCC concurrency, and extensibility through custom types, functions and extensions, and is used for general-purpose and enterprise database workloads.

pgvector is an open-source PostgreSQL extension for storing vectors alongside relational data and querying exact or approximate nearest neighbors. It supports single-precision, half-precision, binary, and sparse vectors, with L2, inner-product, cosine, L1, Hamming, and Jaccard distance operators. The extension uses standard PostgreSQL tables and queries, including inserts, updates, bulk loading with COPY, filtering, joins, and indexed nearest-neighbor searches. It retains PostgreSQL capabilities such as ACID compliance and point-in-time recovery, and provides quantization options for scaling vector collections. It supports PostgreSQL 13 and later and can be compiled on Linux, macOS, and Windows or installed through Docker, package managers, PGXN, and hosted PostgreSQL providers.

Postgres is an open-source relational database created by Mike Stonebraker and subsequently maintained and enhanced by a volunteer community and companies. It is presented as a widely used database whose open ownership contributed to its adoption and continued development.