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
601611336560603City of Prince George, BC74003Question 0.56555874003YesNANANA20.56251357.75398PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
60292796760621Lilongwe City Council989318Question 0.5646750646750Not intending to undertakeNANANA0.631618516.7540552Reported population is 53% greater than expectedNo inventory reportedNo inventory reported
60342537860633La mairie de Bujumbura1300000Question 0.5331700331700Not intending to undertakeNANANA0.636388210.7835697Reported population is 292% greater than expectedNo inventory reportedNo inventory reported
604335963860638Walvis Bay Municipality100000Question 0.55205852058Intending to undertake in the next 2 yearsNANANA4.1618696073.194376Reported population is 92% greater than expectedNo inventory reportedNo inventory reported
605NA60656City of Piedmont, CA11378Question 4.5NA11378YesNANANA19.5645154541.72316missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
606352279060898Ayuntamiento de Naucalpan de Juárez916796Question 0.5792211916796Intending to undertake in the next 2 yearsNANANA6.0050910385.29785PassNo inventory reportedNo inventory reported
607386044361467Dipolog City130759Question 0.5140850130759Intending to undertake in the next 2 yearsNANANA1.7510893021.986863PassNo inventory reportedNo inventory reported
608167419961753Yilan County Government457538Question 4.59418894188YesNANANA12.38148NAReported population is 386% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
60990711161876Mazabuka Municipal Council182205Question 0.56400664006Intending to undertake in the next 2 yearsNANANA1.3637351672.345428Reported population is 185% greater than expectedNo inventory reportedNo inventory reported
61068403962791City of Botosani106847Question 0.5114783106847NANANANA5.99681211534.85862PassNo inventory reportedNo inventory reported
611519707962864City of Lancaster, PA60000Question 0.55933960000YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
61231520262868Eskisehir Metropolitan Municipality871187Question 0.5514869514869Intending to undertake in the next 2 yearsNANANA6.44279115026.70752Reported population is 69% greater than expectedNo inventory reportedNo inventory reported
613262032063615Hillerød Kommune50104Question 0.53085330853YesNANANA10.1600862888.72719Reported population is 62% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
61428116563616Abasan Al-Kabira Municipality31000Question 0.51816318163YesNANANA10.43372NAReported population is 71% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
615571178963862City of Ashland, OR20689Question 4.52086120689YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
616513633463919City of Saratoga Springs, NY28027Question 0.52776528027Intending to undertake in the next 2 yearsNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
617NA63941Broward County, FL1870000Question 0.5NA1870000YesNANANA19.5645154541.72316missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
618NA68296Hobsons Bay City Council96470Question 0.5NA96470NANANANA26.3590356919.37428missing external population dataNo inventory reportedNo inventory reported
619164937868337Bekasi City Government2663011Question 4.515201191520119YesNANANA3.3079714284.652535Reported population is 75% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
620345440768373Prefeitura de Pedreira47321Question 0.53919847321In progressNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
621346059868383Prefeitura de Itatiba115051Question 0.56793467934YesNANANA5.5882211026.24216Reported population is 69% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
62229295368385Municipio de Chorrera161470Question 0.52471624716Intending to undertake in the next 2 yearsNANANA4.1243811723.93056Reported population is 553% greater than expectedNo inventory reportedNo inventory reported
623266268969823Visby24822Question 0.52340224822Intending to undertake in the next 2 yearsNANANA7.166857232.08549PassNo inventory reportedNo inventory reported
624NA69824Västervik36438Question 4.5NA36438YesNANANA7.166857232.08549missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
625NA69850Municipalidad de Comas543000Question 0.5NA543000YesNANANA2.6446656453.922634missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
626367073069968Alcaldia de Rionegro137078Question 0.56229162291NANANANA3.3290427698.412245Reported population is 120% greater than expectedNo inventory reportedNo inventory reported
62729107469985Sillamäe12900Question 0.5115949115949In progressNANANA18.0765719948.92283Reported population is 89% less than expectedNo inventory reportedNo inventory reported
62865328169995Kemi21256Question 4.52264121256YesNANANA14.6399648579.87129PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
62959395970005Taurage38500Question 0.52766238500Not intending to undertakeNANANA7.83117617669.65898PassNo inventory reportedNo inventory reported
630367316470017Alcaldia de Palmira294580Question 4.5247986294580YesNANANA3.3290427698.412245PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
631NA73240Tuzla Municipality235000Question 0.5NA235000NANANANA6.44279115026.70752missing external population dataNo inventory reportedNo inventory reported
632102891873252Pemba Municipality221316Question 0.5108737108737Intending to undertake in the next 2 yearsNANANA0.757499539.1833403Reported population is 104% greater than expectedNo inventory reportedNo inventory reported
633NA73293City of LaGrange, MO931Question 0.5NA931NANANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
634525895773295City of La Crosse, WI51567Question 4.55230651567YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
635432657573301City of Gretna, LA17935Question 0.51788017935Intending to undertake in the next 2 yearsNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
636NA73302City of Port Allen, LA5320Question 0.5NA5320Not intending to undertakeNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
637NA73676Umhlathuze410465Question 0.5NA410465Intending to undertake in the next 2 yearsNANANA9.1451487432.868382missing external population dataNo inventory reportedNo inventory reported
638532273773706City of Alameda75961Question 0.57863075961YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
639NA73746Probolinggo233123Question 4.5NA233123YesNANANA3.3079714284.652535missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
640NA73749Nagpur2405665Question 0.5NA2405665In progressNANANA2.5024152104.163292missing external population dataNo inventory reportedNo inventory reported
641NA73752Bontang City143683Question 4.5NA143683YesNANANA3.3079714284.652535missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
642NA73754Panaji40017Question 0.5NA40017YesNANANA2.5024152104.163292missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
643NA73759Jambi City591134Question 0.5NA591134In progressNANANA3.3079714284.652535missing external population dataNo inventory reportedNo inventory reported
644127163174386Gangtok100286Question 0.53070030700Not intending to undertakeNANANA2.5024152104.163292Reported population is 227% greater than expectedNo inventory reportedNo inventory reported
645534664674401City of Encinitas, CA60991Question 4.56293060991YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
646NA74418Town of Breckenridge, CO5035Question 0.5NA5035YesNANANA19.5645154541.72316missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
647416081274423City of Key West, FL24565Question 0.52575524565In progressNANANA19.5645154541.72316PassNo inventory reportedNo inventory reported
648NA74428City of South Miami, FL12500Question 0.5NA12500In progressNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
649NA74466Village of South Barrington, IL4565Question 0.5NA4565Not intending to undertakeNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
650493050574488City of Beverly, MA41648Question 0.54118641648Intending 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