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
651505315674508City of Winona, MN26928Question 0.52709426928YesNANANA19.5645154541.72316PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
652549026374531Santa Fe County150056Question 0.58409984099NANANANA19.5645154541.72316Reported population is 78% greater than expectedNo inventory reportedNo inventory reported
653NA74534Erie County, NY921794Question 4.5NA921794YesNANANA19.5645154541.72316missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
65429267274558Summit County, UT41106Question 0.5543733543733YesNANANA19.5645154541.72316Reported population is 92% less than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
655NA74563Town of Guilford, VT2121Question 0.5NA2121Not intending to undertakeNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
656NA74573Snoqualmie, WA13670Question 0.5NA13670Not intending to undertakeNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
657NA74575Dane County542400Question 0.5NA542400NANANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
65892270474631Lubumbashi5652000Question 0.513737701373770In progressNANANANANAReported population is 311% greater than expectedNo inventory reportedNo inventory reported
65968129074677City of Cluj-Napoca309338Question 0.5316748309338Intending to undertake in the next 2 yearsNANANA5.99681211534.85862PassNo inventory reportedNo inventory reported
66067769774678City of Galati303000Question 0.5294087303000Intending to undertake in the next 2 yearsNANANA5.99681211534.85862PassNo inventory reportedNo inventory reported
66167581074680City of IasiNANA318012318012In progressNANANA5.99681211534.85862missing reported population dataNo inventory reportedNo inventory reported
662NA826167Ayuntamiento de Tapalpa19506Question 0.5NA19506Intending to undertake in the next 2 yearsNANANA6.0050910385.29785missing external population dataNo inventory reportedNo inventory reported
6633816721826182Ayuntamiento de Tonalá477117Question 0.53532235322Intending to undertake in the next 2 yearsNANANA6.0050910385.29785Reported population is 1251% greater than expectedNo inventory reportedNo inventory reported
664NA826208Junta Intermunicipal de Medio Ambiente de Sierra Occidental y Costa (JISOC)344325Question 0.5NA344325NANANANA6.0050910385.29785missing external population dataNo inventory reportedNo inventory reported
6654014553826209Aipromades Lago de Chapala601263Question 0.52159621596In progressNANANA6.0050910385.29785Reported population is 2684% greater than expectedNo inventory reportedNo inventory reported
666NA826210Junta Intermunicipal de Medio Ambiente de la Costa Sur (JICOSUR)147918Question 0.5NA147918Intending to undertake in the next 2 yearsNANANA6.0050910385.29785missing external population dataNo inventory reportedNo inventory reported
667NA826212Junta intermunicipal para la gestión integral de la cuenca del Río Coahuayana (JIRCO)285774Question 0.5NA285774Not intending to undertakeNANANA6.0050910385.29785missing external population dataNo inventory reportedNo inventory reported
6683446194826236Prefeitura de Tremembé40984Question 0.53171940984Not intending to undertakeNANANA5.5882211026.24216PassNo inventory reportedNo inventory reported
669NA826239Alcaldia de Sopó27932Question 0.5NA27932In progressNANANA3.3290427698.412245missing external population dataNo inventory reportedNo inventory reported
670NA826380Junta Intermunicipal de la Cuenca Baja del Rio Ayuquila (JIRA)144000Question 0.5NA144000Not intending to undertakeNANANA6.0050910385.29785missing external population dataNo inventory reportedNo inventory reported
6712262912826396Munícipio de Sintra383946Question 4.52619326193YesNANANA6.34129423737.65833Reported population is 1366% greater than expectedInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
672NA826407Munícipio de Mirandela11852Question 0.5NA11852NANANANA6.34129423737.65833missing external population dataNo inventory reportedNo inventory reported
6732739590826429Município de Figueira da Foz62125Question 0.54660062125NANANANA6.34129423737.65833PassNo inventory reportedNo inventory reported
674NA831152Municipio de San Pedro de Urabá37255Question 0.5NA37255Intending to undertake in the next 2 yearsNANANA3.3290427698.412245missing external population dataNo inventory reportedNo inventory reported
6751469706831230Municipality of La Marsa92787Question 0.51509815098In progressNANANA3.3495854402.0237Reported population is 515% greater than expectedNo inventory reportedNo inventory reported
676NA831433Comuna de Ataliva2500Question 0.5NA2500NANANANA8.51995310040.13074missing external population dataNo inventory reportedNo inventory reported
6772363534831616Commune de Tsévié59000Question 0.55577559000YesNANANA1.004837672.4947925PassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
6782290956831617Commune de Bouaké715435Question 0.5567481715435YesNANANANANAPassInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
679NA831618Yaoundé 4792546Question 0.5NA792546In progressNANANA1.7252731497.783485missing external population dataNo inventory reportedNo inventory reported
680NA831620Yaoundé 3476016Question 0.5NA476016In progressNANANA1.7252731497.783485missing external population dataNo inventory reportedNo inventory reported
681NA831823Comune di Massa Marittima8303Question 0.5NA8303Not intending to undertakeNANANA7.71511335391.70548missing external population dataNo inventory reportedNo inventory reported
682NA831926Ramallah66000Question 0.5NA66000Not intending to undertakeNANANA10.43372NAmissing external population dataNo inventory reportedNo inventory reported
683NA832078Município de Mafra81961Question 0.5NA81961Intending to undertake in the next 2 yearsNANANA6.34129423737.65833missing external population dataNo inventory reportedNo inventory reported
6842267226832097Município de Lagos30442Question 0.51883118831Intending to undertake in the next 2 yearsNANANA6.34129423737.65833Reported population is 62% greater than expectedNo inventory reportedNo inventory reported
685NA832274Município de Odemira26066Question 0.5NA26066NANANANA6.34129423737.65833missing external population dataNo inventory reportedNo inventory reported
686NA832610Orange County, NC142830Question 0.5NA142830In progressNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
687NA834120City of Tanjungpinang207057Question 0.5NA207057Intending to undertake in the next 2 yearsNANANA3.3079714284.652535missing external population dataNo inventory reportedNo inventory reported
688NA834153Jasin Municipal Council141000Question 0.5NA141000Intending to undertake in the next 2 yearsNANANA9.39333912109.48855missing external population dataNo inventory reportedNo inventory reported
689NA834202Mogale City Local Municipality383864Question 0.5NA383864Not intending to undertakeNANANA9.1451487432.868382missing external population dataNo inventory reportedNo inventory reported
690NA834261Municipality of Irapuato529440Question 0.5NA529440YesNANANA6.0050910385.29785missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
691NA834300Municipality of Villanueva1200000Question 0.5NA1200000Intending to undertake in the next 2 yearsNANANA1.6618533160.005492missing external population dataNo inventory reportedNo inventory reported
692NA834370Town of Secaucus, NJ18000Question 0.5NA18000In progressNANANA19.5645154541.72316missing external population dataNo inventory reportedNo inventory reported
693NA834374Tagum City259444Question 4.5NA259444YesNANANA1.7510893021.986863missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
694NA834406Municipality of San Pedro Tlaquepaque608114Question 4.5NA608114YesNANANA6.0050910385.29785missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
695NA834413Municipality of Tahuamanu2500Question 0.5NA2500Intending to undertake in the next 2 yearsNANANA2.6446656453.922634missing external population dataNo inventory reportedNo inventory reported
696NA839648Ayuntamiento Victoria19820Question 0.5NA19820Not intending to undertakeNANANA6.0050910385.29785missing external population dataNo inventory reportedNo inventory reported
697NA839650Ayuntamiento de Uriangato1241Question 0.5NA1241Intending to undertake in the next 2 yearsNANANA6.0050910385.29785missing external population dataNo inventory reportedNo inventory reported
698NA839667Municipio de Guanagazapa13000Question 4.5NA13000YesNANANA1.6618533160.005492missing external population dataInventory reported, but total emissions value not providedInventory reported, but total emissions value not provided
699NA839670Municipio de Santa Catarina Pinula97000Question 0.5NA97000Intending to undertake in the next 2 yearsNANANA1.6618533160.005492missing external population dataNo inventory reportedNo inventory reported
700NA839673Municipalidad Distrital de Jesús María77955Question 0.5NA77955In progressNANANA2.6446656453.922634missing 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