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
551206711959969City of Mandurah85302Question 0.58329485302Intending to undertake in the next 2 yearsNANANA26.3590356919.37428PassNo inventory reportedNo inventory reported
552214397360003Baguio City345366Question 0.51630916309Intending to undertake in the next 2 yearsNANANA1.7510893021.986863Reported population is 2018% greater than expectedNo inventory reportedNo inventory reported
553127147660050Guwahati Municipal Corporation1498970Question 0.5899094899094Intending to undertake in the next 2 yearsNANANA2.5024152104.163292Reported population is 67% greater than expectedNo inventory reportedNo inventory reported
554263369160073Wolverhampton City Council262470Question 0.5252791262470Intending to undertake in the next 2 yearsNANANA8.71670242986.03288PassNo inventory reportedNo inventory reported
555309942460114City of Gdynia246309Question 0.5253730246309Intending to undertake in the next 2 yearsNANANA10.4897516639.72798PassNo inventory reportedNo inventory reported
556NA60125Klaipeda City Municipality148000Question 0.5NA148000In progressNANANA7.83117617669.65898missing external population dataNo inventory reportedNo inventory reported
55758833560126Tartu City Council95147Question 0.510109295147In progressNANANA18.0765719948.92283PassNo inventory reportedNo inventory reported
55818462260140City of Nakuru2038945Question 0.5259903259903In progressNANANA1.6834781202.133023Reported population is 685% greater than expectedNo inventory reportedNo inventory reported
55919124560142City of Kisumu968909Question 0.5216479216479Intending to undertake in the next 2 yearsNANANA1.6834781202.133023Reported population is 348% greater than expectedNo inventory reportedNo inventory reported
560NA60223Panevežys City Municipality92949Question 0.5NA92949Intending to undertake in the next 2 yearsNANANA7.83117617669.65898missing external population dataNo inventory reportedNo inventory reported
561NA60233Pärnu City Government51272Question 0.5NA51272Not intending to undertakeNANANA18.0765719948.92283missing external population dataNo inventory reportedNo inventory reported
562266740260236Municipality of Trelleborg44854Question 0.52931629316Not intending to undertakeNANANA7.166857232.08549Reported population is 53% greater than expectedNo inventory reportedNo inventory reported
563346887960258Prefeitura de Brusque128818Question 0.588284128818Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
564346913660264Prefeitura de Botucatu144000Question 0.5113862144000Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
565346178960267Prefeitura de Guarujá290752Question 0.5310424290752In progressNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
566346889460268Prefeitura de Brumadinho33973Question 0.52756333973Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
567347005260271Prefeitura de Bertioga61736Question 0.53575935759Not intending to undertakeNANANA5.5882211026.24216Reported population is 73% greater than expectedNo inventory reportedNo inventory reported
568340364260272Prefeitura de Campina Grande410332Question 0.5348936410332Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
569366446460274Prefeitura de Cruzeiro do Sul82075Question 0.57981982075NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
570347137460276Prefeitura de Assis103000Question 0.5101597103000Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
571346343260278Prefeitura de Fernandópolis68823Question 0.56193168823NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
572346769360279Prefeitura de Campos de Goytacazes483970Question 0.5387417483970NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
573347217760284Prefeitura de Angra dos Reis169511Question 0.5153635169511NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
574343366360292Prefeitura de Jahu141840Question 0.53312033120In progressNANANA5.5882211026.24216Reported population is 328% greater than expectedNo inventory reportedNo inventory reported
575345616660307Prefeitura de Nova Friburgo182082Question 0.5153361182082Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
576366276260318Prefeitura de Porto Velho428527Question 0.5306180428527YesNANANA5.5882211026.24216PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
577345232460320Prefeitura de Presidente Prudente226Question 0.5209502209502Intending to undertake in the next 2 yearsNANANA5.5882211026.24216Reported population is 100% less than expectedNo inventory reportedNo inventory reported
578NA60328Prefeitura de Pirenópolis24749Question 0.5NA24749Intending to undertake in the next 2 yearsNANANA5.5882211026.24216missing external population dataNo inventory reportedNo inventory reported
579344931960332Prefeitura de São CarlosNANA205035205035NANANANA5.5882211026.24216missing reported population dataNo inventory reportedNo inventory reported
580216153260340Prefeitura de Rio Verde229651Question 0.52270022700Not intending to undertakeNANANA5.5882211026.24216Reported population is 912% greater than expectedNo inventory reportedNo inventory reported
581344862260349Prefeitura de São Leopoldo234947Question 0.5209229234947Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
582NA60361Prefeitura de Tangará da Serra83431Question 0.5NA83431Intending to undertake in the next 2 yearsNANANA5.5882211026.24216missing external population dataNo inventory reportedNo inventory reported
583368956060369Alcaldía Municipal de Armenia301226Question 0.5315328301226YesNANANA3.3290427698.412245PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
584367662360371Alcaldía de Leticia42280Question 0.52966642280NANANANA3.3290427698.412245PassNo inventory reportedNo inventory reported
585368065660374Alcaldía de Ibagué564077Question 0.5421685564077Intending to undertake in the next 2 yearsNANANA3.3290427698.412245PassNo inventory reportedNo inventory reported
586367021860375Gobiernación del Archipiélago de San Andrés120000Question 0.55825758257Intending to undertake in the next 2 yearsNANANA3.3290427698.412245Reported population is 106% greater than expectedNo inventory reportedNo inventory reported
587366860560381Alcaldía Distrital de Santa Marta491535Question 4.5431781491535YesNANANA3.3290427698.412245PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
588366568860384Alcaldía de Yopal152655Question 0.56102961029Intending to undertake in the next 2 yearsNANANA3.3290427698.412245Reported population is 150% greater than expectedNo inventory reportedNo inventory reported
589366590060385Alcaldía de Villavicencio527673Question 0.5321717321717Not intending to undertakeNANANA3.3290427698.412245Reported population is 64% greater than expectedNo inventory reportedNo inventory reported
590366798360387Alcaldíade Sincelejo275207Question 0.5261187275207NANANANA3.3290427698.412245PassNo inventory reportedNo inventory reported
591NA60392Municipalidad de San Isidro (Lima)54206Question 0.5NA54206In progressNANANA2.6446656453.922634missing external population dataNo inventory reportedNo inventory reported
592387133660393Municipalidad de Santiago404495Question 0.548372954837295In progressNANANA6.32608815130.15432Reported population is 92% less than expectedNo inventory reportedNo inventory reported
593390332060394Gobierno Autónomo Municipal de Tarija261188Question 0.5159269159269Intending to undertake in the next 2 yearsNANANA4.5956512559.511317Reported population is 64% greater than expectedNo inventory reportedNo inventory reported
594NA60399Municipalidad de Miraflores99337Question 0.5NA99337Intending to undertake in the next 2 yearsNANANA2.6446656453.922634missing external population dataNo inventory reportedNo inventory reported
595387029460408Municipalidad de Talca220357Question 0.5197479220357Intending to undertake in the next 2 yearsNANANA6.32608815130.15432PassNo inventory reportedNo inventory reported
596NA60410Municipalidad de Peñalolén241599Question 0.5NA241599Intending to undertake in the next 2 yearsNANANA6.32608815130.15432missing external population dataNo inventory reportedNo inventory reported
597NA60416Municipalidad de San Isidro (Argentina)293Question 0.5NA293Intending to undertake in the next 2 yearsNANANA8.51995310040.13074missing external population dataNo inventory reportedNo inventory reported
598262192760577Frederikshavn Kommune60379Question 0.52410324103NANANANA10.1600862888.72719Reported population is 151% greater than expectedNo inventory reportedNo inventory reported
599334776260588City of Alba-Iulia74000Question 0.510254174000In progressNANANA5.99681211534.85862PassNo inventory reportedNo inventory reported
600NA60599Town of Bridgewater, NS8532Question 0.5NA8532Intending to undertake in the next 2 yearsNANANA20.56251357.75398missing external population dataNo 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