Go back to the interactive dataset
2019 City Emissions Data Quality Checks
| Row number | geoid | account_id | org_name | rep.population | rep.population.source | geo.population | effective.population | has.inventory | inventory.type | effective.s1.s2.sum | city.emissions.per.cap | country_co2e_per_capita_2012 | country.GDP.pc.2018 | flag.population | flag.emissions.check1.statistical.outliers | flag.emissions.check2.per.capita.country |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 551 | 2067119 | 59969 | City of Mandurah | 85302 | Question 0.5 | 83294 | 85302 | Intending to undertake in the next 2 years | NA | NA | NA | 26.35903 | 56919.37428 | Pass | No inventory reported | No inventory reported |
| 552 | 2143973 | 60003 | Baguio City | 345366 | Question 0.5 | 16309 | 16309 | Intending to undertake in the next 2 years | NA | NA | NA | 1.751089 | 3021.986863 | Reported population is 2018% greater than expected | No inventory reported | No inventory reported |
| 553 | 1271476 | 60050 | Guwahati Municipal Corporation | 1498970 | Question 0.5 | 899094 | 899094 | Intending to undertake in the next 2 years | NA | NA | NA | 2.502415 | 2104.163292 | Reported population is 67% greater than expected | No inventory reported | No inventory reported |
| 554 | 2633691 | 60073 | Wolverhampton City Council | 262470 | Question 0.5 | 252791 | 262470 | Intending to undertake in the next 2 years | NA | NA | NA | 8.716702 | 42986.03288 | Pass | No inventory reported | No inventory reported |
| 555 | 3099424 | 60114 | City of Gdynia | 246309 | Question 0.5 | 253730 | 246309 | Intending to undertake in the next 2 years | NA | NA | NA | 10.48975 | 16639.72798 | Pass | No inventory reported | No inventory reported |
| 556 | NA | 60125 | Klaipeda City Municipality | 148000 | Question 0.5 | NA | 148000 | In progress | NA | NA | NA | 7.831176 | 17669.65898 | missing external population data | No inventory reported | No inventory reported |
| 557 | 588335 | 60126 | Tartu City Council | 95147 | Question 0.5 | 101092 | 95147 | In progress | NA | NA | NA | 18.07657 | 19948.92283 | Pass | No inventory reported | No inventory reported |
| 558 | 184622 | 60140 | City of Nakuru | 2038945 | Question 0.5 | 259903 | 259903 | In progress | NA | NA | NA | 1.683478 | 1202.133023 | Reported population is 685% greater than expected | No inventory reported | No inventory reported |
| 559 | 191245 | 60142 | City of Kisumu | 968909 | Question 0.5 | 216479 | 216479 | Intending to undertake in the next 2 years | NA | NA | NA | 1.683478 | 1202.133023 | Reported population is 348% greater than expected | No inventory reported | No inventory reported |
| 560 | NA | 60223 | Panevežys City Municipality | 92949 | Question 0.5 | NA | 92949 | Intending to undertake in the next 2 years | NA | NA | NA | 7.831176 | 17669.65898 | missing external population data | No inventory reported | No inventory reported |
| 561 | NA | 60233 | Pärnu City Government | 51272 | Question 0.5 | NA | 51272 | Not intending to undertake | NA | NA | NA | 18.07657 | 19948.92283 | missing external population data | No inventory reported | No inventory reported |
| 562 | 2667402 | 60236 | Municipality of Trelleborg | 44854 | Question 0.5 | 29316 | 29316 | Not intending to undertake | NA | NA | NA | 7.1668 | 57232.08549 | Reported population is 53% greater than expected | No inventory reported | No inventory reported |
| 563 | 3468879 | 60258 | Prefeitura de Brusque | 128818 | Question 0.5 | 88284 | 128818 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 564 | 3469136 | 60264 | Prefeitura de Botucatu | 144000 | Question 0.5 | 113862 | 144000 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 565 | 3461789 | 60267 | Prefeitura de Guarujá | 290752 | Question 0.5 | 310424 | 290752 | In progress | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 566 | 3468894 | 60268 | Prefeitura de Brumadinho | 33973 | Question 0.5 | 27563 | 33973 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 567 | 3470052 | 60271 | Prefeitura de Bertioga | 61736 | Question 0.5 | 35759 | 35759 | Not intending to undertake | NA | NA | NA | 5.58822 | 11026.24216 | Reported population is 73% greater than expected | No inventory reported | No inventory reported |
| 568 | 3403642 | 60272 | Prefeitura de Campina Grande | 410332 | Question 0.5 | 348936 | 410332 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 569 | 3664464 | 60274 | Prefeitura de Cruzeiro do Sul | 82075 | Question 0.5 | 79819 | 82075 | NA | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 570 | 3471374 | 60276 | Prefeitura de Assis | 103000 | Question 0.5 | 101597 | 103000 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 571 | 3463432 | 60278 | Prefeitura de Fernandópolis | 68823 | Question 0.5 | 61931 | 68823 | NA | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 572 | 3467693 | 60279 | Prefeitura de Campos de Goytacazes | 483970 | Question 0.5 | 387417 | 483970 | NA | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 573 | 3472177 | 60284 | Prefeitura de Angra dos Reis | 169511 | Question 0.5 | 153635 | 169511 | NA | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 574 | 3433663 | 60292 | Prefeitura de Jahu | 141840 | Question 0.5 | 33120 | 33120 | In progress | NA | NA | NA | 5.58822 | 11026.24216 | Reported population is 328% greater than expected | No inventory reported | No inventory reported |
| 575 | 3456166 | 60307 | Prefeitura de Nova Friburgo | 182082 | Question 0.5 | 153361 | 182082 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 576 | 3662762 | 60318 | Prefeitura de Porto Velho | 428527 | Question 0.5 | 306180 | 428527 | Yes | NA | NA | NA | 5.58822 | 11026.24216 | Pass | Inventory reported, but total emissions value not provided | Inventory reported, but total emissions value not provided |
| 577 | 3452324 | 60320 | Prefeitura de Presidente Prudente | 226 | Question 0.5 | 209502 | 209502 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Reported population is 100% less than expected | No inventory reported | No inventory reported |
| 578 | NA | 60328 | Prefeitura de Pirenópolis | 24749 | Question 0.5 | NA | 24749 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | missing external population data | No inventory reported | No inventory reported |
| 579 | 3449319 | 60332 | Prefeitura de São Carlos | NA | NA | 205035 | 205035 | NA | NA | NA | NA | 5.58822 | 11026.24216 | missing reported population data | No inventory reported | No inventory reported |
| 580 | 2161532 | 60340 | Prefeitura de Rio Verde | 229651 | Question 0.5 | 22700 | 22700 | Not intending to undertake | NA | NA | NA | 5.58822 | 11026.24216 | Reported population is 912% greater than expected | No inventory reported | No inventory reported |
| 581 | 3448622 | 60349 | Prefeitura de São Leopoldo | 234947 | Question 0.5 | 209229 | 234947 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | Pass | No inventory reported | No inventory reported |
| 582 | NA | 60361 | Prefeitura de Tangará da Serra | 83431 | Question 0.5 | NA | 83431 | Intending to undertake in the next 2 years | NA | NA | NA | 5.58822 | 11026.24216 | missing external population data | No inventory reported | No inventory reported |
| 583 | 3689560 | 60369 | Alcaldía Municipal de Armenia | 301226 | Question 0.5 | 315328 | 301226 | Yes | NA | NA | NA | 3.329042 | 7698.412245 | Pass | Inventory reported, but total emissions value not provided | Inventory reported, but total emissions value not provided |
| 584 | 3676623 | 60371 | Alcaldía de Leticia | 42280 | Question 0.5 | 29666 | 42280 | NA | NA | NA | NA | 3.329042 | 7698.412245 | Pass | No inventory reported | No inventory reported |
| 585 | 3680656 | 60374 | Alcaldía de Ibagué | 564077 | Question 0.5 | 421685 | 564077 | Intending to undertake in the next 2 years | NA | NA | NA | 3.329042 | 7698.412245 | Pass | No inventory reported | No inventory reported |
| 586 | 3670218 | 60375 | Gobiernación del Archipiélago de San Andrés | 120000 | Question 0.5 | 58257 | 58257 | Intending to undertake in the next 2 years | NA | NA | NA | 3.329042 | 7698.412245 | Reported population is 106% greater than expected | No inventory reported | No inventory reported |
| 587 | 3668605 | 60381 | Alcaldía Distrital de Santa Marta | 491535 | Question 4.5 | 431781 | 491535 | Yes | NA | NA | NA | 3.329042 | 7698.412245 | Pass | Inventory reported, but total emissions value not provided | Inventory reported, but total emissions value not provided |
| 588 | 3665688 | 60384 | Alcaldía de Yopal | 152655 | Question 0.5 | 61029 | 61029 | Intending to undertake in the next 2 years | NA | NA | NA | 3.329042 | 7698.412245 | Reported population is 150% greater than expected | No inventory reported | No inventory reported |
| 589 | 3665900 | 60385 | Alcaldía de Villavicencio | 527673 | Question 0.5 | 321717 | 321717 | Not intending to undertake | NA | NA | NA | 3.329042 | 7698.412245 | Reported population is 64% greater than expected | No inventory reported | No inventory reported |
| 590 | 3667983 | 60387 | Alcaldíade Sincelejo | 275207 | Question 0.5 | 261187 | 275207 | NA | NA | NA | NA | 3.329042 | 7698.412245 | Pass | No inventory reported | No inventory reported |
| 591 | NA | 60392 | Municipalidad de San Isidro (Lima) | 54206 | Question 0.5 | NA | 54206 | In progress | NA | NA | NA | 2.644665 | 6453.922634 | missing external population data | No inventory reported | No inventory reported |
| 592 | 3871336 | 60393 | Municipalidad de Santiago | 404495 | Question 0.5 | 4837295 | 4837295 | In progress | NA | NA | NA | 6.326088 | 15130.15432 | Reported population is 92% less than expected | No inventory reported | No inventory reported |
| 593 | 3903320 | 60394 | Gobierno Autónomo Municipal de Tarija | 261188 | Question 0.5 | 159269 | 159269 | Intending to undertake in the next 2 years | NA | NA | NA | 4.595651 | 2559.511317 | Reported population is 64% greater than expected | No inventory reported | No inventory reported |
| 594 | NA | 60399 | Municipalidad de Miraflores | 99337 | Question 0.5 | NA | 99337 | Intending to undertake in the next 2 years | NA | NA | NA | 2.644665 | 6453.922634 | missing external population data | No inventory reported | No inventory reported |
| 595 | 3870294 | 60408 | Municipalidad de Talca | 220357 | Question 0.5 | 197479 | 220357 | Intending to undertake in the next 2 years | NA | NA | NA | 6.326088 | 15130.15432 | Pass | No inventory reported | No inventory reported |
| 596 | NA | 60410 | Municipalidad de Peñalolén | 241599 | Question 0.5 | NA | 241599 | Intending to undertake in the next 2 years | NA | NA | NA | 6.326088 | 15130.15432 | missing external population data | No inventory reported | No inventory reported |
| 597 | NA | 60416 | Municipalidad de San Isidro (Argentina) | 293 | Question 0.5 | NA | 293 | Intending to undertake in the next 2 years | NA | NA | NA | 8.519953 | 10040.13074 | missing external population data | No inventory reported | No inventory reported |
| 598 | 2621927 | 60577 | Frederikshavn Kommune | 60379 | Question 0.5 | 24103 | 24103 | NA | NA | NA | NA | 10.16008 | 62888.72719 | Reported population is 151% greater than expected | No inventory reported | No inventory reported |
| 599 | 3347762 | 60588 | City of Alba-Iulia | 74000 | Question 0.5 | 102541 | 74000 | In progress | NA | NA | NA | 5.996812 | 11534.85862 | Pass | No inventory reported | No inventory reported |
| 600 | NA | 60599 | Town of Bridgewater, NS | 8532 | Question 0.5 | NA | 8532 | Intending to undertake in the next 2 years | NA | NA | NA | 20.562 | 51357.75398 | missing external population data | No inventory reported | No inventory reported |
About
This information is now on Primer
All the information that is in this pane, and more, is now on Primer, in a more consumable and user friendly format. You can also edit metadata from this page.
Take me there!
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
- 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.
- 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)
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
