Prompt file imported from vastuhlfauth/phd_model (
.github/prompts/schema.prompt.md). Fill in{{dataset}}before use. Copyright stays with the author.
Document the dataset in data/raw/{{dataset}}. Do not modify the data.
- List the files, including the content of any zip archive.
- For each table file, use DuckDB to get the schema, the row count and 20 sample rows, without loading the whole file into memory:
- CSV:
read_csv; - Parquet:
read_parquet; - GeoPackage, Shapefile or GeoJSON:
ST_Read; - OSM PBF:
ST_ReadOSM, limited to a few thousand rows.
- CSV:
- Write
docs/data/{{dataset}}.mdwith the template of docs/data/README.md:- source and vintage, files, row counts;
- for each column: name, type, unit, meaning, example;
- keys and joins with other datasets, CRS;
- quirks: missing values, special codes, encodings, separators.
- Add one line for the dataset in the index of
docs/data/README.md.
