Open Ried Sens – Monthly public three-table snapshot (format 2)

entities.csv: objects; id is the key.
measurement_definitions.csv: measurement definitions; entity_id references entities.id.
readings.csv: readings; measurement_id references measurement_definitions.id.
Each ZIP part contains exactly the entities and definitions referenced by its readings.
Metadata can occur in multiple parts; merge it by id. Download ALL parts for a full month.
UTF-8 BOM CSV, comma delimiter, UTC timestamps with microseconds, exact numeric values.
metadata, dimensions and provenance are JSON. Empty cells are missing values, not zeros.
basis distinguishes observations, reports, models, schedules and unknown legacy data.
Legacy telemetry is transferred without inventing its basis or source certainty.
Duplicate legacy keys with identical values are represented by one canonical reading.
Entity metadata reflects export time, not a historical version sequence.
Current-month snapshots are incomplete. Late arrivals require a refreshed snapshot.
Sources and licensing: see source_id and https://open-ried-sens.vercel.app/quellen.
Text starting with spreadsheet formula characters is protected by an apostrophe.
manifest.json contains the UTC period, snapshot, part and table counts.
