Country statistics
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>Statistics are based on fossil fuel reserve data from the Bundesanstalt für Geowissenschaften und Rohstoffe (BGR) [German Federal Institute for Geosciences and Natural Resources], CO2 conversion calculations from the Leave it in the Ground Initiative, and fossil fuel extraction asset databases from Rystad Energy and the Global Energy Monitor project. </SPAN></SPAN></P><P><SPAN><SPAN>Area-based statistics are based on data from the United States Geographic Survey, LINGO, and the World Database of Protected Areas. National and exclusive economic zone boundaries provided by the Flanders Marine Institute. Area-based calculations began with creating a pair of polygon sets representing overlapping areas between coal/oil/gas deposits and protected areas. Both the original polygons and these “overlap” polygons were further processed in a five-step workflow: (1) Transnational deposits were split at national borders using the Flanders Institute’s map of national borders and economic exclusive zones. This normalized border lines across different sources and ensured that each country’s statistics would only include deposits within their borders.(2) Each resulting polygon’s area in square kilometers was calculated and appended to the polygon’s attribute data. (3) ISO three-letter country codes were added to each polygon’s attribute table to identify which country they are located in. (4) Country stats were summarized by summing the area attribute values for all the polygons with the same country code. (5) Each country’s coal and oil/gas deposits under protected areas was calculated as a percentage of the national total coal and oil/gas area. These percentages were then used as multipliers for BGR’s energy statistics to estimate the amount of each fossil fuel under protected areas.</SPAN></SPAN></P><P><SPAN><SPAN>Processing of current and planned extraction data from Rystad Energy and Global Energy Monitor started with clipping the respective data sets to include only protected areas. Duplicate, abandoned, cancelled, and spurious assets were then removed before summing values for each three-letter ISO country code, creating the final per-country statistics.</SPAN></SPAN></P><P><SPAN><SPAN>All processing was performed with ArcGIS Pro Advanced (v3.0.1, and later, v3.0.2) on the author’s computer workstation. Microsoft Excel (v2207, and later, v2208) was used to prepare spreadsheets and collate data. </SPAN></SPAN></P><P><SPAN><SPAN>Using LINGO’s “Keep it in the Ground” conversion metrics, equivalent potential carbon dioxide emissions have been provided.</SPAN></SPAN></P><P><SPAN /></P><P><SPAN>Fields:</SPAN></P><P><SPAN>SOVEREIGN1 - Name of the nation claiming this area. If multiple claims exist, this field indicates the nation with the most recognized status (LINGO, participating organizations, and sources express no opinion about the legal state neither of any country, territory or area nor concerning its delimitation, frontier, or borders).</SPAN></P><P><SPAN>ISO_SOV1 - Name of the nation claiming this area, expressed as a three-character ISO 3166 country code. If multiple claims exist, this field indicates the nation with the most recognized status (LINGO, participating organizations, and sources express no opinion about the legal state neither of any country, territory, or area nor concerning its delimitation, frontier, or borders).</SPAN></P><P><SPAN>CountryEEZTotalAreaKM2 - The total calculated area of the country, including land and marine areas that have been recognized as part of the economic exclusive zone. Expressed in square kilometers.</SPAN></P><P><SPAN>Total_Emissions_in_PA_CO2_Mt - The combined potential CO2 emissions from current and planned extraction of oil, gas, and coal from Protected Areas. Expressed in millions of tons of CO2.</SPAN></P><P><SPAN>Coal_in_PA_Mt - Total current and planned coal resources/reserves extraction in protected areas. Resource values are used unless reserve numbers are higher (due to Global Energy Monitor's methodology). Expressed in millions of tons of raw coal.</SPAN></P><P><SPAN>Coal_in_PA_CO2_Mt - Total current and planned CO2 emissions from coal resources/reserves extraction in protected areas. Resource values are used unless reserve numbers are higher (due to Global Energy Monitor's methodology). Expressed in millions of tons of CO2.</SPAN></P><P><SPAN>OilGas_in_PA__MMBOE - Total current and planned oil/gas resources extraction in protected areas. Expressed in millions of barrels oil equivalent.</SPAN></P><P><SPAN>OilGas_in_PA_CO2_Mt - Total current and planned CO2 emissions from oil/gas resource extraction in protected areas. Expressed in millions of tons of CO2.</SPAN></P><P><SPAN>Total_Coal_Area_KM2 - Total area of coal deposits. Expressed in square kilometers.</SPAN></P><P><SPAN>Overlapping_Coal_Area_KM2 - Total area of coal deposits under protected areas.</SPAN></P><P><SPAN>Remaining_Potential_Coal_Under_PA_USGSarea_Mt - Estimated remaining potential coal resources under protected areas. Area-based calculations, assuming equal deposits across areas identified as coal-bearing. Expressed in millions of tons of raw coal.</SPAN></P><P><SPAN>Remaining_Potential_Coal_Under_PA_CO2_USGSarea_Mt - Estimated remaining potential coal resources under protected areas. Area-based calculations, assuming equal deposits across areas identified as coal-bearing. Expressed in millions of tons of CO2.</SPAN></P></DIV></DIV></DIV>
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'ISO_SOV', 'type': 'esriFieldTypeString', 'alias': 'ISO3 Country Code', 'sqlType': 'sqlTypeOther', 'length': 254, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SOVEREIGN', 'type': 'esriFieldTypeString', 'alias': 'Sovereign Name', 'sqlType': 'sqlTypeOther', 'length': 254, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CountryEEZTotalAreaKM2', 'type': 'esriFieldTypeDouble', 'alias': 'Total Country Area with EEZ KM2', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Total_Emissions_in_PA_CO2_Mt', 'type': 'esriFieldTypeDouble', 'alias': 'Total Current and Planned Emissions from Protected Areas CO2 Mt', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Coal_in_PA_Mt', 'type': 'esriFieldTypeInteger', 'alias': 'Total Current and Planned Coal Extraction in PA Mt', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Coal_in_PA_CO2_Mt', 'type': 'esriFieldTypeInteger', 'alias': 'Total Current and Planned Emissions from Coal Extraction in PA CO2 Mt', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OilGas_in_PA__MMBOE', 'type': 'esriFieldTypeDouble', 'alias': 'Total Current and Planned OilGas Extraction in PA MMBOE', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OilGas_in_PA_CO2_Mt', 'type': 'esriFieldTypeDouble', 'alias': 'Total Current and Planned Emissions from OilGas Extraction in PA CO2 Mt', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Total_Coal_Area_KM2', 'type': 'esriFieldTypeDouble', 'alias': 'Total Coal Area KM2', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Overlapping_Coal_Area_KM2', 'type': 'esriFieldTypeDouble', 'alias': 'Overlapping Coal Area KM2', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Remaining_Potential_Coal_Under_', 'type': 'esriFieldTypeString', 'alias': 'Remaining Potential Coal Under PA Area-based Mt', 'sqlType': 'sqlTypeOther', 'length': 8000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Remaining_Potential_Coal_Under1', 'type': 'esriFieldTypeString', 'alias': 'Remaining Potential Emissions from Coal Under PA CO2 Area-based CO2 Mt', 'sqlType': 'sqlTypeOther', 'length': 8000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Shape__Area', 'type': 'esriFieldTypeDouble', 'alias': 'Shape__Area', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'Shape__Length', 'type': 'esriFieldTypeDouble', 'alias': 'Shape__Length', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__LINGO_BA__F4B70D85D753D944', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_2643.LINGO_BASE_LAYERS_COUNTRY_STATISTICS_Shape_sidx', 'fields': 'Shape', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Spatial'}, {'name': 'Shape__Area_Index', 'fields': 'Shape__Area', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}, {'name': 'Shape__Length_Index', 'fields': 'Shape__Length', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}]
nan
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [198, 252, 181, 0], 'outline': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [0, 0, 0, 255], 'width': 0.7}}}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': None}
[]
[{'name': 'Country statistics', 'description': '', 'drawingTool': 'esriFeatureEditToolPolygon', 'prototype': {'attributes': {}}}]