WRI-CAIT - Test mapping with OGS data model

[S-AI-F]

Mapping rules: https://docs.google.com/spreadsheets/d/1CnTpHjZZZepgJ1o1VuQUN61ZaLLRtM1OhZzJU9HCPaY/edit#gid=0

[S-AI-F]

@CJeannesson

Goal

The goal of this issue consists of testing ogs ghg emissions data model. Outputs are:

• Filling the excel file for mapping information
• Mapping script
• mapped data in json format

Mapping information

You are invited to map the dataset you are responsible of with the proposed data model in this file: https://docs.google.com/spreadsheets/d/1CnTpHjZZZepgJ1o1VuQUN61ZaLLRtM1OhZzJU9HCPaY/edit#gid=0

Mapping script

The mapping script will be stored in ogs-data-exploration/ghg-emissions/notebooks/your data source name/mapping_datasourcename Here is a script example for ammping gcp dataset: https://github.com/OpenGeoScales/ogs-data-exploration/blob/main/notebooks/ghg-emissions/gcp/Mapping_GCP.ipynb

Mapped data

Mapped data should be stored as json files in ogs-data-exploration/ghg-emissions/data/your data source name/mapped/mapped_data_yorudatasourcename

Here is an example of gcp mapped data: https://github.com/OpenGeoScales/ogs-data-exploration/tree/main/data/ghg-emissions/gcp/mapped

[S-AI-F]

@CJeannesson Here are the links for updated data model:

• mapping file: https://docs.google.com/spreadsheets/d/1CnTpHjZZZepgJ1o1VuQUN61ZaLLRtM1OhZzJU9HCPaY/edit#gid=2038606787
• doc wiki: https://github.com/OpenGeoScales/ogs-connectors/wiki/Data-model

{
    "data_source": {
        "name": "wri-cait",
        "link": "url",
    },
    "geo_component": {
        "scale": "Country",
        "name": "france",
        "identifier": {
            "id": "FRA",
            "type": "alpha3"
        }
    },
    "date": "2011-01-01",
    "emission": {
        "gas": "co2",
        "value": 624.0,
        "unit": {
            "unit_used": "Mt co2eq"
        },
        "sector":{
            "sector_origin_name": "Total excluding LUCF",
            "sector_mapped_name": "total_excluding_LUCF"
        }
    }
}