sdg-data / sdgs Goto Github PK

related to #32. The hard copy of the files should be saved as a reference, in case the link does not work in the future.

Add new fields (data source, indicator id, priority) and consolidate/remove/rename some others to reflect new proposals from UNSTAT mentioned in #27

Specifically,

• "targets": "1.1" -> "targets" : {"primary-target": "1.1", "other-targets": "1.2, 1.3"}
• "indicator" is renamed to "title"
• + "indicator" (indicator id field)
• + "data-source" (= "source" from the UNSTAT proposal)
• - "other targets" (moved under "targets")
• - "other goals"
• + "priority" (= "priority" from the UNSTAT proposal)
• "available" now also includes "Tier" from the UNSTAT proposal (Tier I, II, III)

SAP made vizs for some of the goals at Globalgoals.org

e.g. http://www.globalgoals.org/global-goals/no-poverty/

From the documentation

{
    "title": "Example Schema",
    "type": "object",
    "properties": {
        "firstName": {
            "type": "string"
        },
        "lastName": {
            "type": "string"
        },
        "age": {
            "description": "Age in years",
            "type": "integer",
            "minimum": 0
        }
    },
    "required": ["firstName", "lastName"]
}

Depends on #3. Could use https://github.com/ruby-json-schema/json-schema

Where the index (A, B, C and I, II, IIII) is coming from, and what it means need to be explained at a footnote or somewhere on the website.

I don't know if we really need to have the tags format, available and meta on the Indicators file.

the idea was to specify if the data is "queriable" via API, or a pdf, xls file. On the cases that is API accesible, it would allows to query a particular countriy or year, which is good.

But we can ge tthat information just by looking a the url of the data field. E.g. we know this is queriable from World Bank:

"goal": 1,
      "indicator": " Proportion of population below $1.25 (PPP) per day",
      "data": {
        "url": "http://data.worldbank.org/indicator/SI.POV.DDAY",
        "format": "WB-API",
        "meta": ""
      },
      "source": "http://unsdsn.org/wp-content/uploads/2014/02/140214-SDSN-indicator-report-DRAFT-for-consultation.pdf",
      "leads": "World Bank",
      "other goals": "8",
      "available": "",
      "category": "MDG Indicator, 100"
    }

There seems to be already an official list of candidates:

pdf
xls

"made available 11 August 2015"

This is the one to be approved at the next annual meeting of the International Statistical Commission. We should integrate it.

Sources mostly Suggested SDG Indicators arranged by OWG Goals and Suggested SDG Indicators arranged by OWG Targets. From SDN

Possible scheme:

{ "indicators":[
  {
    "id" :  "1.1",
    "goal" : "1",
    "MDG" : "1",
    "title" : "Proportion of population below $1.25 (PPP) per day (MDG
Indicator)",
   "other goals" : "8",
   "data": {
       "institution" : "World Bank",
       "url" : "http://data.worldbank.org/indicator/SI.POV.DDAY" 
  },
...
]
}

E.g. Bootstrap Dashboard

(from email)
are they already there? relates to #10

General

o MDG Progress Status (http://data.worldbank.org/mdgs)
o UN MDGs Indicators (http://mdgs.un.org/unsd/mdg/Data.aspx)
o UNDP Human Development Reports (http://hdr.undp.org/en/data)

Population and Vital Statistics

o UN Stats (http://unstats.un.org/unsd/demographic/products/dyb/default.htm)

Nutrition/Agriculture

o FAO Stats (http://faostat3.fao.org/home/E)

Economic growth

o World Bank Data Bank (http://data.worldbank.org/indicator)
o Observatory of Economic Complexity (https://atlas.media.mit.edu/en/)
o UN National Accounts database (http://unstats.un.org/unsd/snaama/introduction.asp)

Finance and Aid Spending:

o OECD Development Co-operation Directorate (http://www.oecd.org/dac/)
o US ForeignAssistance.gov (http://foreignassistance.gov)

Health

o WHO Global Health Observatory (http://www.who.int/research/en/)
o DHS Surveys (http://dhsprogram.com/)

Sex/Gender Equality

o Woman Stats (http://www.womanstats.org/data.html)
o OECD Gender Data Portal (http://www.oecd.org/gender/data/)
o World Bank Gender Data Portal (http://data.worldbank.org/topic/gender)
o WEF Global Gender Gap Report (http://reports.weforum.org/global-gender-gap-report-2014/)
o UNDP Gender Equality Index (http://hdr.undp.org/en/content/table-4-gender-inequality-index) and Gender-related development index (http://hdr.undp.org/en/content/table-5-gender-related-development-index-gdi)

Satellite/Environment:

o OpenStreetMap (https://www.openstreetmap.org/)
o Nasa Landsat (http://landsatlook.usgs.gov/)

Climate/Environment

o UN Stats country snapshots – best used as a reference to other data sets (http://unstats.un.org/unsd/ENVIRONMENT/Questionnaires/country_snapshots.htm)
o Data.gov climate (http://www.data.gov/climate/) and Ocean (http://www.data.gov/ocean/)
o OECD Green Growth indicators (http://www.oecd.org/greengrowth/greengrowthindicators.htm)
o UN Greenhouse Gas Inventory (http://unfccc.int/ghg_emissions_data/items/3800.php)
o UN Energy Statistics Database (http://unstats.un.org/unsd/energy/edbase.htm)
o UN Stats Division Environmental Indicators (http://unstats.un.org/unsd/environment/qindicators.htm)
o Threatened Species (http://www.iucnredlist.org/)
o NOAA World Oceans Database (https://www.nodc.noaa.gov/access/index.html)

Check out this website. It is powered by a bunch of pretty good APIs, including these examples:

http://mdg-sdg3d.undp.org/en/country-database/countries/ken/goals/2/indicators/429.json

Note that you can change ken in the URL to, say, ago to switch countries from Kenya to Angola. There are also a few other endpoints that are neat, including this one that tracks the number of SDGs involving each country:

http://mdg-sdg3d.undp.org/en/country-database.json?iso=ROU

Seems worth thinking about, maybe building visualizations or something.

• UNSTAT: https://sustainabledevelopment.un.org/content/documents/7981List%20of%20Indicator%20Proposals%2011-8-2015.pdf
• Suggested Indicator: as specified in UNSTAT source.
• 100: http://indicators.report/indicators/
• Otherwise it is coming from the original un-updated source: http://unsdsn.org/wp-content/uploads/2014/02/140214-SDSN-indicator-report-DRAFT-for-consultation.pdf
• MDG Indicator & Complementary National Indicator: as specified in the original unsdsn.org source.

We don't currently have that info complete. It would help assess data availability, since those are more likely to exist.

Can you take @pythagoraswitch ?

Latest proposal has Ids for Indicators. Include them.

Related to #27

• Dignity
• People
• Planet
• Partnership
• Justice

as seen in e.g. here

Sometimes sources can relate to several indicators, plus this allows to expand space to add more metadata like API link, documentation links, ...

From http://indicators.report/indicators/

Add those not there, and keyword mark them. They made a nice summary page with data links and leads to integrate too.

Basic barebones for now. To select Goals, targets or indicators and list them.

So we can have more than one page,

Some SDGs are related to MDGs, it can be useful to make that link to see which ones are not new Goals.

Can you help me, @zemogle

Sources mostly Suggested SDG Indicators arranged by OWG Goals and Suggested SDG Indicators arranged by OWG Targets. From SDN

Format:

{ "tarjets":[
  {
    "id" :  "1.1",
    "goal" : "1",
    "title" : "by 2030, eradicate extreme poverty for all
people everywhere, currently measured as people
living on less than $1.25 a day"
  },
...
]
}