insertScript.sql

-- delete rows from tables

CREATE or replace FUNCTION clean_tables() RETURNS void AS $$
declare
  l_stmt text;
begin
  select 'truncate ' || string_agg(format('%I.%I', schemaname, tablename) , ',')
    into l_stmt
  from pg_tables
  where schemaname in ('public');

  execute l_stmt || ' cascade';
end;
$$ LANGUAGE plpgsql;
select clean_tables();

-- reset sequential

CREATE or replace FUNCTION restart_sequences() RETURNS void AS $$
DECLARE
i TEXT;
BEGIN
 FOR i IN (SELECT column_default FROM information_schema.columns WHERE column_default SIMILAR TO 'nextval%')
  LOOP
         EXECUTE 'ALTER SEQUENCE'||' ' || substring(substring(i from '''[a-z_]*')from '[a-z_]+') || ' '||' RESTART 1;';
  END LOOP;
END $$ LANGUAGE plpgsql;
select restart_sequences();
-- reset end

-- deletion end

-- table location
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (113.264385, 23.12911, 450.26, 46.25, 'Guanghou');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (18.0755564, 51.4174879, 487.62, 30.59, 'Doruchów');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-0.445788, 52.913784, 663.66, 33.52, 'Newton');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (18.2637328, 59.2916062, 1251.18, 16.56, 'Saltsjöbaden');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (99.850365, 26.312444, 1515.71, 24.53, 'Shaxi');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (96.5756695, 17.292049, 1404.7, 26.81, 'Thanatpin');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-103.9970779, 20.3411024, 1237.37, 4.36, 'Lagunillas');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-64.6866092, 10.19062, 238.28, 8.64, 'Lecherías');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (6.092908, 52.5112898, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (97.9157099, 17.9341079, 1597.65, 32.58, 'Sop Moei');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (139.9854087, 36.9351637, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (119.460526, 29.208918, 1341.0, 30.34, 'Lanxi');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (110.464464, 28.998299, 548.08, 14.55, 'Baishuitan');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-8.9052753, 39.8647755, 910.05, 4.32, 'Boco');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (20.1089899, 40.8358295, 880.09, 22.9, 'Tunjë');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (20.9095433, 41.8632851, 1217.13, 39.95, 'Dobri Dol');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-81.0451037, -4.1034782, 1060.64, 33.24, 'Máncora');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (15.8176288, 46.3989378, 1305.79, 47.54, 'Spodnja Hajdina');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (30.20897, 60.0122, 970.04, 22.07, 'Untolovo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (119.141473, 28.074649, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (116.4073963, 39.9041999, 963.1, 16.66, 'Sijing');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (28.8115769, 45.7327203, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (102.7755279, 17.387112, 939.04, 15.52, 'Udon Thani');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-68.8824233, 12.1224221, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-90.5158438, 14.6050898, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (118.553352, 31.59998, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (139.9200321, 36.8079089, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (104.745823, 31.778022, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (67.34516, 34.26545, 1247.29, 35.33, 'Cool űrhajó');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (121.1364, -8.4465, 861.48, 25.74, 'Tungguwaneng');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (135.0394338, 48.5393826, 865.31, 43.5, 'Khabarovsk');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (31.89571, -28.73688, 627.4, 48.68, 'Mtubatuba');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-6.4769877, 7.3750631, 370.53, 48.12, 'Vavoua');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (41.9931328, 41.9208048, 204.87, 11.61, 'Ozurgeti');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-9.3975414, 38.7107263, 1599.58, 34.17, 'Estoril');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-74.8058417, 41.3234558, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (105.411797, 50.097858, 362.68, 7.41, 'Huurch');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (119.110257, 25.435964, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-49.8004866, -16.0222492, 975.8, 25.67, 'Itaberaí');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (6.0732146, 7.8231145, 1340.88, 28.97, 'Kabba');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (8.98527, 13.8018124, 1139.85, 27.73, 'Zinder');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (113.576677, 22.270978, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (17.9932873, 59.3635749, 719.45, 25.42, 'Solna');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (86.311647, 44.254148, 670.75, 48.49, 'Baojiadian');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-81.6363869, 41.0875099, 1809.75, 49.2, 'Akron');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (124.3973046, 11.562733, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (73.6658984, 30.663128, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (143.0677264, -5.9617867, 1390.48, 17.54, 'Tari');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-58.4794508, -34.6204268, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (42.503334, 45.116904, 1368.62, 9.49, 'Spitsevka');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (121.0298199, 14.5672317, 408.36, 45.64, 'Santiago');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (103.7983752, 1.5484759, 1073.25, 23.73, 'Johor Bahru');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-8.6714665, 41.558895, 1326.57, 32.8, 'Vilar do Monte');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (23.287731, 69.9717043, 712.46, 19.8, 'Alta');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (112.636417, 28.040943, 1619.16, 15.28, 'Huaminglou');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (106.7411559, -6.3991308, 796.57, 33.74, 'Bojongsari');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (6.0684306, 52.5019685, 672.12, 21.11, 'Zwolle');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-36.6602483, -6.6858425, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (38.563128, 48.1292028, 1299.03, 39.7, 'Rozsypne');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (18.2903712, 51.1644956, 1677.75, 21.14, 'Łubnice');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (36.2249059, 55.9576019, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (35.31083, 54.98806, 1927.74, 21.67, 'Iznoski');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-75.4102538, -13.3108167, 1729.4, 43.21, 'Mollepampa');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (35.201315, 32.852247, 1614.8, 8.16, 'Tamra');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (112.7211714, -7.2630131, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (41.1062184, 42.9314238, 516.12, 21.25, 'Gulrip’shi');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (125.2122777, 9.0072301, 1831.13, 21.66, 'Kibonsod');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (37.58435, 48.738967, 1421.99, 43.31, 'Kramators’k');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (19.5968399, 51.2150482, 346.27, 14.16, 'Gorzkowice');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (1.4974024, 43.470556, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (106.4206269, -6.9034154, 1035.87, 48.75, 'Cijapar');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (42.0384264, 44.2220765, 1400.58, 19.97, 'Psyzh');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (19.94522, 42.0416939, 349.54, 28.8, 'Rrapë');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-64.8375639, -24.2313531, 1076.89, 4.09, 'Ingenio La Esperanza');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (5.8978018, 43.4945737, 1986.05, 29.05, 'Paris 08');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (112.6973355, -8.4428564, 412.31, 3.96, 'Sempu');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-117.2948343, 49.4928119, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (88.880492, 29.270311, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (12.0599176, 57.731461, 1603.46, 8.39, 'Göteborg');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (121.0589081, 14.7596318, 1248.65, 29.19, 'San Vicente');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-64.2837225, -27.7828418, 1883.55, 44.48, 'Añatuya');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (119.5513689, -3.6619451, 684.4, 34.07, 'Lampa');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (121.0758172, 14.7512576, 509.24, 4.8, 'Bigaa');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (34.0084395, -11.4389649, 620.13, 48.32, 'Mzuzu');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (27.2797506, 59.3974738, 1781.46, 15.97, 'Kohtla-Järve');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-96.9799755, 32.8449965, 1493.97, 20.91, 'Irving');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-7.121411, 40.1122778, 1441.21, 48.54, 'Aranhas');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-78.69957, 46.31681, 1032.06, 3.09, 'Mattawa');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (107.345882, 28.693048, 1732.57, 4.98, 'Bifeng');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (44.1221682, 17.037629, 998.1, 46.18, 'Kitāf');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (122.9082413, 9.8245916, 1596.42, 27.16, 'Lalagsan');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (38.0011402, 55.9240189, 949.08, 33.65, 'Shchelkovo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-2.1318548, 46.8260183, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (10.6587684, 59.9684367, 1645.87, 20.73, 'Oslo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (19.710237, 49.5904912, 843.39, 16.53, 'Sidzina');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (5.8978018, 43.4945737, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (19.2988999, 44.9856696, 1875.83, 24.36, 'Višnjićevo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (106.7817741, -6.2455587, 595.56, 18.72, 'Lantera');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (118.874552, 39.500179, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (121.0317737, 14.565668, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (37.7673912, 55.5807611, 1728.89, 25.51, 'Vidnoye');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (45.3024464, 43.2900441, 1070.32, 34.59, 'Samashki');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (30.5168633, 60.1475268, 704.78, 11.37, 'Toksovo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (120.0041, -8.6431, 944.13, 7.47, 'Teongtoda');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (167.7373396, 8.7814708, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (51.1977605, 26.1301245, 292.86, 48.02, 'Ar Ru’ays');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (107.322323, 25.822349, 1766.41, 15.55, 'Pingtang');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (122.597251, 11.427407, 507.23, 10.67, 'Mambusao');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-35.2697802, -7.2787651, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-55.168269, -21.6110027, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-46.9513691, -23.0931156, 697.71, 2.51, 'Louveira');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (12.933356, 57.7197857, 1814.45, 25.09, 'Borås');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (83.3748613, 54.4555308, 337.04, 42.82, 'Linëvo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (136.1957329, 35.8515197, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (14.2352339, 40.846108, 1898.83, 38.57, 'Napoli');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (114.040353, 30.63166, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-9.0288689, 53.2737147, 1539.99, 45.75, 'Gweedore');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (113.913977, -2.2161048, 1063.66, 41.42, 'Palangkaraya');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (2.074954, 49.039076, 1175.0, 36.96, 'Cergy-Pontoise');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-8.5367175, 39.4781672, 1782.22, 16.41, 'Torres Novas');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (27.2119237, 52.0546671, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (62.1571349, 37.6156855, 863.64, 13.69, 'Bayramaly');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (112.910406, 24.111841, 466.64, 33.17, 'Yanbei');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-77.6478852, -9.2247779, 1526.47, 2.91, 'Amashca');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-55.738391, -34.7647679, 417.96, 35.46, 'Las Toscas');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (106.82725, -6.38706, 1855.05, 33.33, 'Werangere');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-49.6555394, -22.2131635, 1614.33, 28.16, 'Garça');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (102.544405, 32.790891, 265.17, 7.64, 'Hongyuan');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (4.3642884, 46.6750305, 1014.14, 8.96, 'Montceau-les-Mines');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (117.764198, 9.074122, 216.98, 14.09, 'Bunog');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (15.9614667, 44.9564928, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (111.012675, 22.0462137, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (5.1190026, 43.5958543, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (109.9526633, -7.6695988, 1754.85, 28.13, 'Winong');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (124.7225, 6.39694, 1158.14, 16.06, 'Dahay');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (119.85254, 32.910459, 1752.72, 42.51, 'Xinghua');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-8.7836111, 39.8595809, 889.66, 16.78, 'Vale da Pedra');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-96.795855, 33.0524588, 877.01, 19.06, 'Magong');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-45.2515461, -21.692578, 980.08, 8.15, 'Três Corações');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (15.2748089, 50.6594689, 711.74, 23.23, 'Jirkov');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (48.1450932, 50.4438122, 1521.62, 2.49, 'Novouzensk');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-6.2940354, 36.5292176, 749.96, 33.54, 'Cadiz');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (19.0552361, 45.5824038, 1860.23, 1.26, 'Sonta');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-43.0343237, -19.7667781, 825.09, 26.08, 'Nova Era');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (10.0852568, 53.607925, 1745.94, 9.73, 'Hamburg Bramfeld');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (21.97678, 49.65841, 1813.29, 37.0, 'Jasionów');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (33.90812, 18.26196, 831.68, 4.08, 'El Bauga');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (4.2094771, 49.1790652, 822.03, 19.03, 'Reims');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (12.58084, 55.6819664, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (37.7609688, 8.9705754, 1302.38, 3.63, 'Guder');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (105.9714566, 20.0045547, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-60.6923382, -32.9285798, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (17.0877754, 44.2837305, 428.36, 11.67, 'Šipovo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (111.8784707, -7.5849174, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (140.0433007, 39.0000158, 1275.3, 35.28, 'Masuda');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (42.7731878, 55.80192, 1496.19, 19.5, 'Vacha');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (26.1751462, 39.367146, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (104.0769024, 17.5165974, 443.48, 37.34, 'Na Wa');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (36.1192307, 34.8190348, 285.57, 28.79, 'Satita');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (114.112961, 38.570152, 849.3, 49.0, 'Chenzhuang');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (139.8016577, 35.8387024, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (27.797184, -26.1633679, 385.61, 19.92, 'Ixopo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-74.6502902, 40.1929685, 1726.44, 11.8, 'Trenton');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (113.1916737, 23.9563274, 1915.95, 31.7, 'Beijiang');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-54.9171412, -28.4262462, 1262.69, 10.75, 'São Luiz Gonzaga');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (29.7831356, -0.8897256, 1448.08, 24.89, 'Kalungu');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (113.618216, 22.919769, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (119.7371425, -9.8492904, 1142.23, 8.19, 'Praimarada');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-79.8226708, -6.3929812, 1370.6, 16.74, 'Jayanca');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (48.0477271, 46.2824183, 1175.39, 21.86, 'Starokucherganovka');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (105.9128, -6.3623, 837.42, 23.24, 'Sorodot');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (105.4943648, 21.0598649, 846.18, 25.97, 'Đồng Mỏ');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-5.5459787, 30.7717757, 1068.7, 13.49, 'Tazarine');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-76.5112471, 3.4851908, 1727.51, 9.71, 'Cali');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-46.5282973, -22.5905906, 203.88, 5.62, 'Socorro');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (38.3745149, 8.116779, 697.42, 20.41, 'Butajīra');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (37.9891132, 56.1597869, 387.47, 15.91, 'Rakhmanovo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-70.582502, -33.459409, 292.02, 20.5, 'Villa Presidente Frei, Ñuñoa, Santiago, Chile');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (107.6266329, -6.883367, 1741.56, 16.25, 'Cigadung');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (114.860055, 34.850606, 286.98, 41.55, 'Xihanling');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-78.0327377, -7.7061422, 1243.76, 33.13, 'Marcabal');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (45.1501554, -12.9361186, 1259.81, 23.81, 'Chirongui');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (28.3570946, 57.3397034, 1311.18, 36.61, 'Ostrov');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-70.0339387, -17.4776078, 1450.08, 45.44, 'Tarata');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (105.8466437, -6.6551319, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (90.5074729, 23.6367493, 1976.27, 47.54, 'Hājīganj');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-73.083333, -14.216667, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (124.3382, -10.0431, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (39.1422317, 58.5007075, 1717.62, 9.36, 'Poshekhon’ye');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-48.5962748, -23.7981763, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-8.334953, 51.8610022, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-47.6790285, -23.2860188, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (19.5865629, -4.061738, 1380.74, 34.84, 'Mangai');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (116.3169416, 39.7601611, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (102.7834876, 16.4656784, 1427.15, 32.37, 'Khon Kaen');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (93.2187293, 54.3141155, 975.65, 49.77, 'Krasnokamensk');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (123.4091052, 10.0016057, 282.07, 46.75, 'Ronda');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (22.4781721, 61.7664099, 1867.06, 45.42, 'Lavia');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (19.0030052, 44.9597766, 642.45, 12.06, 'Soljani');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (135.2621426, 34.3726258, 500.84, 45.02, 'Tarui');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-46.9772966, -23.5325624, 1026.42, 33.64, 'Itapevi');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (123.1239049, -10.7386421, 1777.04, 37.38, 'Rote');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (6.2651155, 49.8674755, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (50.1706415, 58.7113992, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (111.9403254, -7.0961965, 1827.97, 27.33, 'Soko');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (112.453926, 34.620202, 758.9, 27.86, 'Luoyang');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-99.1303962, 19.4468231, 1627.0, 22.9, 'Morelos');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (117.943433, 28.454862, 1573.75, 20.16, 'Shangrao');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (15.0737321, 46.280897, 539.62, 29.64, 'Polzela');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (106.009915, 34.34866, 385.69, 18.23, 'Maji');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (102.2090224, 16.1344075, 1036.79, 17.82, 'Kaeng Khro');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (57.6240731, -20.0207751, 834.36, 45.17, 'Petit Raffray');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (120.156218, 14.973465, 1458.63, 24.09, 'San Marcelino');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (106.912251, 29.4315861, 396.24, 48.86, 'Changkeng');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (24.4173321, 37.3933984, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (15.1025075, 32.3196827, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (22.88353, 37.90953, 220.96, 47.77, 'Arkhaía Kórinthos');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (118.8322, 31.264895, 540.38, 17.35, 'Zhuanqiang');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (120.1022118, 13.8493774, 1325.07, 14.04, 'Tangal');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (120.9965883, 14.5792342, 1473.1, 44.87, 'Union');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-76.1377935, 42.9979838, 554.27, 16.44, 'Syracuse');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (119.04263, 25.485074, 629.4, 25.44, 'Xitianwei');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (121.0298199, 14.5672317, 1447.56, 18.88, 'Santiago');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (47.0291162, -19.8730077, 823.71, 40.99, 'Antsirabe');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-75.281155, 8.853929, 335.95, 7.97, 'La Unión');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (16.101507, 50.2609615, 284.69, 34.72, 'Opočno');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (111.0534923, -6.5596329, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (49.8905718, 31.5259995, 1107.41, 2.04, 'Bāgh-e Malek');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (114.886335, 40.767544, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (108.7987084, -7.0890676, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (123.2989088, 9.492846, 1480.0, 22.79, 'Samboan');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-40.6953223, -16.1796844, 1949.01, 22.79, 'Almenara');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (118.579936, 28.915608, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (18.9379685, 52.9468825, 1408.04, 22.08, 'Czernikowo');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-39.0710754, -11.2568167, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-7.349941, 39.4110563, 1744.05, 42.71, 'Santo António das Areias');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (107.0303221, 10.9667039, 1655.41, 24.48, 'Trảng Bom');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (4.647618, 12.4069994, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (118.6143878, 35.9705797, 447.52, 40.12, 'Chengzi');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (10.4024274, 63.4400274, 268.47, 6.74, 'Trondheim');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (105.9039005, -6.3710341, 453.85, 32.55, 'Muruy');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (83.6616699, 46.5067026, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-7.1636637, 38.8802788, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (121.488302, 31.1710599, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (116.00261, 25.881342, 938.29, 35.77, 'Shazhouba');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (120.167774, 29.693316, null, null, null);
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (-70.7423218, -33.7309374, 202.55, 12.22, 'Buin');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (108.5151507, -6.8353325, 789.45, 37.97, 'Halimpu');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (4.3520438, 43.8447278, 685.28, 4.18, 'Nîmes');
insert into location (longitude, latitude, solar_constant, wind_speed, name) values (105.9376756, 21.0078386, 1053.18, 40.6, 'Trâu Quỳ');

-- table solar_power_plant
insert into solar_power_plant (id_location, solar_type, total_area) values (12, 'Ground panel', 4942.76);
insert into solar_power_plant (id_location, solar_type, total_area) values (86, 'Mirror panel', 1695.97);
insert into solar_power_plant (id_location, solar_type, total_area) values (94, 'Mirror panel', 389.54);
insert into solar_power_plant (id_location, solar_type, total_area) values (26, 'Mirror panel', 3657.07);
insert into solar_power_plant (id_location, solar_type, total_area) values (187, 'Roof panel', 2829.88);
insert into solar_power_plant (id_location, solar_type, total_area) values (230, 'Roof panel', 1859.69);
insert into solar_power_plant (id_location, solar_type, total_area) values (241, 'Roof panel', 897.82);
insert into solar_power_plant (id_location, solar_type, total_area) values (222, 'Ground panel', 92.19);
insert into solar_power_plant (id_location, solar_type, total_area) values (3, 'Roof panel', 4993.72);
insert into solar_power_plant (id_location, solar_type, total_area) values (24, 'Roof panel', 2383.89);
insert into solar_power_plant (id_location, solar_type, total_area) values (93, 'Roof panel', 1957.32);
insert into solar_power_plant (id_location, solar_type, total_area) values (20, 'Mirror panel', 1258.87);
insert into solar_power_plant (id_location, solar_type, total_area) values (248, 'Mirror panel', 2711.34);
insert into solar_power_plant (id_location, solar_type, total_area) values (104, 'Mirror panel', 3863.21);
insert into solar_power_plant (id_location, solar_type, total_area) values (227, 'Mirror panel', 302.31);
insert into solar_power_plant (id_location, solar_type, total_area) values (25, 'Mirror panel', 744.27);
insert into solar_power_plant (id_location, solar_type, total_area) values (176, 'Ground panel', 4953.68);
insert into solar_power_plant (id_location, solar_type, total_area) values (202, 'Roof panel', 817.09);
insert into solar_power_plant (id_location, solar_type, total_area) values (178, 'Ground panel', 1936.91);
insert into solar_power_plant (id_location, solar_type, total_area) values (65, 'Ground panel', 1795.9);
insert into solar_power_plant (id_location, solar_type, total_area) values (204, 'Mirror panel', 3163.64);
insert into solar_power_plant (id_location, solar_type, total_area) values (54, 'Ground panel', 4056.61);
insert into solar_power_plant (id_location, solar_type, total_area) values (147, 'Mirror panel', 3633.94);
insert into solar_power_plant (id_location, solar_type, total_area) values (193, 'Roof panel', 3098.03);
insert into solar_power_plant (id_location, solar_type, total_area) values (174, 'Mirror panel', 1131.89);
insert into solar_power_plant (id_location, solar_type, total_area) values (237, 'Roof panel', 3562.39);
insert into solar_power_plant (id_location, solar_type, total_area) values (217, 'Roof panel', 3601.37);
insert into solar_power_plant (id_location, solar_type, total_area) values (62, 'Roof panel', 3101.98);
insert into solar_power_plant (id_location, solar_type, total_area) values (70, 'Mirror panel', 396.78);
insert into solar_power_plant (id_location, solar_type, total_area) values (4, 'Ground panel', 1046.26);
insert into solar_power_plant (id_location, solar_type, total_area) values (194, 'Mirror panel', 1484.1);
insert into solar_power_plant (id_location, solar_type, total_area) values (181, 'Ground panel', 2793.51);
insert into solar_power_plant (id_location, solar_type, total_area) values (28, 'Roof panel', 3105.83);
insert into solar_power_plant (id_location, solar_type, total_area) values (2, 'Roof panel', 2321.26);
insert into solar_power_plant (id_location, solar_type, total_area) values (150, 'Roof panel', 2018.21);
insert into solar_power_plant (id_location, solar_type, total_area) values (235, 'Roof panel', 1607.43);
insert into solar_power_plant (id_location, solar_type, total_area) values (210, 'Mirror panel', 653.44);
insert into solar_power_plant (id_location, solar_type, total_area) values (139, 'Roof panel', 4350.48);
insert into solar_power_plant (id_location, solar_type, total_area) values (27, 'Ground panel', 4435.9);
insert into solar_power_plant (id_location, solar_type, total_area) values (11, 'Mirror panel', 284.19);
insert into solar_power_plant (id_location, solar_type, total_area) values (225, 'Roof panel', 1461.69);
insert into solar_power_plant (id_location, solar_type, total_area) values (123, 'Ground panel', 1842.27);
insert into solar_power_plant (id_location, solar_type, total_area) values (134, 'Roof panel', 644.19);
insert into solar_power_plant (id_location, solar_type, total_area) values (39, 'Roof panel', 3019.43);
insert into solar_power_plant (id_location, solar_type, total_area) values (6, 'Ground panel', 2517.81);
insert into solar_power_plant (id_location, solar_type, total_area) values (154, 'Roof panel', 2377.35);
insert into solar_power_plant (id_location, solar_type, total_area) values (85, 'Mirror panel', 4046.51);
insert into solar_power_plant (id_location, solar_type, total_area) values (143, 'Ground panel', 4632.73);
insert into solar_power_plant (id_location, solar_type, total_area) values (148, 'Mirror panel', 1206.74);
insert into solar_power_plant (id_location, solar_type, total_area) values (72, 'Roof panel', 2346.28);
insert into solar_power_plant (id_location, solar_type, total_area) values (105, 'Ground panel', 2862.84);
insert into solar_power_plant (id_location, solar_type, total_area) values (21, 'Roof panel', 2599.62);
insert into solar_power_plant (id_location, solar_type, total_area) values (203, 'Ground panel', 48.95);
insert into solar_power_plant (id_location, solar_type, total_area) values (19, 'Roof panel', 262.08);
insert into solar_power_plant (id_location, solar_type, total_area) values (121, 'Mirror panel', 2309.95);
insert into solar_power_plant (id_location, solar_type, total_area) values (200, 'Ground panel', 4168.92);
insert into solar_power_plant (id_location, solar_type, total_area) values (5, 'Roof panel', 4874.33);
insert into solar_power_plant (id_location, solar_type, total_area) values (115, 'Mirror panel', 4379.86);
insert into solar_power_plant (id_location, solar_type, total_area) values (125, 'Ground panel', 1651.99);
insert into solar_power_plant (id_location, solar_type, total_area) values (219, 'Roof panel', 320.41);
insert into solar_power_plant (id_location, solar_type, total_area) values (165, 'Roof panel', 4693.88);
insert into solar_power_plant (id_location, solar_type, total_area) values (119, 'Mirror panel', 2235.51);
insert into solar_power_plant (id_location, solar_type, total_area) values (107, 'Mirror panel', 4591.24);
insert into solar_power_plant (id_location, solar_type, total_area) values (171, 'Mirror panel', 3738.33);
insert into solar_power_plant (id_location, solar_type, total_area) values (135, 'Mirror panel', 2585.53);
insert into solar_power_plant (id_location, solar_type, total_area) values (199, 'Ground panel', 1532.33);
insert into solar_power_plant (id_location, solar_type, total_area) values (238, 'Ground panel', 3083.96);
insert into solar_power_plant (id_location, solar_type, total_area) values (46, 'Roof panel', 3802.02);
insert into solar_power_plant (id_location, solar_type, total_area) values (185, 'Ground panel', 2856.25);
insert into solar_power_plant (id_location, solar_type, total_area) values (49, 'Mirror panel', 2251.41);
insert into solar_power_plant (id_location, solar_type, total_area) values (249, 'Mirror panel', 2407.52);
insert into solar_power_plant (id_location, solar_type, total_area) values (166, 'Ground panel', 2248.46);
insert into solar_power_plant (id_location, solar_type, total_area) values (124, 'Roof panel', 261.91);
insert into solar_power_plant (id_location, solar_type, total_area) values (82, 'Roof panel', 4104.2);
insert into solar_power_plant (id_location, solar_type, total_area) values (113, 'Ground panel', 1067.26);
insert into solar_power_plant (id_location, solar_type, total_area) values (245, 'Mirror panel', 423.49);
insert into solar_power_plant (id_location, solar_type, total_area) values (146, 'Roof panel', 1008.37);
insert into solar_power_plant (id_location, solar_type, total_area) values (112, 'Ground panel', 4573.86);
insert into solar_power_plant (id_location, solar_type, total_area) values (142, 'Roof panel', 3839.56);
insert into solar_power_plant (id_location, solar_type, total_area) values (196, 'Mirror panel', 1752.8);
insert into solar_power_plant (id_location, solar_type, total_area) values (198, 'Ground panel', 4902.34);
insert into solar_power_plant (id_location, solar_type, total_area) values (161, 'Roof panel', 4135.75);
insert into solar_power_plant (id_location, solar_type, total_area) values (76, 'Roof panel', 303.67);

-- table solar_panel
insert into solar_panel (id_solar, panel_power, panel_size) values (4, 153.61, 1209.8684);
insert into solar_panel (id_solar, panel_power, panel_size) values (40, 1778.6, 1479.9737);
insert into solar_panel (id_solar, panel_power, panel_size) values (63, 3684.91, 1432.2576);
insert into solar_panel (id_solar, panel_power, panel_size) values (79, 298.27, 2054.1235);
insert into solar_panel (id_solar, panel_power, panel_size) values (45, 3825.42, 3625.2109);
insert into solar_panel (id_solar, panel_power, panel_size) values (25, 1605.92, 3458.0129);
insert into solar_panel (id_solar, panel_power, panel_size) values (10, 770.71, 2900.833);
insert into solar_panel (id_solar, panel_power, panel_size) values (21, 1013.32, 2599.2126);
insert into solar_panel (id_solar, panel_power, panel_size) values (74, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (68, 3205.73, 1632.703);
insert into solar_panel (id_solar, panel_power, panel_size) values (80, 661.22, 4479.9555);
insert into solar_panel (id_solar, panel_power, panel_size) values (49, 2254.77, 1259.547);
insert into solar_panel (id_solar, panel_power, panel_size) values (40, 4385.32, 2115.3832);
insert into solar_panel (id_solar, panel_power, panel_size) values (14, 915.02, 3801.3658);
insert into solar_panel (id_solar, panel_power, panel_size) values (74, 3271.31, 2743.0377);
insert into solar_panel (id_solar, panel_power, panel_size) values (68, 409.04, 4491.4802);
insert into solar_panel (id_solar, panel_power, panel_size) values (38, 3169.17, 3625.9095);
insert into solar_panel (id_solar, panel_power, panel_size) values (64, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (35, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (33, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (34, 1232.6, 1298.1849);
insert into solar_panel (id_solar, panel_power, panel_size) values (70, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (35, 59.44, 1830.2148);
insert into solar_panel (id_solar, panel_power, panel_size) values (25, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (62, 4858.21, 3611.1969);
insert into solar_panel (id_solar, panel_power, panel_size) values (61, 3102.78, 4280.5786);
insert into solar_panel (id_solar, panel_power, panel_size) values (77, 927.55, 1205.9787);
insert into solar_panel (id_solar, panel_power, panel_size) values (41, 1120.94, 1492.8998);
insert into solar_panel (id_solar, panel_power, panel_size) values (13, 1145.22, 1768.736);
insert into solar_panel (id_solar, panel_power, panel_size) values (59, 3871.59, 2000.5837);
insert into solar_panel (id_solar, panel_power, panel_size) values (19, 3130.1, 274.175);
insert into solar_panel (id_solar, panel_power, panel_size) values (65, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (1, 774.35, 3740.9088);
insert into solar_panel (id_solar, panel_power, panel_size) values (36, 3460.79, 4603.6269);
insert into solar_panel (id_solar, panel_power, panel_size) values (4, 4378.61, 723.4142);
insert into solar_panel (id_solar, panel_power, panel_size) values (78, 129.37, 633.1775);
insert into solar_panel (id_solar, panel_power, panel_size) values (73, 1024.81, 1495.7866);
insert into solar_panel (id_solar, panel_power, panel_size) values (47, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (74, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (49, 2063.61, 1724.8217);
insert into solar_panel (id_solar, panel_power, panel_size) values (77, 2482.25, 3863.9171);
insert into solar_panel (id_solar, panel_power, panel_size) values (69, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (11, 2791.72, 2382.6096);
insert into solar_panel (id_solar, panel_power, panel_size) values (31, 3693.51, 614.4176);
insert into solar_panel (id_solar, panel_power, panel_size) values (52, 3189.13, 3311.5024);
insert into solar_panel (id_solar, panel_power, panel_size) values (9, 3698.21, 670.4834);
insert into solar_panel (id_solar, panel_power, panel_size) values (16, 1329.48, 3338.3647);
insert into solar_panel (id_solar, panel_power, panel_size) values (46, 1192.83, 289.8647);
insert into solar_panel (id_solar, panel_power, panel_size) values (34, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (5, 4688.06, 4711.3125);
insert into solar_panel (id_solar, panel_power, panel_size) values (19, 1944.89, 71.0824);
insert into solar_panel (id_solar, panel_power, panel_size) values (79, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (36, 3066.69, 3521.9652);
insert into solar_panel (id_solar, panel_power, panel_size) values (68, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (63, 2516.18, 2919.3796);
insert into solar_panel (id_solar, panel_power, panel_size) values (40, 627.23, 2092.7659);
insert into solar_panel (id_solar, panel_power, panel_size) values (20, 3351.68, 293.2993);
insert into solar_panel (id_solar, panel_power, panel_size) values (61, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (68, 935.13, 319.7573);
insert into solar_panel (id_solar, panel_power, panel_size) values (67, 4278.36, 214.0678);
insert into solar_panel (id_solar, panel_power, panel_size) values (43, 3832.78, 4344.4579);
insert into solar_panel (id_solar, panel_power, panel_size) values (55, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (40, 1294.79, 4336.2436);
insert into solar_panel (id_solar, panel_power, panel_size) values (44, 446.21, 2722.477);
insert into solar_panel (id_solar, panel_power, panel_size) values (69, 4344.9, 1674.8792);
insert into solar_panel (id_solar, panel_power, panel_size) values (40, 993.79, 4456.4633);
insert into solar_panel (id_solar, panel_power, panel_size) values (69, 3437.24, 4693.5729);
insert into solar_panel (id_solar, panel_power, panel_size) values (36, 820.95, 3972.5058);
insert into solar_panel (id_solar, panel_power, panel_size) values (58, 2527.57, 2527.3623);
insert into solar_panel (id_solar, panel_power, panel_size) values (78, 2931.82, 795.4645);
insert into solar_panel (id_solar, panel_power, panel_size) values (47, 2567.79, 3852.7945);
insert into solar_panel (id_solar, panel_power, panel_size) values (13, 1319.6, 3196.6873);
insert into solar_panel (id_solar, panel_power, panel_size) values (57, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (63, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (10, 1496.41, 90.2026);
insert into solar_panel (id_solar, panel_power, panel_size) values (30, 1661.58, 1034.6012);
insert into solar_panel (id_solar, panel_power, panel_size) values (6, 804.05, 2413.2999);
insert into solar_panel (id_solar, panel_power, panel_size) values (73, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (52, 2588.84, 311.8193);
insert into solar_panel (id_solar, panel_power, panel_size) values (63, 3220.34, 4399.5569);
insert into solar_panel (id_solar, panel_power, panel_size) values (33, 9.22, 75.1627);
insert into solar_panel (id_solar, panel_power, panel_size) values (2, 271.98, 3776.5537);
insert into solar_panel (id_solar, panel_power, panel_size) values (14, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (7, 1282.19, 183.0341);
insert into solar_panel (id_solar, panel_power, panel_size) values (53, null, null);
insert into solar_panel (id_solar, panel_power, panel_size) values (18, 2762.85, 3949.0925);

-- table wind_power_plant
insert into wind_power_plant (id_location, total_area) values (166, 1428.77);
insert into wind_power_plant (id_location, total_area) values (24, 432.68);
insert into wind_power_plant (id_location, total_area) values (37, 4108.42);
insert into wind_power_plant (id_location, total_area) values (229, 1096.87);
insert into wind_power_plant (id_location, total_area) values (184, 180.78);
insert into wind_power_plant (id_location, total_area) values (8, 956.16);
insert into wind_power_plant (id_location, total_area) values (78, 1834.45);
insert into wind_power_plant (id_location, total_area) values (148, 2503.16);
insert into wind_power_plant (id_location, total_area) values (109, 1973.57);
insert into wind_power_plant (id_location, total_area) values (216, 2576.17);
insert into wind_power_plant (id_location, total_area) values (180, 1665.46);
insert into wind_power_plant (id_location, total_area) values (151, 4757.93);
insert into wind_power_plant (id_location, total_area) values (17, 3748.47);
insert into wind_power_plant (id_location, total_area) values (121, 4771.1);
insert into wind_power_plant (id_location, total_area) values (190, 239.72);
insert into wind_power_plant (id_location, total_area) values (84, 4779.46);
insert into wind_power_plant (id_location, total_area) values (126, 1157.33);
insert into wind_power_plant (id_location, total_area) values (48, 2047.64);
insert into wind_power_plant (id_location, total_area) values (188, 3251.88);
insert into wind_power_plant (id_location, total_area) values (57, 4043.85);
insert into wind_power_plant (id_location, total_area) values (103, 756.26);
insert into wind_power_plant (id_location, total_area) values (11, 2846.73);
insert into wind_power_plant (id_location, total_area) values (88, 3167.47);
insert into wind_power_plant (id_location, total_area) values (41, 622.93);
insert into wind_power_plant (id_location, total_area) values (58, 1615.49);
insert into wind_power_plant (id_location, total_area) values (50, 31.02);
insert into wind_power_plant (id_location, total_area) values (141, 2351.99);
insert into wind_power_plant (id_location, total_area) values (29, 3136.26);
insert into wind_power_plant (id_location, total_area) values (100, 3519.17);
insert into wind_power_plant (id_location, total_area) values (123, 1464.99);
insert into wind_power_plant (id_location, total_area) values (176, 4783.33);
insert into wind_power_plant (id_location, total_area) values (209, 3550.19);
insert into wind_power_plant (id_location, total_area) values (189, 1693.18);
insert into wind_power_plant (id_location, total_area) values (96, 626.99);
insert into wind_power_plant (id_location, total_area) values (106, 3772.06);
insert into wind_power_plant (id_location, total_area) values (171, 3265.23);
insert into wind_power_plant (id_location, total_area) values (117, 191.89);
insert into wind_power_plant (id_location, total_area) values (233, 4823.14);
insert into wind_power_plant (id_location, total_area) values (129, 2716.11);
insert into wind_power_plant (id_location, total_area) values (27, 2992.78);
insert into wind_power_plant (id_location, total_area) values (241, 3940.01);
insert into wind_power_plant (id_location, total_area) values (108, 529.68);
insert into wind_power_plant (id_location, total_area) values (150, 3836.19);
insert into wind_power_plant (id_location, total_area) values (169, 2058.96);
insert into wind_power_plant (id_location, total_area) values (219, 3670.08);
insert into wind_power_plant (id_location, total_area) values (182, 1794.79);
insert into wind_power_plant (id_location, total_area) values (101, 4496.33);
insert into wind_power_plant (id_location, total_area) values (95, 2264.53);
insert into wind_power_plant (id_location, total_area) values (45, 3984.47);
insert into wind_power_plant (id_location, total_area) values (234, 497.53);
insert into wind_power_plant (id_location, total_area) values (71, 1652.85);
insert into wind_power_plant (id_location, total_area) values (39, 4183.46);
insert into wind_power_plant (id_location, total_area) values (40, 1682.45);
insert into wind_power_plant (id_location, total_area) values (168, 1364.14);
insert into wind_power_plant (id_location, total_area) values (47, 41.01);
insert into wind_power_plant (id_location, total_area) values (214, 2224.12);
insert into wind_power_plant (id_location, total_area) values (61, 730.44);
insert into wind_power_plant (id_location, total_area) values (208, 426.37);
insert into wind_power_plant (id_location, total_area) values (135, 1409.49);
insert into wind_power_plant (id_location, total_area) values (76, 518.74);
insert into wind_power_plant (id_location, total_area) values (231, 638.23);
insert into wind_power_plant (id_location, total_area) values (177, 3431.86);
insert into wind_power_plant (id_location, total_area) values (232, 218.39);
insert into wind_power_plant (id_location, total_area) values (211, 3345.61);
insert into wind_power_plant (id_location, total_area) values (157, 1601.92);
insert into wind_power_plant (id_location, total_area) values (22, 2251.46);
insert into wind_power_plant (id_location, total_area) values (167, 5.87);
insert into wind_power_plant (id_location, total_area) values (44, 1523.84);
insert into wind_power_plant (id_location, total_area) values (218, 4591.5);
insert into wind_power_plant (id_location, total_area) values (116, 1513.84);
insert into wind_power_plant (id_location, total_area) values (65, 1659.98);
insert into wind_power_plant (id_location, total_area) values (25, 899.66);
insert into wind_power_plant (id_location, total_area) values (203, 758.81);
insert into wind_power_plant (id_location, total_area) values (38, 2910.44);
insert into wind_power_plant (id_location, total_area) values (236, 1492.14);
insert into wind_power_plant (id_location, total_area) values (87, 684.87);
insert into wind_power_plant (id_location, total_area) values (33, 1049.76);
insert into wind_power_plant (id_location, total_area) values (185, 2799.03);
insert into wind_power_plant (id_location, total_area) values (112, 4431.58);
insert into wind_power_plant (id_location, total_area) values (56, 4980.11);
insert into wind_power_plant (id_location, total_area) values (70, 3187.23);
insert into wind_power_plant (id_location, total_area) values (206, 1709.81);
insert into wind_power_plant (id_location, total_area) values (220, 1195.17);

-- table wind_turbine
insert into wind_turbine (id_wind, wind_turbine_power, height) values (35, 471.06, 311.89);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (75, 1377.17, 177.97);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (23, 1665.34, 35.9);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (82, 2937.96, 466.06);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (52, 2705.36, 98.63);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (51, 2967.91, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (13, 2804.63, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (42, 325.88, 395.07);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (62, null, 172.12);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (38, 1110.11, 452.54);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (38, null, 189.49);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (44, 2295.92, 184.59);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (5, 2940.36, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (5, 2208.16, 119.67);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (80, 2033.94, 375.45);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (62, null, 409.09);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (7, 1122.91, 470.77);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (23, null, 183.03);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (38, 1910.33, 103.49);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (40, 2067.21, 13.7);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (80, 52.77, 221.23);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (12, 2547.64, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (54, 2452.06, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (36, 1694.57, 396.32);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (47, 2117.47, 350.04);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (27, null, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (58, 1005.1, 398.07);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (12, 2508.1, 170.15);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (54, 115.95, 293.21);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (9, 1289.7, 149.34);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (70, 1360.81, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (66, 1348.37, 362.02);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (48, 218.64, 236.95);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (47, null, 253.95);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (4, 2827.86, 291.46);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (45, null, 124.55);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (54, 1535.07, 354.67);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (51, null, 187.83);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (30, 18.58, 496.69);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (64, null, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (29, 2853.29, 460.83);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (16, 1502.74, 27.37);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (32, 2761.2, 405.29);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (10, null, 33.54);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (56, 1100.3, 422.0);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (29, 1191.99, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (78, 1387.98, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (82, 1556.78, 265.54);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (10, 2478.71, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (1, null, 203.48);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (72, 2310.08, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (49, 262.47, 423.66);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (83, 2332.08, 399.39);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (76, 2930.33, 233.53);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (32, 1481.57, 142.28);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (14, 2276.3, 394.63);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (16, 745.99, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (15, 1046.88, 241.51);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (1, 2142.49, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (53, null, 254.01);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (79, 1545.8, 234.55);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (23, 1686.09, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (61, 2106.4, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (10, 972.84, 488.52);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (74, 2859.67, 279.82);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (56, null, 472.29);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (1, 211.86, 469.13);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (21, 294.63, 431.96);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (10, null, 420.54);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (43, 1948.5, 190.47);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (36, 1073.29, 368.47);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (9, 599.22, 141.26);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (17, 136.09, 262.92);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (79, 178.15, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (72, 2003.64, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (30, 634.23, 340.61);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (9, 1521.04, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (21, 1530.38, null);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (15, null, 215.04);
insert into wind_turbine (id_wind, wind_turbine_power, height) values (17, 845.02, 237.96);

-- table river
insert into river (river_id_river, lowest_point, flow_rate) values (null, 60.71, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (null, 560.34, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (null, 383.09, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (null, 19.71, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (1, 260.82, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (2, 785.42, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (3, 400.02, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (4, 639.79, 338984.37);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 397.73, 14651.18);
insert into river (river_id_river, lowest_point, flow_rate) values (6, 1024.38, 441684.92);
insert into river (river_id_river, lowest_point, flow_rate) values (7, 535.42, 392004.73);
insert into river (river_id_river, lowest_point, flow_rate) values (7, 1034.85, 384483.04);
insert into river (river_id_river, lowest_point, flow_rate) values (10, 1076.04, 23302.1);
insert into river (river_id_river, lowest_point, flow_rate) values (11, 905.5, 389305.34);
insert into river (river_id_river, lowest_point, flow_rate) values (12, 1104.64, 365231.86);
insert into river (river_id_river, lowest_point, flow_rate) values (12, 1225.97, 85437.65);
insert into river (river_id_river, lowest_point, flow_rate) values (14, 1341.94, 91127.71);
insert into river (river_id_river, lowest_point, flow_rate) values (14, 1481.85, 162746.38);
insert into river (river_id_river, lowest_point, flow_rate) values (16, 1560.62, 41671.49);
insert into river (river_id_river, lowest_point, flow_rate) values (16, 1629.7, 326729.8);
insert into river (river_id_river, lowest_point, flow_rate) values (16, 1778.95, 389802.88);
insert into river (river_id_river, lowest_point, flow_rate) values (17, 1866.98, 51989.87);
insert into river (river_id_river, lowest_point, flow_rate) values (17, 1929.28, 67903.33);
insert into river (river_id_river, lowest_point, flow_rate) values (17, 2079.11, 440031.77);
insert into river (river_id_river, lowest_point, flow_rate) values (17, 2403.05, 480848.23);
insert into river (river_id_river, lowest_point, flow_rate) values (17, 2433.47, 105885.82);
insert into river (river_id_river, lowest_point, flow_rate) values (19, 2436.9, null);
insert into river (river_id_river, lowest_point, flow_rate) values (22, 2453.34, 76602.14);
insert into river (river_id_river, lowest_point, flow_rate) values (22, 2478.28, null);
insert into river (river_id_river, lowest_point, flow_rate) values (23, 2506.46, 367329.93);
insert into river (river_id_river, lowest_point, flow_rate) values (24, 2576.73, 13636.22);
insert into river (river_id_river, lowest_point, flow_rate) values (25, 2615.87, null);
insert into river (river_id_river, lowest_point, flow_rate) values (25, 2677.83, 473568.05);
insert into river (river_id_river, lowest_point, flow_rate) values (26, 2682.57, 99299.48);
insert into river (river_id_river, lowest_point, flow_rate) values (26, 2694.93, 453267.72);
insert into river (river_id_river, lowest_point, flow_rate) values (27, 2700.94, 33851.1);
insert into river (river_id_river, lowest_point, flow_rate) values (28, 2701.01, 163306.75);
insert into river (river_id_river, lowest_point, flow_rate) values (30, 2807.7, 216567.0);
insert into river (river_id_river, lowest_point, flow_rate) values (1, 2813.06, 135085.64);
insert into river (river_id_river, lowest_point, flow_rate) values (1, 2885.83, null);
insert into river (river_id_river, lowest_point, flow_rate) values (3, 2979.92, 180185.65);
insert into river (river_id_river, lowest_point, flow_rate) values (4, 3078.59, 182022.66);
insert into river (river_id_river, lowest_point, flow_rate) values (34, 3150.96, null);
insert into river (river_id_river, lowest_point, flow_rate) values (34, 3154.43, null);
insert into river (river_id_river, lowest_point, flow_rate) values (35, 3224.56, 221558.36);
insert into river (river_id_river, lowest_point, flow_rate) values (6, 3279.83, null);
insert into river (river_id_river, lowest_point, flow_rate) values (37, 3318.97, null);
insert into river (river_id_river, lowest_point, flow_rate) values (7, 3204.61, 22854.77);
insert into river (river_id_river, lowest_point, flow_rate) values (7, 3208.26, 427243.91);
insert into river (river_id_river, lowest_point, flow_rate) values (39, 3264.86, 480517.0);
insert into river (river_id_river, lowest_point, flow_rate) values (9, 3255.3, 487262.07);
insert into river (river_id_river, lowest_point, flow_rate) values (1, 3287.11, 460280.11);
insert into river (river_id_river, lowest_point, flow_rate) values (40, 3226.83, 424513.71);
insert into river (river_id_river, lowest_point, flow_rate) values (46, 3281.91, 39684.01);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 3247.48, 72764.41);
insert into river (river_id_river, lowest_point, flow_rate) values (49, 3292.53, null);
insert into river (river_id_river, lowest_point, flow_rate) values (45, 3256.64, 238453.94);
insert into river (river_id_river, lowest_point, flow_rate) values (49, 3248.03, null);
insert into river (river_id_river, lowest_point, flow_rate) values (49, 3261.43, 484918.0);
insert into river (river_id_river, lowest_point, flow_rate) values (49, 3360.57, null);
insert into river (river_id_river, lowest_point, flow_rate) values (6, 3333.39, 188273.79);
insert into river (river_id_river, lowest_point, flow_rate) values (55, 3325.18, null);
insert into river (river_id_river, lowest_point, flow_rate) values (58, 3372.76, 84954.0);
insert into river (river_id_river, lowest_point, flow_rate) values (3, 3366.26, null);
insert into river (river_id_river, lowest_point, flow_rate) values (51, 3446.93, null);
insert into river (river_id_river, lowest_point, flow_rate) values (6, 858.66, 234938.12);
insert into river (river_id_river, lowest_point, flow_rate) values (58, 3356.27, 215405.0);
insert into river (river_id_river, lowest_point, flow_rate) values (58, 3401.15, 114603.89);
insert into river (river_id_river, lowest_point, flow_rate) values (4, 3409.66, null);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 822.67, 23620.92);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 832.43, 195711.88);
insert into river (river_id_river, lowest_point, flow_rate) values (52, 3463.35, 151840.92);
insert into river (river_id_river, lowest_point, flow_rate) values (4, 3470.02, null);
insert into river (river_id_river, lowest_point, flow_rate) values (63, 3454.45, 472818.44);
insert into river (river_id_river, lowest_point, flow_rate) values (64, 3436.4, 275352.83);
insert into river (river_id_river, lowest_point, flow_rate) values (64, 3566.65, 494449.26);
insert into river (river_id_river, lowest_point, flow_rate) values (2, 3586.71, 392687.98);
insert into river (river_id_river, lowest_point, flow_rate) values (69, 3530.56, 216883.56);
insert into river (river_id_river, lowest_point, flow_rate) values (63, 3526.93, 76994.68);
insert into river (river_id_river, lowest_point, flow_rate) values (63, 3509.49, 424069.53);
insert into river (river_id_river, lowest_point, flow_rate) values (2, 3515.41, 470186.45);
insert into river (river_id_river, lowest_point, flow_rate) values (64, 3623.57, 394105.93);
insert into river (river_id_river, lowest_point, flow_rate) values (66, 3681.22, 481185.44);
insert into river (river_id_river, lowest_point, flow_rate) values (8, 3654.05, 21058.96);
insert into river (river_id_river, lowest_point, flow_rate) values (70, 3638.25, 123337.83);
insert into river (river_id_river, lowest_point, flow_rate) values (74, 3743.39, 373984.91);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 3743.78, null);
insert into river (river_id_river, lowest_point, flow_rate) values (2, 3729.9, 478256.74);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 3734.6, null);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 3754.03, 488006.65);
insert into river (river_id_river, lowest_point, flow_rate) values (72, 3748.76, null);
insert into river (river_id_river, lowest_point, flow_rate) values (85, 3765.9, 173010.7);
insert into river (river_id_river, lowest_point, flow_rate) values (4, 3714.41, 214869.53);
insert into river (river_id_river, lowest_point, flow_rate) values (1, 3850.63, 282334.62);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 3809.23, 469287.77);
insert into river (river_id_river, lowest_point, flow_rate) values (6, 3861.33, null);
insert into river (river_id_river, lowest_point, flow_rate) values (9, 3898.93, 14043.98);
insert into river (river_id_river, lowest_point, flow_rate) values (5, 3863.22, 160343.88);
insert into river (river_id_river, lowest_point, flow_rate) values (93, 3911.2, 279230.27);
insert into river (river_id_river, lowest_point, flow_rate) values (9, 3937.29, 396594.36);
insert into river (river_id_river, lowest_point, flow_rate) values (97, 3927.63, null);
insert into river (river_id_river, lowest_point, flow_rate) values (93, 3993.18, 184167.8);
insert into river (river_id_river, lowest_point, flow_rate) values (9, 3964.7, 10506.55);
insert into river (river_id_river, lowest_point, flow_rate) values (95, 4041.84, 8016.72);
insert into river (river_id_river, lowest_point, flow_rate) values (94, 4082.04, 328688.16);
insert into river (river_id_river, lowest_point, flow_rate) values (99, 4092.54, 24043.63);
insert into river (river_id_river, lowest_point, flow_rate) values (1, 4038.33, 402290.04);
insert into river (river_id_river, lowest_point, flow_rate) values (102, 4134.9, 403614.87);
insert into river (river_id_river, lowest_point, flow_rate) values (103, 4136.72, 27334.92);
insert into river (river_id_river, lowest_point, flow_rate) values (105, 4120.5, 313829.76);
insert into river (river_id_river, lowest_point, flow_rate) values (105, 4118.86, null);
insert into river (river_id_river, lowest_point, flow_rate) values (105, 4199.48, 136946.62);
insert into river (river_id_river, lowest_point, flow_rate) values (108, 4135.42, 252621.49);
insert into river (river_id_river, lowest_point, flow_rate) values (11, 4192.15, 243222.61);
insert into river (river_id_river, lowest_point, flow_rate) values (111, 4119.12, 47077.31);
insert into river (river_id_river, lowest_point, flow_rate) values (112, 4200.04, null);
insert into river (river_id_river, lowest_point, flow_rate) values (112, 4200.48, 416327.31);
insert into river (river_id_river, lowest_point, flow_rate) values (113, 4195.08, null);
insert into river (river_id_river, lowest_point, flow_rate) values (113, 4218.3, null);
insert into river (river_id_river, lowest_point, flow_rate) values (113, 4237.86, 195643.57);
insert into river (river_id_river, lowest_point, flow_rate) values (115, 4214.5, null);
insert into river (river_id_river, lowest_point, flow_rate) values (116, 4220.13, 88702.14);
insert into river (river_id_river, lowest_point, flow_rate) values (119, 4265.77, 153591.66);
insert into river (river_id_river, lowest_point, flow_rate) values (122, 4303.07, null);
insert into river (river_id_river, lowest_point, flow_rate) values (123, 4381.1, 25586.12);
insert into river (river_id_river, lowest_point, flow_rate) values (124, 4357.49, 174028.28);
insert into river (river_id_river, lowest_point, flow_rate) values (124, 4314.34, 275289.27);
insert into river (river_id_river, lowest_point, flow_rate) values (124, 4430.9, 487124.91);
insert into river (river_id_river, lowest_point, flow_rate) values (125, 4436.71, 255204.98);
insert into river (river_id_river, lowest_point, flow_rate) values (126, 4444.44, 51992.45);
insert into river (river_id_river, lowest_point, flow_rate) values (126, 4499.99, 201597.85);
insert into river (river_id_river, lowest_point, flow_rate) values (127, 4526.76, null);
insert into river (river_id_river, lowest_point, flow_rate) values (128, 4547.65, null);
insert into river (river_id_river, lowest_point, flow_rate) values (129, 4562.38, 367614.95);
insert into river (river_id_river, lowest_point, flow_rate) values (130, 4697.95, 425741.77);
insert into river (river_id_river, lowest_point, flow_rate) values (131, 4678.87, 373916.93);
insert into river (river_id_river, lowest_point, flow_rate) values (132, 4750.01, null);
insert into river (river_id_river, lowest_point, flow_rate) values (133, 4854.9, 297105.85);
insert into river (river_id_river, lowest_point, flow_rate) values (134, 4896.57, 384820.41);
insert into river (river_id_river, lowest_point, flow_rate) values (136, 4827.85, null);
insert into river (river_id_river, lowest_point, flow_rate) values (137, 4885.46, 409178.68);
insert into river (river_id_river, lowest_point, flow_rate) values (137, 4884.85, 88634.05);
insert into river (river_id_river, lowest_point, flow_rate) values (140, 4946.18, null);
insert into river (river_id_river, lowest_point, flow_rate) values (140, 4965.83, 305277.9);
insert into river (river_id_river, lowest_point, flow_rate) values (142, 4930.82, 94066.18);
insert into river (river_id_river, lowest_point, flow_rate) values (143, 4986.1, 345.63);
insert into river (river_id_river, lowest_point, flow_rate) values (144, 4966.44, null);
insert into river (river_id_river, lowest_point, flow_rate) values (145, 4977.45, 382171.55);
insert into river (river_id_river, lowest_point, flow_rate) values (146, 5029.08, 193728.22);
insert into river (river_id_river, lowest_point, flow_rate) values (147, 5011.6, 345097.62);
insert into river (river_id_river, lowest_point, flow_rate) values (149, 5030.89, 395321.59);
insert into river (river_id_river, lowest_point, flow_rate) values (150, 5100.26, null);
insert into river (river_id_river, lowest_point, flow_rate) values (151, 5220.82, 380289.01);
insert into river (river_id_river, lowest_point, flow_rate) values (152, 5273.98, 406856.0);
insert into river (river_id_river, lowest_point, flow_rate) values (153, 5225.72, 70433.82);
insert into river (river_id_river, lowest_point, flow_rate) values (155, 5268.87, null);
insert into river (river_id_river, lowest_point, flow_rate) values (156, 5367.47, 462641.49);
insert into river (river_id_river, lowest_point, flow_rate) values (156, 5353.52, 1840.5);
insert into river (river_id_river, lowest_point, flow_rate) values (156, 5374.25, 63571.75);
insert into river (river_id_river, lowest_point, flow_rate) values (157, 5451.89, 242470.52);
insert into river (river_id_river, lowest_point, flow_rate) values (159, 5474.92, 472974.89);
insert into river (river_id_river, lowest_point, flow_rate) values (160, 5477.4, 344289.71);
insert into river (river_id_river, lowest_point, flow_rate) values (160, 5457.26, 386611.9);
insert into river (river_id_river, lowest_point, flow_rate) values (161, 5586.6, null);
insert into river (river_id_river, lowest_point, flow_rate) values (162, 5516.0, 366035.02);
insert into river (river_id_river, lowest_point, flow_rate) values (164, 5603.06, 165550.76);
insert into river (river_id_river, lowest_point, flow_rate) values (166, 5604.51, 276203.59);
insert into river (river_id_river, lowest_point, flow_rate) values (160, 5653.83, 483489.0);
insert into river (river_id_river, lowest_point, flow_rate) values (154, 5773.33, 98492.06);
insert into river (river_id_river, lowest_point, flow_rate) values (168, 5791.27, 109346.04);
insert into river (river_id_river, lowest_point, flow_rate) values (165, 5878.25, null);
insert into river (river_id_river, lowest_point, flow_rate) values (152, 5858.18, 140933.54);
insert into river (river_id_river, lowest_point, flow_rate) values (157, 5955.64, 73068.38);
insert into river (river_id_river, lowest_point, flow_rate) values (167, 5938.66, 269684.16);
insert into river (river_id_river, lowest_point, flow_rate) values (153, 5918.96, 106097.18);
insert into river (river_id_river, lowest_point, flow_rate) values (159, 5975.44, 303031.33);
insert into river (river_id_river, lowest_point, flow_rate) values (168, 6080.15, 22860.68);
insert into river (river_id_river, lowest_point, flow_rate) values (167, 6072.99, 421236.5);
insert into river (river_id_river, lowest_point, flow_rate) values (169, 6069.65, 307121.43);
insert into river (river_id_river, lowest_point, flow_rate) values (158, 6051.97, 239419.21);
insert into river (river_id_river, lowest_point, flow_rate) values (164, 6066.57, 442033.46);
insert into river (river_id_river, lowest_point, flow_rate) values (153, 6165.18, 120102.24);
insert into river (river_id_river, lowest_point, flow_rate) values (168, 6150.13, 486733.52);
insert into river (river_id_river, lowest_point, flow_rate) values (159, 6177.98, 290370.84);
insert into river (river_id_river, lowest_point, flow_rate) values (168, 6126.43, 9029.09);
insert into river (river_id_river, lowest_point, flow_rate) values (167, 6190.2, null);
insert into river (river_id_river, lowest_point, flow_rate) values (158, 6214.16, null);
insert into river (river_id_river, lowest_point, flow_rate) values (156, 6291.58, 284436.35);
insert into river (river_id_river, lowest_point, flow_rate) values (152, 6241.49, 146363.42);
insert into river (river_id_river, lowest_point, flow_rate) values (165, 6291.3, 233449.27);
insert into river (river_id_river, lowest_point, flow_rate) values (164, 6304.14, null);
insert into river (river_id_river, lowest_point, flow_rate) values (151, 6300.24, 41407.65);
insert into river (river_id_river, lowest_point, flow_rate) values (159, 6333.3, null);
insert into river (river_id_river, lowest_point, flow_rate) values (165, 6355.47, 399763.11);
insert into river (river_id_river, lowest_point, flow_rate) values (151, 6402.21, 206786.75);
insert into river (river_id_river, lowest_point, flow_rate) values (174, 6493.74, 437739.48);
insert into river (river_id_river, lowest_point, flow_rate) values (179, 6499.68, null);
insert into river (river_id_river, lowest_point, flow_rate) values (177, 6558.66, 368724.95);
insert into river (river_id_river, lowest_point, flow_rate) values (198, 6568.88, 180417.03);
insert into river (river_id_river, lowest_point, flow_rate) values (185, 6567.21, 244950.12);
insert into river (river_id_river, lowest_point, flow_rate) values (188, 6563.34, null);
insert into river (river_id_river, lowest_point, flow_rate) values (173, 6565.96, 421582.91);
insert into river (river_id_river, lowest_point, flow_rate) values (173, 6666.71, 80932.53);
insert into river (river_id_river, lowest_point, flow_rate) values (170, 6655.15, 234713.83);
insert into river (river_id_river, lowest_point, flow_rate) values (182, 6659.04, 204767.59);
insert into river (river_id_river, lowest_point, flow_rate) values (191, 6654.26, 390340.94);
insert into river (river_id_river, lowest_point, flow_rate) values (190, 6680.93, 428136.67);
insert into river (river_id_river, lowest_point, flow_rate) values (180, 6797.53, 170962.57);
insert into river (river_id_river, lowest_point, flow_rate) values (187, 6786.73, null);
insert into river (river_id_river, lowest_point, flow_rate) values (199, 6748.03, null);
insert into river (river_id_river, lowest_point, flow_rate) values (194, 6729.71, 157834.35);
insert into river (river_id_river, lowest_point, flow_rate) values (187, 6785.4, 499419.14);
insert into river (river_id_river, lowest_point, flow_rate) values (189, 6876.19, 439692.69);
insert into river (river_id_river, lowest_point, flow_rate) values (198, 6852.97, 471265.86);
insert into river (river_id_river, lowest_point, flow_rate) values (178, 6845.48, 172562.0);
insert into river (river_id_river, lowest_point, flow_rate) values (197, 6896.83, 258533.21);
insert into river (river_id_river, lowest_point, flow_rate) values (170, 6992.12, 359434.99);
insert into river (river_id_river, lowest_point, flow_rate) values (191, 7000.55, null);
insert into river (river_id_river, lowest_point, flow_rate) values (199, 7062.36, null);
insert into river (river_id_river, lowest_point, flow_rate) values (172, 7051.66, null);
insert into river (river_id_river, lowest_point, flow_rate) values (194, 7000.71, null);
insert into river (river_id_river, lowest_point, flow_rate) values (188, 7019.79, 452351.91);
insert into river (river_id_river, lowest_point, flow_rate) values (180, 7101.06, 59108.56);
insert into river (river_id_river, lowest_point, flow_rate) values (200, 7124.41, 152489.14);
insert into river (river_id_river, lowest_point, flow_rate) values (195, 7198.27, 498273.92);
insert into river (river_id_river, lowest_point, flow_rate) values (185, 7120.12, 128279.39);
insert into river (river_id_river, lowest_point, flow_rate) values (194, 7187.13, null);
insert into river (river_id_river, lowest_point, flow_rate) values (173, 7173.21, null);
insert into river (river_id_river, lowest_point, flow_rate) values (180, 7161.03, 263496.53);
insert into river (river_id_river, lowest_point, flow_rate) values (189, 7164.42, 351710.89);
insert into river (river_id_river, lowest_point, flow_rate) values (185, 7122.61, 361090.82);
insert into river (river_id_river, lowest_point, flow_rate) values (171, 7176.5, 73693.13);
insert into river (river_id_river, lowest_point, flow_rate) values (197, 7191.38, 44449.08);
insert into river (river_id_river, lowest_point, flow_rate) values (173, 7222.6, 25603.63);
insert into river (river_id_river, lowest_point, flow_rate) values (199, 7288.84, 473391.53);
insert into river (river_id_river, lowest_point, flow_rate) values (156, 7224.98, 266561.75);
insert into river (river_id_river, lowest_point, flow_rate) values (200, 7249.81, 217465.52);
insert into river (river_id_river, lowest_point, flow_rate) values (163, 7349.79, 290100.34);
insert into river (river_id_river, lowest_point, flow_rate) values (191, 7388.96, 359854.99);
insert into river (river_id_river, lowest_point, flow_rate) values (189, 7360.35, 105628.8);
insert into river (river_id_river, lowest_point, flow_rate) values (181, 7382.32, 371287.21);
insert into river (river_id_river, lowest_point, flow_rate) values (159, 7415.16, 15745.29);
insert into river (river_id_river, lowest_point, flow_rate) values (165, 7463.83, 111608.69);
insert into river (river_id_river, lowest_point, flow_rate) values (160, 7435.39, null);
insert into river (river_id_river, lowest_point, flow_rate) values (160, 7482.04, null);
insert into river (river_id_river, lowest_point, flow_rate) values (159, 7562.84, 110134.4);
insert into river (river_id_river, lowest_point, flow_rate) values (150, 7555.07, 377522.85);
insert into river (river_id_river, lowest_point, flow_rate) values (157, 7569.93, 413745.64);
insert into river (river_id_river, lowest_point, flow_rate) values (163, 7531.07, 154415.35);
insert into river (river_id_river, lowest_point, flow_rate) values (188, 7601.25, 431763.36);
insert into river (river_id_river, lowest_point, flow_rate) values (194, 7662.04, 138620.63);
insert into river (river_id_river, lowest_point, flow_rate) values (177, 7700.97, 289359.63);
insert into river (river_id_river, lowest_point, flow_rate) values (187, 7889.97, null);
insert into river (river_id_river, lowest_point, flow_rate) values (196, 7879.01, 397315.58);
insert into river (river_id_river, lowest_point, flow_rate) values (155, 7891.99, 483004.34);
insert into river (river_id_river, lowest_point, flow_rate) values (183, 7814.95, 235349.89);
insert into river (river_id_river, lowest_point, flow_rate) values (153, 7807.47, null);
insert into river (river_id_river, lowest_point, flow_rate) values (193, 7943.53, null);
insert into river (river_id_river, lowest_point, flow_rate) values (173, 7959.98, 59599.87);
insert into river (river_id_river, lowest_point, flow_rate) values (171, 7913.85, 309596.0);
insert into river (river_id_river, lowest_point, flow_rate) values (166, 7969.28, null);
insert into river (river_id_river, lowest_point, flow_rate) values (171, 7990.57, null);
insert into river (river_id_river, lowest_point, flow_rate) values (192, 7926.89, 73070.09);
insert into river (river_id_river, lowest_point, flow_rate) values (164, 8065.5, null);
insert into river (river_id_river, lowest_point, flow_rate) values (173, 8012.79, 150032.69);
insert into river (river_id_river, lowest_point, flow_rate) values (158, 8029.37, 365730.96);

-- table reservoir
insert into reservoir (id_river, capacity) values (31, 857768);
insert into reservoir (id_river, capacity) values (145, 296093);
insert into reservoir (id_river, capacity) values (16, 822276);
insert into reservoir (id_river, capacity) values (147, 114593);
insert into reservoir (id_river, capacity) values (127, 26417);
insert into reservoir (id_river, capacity) values (48, 589441);
insert into reservoir (id_river, capacity) values (88, 735538);
insert into reservoir (id_river, capacity) values (9, null);
insert into reservoir (id_river, capacity) values (126, 200202);
insert into reservoir (id_river, capacity) values (55, 274811);
insert into reservoir (id_river, capacity) values (121, 60855);
insert into reservoir (id_river, capacity) values (73, 894475);
insert into reservoir (id_river, capacity) values (45, 535686);
insert into reservoir (id_river, capacity) values (30, 354738);
insert into reservoir (id_river, capacity) values (102, 737874);
insert into reservoir (id_river, capacity) values (118, 308141);
insert into reservoir (id_river, capacity) values (130, 597448);
insert into reservoir (id_river, capacity) values (63, 728801);
insert into reservoir (id_river, capacity) values (24, 780557);
insert into reservoir (id_river, capacity) values (70, 721304);
insert into reservoir (id_river, capacity) values (150, 810403);
insert into reservoir (id_river, capacity) values (139, null);
insert into reservoir (id_river, capacity) values (35, 420431);
insert into reservoir (id_river, capacity) values (119, 543453);
insert into reservoir (id_river, capacity) values (72, 908563);
insert into reservoir (id_river, capacity) values (80, 337280);
insert into reservoir (id_river, capacity) values (115, null);
insert into reservoir (id_river, capacity) values (50, null);
insert into reservoir (id_river, capacity) values (126, 2167);
insert into reservoir (id_river, capacity) values (19, 109551);
insert into reservoir (id_river, capacity) values (87, 777887);
insert into reservoir (id_river, capacity) values (98, 979009);
insert into reservoir (id_river, capacity) values (10, 416797);
insert into reservoir (id_river, capacity) values (101, 838902);
insert into reservoir (id_river, capacity) values (71, 137316);
insert into reservoir (id_river, capacity) values (44, 586744);
insert into reservoir (id_river, capacity) values (131, 44654);
insert into reservoir (id_river, capacity) values (148, 973474);
insert into reservoir (id_river, capacity) values (119, 575421);
insert into reservoir (id_river, capacity) values (26, null);
insert into reservoir (id_river, capacity) values (24, null);
insert into reservoir (id_river, capacity) values (70, 613221);
insert into reservoir (id_river, capacity) values (117, 92138);
insert into reservoir (id_river, capacity) values (125, null);
insert into reservoir (id_river, capacity) values (11, 596049);
insert into reservoir (id_river, capacity) values (126, 733244);
insert into reservoir (id_river, capacity) values (40, 922568);
insert into reservoir (id_river, capacity) values (47, 271067);
insert into reservoir (id_river, capacity) values (1, 78463);
insert into reservoir (id_river, capacity) values (15, 508819);
insert into reservoir (id_river, capacity) values (141, 325942);
insert into reservoir (id_river, capacity) values (127, 566954);
insert into reservoir (id_river, capacity) values (5, 551260);
insert into reservoir (id_river, capacity) values (67, 933195);
insert into reservoir (id_river, capacity) values (114, 254694);
insert into reservoir (id_river, capacity) values (117, 8531);
insert into reservoir (id_river, capacity) values (119, 81398);
insert into reservoir (id_river, capacity) values (70, 848533);
insert into reservoir (id_river, capacity) values (74, 798010);
insert into reservoir (id_river, capacity) values (123, 666115);
insert into reservoir (id_river, capacity) values (59, 466831);
insert into reservoir (id_river, capacity) values (137, 40425);
insert into reservoir (id_river, capacity) values (149, 179838);
insert into reservoir (id_river, capacity) values (149, 689279);
insert into reservoir (id_river, capacity) values (28, 136380);
insert into reservoir (id_river, capacity) values (59, 948191);
insert into reservoir (id_river, capacity) values (53, 751082);
insert into reservoir (id_river, capacity) values (80, 802231);
insert into reservoir (id_river, capacity) values (55, 646745);
insert into reservoir (id_river, capacity) values (91, 266798);
insert into reservoir (id_river, capacity) values (130, null);
insert into reservoir (id_river, capacity) values (105, 606946);
insert into reservoir (id_river, capacity) values (105, 348388);
insert into reservoir (id_river, capacity) values (72, 706731);
insert into reservoir (id_river, capacity) values (21, 864818);
insert into reservoir (id_river, capacity) values (123, 879277);
insert into reservoir (id_river, capacity) values (11, null);
insert into reservoir (id_river, capacity) values (23, 937893);
insert into reservoir (id_river, capacity) values (12, 220085);
insert into reservoir (id_river, capacity) values (78, 888708);
insert into reservoir (id_river, capacity) values (118, 134774);
insert into reservoir (id_river, capacity) values (79, 530855);
insert into reservoir (id_river, capacity) values (42, 265652);
insert into reservoir (id_river, capacity) values (134, null);
insert into reservoir (id_river, capacity) values (143, 883691);
insert into reservoir (id_river, capacity) values (60, 550536);
insert into reservoir (id_river, capacity) values (95, 193485);
insert into reservoir (id_river, capacity) values (50, 370923);
insert into reservoir (id_river, capacity) values (24, 976689);
insert into reservoir (id_river, capacity) values (16, 752388);
insert into reservoir (id_river, capacity) values (65, 768906);
insert into reservoir (id_river, capacity) values (39, 749950);
insert into reservoir (id_river, capacity) values (125, 757488);
insert into reservoir (id_river, capacity) values (150, 779598);
insert into reservoir (id_river, capacity) values (68, 362544);
insert into reservoir (id_river, capacity) values (80, null);
insert into reservoir (id_river, capacity) values (102, 63970);
insert into reservoir (id_river, capacity) values (105, 623814);
insert into reservoir (id_river, capacity) values (3, 994719);
insert into reservoir (id_river, capacity) values (114, 695570);
insert into reservoir (id_river, capacity) values (83, null);
insert into reservoir (id_river, capacity) values (55, 799249);
insert into reservoir (id_river, capacity) values (125, 229626);
insert into reservoir (id_river, capacity) values (111, null);
insert into reservoir (id_river, capacity) values (136, 907917);
insert into reservoir (id_river, capacity) values (44, 744917);
insert into reservoir (id_river, capacity) values (5, 657521);
insert into reservoir (id_river, capacity) values (128, 28316);
insert into reservoir (id_river, capacity) values (119, 748630);
insert into reservoir (id_river, capacity) values (72, 410970);
insert into reservoir (id_river, capacity) values (56, 121665);
insert into reservoir (id_river, capacity) values (1, 900640);
insert into reservoir (id_river, capacity) values (28, 215938);
insert into reservoir (id_river, capacity) values (73, 508708);
insert into reservoir (id_river, capacity) values (122, 756022);
insert into reservoir (id_river, capacity) values (123, 240594);
insert into reservoir (id_river, capacity) values (136, 2726);
insert into reservoir (id_river, capacity) values (98, null);
insert into reservoir (id_river, capacity) values (78, 460094);
insert into reservoir (id_river, capacity) values (65, 795156);
insert into reservoir (id_river, capacity) values (134, 498795);
insert into reservoir (id_river, capacity) values (30, 951116);
insert into reservoir (id_river, capacity) values (97, 600164);
insert into reservoir (id_river, capacity) values (139, null);
insert into reservoir (id_river, capacity) values (79, 167241);
insert into reservoir (id_river, capacity) values (44, 861878);
insert into reservoir (id_river, capacity) values (128, 55183);
insert into reservoir (id_river, capacity) values (75, 374837);
insert into reservoir (id_river, capacity) values (143, 325351);
insert into reservoir (id_river, capacity) values (90, 911663);
insert into reservoir (id_river, capacity) values (2, 893855);
insert into reservoir (id_river, capacity) values (109, null);
insert into reservoir (id_river, capacity) values (28, null);
insert into reservoir (id_river, capacity) values (6, 558198);
insert into reservoir (id_river, capacity) values (35, 935984);
insert into reservoir (id_river, capacity) values (121, null);
insert into reservoir (id_river, capacity) values (99, 321416);
insert into reservoir (id_river, capacity) values (68, 98158);
insert into reservoir (id_river, capacity) values (44, 835375);
insert into reservoir (id_river, capacity) values (71, null);
insert into reservoir (id_river, capacity) values (29, null);
insert into reservoir (id_river, capacity) values (80, null);
insert into reservoir (id_river, capacity) values (50, 675288);
insert into reservoir (id_river, capacity) values (65, 557515);
insert into reservoir (id_river, capacity) values (98, 791439);
insert into reservoir (id_river, capacity) values (131, 243114);
insert into reservoir (id_river, capacity) values (57, 387737);
insert into reservoir (id_river, capacity) values (136, 432718);
insert into reservoir (id_river, capacity) values (106, 411963);
insert into reservoir (id_river, capacity) values (15, 455857);
insert into reservoir (id_river, capacity) values (106, 67365);
insert into reservoir (id_river, capacity) values (62, 373507);
insert into reservoir (id_river, capacity) values (91, 63907);
insert into reservoir (id_river, capacity) values (67, 438199);
insert into reservoir (id_river, capacity) values (13, 694130);
insert into reservoir (id_river, capacity) values (115, 734633);
insert into reservoir (id_river, capacity) values (2, 980496);
insert into reservoir (id_river, capacity) values (72, 21644);
insert into reservoir (id_river, capacity) values (65, 565657);
insert into reservoir (id_river, capacity) values (97, 840954);
insert into reservoir (id_river, capacity) values (23, 425572);
insert into reservoir (id_river, capacity) values (59, 585480);
insert into reservoir (id_river, capacity) values (116, 379467);
insert into reservoir (id_river, capacity) values (102, 726414);
insert into reservoir (id_river, capacity) values (7, 117817);
insert into reservoir (id_river, capacity) values (117, 24879);
insert into reservoir (id_river, capacity) values (78, 660320);
insert into reservoir (id_river, capacity) values (68, 59782);
insert into reservoir (id_river, capacity) values (141, 783052);
insert into reservoir (id_river, capacity) values (124, 66748);
insert into reservoir (id_river, capacity) values (55, 521543);
insert into reservoir (id_river, capacity) values (78, 402207);
insert into reservoir (id_river, capacity) values (77, 619086);
insert into reservoir (id_river, capacity) values (5, null);
insert into reservoir (id_river, capacity) values (24, 581019);
insert into reservoir (id_river, capacity) values (103, 671372);
insert into reservoir (id_river, capacity) values (117, 295204);
insert into reservoir (id_river, capacity) values (18, 984197);
insert into reservoir (id_river, capacity) values (120, 983916);
insert into reservoir (id_river, capacity) values (122, 362448);
insert into reservoir (id_river, capacity) values (126, 88105);
insert into reservoir (id_river, capacity) values (143, 321108);
insert into reservoir (id_river, capacity) values (90, 823074);
insert into reservoir (id_river, capacity) values (71, 9813);
insert into reservoir (id_river, capacity) values (104, 491153);
insert into reservoir (id_river, capacity) values (112, 259606);
insert into reservoir (id_river, capacity) values (137, 825248);
insert into reservoir (id_river, capacity) values (38, 214295);
insert into reservoir (id_river, capacity) values (4, 367704);
insert into reservoir (id_river, capacity) values (143, null);
insert into reservoir (id_river, capacity) values (108, 144886);
insert into reservoir (id_river, capacity) values (116, 132627);
insert into reservoir (id_river, capacity) values (117, 434936);
insert into reservoir (id_river, capacity) values (132, 388011);
insert into reservoir (id_river, capacity) values (33, 655496);
insert into reservoir (id_river, capacity) values (5, 801489);
insert into reservoir (id_river, capacity) values (150, 545587);
insert into reservoir (id_river, capacity) values (100, 737940);

-- table hydro_power_plant
insert into hydro_power_plant (id_river, head) values (130, null);
insert into hydro_power_plant (id_river, head) values (9, 288.88);
insert into hydro_power_plant (id_river, head) values (69, 823.24);
insert into hydro_power_plant (id_river, head) values (133, 196.84);
insert into hydro_power_plant (id_river, head) values (28, 433.86);
insert into hydro_power_plant (id_river, head) values (21, 22.06);
insert into hydro_power_plant (id_river, head) values (91, 810.33);
insert into hydro_power_plant (id_river, head) values (58, 621.42);
insert into hydro_power_plant (id_river, head) values (30, 566.87);
insert into hydro_power_plant (id_river, head) values (114, null);
insert into hydro_power_plant (id_river, head) values (84, null);
insert into hydro_power_plant (id_river, head) values (52, 384.11);
insert into hydro_power_plant (id_river, head) values (78, 6.04);
insert into hydro_power_plant (id_river, head) values (135, 201.78);
insert into hydro_power_plant (id_river, head) values (135, 536.14);
insert into hydro_power_plant (id_river, head) values (28, 946.87);
insert into hydro_power_plant (id_river, head) values (141, 192.2);
insert into hydro_power_plant (id_river, head) values (37, null);
insert into hydro_power_plant (id_river, head) values (22, 202.11);
insert into hydro_power_plant (id_river, head) values (74, 376.66);
insert into hydro_power_plant (id_river, head) values (135, 122.21);
insert into hydro_power_plant (id_river, head) values (12, 445.65);
insert into hydro_power_plant (id_river, head) values (131, 626.94);
insert into hydro_power_plant (id_river, head) values (21, 772.05);
insert into hydro_power_plant (id_river, head) values (121, 587.95);
insert into hydro_power_plant (id_river, head) values (39, 742.13);
insert into hydro_power_plant (id_river, head) values (125, 974.61);
insert into hydro_power_plant (id_river, head) values (85, 517.15);
insert into hydro_power_plant (id_river, head) values (46, 509.93);
insert into hydro_power_plant (id_river, head) values (113, 481.26);
insert into hydro_power_plant (id_river, head) values (7, 377.84);
insert into hydro_power_plant (id_river, head) values (75, 3.72);
insert into hydro_power_plant (id_river, head) values (16, 969.85);
insert into hydro_power_plant (id_river, head) values (139, 864.84);
insert into hydro_power_plant (id_river, head) values (20, null);
insert into hydro_power_plant (id_river, head) values (142, 779.53);
insert into hydro_power_plant (id_river, head) values (135, 145.01);
insert into hydro_power_plant (id_river, head) values (117, 622.51);
insert into hydro_power_plant (id_river, head) values (79, 695.26);
insert into hydro_power_plant (id_river, head) values (92, 559.25);
insert into hydro_power_plant (id_river, head) values (27, 301.49);
insert into hydro_power_plant (id_river, head) values (41, 375.17);
insert into hydro_power_plant (id_river, head) values (66, 149.21);
insert into hydro_power_plant (id_river, head) values (36, 903.69);
insert into hydro_power_plant (id_river, head) values (21, null);
insert into hydro_power_plant (id_river, head) values (44, 94.92);
insert into hydro_power_plant (id_river, head) values (43, 657.37);
insert into hydro_power_plant (id_river, head) values (41, null);
insert into hydro_power_plant (id_river, head) values (14, 474.04);
insert into hydro_power_plant (id_river, head) values (9, 603.18);
insert into hydro_power_plant (id_river, head) values (21, 333.49);
insert into hydro_power_plant (id_river, head) values (26, 899.94);
insert into hydro_power_plant (id_river, head) values (18, null);
insert into hydro_power_plant (id_river, head) values (135, 969.77);
insert into hydro_power_plant (id_river, head) values (95, 971.12);
insert into hydro_power_plant (id_river, head) values (23, 127.02);
insert into hydro_power_plant (id_river, head) values (101, 354.54);
insert into hydro_power_plant (id_river, head) values (121, 943.18);
insert into hydro_power_plant (id_river, head) values (123, 951.36);
insert into hydro_power_plant (id_river, head) values (13, 933.98);
insert into hydro_power_plant (id_river, head) values (18, 60.18);
insert into hydro_power_plant (id_river, head) values (35, 953.72);
insert into hydro_power_plant (id_river, head) values (38, 420.1);
insert into hydro_power_plant (id_river, head) values (22, null);
insert into hydro_power_plant (id_river, head) values (19, 940.89);
insert into hydro_power_plant (id_river, head) values (125, 784.41);
insert into hydro_power_plant (id_river, head) values (107, 271.95);
insert into hydro_power_plant (id_river, head) values (103, 613.45);
insert into hydro_power_plant (id_river, head) values (36, 366.94);
insert into hydro_power_plant (id_river, head) values (23, 619.85);
insert into hydro_power_plant (id_river, head) values (101, 697.07);
insert into hydro_power_plant (id_river, head) values (11, 800.45);
insert into hydro_power_plant (id_river, head) values (116, 652.85);
insert into hydro_power_plant (id_river, head) values (79, 664.96);
insert into hydro_power_plant (id_river, head) values (58, 737.45);
insert into hydro_power_plant (id_river, head) values (21, 858.49);
insert into hydro_power_plant (id_river, head) values (145, 748.7);
insert into hydro_power_plant (id_river, head) values (124, null);
insert into hydro_power_plant (id_river, head) values (108, 765.7);
insert into hydro_power_plant (id_river, head) values (48, 470.85);
insert into hydro_power_plant (id_river, head) values (124, 321.75);
insert into hydro_power_plant (id_river, head) values (130, 774.56);
insert into hydro_power_plant (id_river, head) values (147, null);
insert into hydro_power_plant (id_river, head) values (50, 460.43);
insert into hydro_power_plant (id_river, head) values (48, 900.59);
insert into hydro_power_plant (id_river, head) values (2, 765.09);
insert into hydro_power_plant (id_river, head) values (20, 238.3);
insert into hydro_power_plant (id_river, head) values (83, null);
insert into hydro_power_plant (id_river, head) values (43, 608.15);
insert into hydro_power_plant (id_river, head) values (2, 269.55);
insert into hydro_power_plant (id_river, head) values (72, 531.74);
insert into hydro_power_plant (id_river, head) values (32, 497.1);
insert into hydro_power_plant (id_river, head) values (112, 172.48);
insert into hydro_power_plant (id_river, head) values (11, 850.02);
insert into hydro_power_plant (id_river, head) values (56, 573.45);
insert into hydro_power_plant (id_river, head) values (33, 782.9);
insert into hydro_power_plant (id_river, head) values (7, null);
insert into hydro_power_plant (id_river, head) values (83, 904.06);
insert into hydro_power_plant (id_river, head) values (23, 344.19);
insert into hydro_power_plant (id_river, head) values (134, 557.65);
insert into hydro_power_plant (id_river, head) values (37, 329.93);
insert into hydro_power_plant (id_river, head) values (106, null);
insert into hydro_power_plant (id_river, head) values (1, 347.98);
insert into hydro_power_plant (id_river, head) values (60, 573.17);
insert into hydro_power_plant (id_river, head) values (105, 789.0);
insert into hydro_power_plant (id_river, head) values (61, 382.45);
insert into hydro_power_plant (id_river, head) values (104, 908.71);
insert into hydro_power_plant (id_river, head) values (107, null);
insert into hydro_power_plant (id_river, head) values (113, 622.67);
insert into hydro_power_plant (id_river, head) values (145, 691.3);
insert into hydro_power_plant (id_river, head) values (13, 77.52);
insert into hydro_power_plant (id_river, head) values (98, 431.9);
insert into hydro_power_plant (id_river, head) values (108, 124.54);
insert into hydro_power_plant (id_river, head) values (31, 941.52);
insert into hydro_power_plant (id_river, head) values (88, 757.86);
insert into hydro_power_plant (id_river, head) values (59, null);
insert into hydro_power_plant (id_river, head) values (83, 30.5);
insert into hydro_power_plant (id_river, head) values (136, 986.97);
insert into hydro_power_plant (id_river, head) values (42, 582.38);
insert into hydro_power_plant (id_river, head) values (43, 726.66);
insert into hydro_power_plant (id_river, head) values (53, 620.77);
insert into hydro_power_plant (id_river, head) values (84, 972.94);
insert into hydro_power_plant (id_river, head) values (92, 331.46);
insert into hydro_power_plant (id_river, head) values (72, 767.48);
insert into hydro_power_plant (id_river, head) values (10, 359.79);
insert into hydro_power_plant (id_river, head) values (110, 62.5);
insert into hydro_power_plant (id_river, head) values (58, 457.71);
insert into hydro_power_plant (id_river, head) values (9, 923.24);
insert into hydro_power_plant (id_river, head) values (135, 681.8);
insert into hydro_power_plant (id_river, head) values (144, 848.14);
insert into hydro_power_plant (id_river, head) values (66, 958.2);
insert into hydro_power_plant (id_river, head) values (29, 221.94);
insert into hydro_power_plant (id_river, head) values (6, 443.94);
insert into hydro_power_plant (id_river, head) values (77, 209.45);
insert into hydro_power_plant (id_river, head) values (138, 425.22);
insert into hydro_power_plant (id_river, head) values (30, 945.62);
insert into hydro_power_plant (id_river, head) values (121, 669.33);
insert into hydro_power_plant (id_river, head) values (65, null);
insert into hydro_power_plant (id_river, head) values (76, 342.57);
insert into hydro_power_plant (id_river, head) values (46, 510.22);
insert into hydro_power_plant (id_river, head) values (125, 41.13);
insert into hydro_power_plant (id_river, head) values (73, 606.02);
insert into hydro_power_plant (id_river, head) values (30, 347.79);
insert into hydro_power_plant (id_river, head) values (78, null);
insert into hydro_power_plant (id_river, head) values (25, 13.42);
insert into hydro_power_plant (id_river, head) values (122, 461.09);
insert into hydro_power_plant (id_river, head) values (62, 293.95);
insert into hydro_power_plant (id_river, head) values (66, 609.81);
insert into hydro_power_plant (id_river, head) values (127, 255.78);
insert into hydro_power_plant (id_river, head) values (105, 590.06);
insert into hydro_power_plant (id_river, head) values (93, 918.83);
insert into hydro_power_plant (id_river, head) values (15, null);
insert into hydro_power_plant (id_river, head) values (36, 986.97);
insert into hydro_power_plant (id_river, head) values (100, null);
insert into hydro_power_plant (id_river, head) values (88, 52.64);
insert into hydro_power_plant (id_river, head) values (58, 816.21);
insert into hydro_power_plant (id_river, head) values (108, 112.53);
insert into hydro_power_plant (id_river, head) values (11, 146.19);
insert into hydro_power_plant (id_river, head) values (54, 49.0);
insert into hydro_power_plant (id_river, head) values (124, 890.95);
insert into hydro_power_plant (id_river, head) values (48, 523.31);
insert into hydro_power_plant (id_river, head) values (119, 247.55);
insert into hydro_power_plant (id_river, head) values (78, 917.4);
insert into hydro_power_plant (id_river, head) values (86, 632.34);
insert into hydro_power_plant (id_river, head) values (133, 506.12);
insert into hydro_power_plant (id_river, head) values (104, 166.54);
insert into hydro_power_plant (id_river, head) values (115, 744.7);
insert into hydro_power_plant (id_river, head) values (67, 518.88);
insert into hydro_power_plant (id_river, head) values (54, 653.9);
insert into hydro_power_plant (id_river, head) values (92, 395.05);
insert into hydro_power_plant (id_river, head) values (107, 712.39);
insert into hydro_power_plant (id_river, head) values (39, 561.82);
insert into hydro_power_plant (id_river, head) values (102, 461.42);
insert into hydro_power_plant (id_river, head) values (73, 701.79);
insert into hydro_power_plant (id_river, head) values (84, 827.95);
insert into hydro_power_plant (id_river, head) values (40, 953.39);
insert into hydro_power_plant (id_river, head) values (46, 484.88);
insert into hydro_power_plant (id_river, head) values (113, 509.39);
insert into hydro_power_plant (id_river, head) values (18, 588.92);
insert into hydro_power_plant (id_river, head) values (10, 908.12);
insert into hydro_power_plant (id_river, head) values (142, 80.6);
insert into hydro_power_plant (id_river, head) values (42, 44.39);
insert into hydro_power_plant (id_river, head) values (53, 370.51);
insert into hydro_power_plant (id_river, head) values (100, 74.84);
insert into hydro_power_plant (id_river, head) values (150, 890.73);
insert into hydro_power_plant (id_river, head) values (112, null);
insert into hydro_power_plant (id_river, head) values (49, 698.42);
insert into hydro_power_plant (id_river, head) values (31, 704.32);
insert into hydro_power_plant (id_river, head) values (78, 523.1);
insert into hydro_power_plant (id_river, head) values (4, 958.4);
insert into hydro_power_plant (id_river, head) values (65, 6.82);
insert into hydro_power_plant (id_river, head) values (51, 606.77);
insert into hydro_power_plant (id_river, head) values (54, null);
insert into hydro_power_plant (id_river, head) values (93, 160.13);
insert into hydro_power_plant (id_river, head) values (75, 302.33);
insert into hydro_power_plant (id_river, head) values (56, 283.33);
insert into hydro_power_plant (id_river, head) values (95, 355.98);
insert into hydro_power_plant (id_river, head) values (91, 756.78);
insert into hydro_power_plant (id_river, head) values (23, 175.9);
insert into hydro_power_plant (id_river, head) values (75, 534.18);

-- table turbine
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (139, 51730.75, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (162, 81655.0, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (72, 28981.08, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (96, 42195.25, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (125, 11924.88, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (4, 56135.61, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (71, 54426.67, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (184, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (109, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (75, 52638.32, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (41, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (6, 82381.19, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (28, 51467.82, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (73, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (143, 15065.26, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (131, 47813.94, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (88, 78760.29, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (180, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (12, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (62, 23242.17, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (127, 35352.47, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (57, 77011.69, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (143, 67179.27, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (76, 36651.01, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (178, 30153.13, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (74, 6208.13, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (127, 34236.98, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (156, 80698.25, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (177, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (131, null, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (37, 32275.94, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (92, 16806.35, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (111, 78154.65, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (196, 61757.6, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (40, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (86, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (58, 94543.2, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (122, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (182, 87592.03, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (185, 38640.67, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (172, 17381.95, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (128, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (113, 7334.83, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (145, 27613.89, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (138, 70236.41, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (125, 22525.19, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (88, 22067.61, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (125, 38981.24, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (133, 93747.15, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (67, 71034.39, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (72, 51619.62, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (148, 73911.06, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (128, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (144, 70154.87, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (19, 14258.54, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (84, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (44, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (25, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (165, 488.66, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (3, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (32, 4474.57, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (122, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (55, 93960.86, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (169, 5406.68, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (1, 47387.52, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (93, 3391.54, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (70, 61560.64, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (176, 33907.96, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (87, 29923.16, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (25, 81179.08, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (144, 73308.73, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (17, 50192.41, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (11, 59862.0, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (184, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (105, 27186.7, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (47, 45654.46, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (69, 7350.6, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (20, 91152.74, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (76, 4280.84, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (152, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (112, 45403.93, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (146, 91240.0, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (168, 39025.64, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (91, 95866.86, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (182, 11379.97, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (144, 79120.87, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (16, 19301.68, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (60, 66031.17, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (173, 28439.93, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (200, 51400.28, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (128, 80506.85, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (172, 94358.76, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (78, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (116, 29490.07, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (49, 8631.73, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (27, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (163, 6348.63, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (147, 1515.37, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (177, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (67, 78092.62, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (81, 95168.77, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (7, 81865.67, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (80, 39420.02, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (144, 36577.57, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (197, 80919.66, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (18, 15568.7, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (161, 52806.73, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (128, 96856.03, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (105, 21590.75, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (86, 57144.39, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (13, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (102, 97018.8, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (132, 48596.17, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (71, 34680.64, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (8, 12459.85, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (34, 19833.04, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (80, 17146.55, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (79, 25101.78, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (44, null, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (193, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (107, 3250.67, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (162, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (27, 93185.98, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (116, 79031.16, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (186, 14614.82, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (115, 60178.72, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (32, 73112.31, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (181, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (76, 17347.09, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (200, 4040.02, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (1, 15862.78, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (80, 34849.61, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (36, 65577.77, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (45, 87237.38, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (34, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (186, 12468.89, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (180, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (20, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (131, 5823.0, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (109, 6696.34, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (68, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (177, 9892.31, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (177, 83319.29, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (54, 33795.71, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (164, 21926.49, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (69, 32987.07, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (57, 37995.2, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (10, 14704.64, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (72, 82302.8, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (2, 95078.01, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (74, 98013.19, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (155, 97200.59, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (105, 28724.58, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (63, 82467.24, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (122, 15002.95, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (19, 95466.86, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (117, 92784.91, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (111, 13738.93, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (81, 19366.87, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (71, 54368.13, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (170, 59771.93, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (31, 53464.05, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (8, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (6, 9139.86, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (176, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (106, 40403.38, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (63, 89680.93, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (46, 387.69, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (46, 62433.4, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (34, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (162, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (183, 14937.5, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (182, 24454.57, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (87, 99287.22, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (150, 47400.64, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (39, null, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (184, 77405.09, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (122, 21635.44, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (165, 16620.93, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (160, 96019.59, null);
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (40, 12849.94, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (121, 72714.97, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (111, 17459.19, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (97, 99466.91, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (26, 63140.93, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (49, 78002.21, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (91, 71909.78, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (38, 13561.61, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (62, 98684.68, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (117, 13730.95, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (125, 163.6, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (131, 56040.34, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (19, null, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (72, 9355.27, 'Francis');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (77, 42697.91, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (174, 99872.38, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (115, null, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (182, 86629.63, 'Banky');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (50, 53090.91, 'Kaplan');
insert into turbine (id_hydro, hydro_turbine_power, turbine_type) values (80, 60149.37, 'Francis');

-- table biomass_power_plant
insert into biomass_power_plant (power) values (7584489.0);
insert into biomass_power_plant (power) values (6042340.0);
insert into biomass_power_plant (power) values (5812623.3);
insert into biomass_power_plant (power) values (8206928.0);
insert into biomass_power_plant (power) values (3651957.94);
insert into biomass_power_plant (power) values (8747714.0);
insert into biomass_power_plant (power) values (8041413.23);
insert into biomass_power_plant (power) values (9290651.0);
insert into biomass_power_plant (power) values (5119106.0);
insert into biomass_power_plant (power) values (3582540.37);
insert into biomass_power_plant (power) values (4874663.0);
insert into biomass_power_plant (power) values (6636124.28);
insert into biomass_power_plant (power) values (5432982.0);
insert into biomass_power_plant (power) values (7160944.0);
insert into biomass_power_plant (power) values (8406612.0);
insert into biomass_power_plant (power) values (1435852.6);
insert into biomass_power_plant (power) values (2434185.0);
insert into biomass_power_plant (power) values (2518104.7);
insert into biomass_power_plant (power) values (3964908.42);
insert into biomass_power_plant (power) values (3366055.54);
insert into biomass_power_plant (power) values (4699554.0);
insert into biomass_power_plant (power) values (8799201.0);
insert into biomass_power_plant (power) values (8007132.1);
insert into biomass_power_plant (power) values (1959403.0);
insert into biomass_power_plant (power) values (3008307.44);
insert into biomass_power_plant (power) values (8451058.0);
insert into biomass_power_plant (power) values (1703770.34);
insert into biomass_power_plant (power) values (8697769.0);
insert into biomass_power_plant (power) values (5069809.0);
insert into biomass_power_plant (power) values (9324085.0);
insert into biomass_power_plant (power) values (4831344.71);
insert into biomass_power_plant (power) values (3241063.09);
insert into biomass_power_plant (power) values (7975812.0);
insert into biomass_power_plant (power) values (5918563.93);
insert into biomass_power_plant (power) values (8416218.0);
insert into biomass_power_plant (power) values (9640342.0);
insert into biomass_power_plant (power) values (5077313.0);
insert into biomass_power_plant (power) values (1206521.0);
insert into biomass_power_plant (power) values (3919516.68);
insert into biomass_power_plant (power) values (7959452.27);
insert into biomass_power_plant (power) values (5942984.0);
insert into biomass_power_plant (power) values (4629873.37);
insert into biomass_power_plant (power) values (1623372.75);
insert into biomass_power_plant (power) values (8826672.0);
insert into biomass_power_plant (power) values (682021.46);
insert into biomass_power_plant (power) values (8849271.0);
insert into biomass_power_plant (power) values (5295665.0);
insert into biomass_power_plant (power) values (6625846.57);
insert into biomass_power_plant (power) values (1304114.49);
insert into biomass_power_plant (power) values (8956830.0);

-- table fuel
insert into fuel (name, price, energy_density) values ('Aristophanes', 332.3315, 492.9079);
insert into fuel (name, price, energy_density) values ('ethane', 797.2161, 535.606);
insert into fuel (name, price, energy_density) values ('Corn', 122.2483, 476.1499);
insert into fuel (name, price, energy_density) values ('bio gas', 347.8988, 326.4286);
insert into fuel (name, price, energy_density) values ('natural gas', 66.8356, 484.556);
insert into fuel (name, price, energy_density) values ('natural gas', 723.3152, 554.2149);
insert into fuel (name, price, energy_density) values ('Black coal', 206.698, 503.8722);
insert into fuel (name, price, energy_density) values ('Charcoal', 17.4999, 786.2797);
insert into fuel (name, price, energy_density) values ('Charcoal', 792.5873, 416.5632);
insert into fuel (name, price, energy_density) values ('Charcoal', 338.0872, 757.4883);
insert into fuel (name, price, energy_density) values ('Charcoal', 736.4499, 804.5082);
insert into fuel (name, price, energy_density) values ('Black coal', 165.6994, 418.6383);
insert into fuel (name, price, energy_density) values ('Corn', 551.6389, 790.1806);
insert into fuel (name, price, energy_density) values ('bio gas', 270.2273, 733.2707);
insert into fuel (name, price, energy_density) values ('Wheat', 434.478, 504.9432);
insert into fuel (name, price, energy_density) values ('ethane', null, null);
insert into fuel (name, price, energy_density) values ('Wheat', 351.0513, 106.3694);
insert into fuel (name, price, energy_density) values ('Wheat', 52.0806, 243.06);
insert into fuel (name, price, energy_density) values ('Charcoal', 959.7923, 641.9607);
insert into fuel (name, price, energy_density) values ('Wheat', 545.2877, 111.3136);
insert into fuel (name, price, energy_density) values ('Brown coal', null, null);
insert into fuel (name, price, energy_density) values ('methane', 349.6063, 660.8149);
insert into fuel (name, price, energy_density) values ('Corn', 540.0196, 193.0775);
insert into fuel (name, price, energy_density) values ('wood', 978.0184, 51.1875);
insert into fuel (name, price, energy_density) values ('Black coal', 276.8834, 376.0328);
insert into fuel (name, price, energy_density) values ('ethane', 977.9193, 341.1492);
insert into fuel (name, price, energy_density) values ('Corn', 121.3256, 3.7611);
insert into fuel (name, price, energy_density) values ('ethane', 534.7981, 869.0438);
insert into fuel (name, price, energy_density) values ('Black coal', 52.0241, 373.391);
insert into fuel (name, price, energy_density) values ('wood', null, null);
insert into fuel (name, price, energy_density) values ('ethane', 784.3914, 880.7705);
insert into fuel (name, price, energy_density) values ('Aristophanes', 154.6977, 897.5871);
insert into fuel (name, price, energy_density) values ('ethane', 277.2499, 863.8286);
insert into fuel (name, price, energy_density) values ('Charcoal', 94.6634, 936.858);
insert into fuel (name, price, energy_density) values ('ethane', 279.222, 503.5765);
insert into fuel (name, price, energy_density) values ('ethane', 677.8574, 669.3995);
insert into fuel (name, price, energy_density) values ('Brown coal', 465.416, 951.7825);
insert into fuel (name, price, energy_density) values ('methane', 440.4269, 181.3512);
insert into fuel (name, price, energy_density) values ('wood', null, null);
insert into fuel (name, price, energy_density) values ('Aristophanes', 522.751, 569.9128);
insert into fuel (name, price, energy_density) values ('Brown coal', 987.9424, 470.4815);
insert into fuel (name, price, energy_density) values ('natural gas', 865.4167, 177.2426);
insert into fuel (name, price, energy_density) values ('methane', 764.3222, 669.8699);
insert into fuel (name, price, energy_density) values ('bio gas', null, null);
insert into fuel (name, price, energy_density) values ('natural gas', 68.726, 499.8);
insert into fuel (name, price, energy_density) values ('methane', 77.8024, 269.5272);
insert into fuel (name, price, energy_density) values ('bio gas', 518.4047, 716.6066);
insert into fuel (name, price, energy_density) values ('natural gas', 789.0111, 87.5861);
insert into fuel (name, price, energy_density) values ('wood', 602.1211, 409.1564);
insert into fuel (name, price, energy_density) values ('Brown coal', 176.2266, 737.4263);

-- table fuel_biomass_power_plant
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (23, 19);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (23, 4);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (35, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (15, 48);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (31, 31);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (18, 22);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (38, 38);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (9, 10);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 34);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (7, 41);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (3, 18);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (19, 10);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (31, 6);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (44, 37);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (42, 28);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (14, 26);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (28, 5);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (14, 22);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 32);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (1, 31);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (6, 2);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (26, 11);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (9, 3);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (3, 1);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (36, 5);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (22, 22);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (44, 41);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (3, 15);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (33, 13);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (23, 30);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (2, 33);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (24, 1);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (31, 40);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (35, 19);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (27, 30);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (29, 17);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (4, 19);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (3, 12);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (41, 4);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (28, 19);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 20);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (8, 50);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (40, 17);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (40, 26);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (47, 13);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (24, 41);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (49, 4);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (7, 10);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (48, 9);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (21, 43);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (9, 32);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (44, 12);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (10, 15);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (39, 40);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (4, 40);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (37, 17);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (44, 3);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (13, 14);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (4, 45);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (11, 48);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (42, 32);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (4, 33);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (35, 39);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (3, 7);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (40, 31);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (8, 45);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (45, 29);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (43, 1);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (17, 18);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (11, 46);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (12, 25);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (50, 11);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (38, 22);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (14, 27);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (26, 30);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (9, 47);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (37, 2);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (16, 8);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (12, 47);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (19, 6);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (47, 18);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (50, 38);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (21, 41);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (29, 50);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (50, 31);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (34, 21);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (44, 11);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (1, 49);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (2, 50);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (25, 34);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (7, 33);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (19, 48);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (39, 46);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (3, 40);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (6, 17);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (27, 25);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (40, 23);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (29, 44);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (6, 32);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (29, 41);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (27, 10);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (32, 15);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (7, 7);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (41, 38);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (33, 16);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (2, 31);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (26, 17);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (22, 25);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 23);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (36, 36);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (4, 9);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (48, 6);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (44, 5);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (21, 28);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (32, 9);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (21, 39);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (17, 14);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (28, 36);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (27, 16);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 15);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (43, 29);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (46, 11);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (49, 30);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (35, 29);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (50, 13);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (14, 38);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (23, 23);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (29, 25);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (30, 7);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (12, 45);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (21, 25);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (39, 10);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (34, 32);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (21, 12);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (42, 49);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (45, 16);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (6, 15);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (36, 12);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (19, 30);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 5);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (41, 22);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (41, 26);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (37, 1);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (33, 5);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (8, 18);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (24, 13);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (10, 29);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (44, 26);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (15, 5);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (11, 43);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (32, 29);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (12, 39);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (22, 5);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (22, 15);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (49, 17);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (32, 19);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (12, 28);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (32, 23);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (40, 20);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (10, 33);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (45, 37);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (47, 30);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (28, 27);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (35, 32);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (39, 15);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 40);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (30, 50);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (34, 48);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (6, 7);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (11, 13);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (34, 43);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (39, 47);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (9, 13);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (12, 29);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (5, 30);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (29, 45);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (17, 47);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (5, 19);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (13, 24);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (47, 17);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (12, 9);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (35, 43);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (2, 49);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (42, 10);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (13, 35);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (47, 41);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (20, 28);

insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (1, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (2, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (3, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (4, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (5, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (7, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (8, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (15, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (22, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (24, 42);
insert into fuel_biomass_power_plant (id_fuel, id_biomass) values (37, 42);

-- table grid_connection
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4345164278.23, 9725, 1, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4092549454.46, 2161, 2, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9901600252.75, 5231, 3, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2044813188.69, 8548, 4, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7718658689.05, 6891, 5, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1094986399.64, 146, 6, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3081093806.73, 9339, 7, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7035097485.15, 8739, 8, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4543804712.68, 2128, 9, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7590405725.49, 7964, 10, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1047696108.18, 2086, 11, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5677960292.46, 8081, 12, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (251282760.96, 1188, 13, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3446193136.71, 8860, 15, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3945119283.27, 8600, 16, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3686142609.88, 4931, 17, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2846045316.36, 2023, 18, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6240167142.44, 9343, 19, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4744055331.67, 4048, 20, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7196188339.82, 4959, 21, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8883426562.32, 5145, 22, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5614284404.31, 1155, 23, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2347451607.59, 391, 24, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7880625515.41, 7172, 25, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7866230693.09, 4251, 26, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9646381949.26, 5525, 27, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1742369624.42, 2524, 28, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (738148231.21, 8646, 30, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3912020317.11, 390, 31, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6961003928.96, 9940, 32, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7537206691.38, 8562, 33, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7187846452.57, 7711, 34, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7764496379.39, 2190, 35, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7499094856.74, 3737, 38, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2954196965.01, 8897, 39, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2154738426.12, 1403, 40, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1126982792.25, 3915, 42, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6026233742.01, 2556, 43, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2478543605.35, 9785, 44, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9370591903.77, 2076, 45, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4071934098.03, 6088, 46, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1667054045.47, 3532, 47, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9244787787.6, 2291, 48, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2462552354.16, 2222, 49, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5217092133.95, 8739, 50, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1573209780.77, 3010, 51, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3070668281.95, 5551, 52, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6391735657.04, 2451, 53, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3833986732.97, 953, 55, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6886179628.05, 8827, 56, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3574581050.34, 7067, 57, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1467048797.41, 928, 58, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7715327263.35, 4290, 61, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6360687425.08, 4076, 62, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3862826950.92, 6853, 63, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4327513783.42, 484, 64, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (946786215.02, 2586, 65, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (521634642.41, 8169, 66, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4660174425.84, 9072, 68, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4571730402.85, 4642, 69, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7946133442.06, 5007, 70, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6062173578.15, 4336, 71, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5433807270.46, 4873, 72, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2791945043.84, 803, 73, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5446950968.54, 1640, 75, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3528875983.15, 9026, 76, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7038112637.03, 6480, 77, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3823937491.6, 8044, 78, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6643987870.13, 6942, 79, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3739545956.13, 1085, 80, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9320610820.3, 4164, 81, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6079905637.09, 4573, 82, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2695665398.34, 2380, 84, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6356289707.07, 9070, 85, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5856831612.48, 2995, 86, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3844870242.78, 3827, 87, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8716916380.72, 1488, 88, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1482547807.32, 9961, 89, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9201957428.56, 619, 90, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7215033448.39, 7823, 91, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5751176984.56, 9494, 92, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8287736880.58, 5419, 93, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2152799306.53, 7410, 94, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8358597192.33, 3238, 95, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5308296121.24, 511, 96, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4403972921.46, 8379, 97, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (695772395.64, 7655, 98, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3765345940.29, 1176, 99, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7689078890.85, 1337, 100, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4141087817.83, 500, 101, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9397128446.77, 5908, 102, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5673538750.21, 8409, 103, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9795015694.85, 7182, 104, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (652532236.16, 1476, 105, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1660866136.15, 2096, 106, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3023756747.89, 2582, 107, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2427350317.46, 5100, 108, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (896571193.29, 3592, 109, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2052671877.45, 7148, 110, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8736964141.81, 819, 111, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2537477118.05, 1233, 112, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7557928342.83, 8800, 113, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (290555178.12, 3639, 114, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7170761742.2, 547, 115, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1299001849.89, 7177, 116, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (228995588.73, 8300, 117, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5452063962.93, 1475, 118, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7775208263.1, 9430, 119, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6532238561.15, 7482, 120, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2076893397.52, 2901, 121, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8710374735.96, 7350, 122, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (343606051.52, 5145, 123, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9788639573.84, 4630, 124, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6629895896.16, 9705, 125, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3165539428.39, 7371, 127, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8335408339.97, 4142, 128, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3945696226.21, 7992, 129, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5786689829.2, 516, 130, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7652721526.41, 2215, 131, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7464023528.94, 9039, 132, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2701185189.29, 9977, 133, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4836916852.65, 5633, 134, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9886434729.43, 3461, 135, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2566079963.93, 9464, 136, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5290603005.14, 5293, 137, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4075325968.38, 6874, 138, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2623730798.06, 4050, 139, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5130227128.1, 5744, 140, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7547010092.39, 6723, 141, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3130317950.85, 466, 142, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1145303383.03, 1870, 143, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2192010426.74, 7338, 144, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (326735978.39, 1127, 145, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9170464476.82, 2945, 146, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9173520452.11, 1011, 147, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (680909194.0, 1170, 148, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3940761419.26, 6466, 149, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6648969912.85, 6413, 150, null, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (274082262.89, 4614, null, 1, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6099194694.38, 621, null, 2, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (367614236.76, 6342, null, 3, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6204456716.92, 9305, null, 4, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1074495906.25, 3880, null, 5, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8410273766.38, 7129, null, 6, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2063662222.03, 9950, null, 7, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4982602626.59, 1493, null, 9, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8500521717.6, 5461, null, 10, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2250824395.42, 4328, null, 12, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3094217598.58, 9858, null, 14, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1023779611.87, 730, null, 17, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (289208985.52, 8048, null, 19, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1089272024.46, 4647, null, 20, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7566230933.3, 4030, null, 21, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6474217813.48, 2202, null, 23, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (512153330.65, 5028, null, 24, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7804645578.0, 7684, null, 26, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8380542721.94, 7174, null, 27, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4064665941.33, 1507, null, 28, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7124520183.33, 576, null, 29, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8877568088.66, 6341, null, 30, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4536263688.54, 1625, null, 32, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (291681563.35, 3204, null, 33, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6845795317.26, 1617, null, 34, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3119462549.0, 6713, null, 35, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (561589608.97, 8055, null, 36, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (301601452.37, 1740, null, 37, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3278900805.23, 7020, null, 38, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3752194828.58, 6571, null, 40, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6731415662.23, 3022, null, 41, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6951340324.36, 2810, null, 42, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7767510150.76, 5356, null, 43, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5723952546.05, 7032, null, 44, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3130359394.56, 6110, null, 45, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6036274789.88, 8722, null, 46, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (926052018.46, 264, null, 48, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5247740619.97, 2965, null, 49, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8264627454.74, 2539, null, 50, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7688535624.94, 2312, null, 51, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5520419102.59, 785, null, 52, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9681145494.52, 7486, null, 54, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5885223227.25, 4081, null, 55, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4200616126.97, 2342, null, 56, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6667326826.96, 9282, null, 58, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5985117605.62, 2193, null, 59, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (541068366.83, 1548, null, 61, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5917416582.38, 8614, null, 62, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8131478441.82, 1320, null, 63, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (655555204.2, 1303, null, 64, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8689855086.91, 9634, null, 65, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2093519131.55, 9275, null, 66, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4863764807.82, 9017, null, 67, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4070106354.8, 8238, null, 68, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2611773482.88, 3410, null, 69, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2132865863.89, 9506, null, 70, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5934887100.4, 9059, null, 71, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9529372839.94, 9007, null, 72, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5318383718.38, 9240, null, 74, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2865981771.07, 159, null, 75, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4187912324.29, 7426, null, 76, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3113867609.78, 3279, null, 77, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2382515491.88, 8155, null, 78, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4322619205.78, 2681, null, 79, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7625049853.93, 4555, null, 80, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2012677893.66, 1091, null, 81, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9821926682.45, 7874, null, 82, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7316870910.24, 8707, null, 83, null, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7024047355.66, 240, null, null, 1, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4506553398.88, 7746, null, null, 2, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8652176448.97, 8543, null, null, 5, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1569936634.98, 7499, null, null, 6, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6769649300.49, 1080, null, null, 7, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1029439056.59, 1307, null, null, 8, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4421486899.79, 4575, null, null, 9, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8503342080.63, 1954, null, null, 10, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (289358384.36, 9526, null, null, 11, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8419848888.07, 8143, null, null, 12, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (235433073.72, 8575, null, null, 13, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2949381246.22, 6423, null, null, 15, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (760275418.56, 9136, null, null, 17, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5195571665.13, 9379, null, null, 18, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7021589051.65, 7918, null, null, 19, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6238985079.14, 5711, null, null, 20, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5165021664.77, 9646, null, null, 21, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1889934601.86, 1426, null, null, 22, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3271397963.96, 1921, null, null, 23, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (759821008.97, 6088, null, null, 24, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2356205726.52, 4305, null, null, 25, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5338326779.46, 9288, null, null, 26, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6210282863.35, 9017, null, null, 27, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (909475816.47, 2075, null, null, 28, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2841205599.76, 8677, null, null, 29, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4943801001.77, 3564, null, null, 30, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5693489907.61, 1263, null, null, 31, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7068024293.53, 4398, null, null, 32, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7826359870.29, 3385, null, null, 33, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6091862745.45, 7922, null, null, 34, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8664017149.77, 7209, null, null, 35, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (107189250.87, 302, null, null, 36, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7814382168.66, 8477, null, null, 37, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6612367112.57, 8415, null, null, 38, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7097319501.61, 1841, null, null, 39, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5981557211.38, 9058, null, null, 40, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6005242414.03, 7976, null, null, 41, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7951820272.91, 3962, null, null, 43, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1455060853.98, 6181, null, null, 44, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3814822064.43, 3445, null, null, 46, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1845438995.59, 1776, null, null, 47, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4596421432.56, 1122, null, null, 48, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2370095011.5, 1832, null, null, 49, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3712690887.91, 8177, null, null, 50, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3016345475.05, 4809, null, null, 51, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6674488146.89, 9163, null, null, 52, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (680641455.12, 311, null, null, 53, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1033561227.94, 3382, null, null, 54, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6220294433.95, 9306, null, null, 55, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4732900425.07, 5146, null, null, 56, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (499626439.3, 6726, null, null, 57, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4115100377.07, 8244, null, null, 58, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2485801357.45, 2667, null, null, 59, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8731578099.82, 4875, null, null, 61, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1831633619.34, 5986, null, null, 62, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8890465825.15, 2992, null, null, 63, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5688375978.0, 7495, null, null, 64, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5669148241.15, 8955, null, null, 66, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6741065332.05, 6785, null, null, 67, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3971406212.36, 707, null, null, 68, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2442401101.54, 9250, null, null, 69, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7410875146.97, 9464, null, null, 70, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5553974700.44, 9578, null, null, 71, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2164408355.9, 603, null, null, 72, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3053841350.38, 4041, null, null, 73, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7409352068.09, 8908, null, null, 74, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2348515558.4, 5048, null, null, 75, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9188722548.71, 2402, null, null, 76, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9778743296.61, 5102, null, null, 78, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2977067436.02, 8092, null, null, 79, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (672393292.44, 396, null, null, 80, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8505520994.22, 3958, null, null, 81, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4735128914.4, 5778, null, null, 83, null);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6862291711.78, 1439, null, null, null, 1);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2182656986.23, 6145, null, null, null, 2);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7973165048.69, 8626, null, null, null, 3);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (7905277053.56, 2223, null, null, null, 4);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3925752923.72, 7706, null, null, null, 5);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9158518705.21, 7721, null, null, null, 6);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3347108810.89, 1593, null, null, null, 8);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5407508944.8, 6687, null, null, null, 9);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5375998399.3, 7697, null, null, null, 10);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1545230886.01, 9606, null, null, null, 12);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1392722670.66, 1892, null, null, null, 13);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4328180078.12, 1430, null, null, null, 14);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9194510846.2, 2074, null, null, null, 15);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3715802441.24, 5606, null, null, null, 16);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3435700519.26, 4842, null, null, null, 17);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2412204980.25, 8552, null, null, null, 18);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2232130144.89, 8270, null, null, null, 19);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3712775713.06, 9119, null, null, null, 20);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5615954199.91, 5130, null, null, null, 21);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6857163322.56, 8849, null, null, null, 23);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4658999590.51, 6174, null, null, null, 24);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (4004295426.63, 725, null, null, null, 25);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5905636843.0, 2134, null, null, null, 27);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3902782612.15, 312, null, null, null, 29);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8447377683.22, 2192, null, null, null, 30);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3092754192.3, 7595, null, null, null, 31);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3874381845.74, 8447, null, null, null, 32);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (2051045008.63, 296, null, null, null, 33);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8289346981.25, 2513, null, null, null, 34);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (1532578701.29, 7674, null, null, null, 37);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8077095569.47, 7811, null, null, null, 38);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (3365670915.76, 1141, null, null, null, 39);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9237575373.73, 9445, null, null, null, 41);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (26100818.49, 9743, null, null, null, 42);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6046517378.4, 6766, null, null, null, 43);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (5530953316.45, 5335, null, null, null, 44);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (8585288799.23, 1742, null, null, null, 46);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (9032376705.41, 6741, null, null, null, 48);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6316135160.47, 8411, null, null, null, 49);
insert into grid_connection (max_power, start_up_time, id_hydro, id_solar, id_wind, id_biomass) values (6567054246.9, 7285, null, null, null, 50);