-- P&ID graph: SQLite and PostgreSQL compatible CREATE TABLE components (id TEXT PRIMARY KEY, type TEXT NOT NULL, tag TEXT, x1 REAL, y1 REAL, x2 REAL, y2 REAL); CREATE TABLE connections (source TEXT NOT NULL REFERENCES components(id), target TEXT NOT NULL REFERENCES components(id), kind TEXT NOT NULL, line TEXT); INSERT INTO components VALUES ('n1', 'valve', 'GH-55483', 826, 398, 886, 446); INSERT INTO components VALUES ('n2', 'fitting', '9"x8"', 721, 498, 772, 551); INSERT INTO components VALUES ('n3', 'fitting', '1"', 985, 364, 1029, 448); INSERT INTO components VALUES ('n4', 'fitting', 'DV-71851', 1200, 398, 1246, 448); INSERT INTO components VALUES ('n5', 'instrument', 'DDL 826', 1575, 382, 1656, 462); INSERT INTO components VALUES ('n6', 'instrument', 'SDL 340', 2154, 382, 2234, 462); INSERT INTO components VALUES ('n7', 'instrument', 'STA', 1871, 681, 1935, 747); INSERT INTO components VALUES ('n8', 'heat_exchanger', 'CS-77', 1961, 766, 2001, 846); INSERT INTO components VALUES ('n9', 'control_valve', 'CV-18402', 1808, 976, 1871, 1065); INSERT INTO components VALUES ('n10', 'instrument', 'SDL 496', 1189, 1539, 1268, 1619); INSERT INTO components VALUES ('n11', 'instrument', 'SDL 945', 1374, 1539, 1453, 1619); INSERT INTO components VALUES ('n12', 'fitting', '11"', 1802, 1497, 1857, 1603); INSERT INTO components VALUES ('n13', 'check_valve', 'KL-26998', 1005, 1750, 1069, 1792); INSERT INTO components VALUES ('n14', 'check_valve', 'KL-15697', 1210, 1750, 1268, 1792); INSERT INTO components VALUES ('n15', 'valve', 'IJ-60239', 1497, 1857, 1535, 1907); INSERT INTO components VALUES ('n16', 'valve', 'MN-30398', 979, 1943, 1039, 1987); INSERT INTO components VALUES ('n17', 'valve', 'AB-52626', 1236, 1943, 1296, 1987); INSERT INTO components VALUES ('n18', 'valve', 'QR-79461', 1410, 1935, 1483, 1983); INSERT INTO components VALUES ('n19', 'instrument', 'STA', 1477, 2031, 1553, 2098); INSERT INTO components VALUES ('n20', 'valve', 'IJ-60726', 534, 2051, 573, 2104); INSERT INTO components VALUES ('n21', 'fitting', '8"x5"', 725, 2047, 772, 2102); INSERT INTO components VALUES ('n22', 'control_valve', 'CV-85305', 920, 2047, 1001, 2120); INSERT INTO components VALUES ('n23', 'valve', 'ERV-3-29', 725, 2232, 770, 2280); INSERT INTO components VALUES ('n24', 'valve', 'IJ-16278', 1173, 2136, 1246, 2178); INSERT INTO components VALUES ('n25', 'check_valve', 'EF-12806', 1760, 2136, 1810, 2178); INSERT INTO components VALUES ('n26', 'valve', 'MN-82149', 1981, 2136, 2039, 2178); INSERT INTO components VALUES ('n27', 'instrument', 'SDL 619', 1477, 2216, 1557, 2295); INSERT INTO components VALUES ('n28', 'valve', 'IJ-31997', 2076, 2256, 2116, 2305); INSERT INTO components VALUES ('n29', 'check_valve', 'EF-55708', 2350, 402, 2397, 442); INSERT INTO components VALUES ('n30', 'fitting', NULL, 2563, 398, 2594, 442); INSERT INTO components VALUES ('n31', 'valve', 'ERV-7-91', 2648, 478, 2704, 538); INSERT INTO components VALUES ('n32', 'fitting', 'DV-88470', 2656, 693, 2694, 733); INSERT INTO components VALUES ('n33', 'instrument', 'STA', 2256, 478, 2318, 547); INSERT INTO components VALUES ('n34', 'fitting', '4"', 2793, 398, 2837, 502); INSERT INTO components VALUES ('n35', 'check_valve', 'EF-83045', 3321, 404, 3375, 442); INSERT INTO components VALUES ('n36', 'instrument', 'RO-10 981', 3502, 384, 3582, 460); INSERT INTO components VALUES ('n37', 'check_valve', 'OP-94534', 3620, 462, 3657, 528); INSERT INTO components VALUES ('n38', 'instrument', 'STA', 2553, 772, 2622, 844); INSERT INTO components VALUES ('n39', 'valve', 'GH-93788', 2371, 788, 2431, 828); INSERT INTO components VALUES ('n40', 'valve', 'AV-15205', 3618, 860, 3657, 916); INSERT INTO components VALUES ('n41', 'instrument', 'INS (33°C)', 3677, 952, 3779, 1027); INSERT INTO components VALUES ('n42', 'valve', 'AB-76067', 2656, 1057, 2694, 1111); INSERT INTO components VALUES ('n43', 'valve', 'MN-51667', 2656, 1274, 2702, 1330); INSERT INTO components VALUES ('n44', 'valve', 'QR-09606', 2465, 1254, 2513, 1334); INSERT INTO components VALUES ('n45', 'check_valve', 'OP-73064', 3100, 1364, 3162, 1402); INSERT INTO components VALUES ('n46', 'instrument', 'RO-10 173', 3315, 1358, 3395, 1417); INSERT INTO components VALUES ('n47', 'valve', 'UV-56185', 3703, 1364, 3755, 1406); INSERT INTO components VALUES ('n48', 'fitting', 'DV-66767', 3233, 1702, 3275, 1744); INSERT INTO components VALUES ('n49', 'valve', 'AB-90443', 3299, 1559, 3351, 1597); INSERT INTO components VALUES ('n50', 'valve', 'QR-43392', 3488, 1553, 3556, 1597); INSERT INTO components VALUES ('n51', 'relief_valve', 'RV-97189', 3679, 1559, 3719, 1599); INSERT INTO components VALUES ('n52', 'valve', 'AV-59188', 3813, 1625, 3853, 1696); INSERT INTO components VALUES ('n53', 'instrument', 'STA', 3604, 1632, 3669, 1708); INSERT INTO components VALUES ('n54', 'valve', 'MN-39629', 3146, 1746, 3208, 1790); INSERT INTO components VALUES ('n55', 'fitting', 'DV-34119', 3361, 1752, 3407, 1792); INSERT INTO components VALUES ('n56', 'valve', 'AV-23482', 3508, 1752, 3564, 1790); INSERT INTO components VALUES ('n57', 'valve', 'EF-60688', 3813, 1824, 3853, 1883); INSERT INTO components VALUES ('n58', 'check_valve', 'KL-88581', 2535, 1945, 2598, 1985); INSERT INTO components VALUES ('n59', 'relief_valve', 'RV-85503', 3614, 1991, 3663, 2041); INSERT INTO components VALUES ('n60', 'fitting', '15"', 2465, 2076, 2563, 2114); INSERT INTO components VALUES ('n61', 'valve', 'EF-28597', 3241, 2226, 3285, 2281); INSERT INTO components VALUES ('n62', 'fitting', '2"', 2563, 2270, 2608, 2379); INSERT INTO components VALUES ('n63', 'instrument', 'DDL 557', 3889, 770, 3968, 844); INSERT INTO components VALUES ('n64', 'valve', 'QR-78354', 4122, 780, 4189, 828); INSERT INTO components VALUES ('n65', 'valve', 'MN-31971', 4281, 786, 4331, 828); INSERT INTO components VALUES ('n66', 'instrument', 'INS (-23°C)', 4456, 786, 4564, 826); INSERT INTO components VALUES ('n67', 'fitting', NULL, 4685, 782, 4715, 830); INSERT INTO components VALUES ('n68', 'relief_valve', 'RV-68883', 4884, 786, 4932, 828); INSERT INTO components VALUES ('n69', 'fitting', NULL, 5071, 782, 5101, 830); INSERT INTO components VALUES ('n70', 'check_valve', 'EF-73042', 4199, 1099, 4239, 1163); INSERT INTO components VALUES ('n71', 'valve', 'AB-76986', 4199, 1256, 4237, 1310); INSERT INTO components VALUES ('n72', 'valve', 'QR-85827', 4199, 1467, 4247, 1539); INSERT INTO components VALUES ('n73', 'relief_valve', 'RV-91499', 4199, 1648, 4237, 1692); INSERT INTO components VALUES ('n74', 'valve', 'UV-28499', 4126, 1362, 4185, 1404); INSERT INTO components VALUES ('n75', 'valve', 'QR-94293', 4257, 1362, 4321, 1404); INSERT INTO components VALUES ('n76', 'control_valve', 'ST-83558', 4659, 1362, 4733, 1421); INSERT INTO components VALUES ('n77', 'valve', 'ST-93347', 5356, 1091, 5412, 1155); INSERT INTO components VALUES ('n78', 'instrument', 'DDL 270', 4653, 1732, 4739, 1804); INSERT INTO components VALUES ('n79', 'fitting', '19"', 4430, 1744, 4470, 1851); INSERT INTO components VALUES ('n80', 'control_valve', 'CV-86457', 5256, 1744, 5336, 1836); INSERT INTO components VALUES ('n81', 'valve', 'EF-19457', 5356, 1832, 5396, 1891); INSERT INTO components VALUES ('n82', 'instrument', 'ZLO 937', 5145, 1828, 5217, 1911); INSERT INTO components VALUES ('n83', 'check_valve', 'EF-50503', 5262, 2138, 5338, 2182); INSERT INTO components VALUES ('n84', 'fitting', '5"', 5296, 2086, 5400, 2122); INSERT INTO components VALUES ('n85', 'valve', 'QR-48191', 5133, 2254, 5213, 2329); INSERT INTO components VALUES ('n86', 'control_valve', 'CV-00837', 5316, 2230, 5400, 2309); INSERT INTO components VALUES ('n87', 'fitting', '2"', 4197, 2086, 4301, 2134); INSERT INTO components VALUES ('n88', 'check_valve', 'UV-68723', 3905, 1947, 3978, 1987); INSERT INTO components VALUES ('n89', 'fitting', 'DV-78174', 532, 2481, 573, 2524); INSERT INTO components VALUES ('n90', 'fitting', '6"', 472, 2775, 571, 2819); INSERT INTO components VALUES ('n91', 'instrument', 'LG-10 949', 607, 2889, 687, 2968); INSERT INTO components VALUES ('n92', 'check_valve', 'OP-36885', 725, 2815, 766, 2889); INSERT INTO components VALUES ('n93', 'valve', 'WX-40553', 725, 2385, 766, 2441); INSERT INTO components VALUES ('n94', 'relief_valve', 'RV-04870', 1304, 2425, 1346, 2467); INSERT INTO components VALUES ('n95', 'valve', 'IJ-98705', 1306, 2634, 1344, 2686); INSERT INTO components VALUES ('n96', 'fitting', 'DV-66274', 1304, 2771, 1346, 2813); INSERT INTO components VALUES ('n97', 'heat_exchanger', 'CS-53', 1294, 3038, 1354, 3074); INSERT INTO components VALUES ('n98', 'fitting', '8"', 1244, 3181, 1350, 3221); INSERT INTO components VALUES ('n99', 'instrument', 'INS (-19°C)', 1565, 2491, 1668, 2570); INSERT INTO components VALUES ('n100', 'valve', 'MN-13137', 1802, 2520, 1861, 2566); INSERT INTO components VALUES ('n101', 'valve', 'WX-53124', 2124, 2524, 2184, 2564); INSERT INTO components VALUES ('n102', 'instrument', 'ZLO 620', 2057, 2413, 2134, 2493); INSERT INTO components VALUES ('n103', 'valve', 'CD-84992', 2270, 2795, 2309, 2843); INSERT INTO components VALUES ('n104', 'valve', 'GH-74381', 2270, 2968, 2309, 3038); INSERT INTO components VALUES ('n105', 'instrument', 'STA', 2254, 3372, 2323, 3440); INSERT INTO components VALUES ('n106', 'instrument', 'STA', 2642, 2421, 2706, 2487); INSERT INTO components VALUES ('n107', 'instrument', 'RO-10 801', 2531, 2518, 2610, 2578); INSERT INTO components VALUES ('n108', 'fitting', '8"x8"', 3233, 2421, 3281, 2477); INSERT INTO components VALUES ('n109', 'valve', 'AB-48297', 2849, 2634, 2889, 2700); INSERT INTO components VALUES ('n110', 'valve', 'IJ-21593', 3040, 2594, 3080, 2650); INSERT INTO components VALUES ('n111', 'check_valve', 'OP-27346', 2849, 3014, 2889, 3086); INSERT INTO components VALUES ('n112', 'fitting', '14"', 2738, 3042, 2788, 3142); INSERT INTO components VALUES ('n113', 'valve', 'ST-60287', 2847, 3217, 2889, 3287); INSERT INTO components VALUES ('n114', 'instrument', 'STA', 3028, 2998, 3090, 3066); INSERT INTO components VALUES ('n115', 'instrument', 'GLR 869', 3018, 3193, 3098, 3273); INSERT INTO components VALUES ('n116', 'check_valve', 'EF-14579', 3341, 3102, 3405, 3144); INSERT INTO components VALUES ('n117', 'check_valve', 'KL-59249', 2847, 3402, 2889, 3456); INSERT INTO components VALUES ('n118', 'check_valve', 'OP-91470', 3040, 3386, 3080, 3456); INSERT INTO components VALUES ('n119', 'valve', 'GH-30478', 3907, 2524, 3966, 2564); INSERT INTO components VALUES ('n120', 'fitting', '5"x6"', 4002, 2596, 4048, 2654); INSERT INTO components VALUES ('n121', 'fitting', '4"x9"', 4293, 2524, 4351, 2568); INSERT INTO components VALUES ('n122', 'check_valve', 'OP-38909', 4394, 2584, 4432, 2656); INSERT INTO components VALUES ('n123', 'relief_valve', 'RV-14440', 4392, 2839, 4430, 2875); INSERT INTO components VALUES ('n124', 'check_valve', 'KL-63740', 4297, 3098, 4351, 3142); INSERT INTO components VALUES ('n125', 'instrument', 'SDL 372', 4377, 3177, 4456, 3261); INSERT INTO components VALUES ('n126', 'heat_exchanger', 'CS-81', 4377, 3416, 4444, 3452); INSERT INTO components VALUES ('n127', 'valve', 'IJ-37700', 4006, 3357, 4046, 3412); INSERT INTO components VALUES ('n128', 'fitting', '3"', 4922, 2467, 4964, 2564); INSERT INTO components VALUES ('n129', 'valve', 'ERV-7-16', 5233, 2510, 5300, 2576); INSERT INTO components VALUES ('n130', 'check_valve', 'KL-51845', 5167, 2425, 5201, 2500); INSERT INTO components VALUES ('n131', 'valve', 'ERV-7-91', 5161, 2590, 5211, 2644); INSERT INTO components VALUES ('n132', 'valve', 'CD-09245', 5356, 2425, 5396, 2485); INSERT INTO components VALUES ('n133', 'fitting', '11"', 5356, 2964, 5456, 3004); INSERT INTO components VALUES ('n134', 'heat_exchanger', 'CS-25', 5270, 3088, 5310, 3157); INSERT INTO components VALUES ('n135', 'instrument', 'ZLO 949', 4850, 3084, 4930, 3163); INSERT INTO components VALUES ('n136', 'instrument', 'INS (41°C)', 5157, 3173, 5209, 3281); INSERT INTO components VALUES ('n137', 'fitting', '3"', 966, 3431, 1005, 3531); INSERT INTO components VALUES ('n138', 'fitting', NULL, 1599, 3487, 1627, 3531); INSERT INTO components VALUES ('n139', 'valve', 'IJ-79828', 1111, 3760, 1151, 3831); INSERT INTO components VALUES ('n140', 'check_valve', 'EF-74609', 1111, 3933, 1151, 3985); INSERT INTO components VALUES ('n141', 'check_valve', 'OP-42988', 1111, 4134, 1151, 4194); INSERT INTO components VALUES ('n142', 'fitting', '9"', 1218, 3865, 1258, 3921); INSERT INTO components VALUES ('n143', 'valve', 'CD-44557', 1304, 3756, 1344, 3825); INSERT INTO components VALUES ('n144', 'relief_valve', 'RV-19622', 1549, 3875, 1589, 3915); INSERT INTO components VALUES ('n145', 'fitting', '13"', 1786, 3841, 1826, 3921); INSERT INTO components VALUES ('n146', 'valve', 'CD-11313', 1941, 3875, 1997, 3915); INSERT INTO components VALUES ('n147', 'instrument', 'DDL 598', 1380, 4247, 1459, 4315); INSERT INTO components VALUES ('n148', 'valve', 'CD-32941', 1573, 4263, 1627, 4299); INSERT INTO components VALUES ('n149', 'valve', 'WX-75983', 1760, 4261, 1822, 4295); INSERT INTO components VALUES ('n150', 'fitting', '15"', 2234, 3590, 2309, 3630); INSERT INTO components VALUES ('n151', 'check_valve', 'OP-39981', 2270, 3805, 2305, 3861); INSERT INTO components VALUES ('n152', 'valve', 'ERV-7-36', 2260, 3925, 2315, 3981); INSERT INTO components VALUES ('n153', 'fitting', NULL, 2130, 4064, 2162, 4112); INSERT INTO components VALUES ('n154', 'instrument', 'SDL 153', 2539, 3467, 2618, 3547); INSERT INTO components VALUES ('n155', 'instrument', 'DDL 944', 3118, 3467, 3198, 3547); INSERT INTO components VALUES ('n156', 'valve', 'WX-79663', 3538, 3487, 3598, 3529); INSERT INTO components VALUES ('n157', 'valve', 'QR-58750', 2463, 3752, 2513, 3825); INSERT INTO components VALUES ('n158', 'valve', 'IJ-45100', 2656, 3792, 2696, 3857); INSERT INTO components VALUES ('n159', 'instrument', 'LG-10 422', 2636, 3951, 2716, 4034); INSERT INTO components VALUES ('n160', 'heat_exchanger', 'CS-97', 2405, 4050, 2439, 4124); INSERT INTO components VALUES ('n161', 'valve', 'IJ-24687', 2563, 4070, 2628, 4108); INSERT INTO components VALUES ('n162', 'valve', 'QR-10555', 2748, 4060, 2823, 4100); INSERT INTO components VALUES ('n163', 'fitting', 'DV-80035', 2543, 4259, 2588, 4299); INSERT INTO components VALUES ('n164', 'check_valve', 'KL-74278', 2748, 4259, 2807, 4299); INSERT INTO components VALUES ('n165', 'instrument', 'RO-10 174', 2827, 3766, 2907, 3845); INSERT INTO components VALUES ('n166', 'valve', 'UV-33413', 2959, 3682, 3020, 3720); INSERT INTO components VALUES ('n167', 'fitting', 'DV-44019', 2979, 3875, 3022, 3915); INSERT INTO components VALUES ('n168', 'instrument', 'ZLO 942', 3020, 3951, 3100, 4028); INSERT INTO components VALUES ('n169', 'valve', 'ERV-6-03', 3034, 3756, 3090, 3809); INSERT INTO components VALUES ('n170', 'heat_exchanger', 'CS-68', 3528, 3656, 3554, 3736); INSERT INTO components VALUES ('n171', 'valve', 'CD-04398', 3709, 3682, 3783, 3722); INSERT INTO components VALUES ('n172', 'fitting', 'DV-59004', 3811, 3792, 3853, 3831); INSERT INTO components VALUES ('n173', 'valve', 'ST-52799', 3610, 3931, 3657, 4001); INSERT INTO components VALUES ('n174', 'valve', 'ERV-3-54', 3753, 4064, 3803, 4114); INSERT INTO components VALUES ('n175', 'instrument', 'GLR 130', 3888, 4040, 3966, 4120); INSERT INTO components VALUES ('n176', 'instrument', 'LG-10 385', 3789, 4152, 3873, 4230); INSERT INTO components VALUES ('n177', 'fitting', '7"', 3305, 4009, 3349, 4108); INSERT INTO components VALUES ('n178', 'check_valve', 'KL-81705', 3490, 4259, 3554, 4299); INSERT INTO components VALUES ('n179', 'valve', 'GH-72399', 3679, 4259, 3759, 4299); INSERT INTO components VALUES ('n180', 'fitting', NULL, 3809, 3407, 3859, 3441); INSERT INTO components VALUES ('n181', 'fitting', '2"x1"', 4002, 3596, 4048, 3648); INSERT INTO components VALUES ('n182', 'check_valve', 'KL-85200', 4006, 3760, 4046, 3825); INSERT INTO components VALUES ('n183', 'check_valve', 'KL-84900', 4076, 3871, 4152, 3915); INSERT INTO components VALUES ('n184', 'instrument', 'LG-10 637', 4277, 3855, 4353, 3935); INSERT INTO components VALUES ('n185', 'check_valve', 'OP-50395', 4006, 3955, 4046, 4024); INSERT INTO components VALUES ('n186', 'valve', 'MN-60206', 4396, 4124, 4436, 4184); INSERT INTO components VALUES ('n187', 'valve', 'GH-33693', 5091, 3871, 5147, 3913); INSERT INTO components VALUES ('n188', 'relief_valve', 'RV-59732', 4255, 3680, 4297, 3722); INSERT INTO components VALUES ('n189', 'fitting', NULL, 4106, 3680, 4138, 3726); INSERT INTO components VALUES ('j1', 'junction', NULL, 1010.375, 1631.9375, 1020.375, 1641.9375); INSERT INTO components VALUES ('j2', 'junction', NULL, 2022.0, 2508.3333333333335, 2032.0, 2518.3333333333335); INSERT INTO components VALUES ('j3', 'junction', NULL, 2357.0, 2470.4411764705883, 2367.0, 2480.4411764705883); INSERT INTO components VALUES ('j4', 'junction', NULL, 2927.9, 3228.7, 2937.9, 3238.7); INSERT INTO components VALUES ('j5', 'junction', NULL, 1494.5, 1690.5, 1504.5, 1700.5); INSERT INTO components VALUES ('j6', 'junction', NULL, 2993.3333333333335, 3125.3333333333335, 3003.3333333333335, 3135.3333333333335); INSERT INTO components VALUES ('j7', 'junction', NULL, 3932.0, 3058.125, 3942.0, 3068.125); INSERT INTO components VALUES ('j8', 'junction', NULL, 4503.291666666667, 2365.9166666666665, 4513.291666666667, 2375.9166666666665); INSERT INTO components VALUES ('j9', 'junction', NULL, 4502.3, 3810.2, 4512.3, 3820.2); INSERT INTO components VALUES ('j10', 'junction', NULL, 5139.875, 2529.5, 5149.875, 2539.5); INSERT INTO components VALUES ('j11', 'junction', NULL, 5344.5, 2655.6666666666665, 5354.5, 2665.6666666666665); INSERT INTO components VALUES ('j12', 'junction', NULL, 5132.25, 3017.5, 5142.25, 3027.5); INSERT INTO components VALUES ('j13', 'junction', NULL, 1265.1, 3550.4, 1275.1, 3560.4); INSERT INTO components VALUES ('j14', 'junction', NULL, 1161.6666666666667, 3877.5, 1171.6666666666667, 3887.5); INSERT INTO components VALUES ('j15', 'junction', NULL, 1372.0, 3854.5, 1382.0, 3864.5); INSERT INTO components VALUES ('j16', 'junction', NULL, 2156.625, 4096.5, 2166.625, 4106.5); INSERT INTO components VALUES ('j17', 'junction', NULL, 1487.5, 1963.5, 1497.5, 1973.5); INSERT INTO components VALUES ('j18', 'junction', NULL, 3874.0, 3646.8571428571427, 3884.0, 3656.8571428571427); INSERT INTO components VALUES ('j19', 'junction', NULL, 2680.6666666666665, 4048.8333333333335, 2690.6666666666665, 4058.8333333333335); INSERT INTO components VALUES ('j20', 'junction', NULL, 3003.0, 3960.7, 3013.0, 3970.7); INSERT INTO components VALUES ('j21', 'junction', NULL, 3035.8333333333335, 3884.0, 3045.8333333333335, 3894.0); INSERT INTO components VALUES ('j22', 'junction', NULL, 3890.9375, 3971.5625, 3900.9375, 3981.5625); INSERT INTO components VALUES ('j23', 'junction', NULL, 3590.9, 4129.3, 3600.9, 4139.3); INSERT INTO components VALUES ('j24', 'junction', NULL, 3978.8, 4133.7, 3988.8, 4143.7); INSERT INTO components VALUES ('j25', 'junction', NULL, 1465.3, 2211.0, 1475.3, 2221.0); INSERT INTO components VALUES ('j26', 'junction', NULL, 645.5, 2222.625, 655.5, 2232.625); INSERT INTO components VALUES ('j27', 'junction', NULL, 2279.8333333333335, 447.1666666666667, 2289.8333333333335, 457.1666666666667); INSERT INTO components VALUES ('j28', 'junction', NULL, 2684.8333333333335, 454.3333333333333, 2694.8333333333335, 464.3333333333333); INSERT INTO components VALUES ('j29', 'junction', NULL, 3185.3333333333335, 794.1666666666666, 3195.3333333333335, 804.1666666666666); INSERT INTO components VALUES ('j30', 'junction', NULL, 2436.125, 850.625, 2446.125, 860.625); INSERT INTO components VALUES ('j31', 'junction', NULL, 3610.285714285714, 1348.4285714285713, 3620.285714285714, 1358.4285714285713); INSERT INTO components VALUES ('j32', 'junction', NULL, 4097.125, 927.875, 4107.125, 937.875); INSERT INTO components VALUES ('j33', 'junction', NULL, 3264.5, 1874.125, 3274.5, 1884.125); INSERT INTO components VALUES ('j34', 'junction', NULL, 1899.1666666666667, 514.3333333333334, 1909.1666666666667, 524.3333333333334); INSERT INTO components VALUES ('j35', 'junction', NULL, 3921.1666666666665, 1830.0555555555557, 3931.1666666666665, 1840.0555555555557); INSERT INTO components VALUES ('j36', 'junction', NULL, 1902.8333333333333, 841.8333333333334, 1912.8333333333333, 851.8333333333334); INSERT INTO components VALUES ('j37', 'junction', NULL, 4216.375, 1383.0, 4226.375, 1393.0); INSERT INTO components VALUES ('j38', 'junction', NULL, 5183.0, 1536.5, 5193.0, 1546.5); INSERT INTO components VALUES ('j39', 'junction', NULL, 5052.666666666667, 1804.1666666666667, 5062.666666666667, 1814.1666666666667); INSERT INTO components VALUES ('j40', 'junction', NULL, 5213.0, 2102.0, 5223.0, 2112.0); INSERT INTO components VALUES ('j41', 'junction', NULL, 5330.333333333333, 2172.8333333333335, 5340.333333333333, 2182.8333333333335); INSERT INTO connections VALUES ('n1', 'n2', 'process', NULL); INSERT INTO connections VALUES ('n1', 'n3', 'process', NULL); INSERT INTO connections VALUES ('n10', 'n11', 'process', NULL); INSERT INTO connections VALUES ('n10', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n13', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n16', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n2', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n20', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n21', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n22', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n9', 'j1', 'process', NULL); INSERT INTO connections VALUES ('n100', 'j2', 'process', NULL); INSERT INTO connections VALUES ('n101', 'j2', 'process', NULL); INSERT INTO connections VALUES ('n102', 'j2', 'process', NULL); INSERT INTO connections VALUES ('n100', 'n99', 'process', NULL); INSERT INTO connections VALUES ('n101', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n103', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n105', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n107', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n12', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n138', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n150', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n154', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n157', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n26', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n28', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n43', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n44', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n45', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n58', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n60', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n62', 'j3', 'process', NULL); INSERT INTO connections VALUES ('n102', 'n28', 'process', NULL); INSERT INTO connections VALUES ('n103', 'n104', 'process', NULL); INSERT INTO connections VALUES ('n104', 'n105', 'process', NULL); INSERT INTO connections VALUES ('n106', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n107', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n108', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n109', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n110', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n112', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n117', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n118', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n154', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n155', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n158', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n165', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n166', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n169', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n170', 'j4', 'process', NULL); INSERT INTO connections VALUES ('n106', 'n62', 'process', NULL); INSERT INTO connections VALUES ('n108', 'n61', 'process', NULL); INSERT INTO connections VALUES ('n109', 'n111', 'process', NULL); INSERT INTO connections VALUES ('n11', 'j5', 'process', NULL); INSERT INTO connections VALUES ('n12', 'j5', 'process', NULL); INSERT INTO connections VALUES ('n14', 'j5', 'process', NULL); INSERT INTO connections VALUES ('n15', 'j5', 'process', NULL); INSERT INTO connections VALUES ('n110', 'n114', 'process', NULL); INSERT INTO connections VALUES ('n111', 'j6', 'process', NULL); INSERT INTO connections VALUES ('n112', 'j6', 'process', NULL); INSERT INTO connections VALUES ('n113', 'j6', 'process', NULL); INSERT INTO connections VALUES ('n114', 'j6', 'process', NULL); INSERT INTO connections VALUES ('n115', 'j6', 'process', NULL); INSERT INTO connections VALUES ('n116', 'j6', 'process', NULL); INSERT INTO connections VALUES ('n113', 'n117', 'process', NULL); INSERT INTO connections VALUES ('n115', 'n118', 'process', NULL); INSERT INTO connections VALUES ('n116', 'j7', 'process', NULL); INSERT INTO connections VALUES ('n120', 'j7', 'process', NULL); INSERT INTO connections VALUES ('n124', 'j7', 'process', NULL); INSERT INTO connections VALUES ('n127', 'j7', 'process', NULL); INSERT INTO connections VALUES ('n119', 'n120', 'process', NULL); INSERT INTO connections VALUES ('n119', 'n59', 'process', NULL); INSERT INTO connections VALUES ('n121', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n122', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n123', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n124', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n125', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n128', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n135', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n75', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n76', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n78', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n79', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n87', 'j8', 'process', NULL); INSERT INTO connections VALUES ('n122', 'n123', 'process', NULL); INSERT INTO connections VALUES ('n125', 'n126', 'process', NULL); INSERT INTO connections VALUES ('n126', 'j9', 'process', NULL); INSERT INTO connections VALUES ('n184', 'j9', 'process', NULL); INSERT INTO connections VALUES ('n186', 'j9', 'process', NULL); INSERT INTO connections VALUES ('n187', 'j9', 'process', NULL); INSERT INTO connections VALUES ('n188', 'j9', 'process', NULL); INSERT INTO connections VALUES ('n127', 'n181', 'process', NULL); INSERT INTO connections VALUES ('n128', 'j10', 'process', NULL); INSERT INTO connections VALUES ('n129', 'j10', 'process', NULL); INSERT INTO connections VALUES ('n130', 'j10', 'process', NULL); INSERT INTO connections VALUES ('n131', 'j10', 'process', NULL); INSERT INTO connections VALUES ('n129', 'j11', 'process', NULL); INSERT INTO connections VALUES ('n132', 'j11', 'process', NULL); INSERT INTO connections VALUES ('n133', 'j11', 'process', NULL); INSERT INTO connections VALUES ('n13', 'n14', 'process', NULL); INSERT INTO connections VALUES ('n130', 'n85', 'process', NULL); INSERT INTO connections VALUES ('n131', 'j12', 'process', NULL); INSERT INTO connections VALUES ('n134', 'j12', 'process', NULL); INSERT INTO connections VALUES ('n135', 'j12', 'process', NULL); INSERT INTO connections VALUES ('n136', 'j12', 'process', NULL); INSERT INTO connections VALUES ('n132', 'n86', 'process', NULL); INSERT INTO connections VALUES ('n133', 'n134', 'process', NULL); INSERT INTO connections VALUES ('n137', 'j13', 'process', NULL); INSERT INTO connections VALUES ('n138', 'j13', 'process', NULL); INSERT INTO connections VALUES ('n139', 'j13', 'process', NULL); INSERT INTO connections VALUES ('n143', 'j13', 'process', NULL); INSERT INTO connections VALUES ('n98', 'j13', 'process', NULL); INSERT INTO connections VALUES ('n139', 'j14', 'process', NULL); INSERT INTO connections VALUES ('n140', 'j14', 'process', NULL); INSERT INTO connections VALUES ('n142', 'j14', 'process', NULL); INSERT INTO connections VALUES ('n140', 'n141', 'process', NULL); INSERT INTO connections VALUES ('n141', 'n147', 'process', NULL); INSERT INTO connections VALUES ('n142', 'j15', 'process', NULL); INSERT INTO connections VALUES ('n143', 'j15', 'process', NULL); INSERT INTO connections VALUES ('n144', 'j15', 'process', NULL); INSERT INTO connections VALUES ('n144', 'n145', 'process', NULL); INSERT INTO connections VALUES ('n145', 'n146', 'process', NULL); INSERT INTO connections VALUES ('n147', 'n148', 'process', NULL); INSERT INTO connections VALUES ('n148', 'n149', 'process', NULL); INSERT INTO connections VALUES ('n149', 'j16', 'process', NULL); INSERT INTO connections VALUES ('n152', 'j16', 'process', NULL); INSERT INTO connections VALUES ('n153', 'j16', 'process', NULL); INSERT INTO connections VALUES ('n160', 'j16', 'process', NULL); INSERT INTO connections VALUES ('n15', 'j17', 'process', NULL); INSERT INTO connections VALUES ('n18', 'j17', 'process', NULL); INSERT INTO connections VALUES ('n19', 'j17', 'process', NULL); INSERT INTO connections VALUES ('n150', 'n151', 'process', NULL); INSERT INTO connections VALUES ('n151', 'n152', 'process', NULL); INSERT INTO connections VALUES ('n156', 'j18', 'process', NULL); INSERT INTO connections VALUES ('n171', 'j18', 'process', NULL); INSERT INTO connections VALUES ('n172', 'j18', 'process', NULL); INSERT INTO connections VALUES ('n180', 'j18', 'process', NULL); INSERT INTO connections VALUES ('n181', 'j18', 'process', NULL); INSERT INTO connections VALUES ('n182', 'j18', 'process', NULL); INSERT INTO connections VALUES ('n189', 'j18', 'process', NULL); INSERT INTO connections VALUES ('n158', 'n159', 'process', NULL); INSERT INTO connections VALUES ('n159', 'j19', 'process', NULL); INSERT INTO connections VALUES ('n161', 'j19', 'process', NULL); INSERT INTO connections VALUES ('n162', 'j19', 'process', NULL); INSERT INTO connections VALUES ('n16', 'n17', 'process', NULL); INSERT INTO connections VALUES ('n160', 'n161', 'process', NULL); INSERT INTO connections VALUES ('n162', 'j20', 'process', NULL); INSERT INTO connections VALUES ('n165', 'j20', 'process', NULL); INSERT INTO connections VALUES ('n167', 'j20', 'process', NULL); INSERT INTO connections VALUES ('n168', 'j20', 'process', NULL); INSERT INTO connections VALUES ('n177', 'j20', 'process', NULL); INSERT INTO connections VALUES ('n163', 'n164', 'process', NULL); INSERT INTO connections VALUES ('n164', 'n178', 'process', NULL); INSERT INTO connections VALUES ('n167', 'j21', 'process', NULL); INSERT INTO connections VALUES ('n168', 'j21', 'process', NULL); INSERT INTO connections VALUES ('n169', 'j21', 'process', NULL); INSERT INTO connections VALUES ('n17', 'n18', 'process', NULL); INSERT INTO connections VALUES ('n170', 'n171', 'process', NULL); INSERT INTO connections VALUES ('n172', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n173', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n174', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n175', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n176', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n182', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n183', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n185', 'j22', 'process', NULL); INSERT INTO connections VALUES ('n173', 'j23', 'process', NULL); INSERT INTO connections VALUES ('n174', 'j23', 'process', NULL); INSERT INTO connections VALUES ('n177', 'j23', 'process', NULL); INSERT INTO connections VALUES ('n178', 'j23', 'process', NULL); INSERT INTO connections VALUES ('n179', 'j23', 'process', NULL); INSERT INTO connections VALUES ('n175', 'j24', 'process', NULL); INSERT INTO connections VALUES ('n176', 'j24', 'process', NULL); INSERT INTO connections VALUES ('n179', 'j24', 'process', NULL); INSERT INTO connections VALUES ('n185', 'j24', 'process', NULL); INSERT INTO connections VALUES ('n186', 'j24', 'process', NULL); INSERT INTO connections VALUES ('n183', 'n184', 'process', NULL); INSERT INTO connections VALUES ('n188', 'n189', 'process', NULL); INSERT INTO connections VALUES ('n19', 'j25', 'process', NULL); INSERT INTO connections VALUES ('n24', 'j25', 'process', NULL); INSERT INTO connections VALUES ('n25', 'j25', 'process', NULL); INSERT INTO connections VALUES ('n27', 'j25', 'process', NULL); INSERT INTO connections VALUES ('n94', 'j25', 'process', NULL); INSERT INTO connections VALUES ('n20', 'j26', 'process', NULL); INSERT INTO connections VALUES ('n21', 'j26', 'process', NULL); INSERT INTO connections VALUES ('n23', 'j26', 'process', NULL); INSERT INTO connections VALUES ('n89', 'j26', 'process', NULL); INSERT INTO connections VALUES ('n22', 'n24', 'process', NULL); INSERT INTO connections VALUES ('n23', 'n93', 'process', NULL); INSERT INTO connections VALUES ('n25', 'n26', 'process', NULL); INSERT INTO connections VALUES ('n27', 'n99', 'process', NULL); INSERT INTO connections VALUES ('n29', 'n30', 'process', NULL); INSERT INTO connections VALUES ('n29', 'j27', 'process', NULL); INSERT INTO connections VALUES ('n33', 'j27', 'process', NULL); INSERT INTO connections VALUES ('n6', 'j27', 'process', NULL); INSERT INTO connections VALUES ('n3', 'n4', 'process', NULL); INSERT INTO connections VALUES ('n30', 'j28', 'process', NULL); INSERT INTO connections VALUES ('n31', 'j28', 'process', NULL); INSERT INTO connections VALUES ('n34', 'j28', 'process', NULL); INSERT INTO connections VALUES ('n31', 'n32', 'process', NULL); INSERT INTO connections VALUES ('n32', 'j29', 'process', NULL); INSERT INTO connections VALUES ('n37', 'j29', 'process', NULL); INSERT INTO connections VALUES ('n38', 'j29', 'process', NULL); INSERT INTO connections VALUES ('n40', 'j29', 'process', NULL); INSERT INTO connections VALUES ('n42', 'j29', 'process', NULL); INSERT INTO connections VALUES ('n63', 'j29', 'process', NULL); INSERT INTO connections VALUES ('n33', 'j30', 'process', NULL); INSERT INTO connections VALUES ('n38', 'j30', 'process', NULL); INSERT INTO connections VALUES ('n39', 'j30', 'process', NULL); INSERT INTO connections VALUES ('n44', 'j30', 'process', NULL); INSERT INTO connections VALUES ('n34', 'n35', 'process', NULL); INSERT INTO connections VALUES ('n35', 'n36', 'process', NULL); INSERT INTO connections VALUES ('n36', 'n37', 'process', NULL); INSERT INTO connections VALUES ('n39', 'n8', 'process', NULL); INSERT INTO connections VALUES ('n40', 'j31', 'process', NULL); INSERT INTO connections VALUES ('n41', 'j31', 'process', NULL); INSERT INTO connections VALUES ('n46', 'j31', 'process', NULL); INSERT INTO connections VALUES ('n47', 'j31', 'process', NULL); INSERT INTO connections VALUES ('n50', 'j31', 'process', NULL); INSERT INTO connections VALUES ('n51', 'j31', 'process', NULL); INSERT INTO connections VALUES ('n53', 'j31', 'process', NULL); INSERT INTO connections VALUES ('n41', 'j32', 'process', NULL); INSERT INTO connections VALUES ('n64', 'j32', 'process', NULL); INSERT INTO connections VALUES ('n65', 'j32', 'process', NULL); INSERT INTO connections VALUES ('n70', 'j32', 'process', NULL); INSERT INTO connections VALUES ('n42', 'n43', 'process', NULL); INSERT INTO connections VALUES ('n45', 'n46', 'process', NULL); INSERT INTO connections VALUES ('n47', 'n74', 'process', NULL); INSERT INTO connections VALUES ('n48', 'n49', 'process', NULL); INSERT INTO connections VALUES ('n48', 'j33', 'process', NULL); INSERT INTO connections VALUES ('n54', 'j33', 'process', NULL); INSERT INTO connections VALUES ('n55', 'j33', 'process', NULL); INSERT INTO connections VALUES ('n61', 'j33', 'process', NULL); INSERT INTO connections VALUES ('n49', 'n50', 'process', NULL); INSERT INTO connections VALUES ('n5', 'j34', 'process', NULL); INSERT INTO connections VALUES ('n6', 'j34', 'process', NULL); INSERT INTO connections VALUES ('n7', 'j34', 'process', NULL); INSERT INTO connections VALUES ('n51', 'n52', 'process', NULL); INSERT INTO connections VALUES ('n52', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n53', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n56', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n57', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n59', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n73', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n79', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n87', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n88', 'j35', 'process', NULL); INSERT INTO connections VALUES ('n54', 'n58', 'process', NULL); INSERT INTO connections VALUES ('n55', 'n56', 'process', NULL); INSERT INTO connections VALUES ('n57', 'n88', 'process', NULL); INSERT INTO connections VALUES ('n63', 'n64', 'process', NULL); INSERT INTO connections VALUES ('n65', 'n66', 'process', NULL); INSERT INTO connections VALUES ('n66', 'n67', 'process', NULL); INSERT INTO connections VALUES ('n67', 'n68', 'process', NULL); INSERT INTO connections VALUES ('n68', 'n69', 'process', NULL); INSERT INTO connections VALUES ('n7', 'j36', 'process', NULL); INSERT INTO connections VALUES ('n8', 'j36', 'process', NULL); INSERT INTO connections VALUES ('n9', 'j36', 'process', NULL); INSERT INTO connections VALUES ('n70', 'n71', 'process', NULL); INSERT INTO connections VALUES ('n71', 'j37', 'process', NULL); INSERT INTO connections VALUES ('n72', 'j37', 'process', NULL); INSERT INTO connections VALUES ('n74', 'j37', 'process', NULL); INSERT INTO connections VALUES ('n75', 'j37', 'process', NULL); INSERT INTO connections VALUES ('n72', 'n73', 'process', NULL); INSERT INTO connections VALUES ('n76', 'j38', 'process', NULL); INSERT INTO connections VALUES ('n77', 'j38', 'process', NULL); INSERT INTO connections VALUES ('n80', 'j38', 'process', NULL); INSERT INTO connections VALUES ('n81', 'j38', 'process', NULL); INSERT INTO connections VALUES ('n78', 'j39', 'process', NULL); INSERT INTO connections VALUES ('n80', 'j39', 'process', NULL); INSERT INTO connections VALUES ('n82', 'j39', 'process', NULL); INSERT INTO connections VALUES ('n80', 'n81', 'process', NULL); INSERT INTO connections VALUES ('n81', 'n84', 'process', NULL); INSERT INTO connections VALUES ('n82', 'j40', 'process', NULL); INSERT INTO connections VALUES ('n83', 'j40', 'process', NULL); INSERT INTO connections VALUES ('n85', 'j40', 'process', NULL); INSERT INTO connections VALUES ('n83', 'j41', 'process', NULL); INSERT INTO connections VALUES ('n84', 'j41', 'process', NULL); INSERT INTO connections VALUES ('n86', 'j41', 'process', NULL); INSERT INTO connections VALUES ('n89', 'n90', 'process', NULL); INSERT INTO connections VALUES ('n90', 'n91', 'process', NULL); INSERT INTO connections VALUES ('n91', 'n92', 'process', NULL); INSERT INTO connections VALUES ('n92', 'n93', 'process', NULL); INSERT INTO connections VALUES ('n94', 'n95', 'process', NULL); INSERT INTO connections VALUES ('n95', 'n96', 'process', NULL); INSERT INTO connections VALUES ('n96', 'n97', 'process', NULL); INSERT INTO connections VALUES ('n97', 'n98', 'process', NULL);