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
501346562454667Prefeitura Municipal de Contagem603442Question 0.5627123603442Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
502345277954678Prefeitura Municipal de Porto Feliz48893Question 0.54101548893NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
503347185954681Prefeitura Municipal de Araçatuba195874Question 0.5170024195874In progressNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
504346296454683Prefeitura Municipal de Franco da Rocha131Question 0.5108858108858Not intending to undertakeNANANA5.5882211026.24216Reported population is 100% less than expectedNo inventory reportedNo inventory reported
505344765154692Prefeitura Municipal de Sertãozinho121412Question 0.599211121412NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
506346642954697Prefeitura Municipal de Cerquilho39617Question 0.53536739617YesNANANA5.5882211026.24216PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
507347035354699Prefeitura Municipal de Barueri271306Question 0.5251994271306Not intending to undertakeNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
508345813154703Prefeitura Municipal de Mairiporã98374Question 0.55441554415Not intending to undertakeNANANA5.5882211026.24216Reported population is 81% greater than expectedNo inventory reportedNo inventory reported
509366498054706Prefeitura Municipal de Boa Vista576568Question 0.5235150235150Intending to undertake in the next 2 yearsNANANA5.5882211026.24216Reported population is 145% greater than expectedNo inventory reportedNo inventory reported
510346996854709Prefeitura de Blumenau309011Question 0.5293949309011In progressNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
511NA55325Município de Águeda47729Question 0.5NA47729YesNANANA6.34129423737.65833missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
512273870755331Município de Ílhavo38598Question 0.51723617236YesNANANA6.34129423737.65833Reported population is 124% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
513NA55371Municipalidad de Vicente López270929Question 0.5NA270929Intending to undertake in the next 2 yearsNANANA8.51995310040.13074missing external population dataNo inventory reportedNo inventory reported
514346746755372Prefeitura Municipal de Canoas341343Question 0.5328291341343Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
515346859255373Prefeitura Municipal de Cabreúva47877Question 0.53873847877NANANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
516346505955380Prefeitura Municipal de Cubatão118720Question 0.5118410118720Intending to undertake in the next 2 yearsNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
517416460155419City of Miramar134037Question 0.5137132134037YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
518489901257616City of Lake Forest, IL20601Question 4.51940820601YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
519264019458346Plymouth City Council260000Question 4.5260203260000YesNANANA8.71670242986.03288PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
520540807658357City of West Hollywood34399Question 0.53622234399In progressNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
521425546658413City of Carmel, IN93510Question 0.58871393510In progressNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
522309943458424Gdansk464254Question 0.5461865464254YesNANANA10.4897516639.72798PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
523319304458569City of Podgorica185937Question 0.5136473185937Intending to undertake in the next 2 yearsNANANANA8226.598844PassNo inventory reportedNo inventory reported
524518814058590City of Easton, PA26915Question 0.52691526915YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
525435684758591City of Greenbelt, MD23000Question 4.52427223000YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
526NA58595Municipalidad de Belén24000000Question 0.5NA24000000YesNANANA2.7743469892.64112missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
527NA58609City of Ærøskøbing6180Question 0.5NA6180YesNANANA10.1600862888.72719missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
528526824958626City of Racine, WI78860Question 0.57774278860Intending to undertake in the next 2 yearsNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
529423267958627City of Alton, IL26581Question 0.52700326581YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
530227489558670City of Monrovia1197684Question 0.59395241197684Intending to undertake in the next 2 yearsNANANA0.701483541.2713241PassNo inventory reportedNo inventory reported
531NA58783Commune de Bakata39308Question 0.5NA39308Not intending to undertakeNANANA1.501416709.7551881missing external population dataNo inventory reportedNo inventory reported
532NA58796Odder Kommune22624Question 0.5NA22624Not intending to undertakeNANANA10.1600862888.72719missing external population dataNo inventory reportedNo inventory reported
533495006558871City of Salem, MA43146Question 0.54286943146Intending to undertake in the next 2 yearsNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
534443798259124City of Natchez, MS15500Question 0.51512815500Not intending to undertakeNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
535318387559163City of Tirana780531Question 0.5374801374801YesNANANA2.6416835075.354985Reported population is 108% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
536NA59166Municipalidad de Independencia100281Question 0.5NA100281Intending to undertake in the next 2 yearsNANANA6.32608815130.15432missing external population dataNo inventory reportedNo inventory reported
537NA59167Municipalidad de Providencia142079Question 0.5NA142079Intending to undertake in the next 2 yearsNANANA6.32608815130.15432missing external population dataNo inventory reportedNo inventory reported
538NA59168Commune de Dioudoubou7050Question 0.5NA7050Not intending to undertakeNANANA1.422721546.520159missing external population dataNo inventory reportedNo inventory reported
539NA59180Middelfart Kommune38211Question 0.5NA38211YesNANANA10.1600862888.72719missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
540NA59298City of Yaoundé 6324734Question 0.5NA324734Not intending to undertakeNANANA1.7252731497.783485missing external population dataNo inventory reportedNo inventory reported
541NA59535Town of Vail, CO5450Question 0.5NA5450Intending to undertake in the next 2 yearsNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
542468590759537City of Denton, TX138541Question 4.5131044138541YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
543534170459552City of Davis, CA68111Question 0.56766668111YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
544437089059563City of Takoma Park, MD17000Question 4.51771317000YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
545NA59595City of Brisbane, CA4603Question 0.5NA4603YesNANANA19.5645154541.72316missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
546539305259633City of Santa Cruz, CA65021Question 0.56422065021In progressNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
547534111459644City of Culver City, CA39860Question 0.53971739860In progressNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
548571337659657City of Beaverton, OR97514Question 0.59657797514YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
549NA59681Town of East Hampton, NY21457Question 0.5NA21457Intending to undertake in the next 2 yearsNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
550416142259697City of Lake Worth, FL36000Question 0.53749836000Intending to undertake in the next 2 yearsNANANA19.5645154541.72316PassNo 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