-- Generated SQL INSERT statements for nodes
-- Generated from nodes.xlsx (new format)

-- Enable explicit ID insertion for node table
SET IDENTITY_INSERT node ON;

-- Node 1: Shanghai (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             1,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Shanghai (Metropolitan area)',
             N'98 Liuhe Rd, Huangpu, Shanghai, China, 200001',
             'Shanghai',
             0,
             0,
             0,
             1,
             31.2306,
             121.4736
         );

-- Node 2: Hangzhou (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             2,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Hangzhou (Metropolitan area)',
             N'Long Hewan Cookshop, 朝晖地区 Xia Cheng Qu, Hang Zhou Shi, Zhe Jiang Sheng, China, 310014',
             'Hangzhou',
             0,
             0,
             0,
             1,
             30.2904,
             120.1701
         );

-- Node 3: Yangzhong (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             3,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Yangzhong (Metropolitan area)',
             N'CN 江苏省 镇江市 扬中市 11-107, China, 212299',
             'Yangzhong',
             0,
             0,
             0,
             1,
             32.251,
             119.8078
         );

-- Node 4: Taicang (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             4,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Taicang (Metropolitan area)',
             N'China, Jiangsu, Suzhou, Taicang, 公园街 邮政编码: 215437',
             'Taicang',
             0,
             0,
             0,
             1,
             31.5521,
             121.1483
         );

-- Node 5: Jingjiang (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             5,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Jingjiang (Metropolitan area)',
             N'8 Xinzhou Rd, Jingjiang, Taizhou, Jiangsu, China, 214527',
             'Jingjiang',
             0,
             0,
             0,
             1,
             31.9836,
             120.2469
         );

-- Node 6: Qingdao (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             6,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Qingdao (Metropolitan area)',
             N'China, 155甲22号CN 山东省 青岛市 李沧区 文昌路 155 邮政编码: 266046',
             'Qingdao',
             0,
             0,
             0,
             1,
             36.1867,
             120.4089
         );

-- Node 7: Fuqing (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             7,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Fuqing (Metropolitan area)',
             N'China, Fujian, Fuzhou, Fuqing, Houpu St, 一拂路 邮政编码: 350323',
             'Fuqing',
             0,
             0,
             0,
             1,
             25.7202,
             119.3837
         );

-- Node 8: Linfen (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             8,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Linfen (Metropolitan area)',
             N'China, Shanxi, Linfen, Yaodu District, Shifu St, 行署巷 邮政编码: 041000',
             'Linfen',
             0,
             0,
             0,
             1,
             36.088,
             111.5189
         );

-- Node 9: Bangalore (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             9,
             (SELECT id FROM country WHERE iso_code = 'IN'),
             N'Bangalore (Metropolitan area)',
             N'197, Bommasandra Indst. Area Hosur Road, Taluk, Anekal, Bengaluru, Karnataka 560099, Indien',
             'Bangalore',
             0,
             0,
             0,
             1,
             12.8205,
             77.6951
         );

-- Node 10: Pune (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             10,
             (SELECT id FROM country WHERE iso_code = 'IN'),
             N'Pune (Metropolitan area)',
             N'Moie, Pimpri-Chinchwad, Maharashtra 411062, Indien',
             'Pune',
             0,
             0,
             0,
             1,
             18.6984,
             73.8239
         );

-- Node 11: Shenzhen (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             11,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Shenzhen (Metropolitan area)',
             N'Fuzhong 3rd Rd, 福田ＣＢＤ Futian District, Shenzhen, Guangdong Province, China, 518000',
             'Shenzhen',
             0,
             0,
             0,
             1,
             22.542,
             114.0593
         );

-- Node 12: Aurangabad (Metropolitan area)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             12,
             (SELECT id FROM country WHERE iso_code = 'IN'),
             N'Aurangabad (Metropolitan area)',
             N'Gut no, Teesgaon, 113 B, Ahmednagar - Aurangabad Rd, CIDCO Waluj Mahanagar 2, Waluj, Aurangabad, Dharmapur, Maharashtra 431136, Indien',
             'Aurangabad',
             0,
             0,
             0,
             1,
             19.8475,
             75.2671
         );

-- Node 13: Linde (China) Forklift Truck (Supplier) (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             13,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Linde (China) Forklift Truck (Supplier) (KION plant)',
             N'89 Jinshang Rd, Siming District, Xiamen, Fujian, China, 361009',
             'LX',
             0,
             0,
             1,
             0,
             24.489,
             118.1478
         );

-- Node 14: KION Baoli (Jiangsu) Forklift Co., Ltd. (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             14,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'KION Baoli (Jiangsu) Forklift Co., Ltd. (KION plant)',
             N'8 Xinzhou Rd, Jingjiang, Taizhou, Jiangsu, China, 214527',
             'JJ',
             0,
             0,
             1,
             0,
             31.9836,
             120.2469
         );

-- Node 15: Aschaffenburg (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             15,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Aschaffenburg (KION plant)',
             N'Großostheimer Str. 198, 63741 Aschaffenburg',
             'AB',
             0,
             1,
             1,
             0,
             49.9506,
             9.1038
         );

-- Node 16: Hamburg (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             16,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Hamburg (KION plant)',
             N'Berzeliusstraße 5, 22113 Hamburg',
             'HH',
             0,
             1,
             1,
             0,
             53.537,
             10.0844
         );

-- Node 17: Geisa (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             17,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Geisa (KION plant)',
             N'Schleider Str. 13, 36419 Geisa',
             'FGG',
             0,
             1,
             1,
             0,
             50.7077,
             9.9478
         );

-- Node 18: Reutlingen (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             18,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Reutlingen (KION plant)',
             N'Ernst-Wagner-Weg 1-5, 72766 Reutlingen',
             'KWS',
             0,
             1,
             1,
             0,
             48.5639,
             9.2456
         );

-- Node 19: Dinklage (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             19,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Dinklage (KION plant)',
             N'In d. Bahler Heide 5, 49413 Dinklage',
             'EGD',
             0,
             1,
             1,
             0,
             52.6736,
             8.1319
         );

-- Node 20: Châtellerault (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             20,
             (SELECT id FROM country WHERE iso_code = 'FR'),
             N'Châtellerault (KION plant)',
             N'Rue de Touraine, 86530 Cenon-sur-Vienne, Frankreich',
             'CTT',
             0,
             1,
             1,
             0,
             46.7762,
             0.5351
         );

-- Node 21: Luzzara (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             21,
             (SELECT id FROM country WHERE iso_code = 'IT'),
             N'Luzzara (KION plant)',
             N'Via Bosa Est, 25, 42045 Luzzara RE, Italien',
             'LZZ',
             0,
             1,
             1,
             0,
             44.9421,
             10.7078
         );

-- Node 22: Stříbro (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             22,
             (SELECT id FROM country WHERE iso_code = 'CZ'),
             N'Stříbro (KION plant)',
             N'Ostrov u Stříbra 19, 349 01 Stříbro, Tschechien',
             'STR',
             0,
             1,
             1,
             0,
             49.7002,
             13.035
         );

-- Node 23: Nový Jičín (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             23,
             (SELECT id FROM country WHERE iso_code = 'CZ'),
             N'Nový Jičín (KION plant)',
             N'Dukelská 102, 742 42 Šenov u Nového Jičína, Tschechien',
             'VOP',
             0,
             1,
             1,
             0,
             49.6153,
             17.9932
         );

-- Node 24: Kołbaskowo (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             24,
             (SELECT id FROM country WHERE iso_code = 'PL'),
             N'Kołbaskowo (KION plant)',
             N'Kołbaskowo 70, 72-001, Polen',
             'KOL',
             0,
             1,
             1,
             0,
             53.3271,
             14.4288
         );

-- Node 25: Český Krumlov (KION plant)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             25,
             (SELECT id FROM country WHERE iso_code = 'CZ'),
             N'Český Krumlov (KION plant)',
             N'Tovární 118, 381 01 Český Krumlov 1, Tschechien',
             'LIPO',
             0,
             1,
             1,
             0,
             48.8316,
             14.334
         );

-- Node 26: Urban Zbůch (Warehouse)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             26,
             (SELECT id FROM country WHERE iso_code = 'CZ'),
             N'Urban Zbůch (Warehouse)',
             N'Sokolská 35, 330 22 Zbůch, Tschechien',
             'WH_ZBU',
             1,
             0,
             0,
             1,
             49.684,
             13.2244
         );

-- Node 27: Urban Stockstadt (Warehouse)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             27,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Urban Stockstadt (Warehouse)',
             N'Gewerbegebiet Nördlich der Aschaffenburger Straße, Aschaffenburger Str. 1, 63811 Stockstadt am Main',
             'WH_STO',
             1,
             0,
             0,
             1,
             49.9725,
             9.0786
         );

-- Node 28: Hamburg (Warehouse)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             28,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Hamburg (Warehouse)',
             N'Berzeliusstraße 5, 22113 Hamburg',
             'WH_HH',
             1,
             0,
             0,
             1,
             53.537,
             10.0844
         );

-- Node 29: Shanghai (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             29,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Shanghai (Port)',
             N'Gangdian Rd, Pudong, Shanghai, China, 200131',
             'CNSHA',
             0,
             0,
             0,
             1,
             31.364,
             121.5979
         );

-- Node 30: Qingdao (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             30,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Qingdao (Port)',
             N'Weisi Rd, Huangdao, Qingdao, Shandong, China, 266500',
             'CNTAO',
             0,
             0,
             0,
             1,
             36.0215,
             120.2149
         );

-- Node 31: Xiamen (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             31,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Xiamen (Port)',
             N'Haicang District, Xiamen, Fujian, China, 361026',
             'CNXMN',
             0,
             0,
             0,
             1,
             24.4486,
             118.0363
         );

-- Node 32: Yantian (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             32,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Yantian (Port)',
             N'Yantian District, Shenzhen, Guangdong Province, China',
             'CNYTN',
             0,
             0,
             0,
             1,
             22.5765,
             114.2656
         );

-- Node 33: Nhava Sheva (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             33,
             (SELECT id FROM country WHERE iso_code = 'IN'),
             N'Nhava Sheva (Port)',
             N'Navi Mumbai, Juna Sheva, Maharashtra 400707, Indien',
             'INNSA',
             0,
             0,
             0,
             1,
             18.9503,
             72.951
         );

-- Node 34: Hamburg (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             34,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Hamburg (Port)',
             N'Waltershofer Damm, 21129 Hamburg',
             'DEHAM',
             0,
             0,
             0,
             1,
             53.5271,
             9.9297
         );

-- Node 35: Le Havre (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             35,
             (SELECT id FROM country WHERE iso_code = 'FR'),
             N'Le Havre (Port)',
             N'Zone Port 2000, Route de l’Estuaire Port Sud, 76600 Le Havre, Frankreich',
             'FRLEH',
             0,
             0,
             0,
             1,
             49.4632,
             0.1485
         );

-- Node 36: Zeebrugge (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             36,
             (SELECT id FROM country WHERE iso_code = 'BE'),
             N'Zeebrugge (Port)',
             N'Leopold II Laan, kaai 120, 8380 Brugge, Belgien',
             'BEZEE',
             0,
             0,
             0,
             1,
             51.3457,
             3.1946
         );

-- Node 37: Chennai (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             37,
             (SELECT id FROM country WHERE iso_code = 'IN'),
             N'Chennai (Port)',
             N'Ground Chennai Port Trust Administrative Building, 1, Rajaji Salai, Chennai, Tamil Nadu 600001, Indien',
             'INMAA',
             0,
             0,
             0,
             1,
             13.1104,
             80.2973
         );

-- Node 38: Hong Kong (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             38,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Hong Kong (Port)',
             N'Tsing Yi, Hongkong',
             'HKMBP',
             0,
             0,
             0,
             1,
             22.3407,
             114.1113
         );

-- Node 39: Genoa (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             39,
             (SELECT id FROM country WHERE iso_code = 'IT'),
             N'Genoa (Port)',
             N'Viale Africa, 16149 Genova GE, Italien',
             'ITGOA',
             0,
             0,
             0,
             1,
             44.4106,
             8.8823
         );

-- Node 40: Shenzhen (Port)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             40,
             (SELECT id FROM country WHERE iso_code = 'CN'),
             N'Shenzhen (Port)',
             N'Yantian District, Shenzhen, Guangdong Province, China',
             'CNSZX',
             0,
             0,
             0,
             1,
             22.558,
             114.2416
         );

-- Node 41: Urban Logistics Hub Aschaffenburg (Warehouse)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             41,
             (SELECT id FROM country WHERE iso_code = 'DE'),
             N'Urban Logistics Hub Aschaffenburg (Warehouse)',
             N'Großostheimer Str. 198, 63741 Aschaffenburg',
             'WH_ULHA',
             0,
             0,
             0,
             1,
             49.9506,
             9.1038
         );

-- Node 42: Geodis bâtiment 3 (Warehouse)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             42,
             (SELECT id FROM country WHERE iso_code = 'FR'),
             N'Geodis bâtiment 3 (Warehouse)',
             N'115 Allée des érables, 86130 Dissay, France',
             'WH_BAT3',
             0,
             0,
             0,
             1,
             46.7027,
             0.4035
         );

-- Node 43: Jeantet Ouest (Warehouse)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             43,
             (SELECT id FROM country WHERE iso_code = 'FR'),
             N'Jeantet Ouest (Warehouse)',
             N'12 Rue Dieudonné Costes et Mauric, 86100 Châtellerault, France',
             'WH_JEAN',
             1,
             0,
             0,
             1,
             46.8403,
             0.5424
         );

-- Node 44: Urban Rolo I (Warehouse)
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             44,
             (SELECT id FROM country WHERE iso_code = 'IT'),
             N'Urban Rolo I (Warehouse)',
             N'Via Vincenzo Mari 3, 42047 Rolo RE, Italien',
             'WH_ROLO',
             1,
             0,
             0,
             1,
             44.8712,
             10.8493
         );

-- Node 45: GW LOGISTICS a.s.
INSERT INTO node (
    id,
    country_id,
    name,
    address,
    external_mapping_id,
    predecessor_required,
    is_destination,
    is_source,
    is_intermediate,
    geo_lat,
    geo_lng
) VALUES (
             45,
             (SELECT id FROM country WHERE iso_code = 'CZ'),
             N'GW LOGISTICS a.s.',
             N'Pekárenská 255/77 37004 České Budějovice 4',
             'WH_BUD',
             1,
             0,
             0,
             1,
             48.9845,
             14.4923
         );

-- Disable explicit ID insertion for node table
SET IDENTITY_INSERT node OFF;

