GSA / sdg-indicators-usa

U.S. National Reporting Platform for the Sustainable Development Goals
https://sdg.data.gov
Other
31 stars 92 forks source link

Subnational Reporting Comments #588

Open JenPark9 opened 6 years ago

JenPark9 commented 6 years ago

Notes and feedback on subnational reporting concept.

JenPark9 commented 6 years ago

Hi Jennifer,

Sorry for the delay. While I'm not an expert on the statistical data side, I made an attempt at what I thought might be possible for subnational statistics. I highlighted those in yellow from your list, which is a good place to start given that they are Tier 1. While it's highly probable that most countries (or only a few) currently have the capacity and/or capability in producing subnational data, examples of countries that do offer lower level geographic data can serve as a model of best practice and indicate the interest in subnational data from different sectors within a country.

Some indicators may have regional data, either consistently across a country, or selectively for areas of interest. Examples of indicators that fall into this category may include (2.2.1, )

Indicators like (2.1.2, ) likely collect data at higher levels of reporting, which may make disaggregating the data more challenging and, in some cases, impossible.

Indicators like 3.6.1 make the most sense at collecting at subnational level so the preventive measures can be taken. In the U.S., this information is reported by the States for lower level governments. In searching, NIH has a paper on "Variations in sub-national road traffic fatality trends in a low-income country" where Pakistan is the case study.

On 4.b.1 on scholarship, it notifications are sent by mail, a match to the postal code or village name could be done to have a more localized view of the results. Similarly, 4.c.1 has similar characteristics if training records exist.

5.b.1 - Mobile phone ownership could be linked to a billing address (web payments make this more difficult if a mailing address is not required). Disaggregating gender mobile phone ownership is more problematic but could possibly be harvested from social media data inputs.

For 6.1.1 - I would hope that subnational governments would know and promote their improved water circumstances. UNICEF and WHO report some large regional values in part of Africa in one of their recent 2017 reports.

7.1.1 should also have the potential to link location based on billing address for electricity services.

8.5.2 on unemployment rate must have local values for some of the data collected. The World Bank ILO shows country comparisons; Disaggregation may provide further details.

Other possible indicators associated with billing addresses or similar linkages include: 8.10.1 (There may be GPS locations for ATMs), 8.10.2, 17.6.2

11.1.1 on proportion of slum inhabitants is under work by several external groups. The results should be monitored and studied.

15.1.1 on forested land can be calculated with imagery use compared to subnational boundaries.

This is a very quick effort to provide a little input. I hope this is helpful.

Tim Trainor Chief Geospatial Scientist U.S. Census Bureau 4600 Silver Hill Road, Mail Stop 7400 Washington, D.C. 20233 301-763-9161


From: Park, Jennifer E. EOP/OMB Jennifer_E_Park@omb.eop.gov Sent: Thursday, June 8, 2017 3:30 PM To: Timothy F Trainor (CENSUS/ADDC FED) Subject: SDG global indicators for which subnational estimates may be possible

Tim, I know you are preparing for GGIM. I'm hoping you can help me with an initial list of global indicators for which subnational estimates may be available. If it may be of assistance to you, I have selected among tier 1 indicators for which we have reported the national statistic. Of course, this means I am missing several other indicators that might fit our interest, but I am hoping to get your early read so that our discussions with cities (30 at the moment) may continue to progress, even with crude sketches of possibilities. Sincerely, Jennifer

1.2.1 Proportion of population living below the national poverty line, by sex and age 2.1.2 Prevalence of moderate or severe food insecurity in the population, based on the Food Insecurity Experience Scale (FIES) 2.2.1 Prevalence of stunting (height for age <-2 standard deviation from the median of the World Health Organization (WHO) Child Growth Standards) among children under 5 years of age 2.2.2 Prevalence of malnutrition (weight for height >+2 or <-2 standard deviation from the median of the WHO Child Growth Standards) among children under 5 years of age, by type (wasting and overweight) 3.1.2 Proportion of births attended by skilled health personnel 3.2.1 Under-five mortality rate 3.2.2 Neonatal mortality rate 3.3.2 Tuberculosis incidence per 1,000 population 3.5.2 Harmful use of alcohol, defined according to the national context as alcohol per capita consumption (aged 15 years and older) within a calendar year in litres of pure alcohol 3.6.1 Death rate due to road traffic injuries 3.7.1 Proportion of women of reproductive age (aged 15-49 years) who have their need for family planning satisfied with modern methods 3.a.1 Age-standardized prevalence of current tobacco use among persons aged 15 years and older 3.c.1 Health worker density and distribution 4.2.2 Participation rate in organized learning (one year before the official primary entry age), by sex 4.b.1 Volume of official development assistance flows for scholarships by sector and type of study 4.c.1 Proportion of teachers in: (a) pre-primary; (b) primary; (c) lower secondary; and (d) upper secondary education who have received at least the minimum organized teacher training (e.g. pedagogical training) pre-service or in-service required for teaching at the relevant level in a given country 5.5.2 Proportion of women in managerial positions 5.b.1 Proportion of individuals who own a mobile telephone, by sex 6.1.1 Proportion of population using safely managed drinking water services 7.1.1 Proportion of population with access to electricity 7.2.1 Renewable energy share in the total final energy consumption 7.3.1 Energy intensity measured in terms of primary energy and GDP 8.1.1 Annual growth rate of real GDP per capita 8.2.1 Annual growth rate of real GDP per employed person 8.5.2 Unemployment rate, by sex, age and persons with disabilities 8.6.1 Proportion of youth (aged 15-24 years) not in education, employment or training 8.8.1 Frequency rates of fatal and non-fatal occupational injuries, by sex and migrant status 8.10.1 Number of commercial bank branches and automated teller machines (ATMs) per 100,000 adults 8.10.2 Proportion of adults (15 years and older) with an account at a bank or other financial institution or with a mobile-money-service provider 8.a.1 Aid for Trade commitments and disbursements 9.1.2 Passenger and freight volumes, by mode of transport 9.2.1 Manufacturing value added as a proportion of GDP and per capita 9.2.2 Manufacturing employment as a proportion of total employment 9.4.1 CO2 emission per unit of value added 9.5.1 Research and development expenditure as a proportion of GDP 10.1.1 Growth rates of household expenditure or income per capita among the bottom 40 per cent of the population and the total population 10.4.1 Labour share of GDP, comprising wages and social protection transfers 11.1.1 Proportion of urban population living in slums, informal settlements or inadequate housing 11.6.2 Annual mean levels of fine particulate matter (e.g. PM2.5 and PM10) in cities (population weighted) 14.4.1 Proportion of fish stocks within biologically sustainable levels 14.5.1 Coverage of protected areas in relation to marine areas 15.1.1 Forest area as a proportion of total land area 16.1.1 Number of victims of intentional homicide per 100,000 population, by sex and age 16.3.2 Unsentenced detainees as a proportion of overall prison population 16.9.1 Proportion of children under 5 years of age whose births have been registered with a civil authority, by age 17.1.1 Total government revenue as a proportion of GDP, by source 17.3.2 Volume of remittances (in United States dollars) as a proportion of total GDP 17.6.2 Fixed Internet broadband subscriptions per 100 inhabitants, by speed 17.8.1 Proportion of individuals using the Internet

JenPark9 commented 6 years ago

Jenn, Sorry for the delay, but here are some comments from me on the whiteboarding doc. Have you had a chance to look at the Indicator Mapping spreadsheet? Thanks, Derek On Wed, Jun 7, 2017 at 2:43 PM Park, Jennifer E. EOP/OMB Jennifer_E_Park@omb.eop.gov wrote: Thank you, Derek! Will review carefully. -----Original Message----- From: Derek Ouyang [mailto:douyang1@stanford.edu] Sent: Wednesday, June 7, 2017 5:42 PM To: Park, Jennifer E. EOP/OMB Jennifer_E_Park@omb.eop.gov Cc: Lawrence I. Sperling SperlingLI@state.gov; SteersCM@state.gov; Dan Sakaguchi dsakaguc@stanford.edu; Tyler Pullen tpullen28@gmail.com; Sandra Ruckstuhl sandra.ruckstuhl@unsdsn.org; Melika Edquist melika.edquist@unsdsn.org Subject: Re: Follow up on San Jose and SDGs Jennifer, Please see the following link for our draft Indicator Mapping to the NRP, compiled by my students Dan Sakaguchi and Tyler Pullen:

https://docs.google.com/spreadsheets/d/1erGEmqvuHZhBfcK4kXcb_5B_TQTGNyC65rYHbtB4Qb0/edit#gid=1709235139

I can provide an Excel version as well, if you can't access.

Thoughts on whiteboarding document coming shortly!

Best, Derek

On Thu, Jun 1, 2017 at 10:34 AM Park, Jennifer E. EOP/OMB <Jennifer_E_Park@omb.eop.gov mailto:Jennifer_E_Park@omb.eop.gov > wrote: Derek, Very nice to speak with you today re next steps with the SDGs. Below are the organizing questions which frame my thinking for collaboration. Attached is the whiteboarding document for your feedback. Looking forward to receiving your local indicator list (even if in draft) and your initial feedback next week. Best, Jennifer

  1. Can we provide an interface through the USG National Reporting Platform https://gsa.github.io/sdg-indicators/status/ by which official USG subnational estimates for global SDG indicators can be displayed, where available? To what extent could we leverage Census Data Mapper https://www.census.gov/geo/maps-data/maps/datamapper.html and or other Census interactive mapping tools https://www.census.gov/geography/interactive-maps.html ? (We understand such estimates would only be available for a small subset of global indicators, and would not likely be available at very low levels of geography.)
  2. Can we provide a means for cities and other localities to plot/link their SDG local indicators and local estimates? (USG would not curate those indicators or estimates.) The National Neighborhood Indicators Partnership http://www.neighborhoodindicators.org/partners/profiles comprises 30 US localities (some counties, some cities) that have acquired statistics regarding their localities for indicators of their interest. The NNIP may be interested in mapping their indicators with the global SDG goals, targets, and indicators, and re-branding their indicators as SDG local indicators.
  3. Can we use this interface to identify common local indicators of interest and data gaps for which USG may be able to provide data/statistics? (A NNIP 2007 report indicated that utility data were in demand.) One reason why connecting subnational, locally driven indicators with the national reporting process for global indicators is that this allows us to better understand indicators that may be most useful to localities and to identify data sources that may be most helpful to them. Our relationship with these localities would be on the level of communication; we would not "own," curate, or manage local sites, their indicators or their statistics.
JenPark9 commented 6 years ago

San Jose comments on US zero draft white boarding: https://community.max.gov/x/doI4NQ

JenPark9 commented 6 years ago

BLS state level data on unemployment, employment etc. The short answer is we have relevant data for states at >https://www.bls.gov/lau/ex14tables.htm< (whether it’s gender, age, or gender and age being sought), and they may want to rethink the URL for the U.S. data.”

angela-smithers commented 6 years ago

adding mockup images here for brainstorming ...

draft-subnational-01 draft-subnational-03 draft-subnational-04 draft-subnational-05 draft-subnational-06 The following is an appended version of the current splash page: draft-subnational-02

angela-smithers commented 6 years ago

Because I missed the last 2 meetings, I may be missing some requirements for the layout. Will the portal point to a forked repo for each individual city or each state?

angela-smithers commented 6 years ago

The old version: artboard 1-80

JenPark9 commented 6 years ago

Angela, Wow! This is really coming along. I am thinking we would remove the table of states by local reporting platform (LRP) status and the title "National SDG Statistics. Then, on the selected state page which could show locality statiistics, instead of cities, we would probably need to show statistics by county and then provide links to cities/localities that have LRPs.. We probably can't provide Federal statistics at the city level. Rock on!