Go back to the interactive dataset

2019 City Emissions Data Quality Checks

Row numbergeoidaccount_idorg_namerep.populationrep.population.sourcegeo.populationeffective.populationhas.inventoryinventory.typeeffective.s1.s2.sumcity.emissions.per.capcountry_co2e_per_capita_2012country.GDP.pc.2018flag.populationflag.emissions.check1.statistical.outliersflag.emissions.check2.per.capita.country
451227107150679Município de Barreiro78764Question 0.55128051280YesNANANA6.34129423737.65833Reported population is 54% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
452226959450680Município de Cascais208122Question 0.53643636436YesNANANA6.34129423737.65833Reported population is 471% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
453226782750681Município de Funchal111892Question 0.5100847111892In progressNANANA6.34129423737.65833PassNo inventory reportedNo inventory reported
454299345850792Ville de Monaco38300Question 4.53296538300YesNANANANANAPassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
455359813251079Guatemala City992541Question 0.5994938992541In progressNANANA1.6618533160.005492PassNo inventory reportedNo inventory reported
456366257451374Prefeitura de Rio Branco401155Question 0.5257642257642In progressNANANA5.5882211026.24216Reported population is 56% greater than expectedNo inventory reportedNo inventory reported
457449961252894City of Winston-Salem246328Question 0.5241218246328Not intending to undertakeNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
458599250053829City of Kingston, ON124000Question 0.5114195124000YesNANANA20.56251357.75398PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
459449937953860City of Wilmington, NC119045Question 0.5115933119045Intending to undertake in the next 2 yearsNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
460531705853921City of Tempe, AZ175826Question 0.5175826175826YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
461411048653959City of Fayetteville, AR88963Question 4.58283088963YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
462411940354030City of Little Rock198600Question 0.5197992198600Intending to undertake in the next 2 yearsNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
463485382854037City of Des Moines217521Question 0.5210330217521YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
464596470054060City of Greater Sudbury / Grand Sudbury161531Question 0.5157857161531In progressNANANA20.56251357.75398PassNo inventory reportedNo inventory reported
465415892854082City of Hollywood, FL145128Question 4.5149728145128YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
466596762954084City of Guelph131794Question 0.5115760131794YesNANANA20.56251357.75398PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
467616614254098City of Thunder Bay107909Question 0.599334107909Intending to undertake in the next 2 yearsNANANA20.56251357.75398PassNo inventory reportedNo inventory reported
468510683454102City of Albany97856Question 0.59846997856YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
469446436854108City of Durham315228Question 4.5257636315228YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
470486203454111City of Iowa City76290Question 4.57422076290YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
471445306654114City of Asheville91902Question 0.58851291902Not intending to undertakeNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
472485452954116City of Dubuque58410Question 4.55879958410YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
473218623954277New Plymouth District Council83400Question 0.54916849168Intending to undertake in the next 2 yearsNANANA18.3272538000.7196Reported population is 70% greater than expectedNo inventory reportedNo inventory reported
474121452054306Medan City Government2247425Question 0.517509712247425Intending to undertake in the next 2 yearsNANANA3.3079714284.652535PassNo inventory reportedNo inventory reported
475NA54318Government of Tangerang City2139891Question 0.5NA2139891In progressNANANA3.3079714284.652535missing external population dataNo inventory reportedNo inventory reported
476162789654327Semarang City Government1729428Question 0.512880841729428In progressNANANA3.3079714284.652535PassNo inventory reportedNo inventory reported
477NA54342Jbail-Byblos Municipality40000000Question 0.5NA40000000Not intending to undertakeNANANA4.9358696249.766655missing external population dataNo inventory reportedNo inventory reported
478NA54352City of Muntinlupa504509Question 0.5NA504509In progressNANANA1.7510893021.986863missing external population dataNo inventory reportedNo inventory reported
479NA54356City of Parañaque714710Question 0.5NA714710Intending to undertake in the next 2 yearsNANANA1.7510893021.986863missing external population dataNo inventory reportedNo inventory reported
480173516154364City of Kuala Lumpur1790000Question 0.514539751790000In progressNANANA9.39333912109.48855PassNo inventory reportedNo inventory reported
481NA54367Melaka Historic City Council524353Question 0.5NA524353YesNANANA9.39333912109.48855missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
482318486254370Municipal Council of Penang748000Question 0.54146941469NANANANA9.39333912109.48855Reported population is 1704% greater than expectedNo inventory reportedNo inventory reported
483NA54457Hansestadt Rostock209000Question 0.5NA209000YesNANANA11.2962347501.81265missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
484275005354478Gemeente Nijmegen175000Question 0.5158732175000YesNANANA12.3100555041.12039PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
485251425654491Municipality of Málaga572000Question 0.5568305572000YesNANANA7.2991833146.39167PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
486314931854493Kristiansand Municipality92282Question 0.56381492282YesNANANA13.6543592121.42113PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
487251341654498Ayuntamiento de Murcia443243Question 0.5436870443243YesNANANA7.2991833146.39167PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
48860215054510Umeå municipality127119Question 0.58324983249YesNANANA7.166857232.08549Reported population is 53% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
489NA54579Sekhukhune District Municipality1076840Question 0.5NA1076840In progressNANANA9.1451487432.868382missing external population dataNo inventory reportedNo inventory reported
490NA54588West Coast District Municipality391766Question 0.5NA391766Intending to undertake in the next 2 yearsNANANA9.1451487432.868382missing external population dataNo inventory reportedNo inventory reported
491367248654617Alcaldia de Pereira472000Question 0.5440118472000Intending to undertake in the next 2 yearsNANANA3.3290427698.412245PassNo inventory reportedNo inventory reported
492347004454623Prefeitura de Betim378089Question 0.5384000378089YesNANANA5.5882211026.24216PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
493345842554633Prefeitura de Lorena88276Question 0.57650688276Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
494345857554641Prefeitura de Limeira276022Question 0.5289665276022NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
495345545954650Prefeitura de Palmas291855Question 0.53915039150YesNANANA5.5882211026.24216Reported population is 645% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
496344970154651Prefeitura de Santo André676407Question 0.5662373676407Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
497345577554652Prefeitura de Osasco676Question 0.5677856677856Not intending to undertakeNANANA5.5882211026.24216Reported population is 100% less than expectedNo inventory reportedNo inventory reported
498344890254654Prefeitura de São João da Boa Vista90089Question 0.57654090089Not intending to undertakeNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
499344501454656Prefeitura de Vinhedo77308Question 0.55649277308YesNANANA5.5882211026.24216PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
500345767154662Prefeitura do Município de Maringá417010Question 0.5311724417010Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported

About

Profile Picture Dua Zehra

created Sep 27 2019

updated Sep 27 2019

Description

This dataset combines reported emissions and population data with external datasets:
- City Population, from the Geonames database
- Country GDP per capita from the World Bank
- Country emissions per capita from EDGAR
The results from the following data quality checks are displayed:
- Population Check - Comparison between reported populations and figures from the Geonames database
- Emissions Check 1 – A multiple regression model is used to identify statistical outliers (using city population and country GDP per capita)
- Emissions Check 2 - A comparison between city per capita emissions and country per capita emissions.
Field names:
geoid - A unique identifier corresponding to the city's record in the Geonames database
account_id - The CRM organisation ID
org_name - The CRM organisation name
rep.population - The reported population
rep.population.source - The source of the reported population. The population data used is primarily from question 4.5, as this figure corresponds to the year the inventory was taken. If no population is provided in question 4.5, then question 0.5 (current population) is used instead.
geo.population - The city population provided in the Geonames database (used to verify the reported population)
effective.population - After the population check has been carried out, the 'effective population' is defined for use in the subsequent emissions checks. If a city passes the population check, their reported data is used here, otherwise external data is used (i.e. from the Geonames database)
has.inventory - This is the city's response to question 4.0 in the 2019 questionnaire, which asks the city to state whether they have an emissions inventory to report
inventory.type - If the city has an emissions inventory, this field specifies the format that this inventory is provided in
effective.s1.s2.sum - The total scope 1 + scope 2 emissions reported by the city. This is obtained from either question 4.6a or 4.6b, depending on whether the city followed the CRF, or GPC
city.emissions.per.cap - The city's effective.s1.s2.sum is divided by the effective.population to calculate the emissions per capita for that city
country_co2e_per_capita_2012 - This is country level per capita emissions data obtained from: EDGAR’s Global Greenhouse Gas Emissions from 1970 to 2012 (EDGARv4.3.2 dataset). While the data used is from 2012, this is the most recent dataset available which includes all greenhouse gases. More recent datasets are available for CO2 alone, however this is not consistent with the cities' data, which generally includes other GHGs too. Link here: https://edgar.jrc.ec.europa.eu/overview.php?v=CO2andGHG1970-2016&dst=GHGpc
country.GDP.pc.2018 - This is country level GDP per capita in 2018 in US$, obtained from the World Bank. Link here: https://data.worldbank.org/indicator/NY.GDP.PCAP.KD
flag.population - The data quality flag identifying cities whose reported population differs from the external population by +/- 50%
flag.emissions.check1.statistical.outliers - The data quality flag identifying cities whose emissions appear to be anomalously high or low, based on a statistical regression with population and country GDP
flag.emissions.check2.per.capita.country - The data quality flag identifying cities whose per capita emissions differ greatly from the country per capita emissions (a generous theshold of 10x is used, as some variation is expected)

Activity
Community Rating
Current value: 0 out of 5
Raters
0
Visits
399
Downloads
80
Comments
0
Contributors
0
Meta
Category
Emissions
Permissions
Public
Tags
2019, cities, emissions
Row Label
SODA2 Only
Yes
Licensing and Attribution
Data Provided By
(none)
Source Link
(none)
License Type
License Type
CDP Open Database License

Filter

  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;

Sort

  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;

Search

Post a Comment

Comments

  • Total Comments: 0
  • Average Rating: 0.0

Sharing

This dataset is public

Publishing

See Preview