🚀 v0.2.0
This update adds new table structures and seed data to the SQL database schema. It also updates the README to clarify the purpose of the repository and some of the design philosophy behind it.
✨ Features
- Updated implementation of core database schema in PostgreSQL
- Split SQL scripts into logically ordered scripts, beginning with schema creation, then seed data population, then querying examples.
- Updated README to start to document the design philosophy.
🐛 Known Issues
- Expect the schemas, integration naming conventions to change in ways big and small.
- The metadata taxonomies and schema are indicative and internally consistent within this repository but are not 100% aligned with the other OSC Physical Risk and Resilience repositories. Those include python classes, json files, and CSV import and configuration files. Do not expect the naming conventions, logical structure, code, data, metadata, or samples found within this repository to accurately reflect those (yet)!
📦 Installation
Manual installation is required by uploading or importing the scripts and samples into a working instance of a PostgreSQL database (for the SQL files); an OpenMetadata instance (if running that); and/or a python environment running Frictionless Data packages or tools.
Clone the repository
git clone https://github.com/os-climate/osc-physrisk-metadata.git
Checkout this release
git checkout v0.2.0