Skip to content

lmakoti/06_World-Environment-Day

Repository files navigation

World Environment Day, 05 June 2022

un_badge cc_badge

OverviewRationale and DefinitionData SourceSolution ArchitectureNetworkingReferenceLicense

Overview

Led by the United Nations Environment Programme (UNEP) and held annually on 5 June since 1974, World Environment Day is the largest global platform for environmental public outreach and is celebrated by millions of people across the world. This year it is hosted by Sweden.

Rationale and Definition (#OnlyOneEarth)

Earth faces a triple planetary emergency:

  • the climate is heating up too quickly for people and nature to adapt;
  • habitat loss and other pressures mean an estimated 1 million species are threatened with extinction;
  • pollution continues to poison our air, land and water.

The way out of this dilemma is to transform our economies and societies to make them inclusive, fair and more connected with nature. We must shift from harming the planet to healing it.

The good news is the solutions and the technology exist and are increasingly affordable.

#OnlyOneEarth is the campaign for World Environment Day 2022. It calls for collective, transformative action on a global scale to celebrate, protect and restore our planet.

“Only One Earth” was the slogan for the first United Nations Conference on the Human Environment, held in Stockholm in 1972. This put sustainable development on the global agenda and led to the establishment of World Environment Day. Fifty years later, Sweden is hosting Stockholm+50 from 2 to 3 June, and World Environment Day on 5 June.

Source: https://www.un.org/en/observances/environment-day

Data Source

1. UNDP Human Development Reports: https://hdr.undp.org/en/data (identify relevant indicators)

http://ec2-54-174-131-205.compute-1.amazonaws.com/API/HDRO_API.php/country_code=AGO,BWA,COM,COD,SWZ,LSO,MDG,MWI,MUS,MOZ,NAM,SYC,ZAF,TZA,ZMB,ZWE/indicator_id=46006

2. World Bank Open Data: https://data.worldbank.org/ (identify relevant indicators)

  • UNDP API: https://datahelpdesk.worldbank.org/knowledgebase/articles/898581

  • Base URL: http://api.worldbank.org/v2/

    Output Format: The API supports the following four output formats.
    
    - XML format: http://api.worldbank.org/v2/country/all/indicator/SP.POP.TOTL?format=xml (paginated)
    - JSON format: http://api.worldbank.org/v2/country/all/indicator/SP.POP.TOTL?format=json (paginated)
    - JSONP format: http://api.worldbank.org/v2/country/all/indicator/SP.POP.TOTL?format=jsonP&prefix=Getdata  (invalid response)
    Note: For JSONP format, prefix parameter must be specified.
    - JSON-stat format: http://api.worldbank.org/v2/country/all/indicator/SP.POP.TOTL?format=jsonstat (usable - not paginated)
  • Parameters:

    http://api.worldbank.org/v2/country/AGO;BWA;COM;COD;SWZ;LSO;MDG;MWI;MUS;MOZ;NAM;SYC;ZAF;TZA;ZMB;ZWE/indicator/AG.LND.ARBL.ZS?format=jsonstat

Analysis Context: United Nations member countries

Solution Architecture

Focus Indicators:

UNDP

World Bank

❤️Project Pyjstat (Amazing libary simplified the data-pull tenfold)

pyjstat is a python library for JSON-stat formatted data manipulation which allows reading and writing JSON-stat [1] format with python,using the DataFrame structures provided by the widely accepted pandas library [2]. The JSON-stat format is a simple lightweight JSON format for data dissemination, currently in its 2.0 version. Pyjstat is inspired in rjstat [3], a library to read and write JSON-stat with R, by ajschumacher. Note that, like in the rjstat project, not all features are supported (i.e. not all metadata are converted). pyjstat is provided under the Apache License 2.0.

M extract from the Power Query Editor

let
    Source = Python.Execute("from pyjstat import pyjstat#(lf)#(lf)EXAMPLE_URL = 'http://api.worldbank.org/v2/country/All/indicator/AG.LND.ARBL.ZS?format=jsonstat'#(lf)#(lf)# read from json-stat#(lf)dataset = pyjstat.Dataset.read(EXAMPLE_URL)#(lf)#(lf)# write to dataframe#(lf)df = dataset.write('dataframe')#(lf)print(df)#(lf)#(lf)# read from dataframe#(lf)dataset_from_df = pyjstat.Dataset.read(df)#(lf)#(lf)# write to json-stat#(lf)print(dataset_from_df.write())"),
    df1 = Source{[Name="df"]}[Value],
    #"Replaced Value" = Table.ReplaceValue(df1,".",",",Replacer.ReplaceText,{"value"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Replaced Value",{{"value", type number}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Year", type date}}),
    #"Filtered Rows1" = Table.SelectRows(#"Changed Type1", each [Year] >= #date(2010, 1, 1))
in
    #"Filtered Rows1"

Tufte's Principles on Data Visualisation

  • The representation of numbers, as physically measured on the surface of the graphic itself, should be directly proportional to the numerical quantities measured.
  • Clear, detailed, and thorough labeling should be used to defeat graphical distortion and ambiguity. Write out explanations of the data on the graphic itself. Label important events in the data.
  • Show data variation, not design variation.
  • In time-series displays of money, deflated and standardized units of monetary measurement are nearly always better than nominal units.
  • The number of information-carrying (variable) dimensions depicted should not exceed the number of dimensions in the data.
  • Graphics must not quote data out of context.

https://images-eu.ssl-images-amazon.com/images/I/41lXBygkVwL.SX218_BO1,204,203,200_QL40_ML2.jpg

PowerBI Report

View Report: PowerBI Report Link

report_image_powerbi

Networking

Connecting and building networks is always part of our priorities, please reach out if you have any ideas on collaborative efforts or any suggestions on ways we could improve our work:

Website: https://lmakoti.codepool.tech

LinkedIn: https://www.linkedin.com/in/lehlohonolomakoti

Reference

License

This license lets others distribute, remix, adapt, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials. (https://creativecommons.org/licenses/)


About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages