Skip to main content
SimilarExport ZIP
100%

Get area stats for parcelles and batiments for each parcelle

✓ Published0🌍 Public
TThomasG77
Last edited Oct 20, 2025
Created on Oct 20, 2025

This example maps French cadastral data for the commune 91114, calculating the built surface area of buildings (batiments) on each land parcel (parcelle). It uses DuckDB’s spatial SQL functions—`ST_intersects`, `ST_intersection`, and `ST_Area`—to query a remote GeoParquet file from data.gouv.fr, then aggregates results with a `LEFT JOIN` to include parcels without buildings. The final query outputs a CSV of per-parcelle statistics, including total building footprint and parcel geometry attributes.

AI-generated description

Similar vizzes

Loading thumbnail…

Export DVF geolocalisées en Geoparquet

This example converts French land-registry transaction data (DVF) from compressed CSV files into a single spatially-indexed GeoParquet file. It downloads yearly datasets from data.gouv.fr, loads them into a DuckDB database, and creates a point geometry for each transaction before exporting with a Hilbert-curve spatial ordering. The script leverages DuckDB’s spatial extension, the `ST_Point` and `ST_Hilbert` functions, and parquet compression via zstd.

TThomasG77
70% match
Loading thumbnail…

Query remote Geoparquet in browser

This example demonstrates querying a remote GeoParquet file directly from a web browser using DuckDB-Wasm. The interactive map displays French priority neighborhoods (QPVs) and identifies which one contains a specific geographic point (2.389798, 48.909514). It uses DuckDB-Wasm’s SQL engine with the spatial extension to run an `ST_contains` query, filtering results by geometric intersection. The workflow converts the matched polygons to GeoJSON via the GDAL driver and exports them as a downloadable file. The dataset was prepared from a government GeoJSON source using DuckDB and gpio utilities.

TThomasG77
69% match
Loading thumbnail…

Exemples de consommation de DVF via parquet et Duckdb

This example demonstrates how to extract and filter French property transaction data (DVF) from a cloud-hosted Parquet file using DuckDB's SQL engine, then export the filtered results as GeoJSON for specific geographic areas. It shows three distinct query scopes: a single commune (Nantes), a multi-commune agglomeration, and a department-level export. The workflow relies on DuckDB's `INSTALL spatial` and `LOAD spatial` extensions, which enable reading the Parquet file directly from the `data.gouv.fr` URL. The `COPY` command with `FORMAT gdal` and `DRIVER 'GeoJSON'` handles the conversion, while explicit type casting (e.g., `::DOUBLE`) ensures correct numeric fields like `valeur_fonciere` and coordinates (longitude/latitude), and preserves the geometry column for spatial output.

TThomasG77
69% match
Loading thumbnail…

Lien Adresse et parcelles

This example shows the relationship between French addresses and land parcels, producing flat CSV files per department and for the whole country from the IGN BAN PLUS dataset. The workflow uses a bash pipeline combining Python with `xml.etree.ElementTree` to fix VRT files, GDAL’s `ogr2ogr` and `ogrinfo` for data conversion and indexing, `jq` to parse layer names, and `xsv` to concatenate departmental rows into a nationwide file. Results are gzip-compressed and organized into `france` and `departements` directories.

TThomasG77
67% match
Loading thumbnail…

Gist 8dafcac4cab52f5242b00c077430c08d

This example demonstrates how to select cadastral parcels from the IGN Cadastre API based on a drawn polygon’s extent. It shows the process of converting a GeoJSON polygon into an encoded URL parameter, then sending a GET request via Bash with `jq` or Python with `urllib.parse` and `urllib.request`. The API returns parcel geometries, which are saved as a GeoJSON file. The code also warns against using overly complex or overly large geometries due to URL length limits and server load.

TThomasG77
64% match
Loading thumbnail…

GDAL VSICURL tests to remote BDTOPO Geopackage France

This example tests GDAL’s VSICURL virtual file system by streaming a remote GeoPackage of French administrative data, specifically focusing on mairie (town hall) geometries. It demonstrates two ogr2ogr commands that query the BDTOPO dataset using SQL joins to extract mairie footprints as multipolygons and their centroids as points, converting them to GeoJSON with EPSG:4326. The visualization shows how both polygon boundaries and point locations are derived from the same remote source, highlighting the ability to perform spatial SQL operations directly on cloud-hosted vector data without local downloads.

TThomasG77
63% match
Loading thumbnail…

Code pour passer des id de parcelles Etalab en commune, prefixe, section, numero et inversement

This example demonstrates how to convert between French land parcel identifiers from the Etalab system and their constituent components: municipality code, prefix, section, and number. It shows the parsing of a composite key, such as `323190000A0133`, into its semantic parts, and the reverse operation to reconstruct the identifier. Implemented in both JavaScript and Python, the code uses basic string manipulation methods including `substring`, `replace` with a regular expression, `padStart`, and `zfill` for handling leading zeros. The JavaScript version runs directly in the console, while the Python version uses f-string formatting for output.

TThomasG77
61% match
Loading thumbnail…

Display cadastre on Maplibre

This interactive map displays the French land registry, or cadastre, within the Maplibre GL rendering engine. It shows administrative boundaries—from regions down to individual communes—along with detailed cadastral sections, parcels, and buildings. Using the WebGL-driven Maplibre GL API, it loads vector tile sources from `openmaptiles.geo.data.gouv.fr`, with parcel lines appearing at zoom level 16 and property numbers labeled for identification. The styling, defined in a JSON style sheet, uses fill and line layers with conditional opacity to highlight parcels.

TThomasG77
58% match