Lien Adresse et parcelles

100%

Lien Adresse et parcelles

✓ Published0🌍 Public

Last edited Sep 14, 2023

Created on Sep 13, 2023

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.

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

67% match

Loading thumbnail…

Get area stats for parcelles and batiments for each parcelle

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.

TThomasG77

67% match

Loading thumbnail…

Gist 349fc7fda8932252cbcb4ee8a0b605c8

This example tracks the availability and licensing of the French IGN’s BD TOPO® departmental datasets by organizing URLs for both December 2021 and March 2021 releases. It shows a structured index of geographic data files, with each entry linking to a specific departmental Shapefile resource. The visualization uses a data-driven list format, likely rendered with JavaScript’s `fetch` to parse the provided CSV or JSON and display the sorted URLs. It highlights the variation in resource IDs across departments and time periods, emphasizing the dataset’s scope without mapping or spatial rendering.

TThomasG77

66% 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

64% match

Loading thumbnail…

Gist d64af23db4c1bd6bbacbe72ef137865e

This visualization shows the extraction and tabularization of French Business Tax Service (SIE) locations. It first filters the full public service dataset, downloaded as a JSON tarball via `wget`, using `jq` to select only SIE entries. It then validates the filtered results against the official website's paginated listing, scraped with `pup`. Finally, the code converts the filtered JSON into a simple CSV file using `jq` to output fields like id, name, and postal address, working within the Linux command-line environment.

TThomasG77

63% match

Loading thumbnail…

Gist edaa46d0ee945829befb88a9e719f0e0

This visualization maps the number of certified organic food operators across French administrative departments, using a choropleth-style representation to reveal regional disparities in organic agriculture density. The data is sourced from the Agence Bio public API, which is queried via a shell script that iterates through department codes. The script uses `curl` and `jq` to extract the `nbTotal` count for each department, storing results in a semicolon-delimited text file. The final map likely employs `d3.geoPath` for rendering the department boundaries, with color intensity or a similar visual encoding driven by the fetched counts.

TThomasG77

62% match

Loading thumbnail…

Copie données WFS depuis le géoportail de l'urbanisme

This example automates the bulk download of France’s urban planning WFS data from the Géoportail de l’Urbanisme, specifically extracting the GPKG files. It shows how to list available remote directories via `lftp` over SFTP, identify the latest dated export, and mirror the chosen folder with parallel transfers. The workflow uses shell commands with `timeout`, `ssh`, and `lftp` to handle authentication and file retrieval. It relies on public credentials and a documented PDF manual, making the process reproducible for users needing recent, structured land-use datasets.

TThomasG77

62% 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

61% match