global-power-plants

Table actions

23 rows where owner = "TransAlta (100%)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, url, year_of_capacity_data, estimated_generation_gwh

primary_fuel 2

owner 1

  • TransAlta (100%) · 23 ✖

country_long 1

Link rowid ▼ country country_long name gppd_idnr capacity_mw latitude longitude primary_fuel other_fuel1 other_fuel2 other_fuel3 commissioning_year owner source url geolocation_source wepp_id year_of_capacity_data generation_gwh_2013 generation_gwh_2014 generation_gwh_2015 generation_gwh_2016 generation_gwh_2017 generation_data_source estimated_generation_gwh
3605 3605 CAN Canada Akolkolex CAN0007606 10.0 50.8227 -118.0295 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 15478 2017             47.41692797739298
3651 3651 CAN Canada Barrier CAN0007645 13.0 51.0342 -115.0409 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34855 2017             61.642006370610865
3662 3662 CAN Canada Bearspaw CAN0007654 17.0 51.1012 -114.2823 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34857 2017             80.60877756156808
3672 3672 CAN Canada Belly River CAN0007663 3.0 49.315 -113.5743 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 15479 2017             14.225078393217895
3683 3683 CAN Canada Bighorn CAN0002111 120.0 52.3081 -116.3245 Hydro         TransAlta (100%) Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 34856 2017             569.0031357287157
3695 3695 CAN Canada Bone Creek CAN0007687 19.0 52.2553 -119.1808 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 56120 2017             90.09216315704666
3710 3710 CAN Canada Brazeau CAN0002113 355.0 52.9101 -115.3754 Hydro         TransAlta (100%) Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 34858 2017             1683.3009431974508
3763 3763 CAN Canada Cascade CAN0007732 36.0 51.2002 -115.5021 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2017             170.7009407186147
3951 3951 CAN Canada Ghost CAN0007882 51.0 51.2188 -114.7078 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34860 2017             241.82633268470417
4036 4036 CAN Canada Horseshoe CAN0007953 14.0 51.118 -115.0343 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34861 2017             66.38369916835018
4049 4049 CAN Canada Interlakes CAN0007967 5.0 50.6335 -115.1392 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34862 2017             23.70846398869649
4077 4077 CAN Canada Kananaskis CAN0007990 19.0 51.0969 -115.0582 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34863 2017             90.09216315704666
4086 4086 CAN Canada Kent Breeze CAN0007997 20.0 42.5452 -82.0506 Wind         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 64348 2016             37.14912063821721
4134 4134 CAN Canada Le Nordais 2 (Matane) CAN0008039 42.8 48.7816 -67.6097 Wind         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 23964 2016             79.49911816578482
4243 4243 CAN Canada Misema CAN0008133 3.0 47.8996 -79.8759 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 51201 2017             14.225078393217895
4280 4280 CAN Canada New Richmond CAN0008162 67.8 48.1999 -65.7166 Wind         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 59717 2016             125.9355189635563
4361 4361 CAN Canada Pocaterra CAN0008236 15.0 50.6993 -115.1194 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34866 2017             71.12539196608947
4449 4449 CAN Canada Rundle CAN0008310 50.0 51.0887 -115.3736 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34867 2017             237.0846398869649
4566 4566 CAN Canada Spray CAN0002244 112.0 51.0745 -115.4024 Hydro         TransAlta (100%) Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 34868 2017             531.0695933468014
4583 4583 CAN Canada St. Mary CAN0008424 2.0 49.3665 -113.1087 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 15481 2017             9.483385595478595
4631 4631 CAN Canada Three Sisters CAN0008469 3.0 50.9985 -115.3746 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34870 2017             14.225078393217895
4669 4669 CAN Canada Upper Mamquam CAN0008500 25.0 49.7178 -123.0546 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 50976 2017             118.54231994348244
4700 4700 CAN Canada Waterton Hydro CAN0008526 3.0 49.3291 -113.6732 Hydro         TransAlta (100%) Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 15482 2017             14.225078393217895

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "global-power-plants" (
"country" TEXT,
  "country_long" TEXT,
  "name" TEXT,
  "gppd_idnr" TEXT,
  "capacity_mw" REAL,
  "latitude" REAL,
  "longitude" REAL,
  "primary_fuel" TEXT,
  "other_fuel1" TEXT,
  "other_fuel2" TEXT,
  "other_fuel3" TEXT,
  "commissioning_year" REAL,
  "owner" TEXT,
  "source" TEXT,
  "url" TEXT,
  "geolocation_source" TEXT,
  "wepp_id" TEXT,
  "year_of_capacity_data" INTEGER,
  "generation_gwh_2013" REAL,
  "generation_gwh_2014" REAL,
  "generation_gwh_2015" REAL,
  "generation_gwh_2016" REAL,
  "generation_gwh_2017" REAL,
  "generation_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");