GitHub user wangzhewwzz added a comment to the discussion: 关于电网拓扑数据导入

原始数据:
{"id": "BDZ-3002", "name": "110kV变电站", "objectType": "变电站", "objectHandle": 
"319E", "deviceType": "110kV变电站", "internalEndpointNo": 0, "terminalNo": 0, 
"usage": "", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3445"]}
{"id": "XLD-3445", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3473", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104954, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["BDZ-3002", "HWX-3087"]}
{"id": "HWX-3087", "name": "环网箱", "objectType": "站房", "objectHandle": "322A", 
"deviceType": "环网箱", "internalEndpointNo": 30, "terminalNo": 104955, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3445", "XLD-3258", "XLD-3455"]}
{"id": "XLD-3258", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33B8", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104279, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3087", "HWX-3109"]}
{"id": "XLD-3455", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"347D", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104989, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3087", "XLKG-3019"]}
{"id": "HWX-3109", "name": "环网箱", "objectType": "站房", "objectHandle": "3293", 
"deviceType": "环网箱", "internalEndpointNo": 23, "terminalNo": 104280, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3258", "XLD-3673", "XLD-3699", "XLD-3505"]}
{"id": "XLKG-3019", "name": "分支开关", "objectType": "线路开关", "objectHandle": 
"33A1", "deviceType": "分支开关", "internalEndpointNo": 0, "terminalNo": 104990, 
"usage": "分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3455", "XLD-3724"]}
{"id": "XLD-3673", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3557", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105637, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3109", "XB-3047"]}
{"id": "XLD-3699", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3571", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105703, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3109", "HWX-3112"]}
{"id": "XLD-3505", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"34AF", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105128, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3109", "XB-3091"]}
{"id": "XLD-3724", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"358A", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105787, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLKG-3019", "XLD-3721", 
"XLD-3722", "XLD-3726"]}
{"id": "XB-3047", "name": "箱变", "objectType": "站房", "objectHandle": "329D", 
"deviceType": "箱变", "internalEndpointNo": 8, "terminalNo": 105638, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3673"]}
{"id": "HWX-3112", "name": "环网箱", "objectType": "站房", "objectHandle": "329C", 
"deviceType": "环网箱", "internalEndpointNo": 25, "terminalNo": 105704, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3699", "XLD-3437", "XLD-3666"]}
{"id": "XB-3091", "name": "箱变", "objectType": "站房", "objectHandle": "338E", 
"deviceType": "箱变", "internalEndpointNo": 2, "terminalNo": 105129, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3505"]}
{"id": "XLD-3721", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"3587", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105774, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3724", "ZSB-3017"]}
{"id": "XLD-3722", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"3588", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105774, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3724"]}
{"id": "XLD-3726", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"358C", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105774, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3724", "ZSB-3016"]}
{"id": "XLD-3437", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"346B", "deviceType": "电缆", "internalEndpointNo": 1, "terminalNo": 104936, 
"usage": "分支", "powerFlowDirection": -1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3112", "DLFZX-3136"]}
{"id": "XLD-3666", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3550", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105619, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3112", "HWX-3062"]}
{"id": "ZSB-3017", "name": "柱上变", "objectType": "用电接入点", "objectHandle": 
"339C", "deviceType": "柱上变", "internalEndpointNo": 0, "terminalNo": 105778, 
"usage": "", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3721"]}
{"id": "ZSB-3016", "name": "柱上变", "objectType": "用电接入点", "objectHandle": 
"339B", "deviceType": "柱上变", "internalEndpointNo": 0, "terminalNo": 105790, 
"usage": "", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3726"]}
{"id": "DLFZX-3136", "name": "电缆分支箱", "objectType": "站房", "objectHandle": 
"324E", "deviceType": "电缆分支箱", "internalEndpointNo": 7, "terminalNo": 104935, 
"usage": "分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3437", "XLD-3484"]}
{"id": "HWX-3062", "name": "环网箱", "objectType": "站房", "objectHandle": "31BB", 
"deviceType": "环网箱", "internalEndpointNo": 30, "terminalNo": 105620, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3666", "XLD-3267", "XLD-3264", "XLD-3263"]}
{"id": "XLD-3484", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"349A", "deviceType": "电缆", "internalEndpointNo": 6, "terminalNo": 105074, 
"usage": "分支", "powerFlowDirection": -1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["DLFZX-3136", "HWX-3085"]}
{"id": "XLD-3267", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33C1", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104325, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3062", "DLFZX-3194"]}
{"id": "XLD-3264", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33BE", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104302, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3062", "HWX-3063"]}
{"id": "XLD-3263", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33BD", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104299, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3062", "HWX-3058"]}
{"id": "HWX-3085", "name": "环网箱", "objectType": "站房", "objectHandle": "3226", 
"deviceType": "环网箱", "internalEndpointNo": 23, "terminalNo": 105073, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3484", "XLD-3257", "XLD-3629", "XLD-3788"]}
{"id": "DLFZX-3194", "name": "电缆分支箱", "objectType": "站房", "objectHandle": 
"32F9", "deviceType": "电缆分支箱", "internalEndpointNo": 8, "terminalNo": 104328, 
"usage": "分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3267", "XLD-3274"]}
{"id": "HWX-3063", "name": "环网箱", "objectType": "站房", "objectHandle": "31BC", 
"deviceType": "环网箱", "internalEndpointNo": 30, "terminalNo": 104308, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3264", "XLD-3265"]}
{"id": "HWX-3058", "name": "环网箱", "objectType": "站房", "objectHandle": "31B8", 
"deviceType": "环网箱", "internalEndpointNo": 14, "terminalNo": 104301, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3263", "XLD-3262"]}
{"id": "XLD-3257", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33B7", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104277, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3085", "PDS-3068"]}
{"id": "XLD-3629", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"352B", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105519, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3085", "HWX-3095"]}
{"id": "XLD-3788", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"35D0", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105915, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3085", "XB-3079"]}
{"id": "XLD-3274", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33C8", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104362, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["DLFZX-3194", "PDS-3008"]}
{"id": "XLD-3265", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33BF", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104309, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3063", "DLFZX-3183"]}
{"id": "XLD-3262", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33BC", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104292, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3058", "HWX-3059"]}
{"id": "PDS-3068", "name": "配电室", "objectType": "站房", "objectHandle": "3289", 
"deviceType": "配电室", "internalEndpointNo": 22, "terminalNo": 104278, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3257"]}
{"id": "HWX-3095", "name": "环网箱", "objectType": "站房", "objectHandle": "3247", 
"deviceType": "环网箱", "internalEndpointNo": 23, "terminalNo": 105520, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3629", "XLD-3510", "XLD-3383", "XLD-3488"]}
{"id": "XB-3079", "name": "箱变", "objectType": "站房", "objectHandle": "3348", 
"deviceType": "箱变", "internalEndpointNo": 3, "terminalNo": 105916, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3788"]}
{"id": "PDS-3008", "name": "配电室", "objectType": "站房", "objectHandle": "306B", 
"deviceType": "配电室", "internalEndpointNo": 19, "terminalNo": 104364, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3274"]}
{"id": "DLFZX-3183", "name": "电缆分支箱", "objectType": "站房", "objectHandle": 
"32D4", "deviceType": "电缆分支箱", "internalEndpointNo": 10, "terminalNo": 104316, 
"usage": "主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3265", "XLD-3266"]}
{"id": "HWX-3059", "name": "环网箱", "objectType": "站房", "objectHandle": "31B9", 
"deviceType": "环网箱", "internalEndpointNo": 14, "terminalNo": 104298, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3262", "XLD-3261"]}
{"id": "XLD-3510", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"34B4", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105149, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3095", "HWX-3143"]}
{"id": "XLD-3383", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3435", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104779, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3095", "HWX-3084"]}
{"id": "XLD-3488", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"349E", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105084, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3095", "HWX-3105"]}
{"id": "XLD-3266", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33C0", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104317, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["DLFZX-3183", "DLFZX-3112"]}
{"id": "XLD-3261", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33BB", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104287, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3059", "HWX-3061"]}
{"id": "HWX-3143", "name": "环网箱", "objectType": "站房", "objectHandle": "3359", 
"deviceType": "环网箱", "internalEndpointNo": 34, "terminalNo": 105151, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3510", "XLD-3789", "XLD-3790", "XLD-3791"]}
{"id": "HWX-3084", "name": "环网箱", "objectType": "站房", "objectHandle": "3220", 
"deviceType": "环网箱", "internalEndpointNo": 25, "terminalNo": 104783, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3383", "XLD-3659"]}
{"id": "HWX-3105", "name": "环网箱", "objectType": "站房", "objectHandle": "327B", 
"deviceType": "环网箱", "internalEndpointNo": 1, "terminalNo": 105085, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3488", "XLD-3502", "XLD-3622"]}
{"id": "DLFZX-3112", "name": "电缆分支箱", "objectType": "站房", "objectHandle": 
"320A", "deviceType": "电缆分支箱", "internalEndpointNo": 9, "terminalNo": 104324, 
"usage": "主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3266", "XLD-3365"]}
{"id": "HWX-3061", "name": "环网箱", "objectType": "站房", "objectHandle": "31BA", 
"deviceType": "环网箱", "internalEndpointNo": 14, "terminalNo": 104291, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3261", "XLD-3576"]}
{"id": "XLD-3789", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"35D1", "deviceType": "电缆", "internalEndpointNo": 1, "terminalNo": 105918, 
"usage": "分支", "powerFlowDirection": -1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3143", "XB-3048"]}
{"id": "XLD-3790", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"35D2", "deviceType": "电缆", "internalEndpointNo": 1, "terminalNo": 105920, 
"usage": "分支", "powerFlowDirection": -1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3143", "XB-3090"]}
{"id": "XLD-3791", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"35D3", "deviceType": "电缆", "internalEndpointNo": 1, "terminalNo": 105922, 
"usage": "分支", "powerFlowDirection": -1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3143", "XB-3086"]}
{"id": "XLD-3659", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3549", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105603, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3084", "HWX-3018"]}
{"id": "XLD-3502", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"34AC", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105123, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3105", "XB-3077"]}
{"id": "XLD-3622", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3524", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105495, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3105", "XB-3080"]}
{"id": "XLD-3365", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3423", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104699, 
"usage": "主干", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["DLFZX-3112", "HWX-3055"]}
{"id": "XLD-3576", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"34F6", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105350, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3061", "HWX-3104"]}
{"id": "XB-3048", "name": "箱变", "objectType": "站房", "objectHandle": "32A1", 
"deviceType": "箱变", "internalEndpointNo": 6, "terminalNo": 105917, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3789"]}
{"id": "XB-3090", "name": "箱变", "objectType": "站房", "objectHandle": "3389", 
"deviceType": "箱变", "internalEndpointNo": 3, "terminalNo": 105919, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3790"]}
{"id": "XB-3086", "name": "箱变", "objectType": "站房", "objectHandle": "3376", 
"deviceType": "箱变", "internalEndpointNo": 2, "terminalNo": 105921, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3791"]}
{"id": "HWX-3018", "name": "环网箱", "objectType": "站房", "objectHandle": "324F", 
"deviceType": "环网箱", "internalEndpointNo": 21, "terminalNo": 105604, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3659", "XLD-3450"]}
{"id": "XB-3077", "name": "箱变", "objectType": "站房", "objectHandle": "332D", 
"deviceType": "箱变", "internalEndpointNo": 7, "terminalNo": 105124, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3502"]}
{"id": "XB-3080", "name": "箱变", "objectType": "站房", "objectHandle": "3349", 
"deviceType": "箱变", "internalEndpointNo": 7, "terminalNo": 105496, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3622"]}
{"id": "HWX-3055", "name": "环网箱", "objectType": "站房", "objectHandle": "31A9", 
"deviceType": "环网箱", "internalEndpointNo": 28, "terminalNo": 104700, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3365", "XLD-3405", "XLD-3719", "XLD-3638", 
"XLD-3269"]}
{"id": "HWX-3104", "name": "环网箱", "objectType": "站房", "objectHandle": "3279", 
"deviceType": "环网箱", "internalEndpointNo": 25, "terminalNo": 105352, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3576"]}
{"id": "XLD-3450", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3478", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104971, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3018", "HWX-3082"]}
{"id": "XLD-3405", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"344B", "deviceType": "电缆", "internalEndpointNo": 6, "terminalNo": 104847, 
"usage": "主干", "powerFlowDirection": -1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3055", "HWX-3004"]}
{"id": "XLD-3719", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"3585", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105763, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3055", "XLD-3792", 
"XLD-3716", "XLD-3720"]}
{"id": "XLD-3638", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3534", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105544, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3055", "DLFZX-3124"]}
{"id": "XLD-3269", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"33C3", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104332, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3055", "XB-3076"]}
{"id": "HWX-3082", "name": "环网箱", "objectType": "站房", "objectHandle": "3218", 
"deviceType": "环网箱", "internalEndpointNo": 30, "terminalNo": 104972, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3450", "XLD-3668", "XLD-4124", "XLD-3377", 
"XLD-3380"]}
{"id": "HWX-3004", "name": "环网箱", "objectType": "站房", "objectHandle": "301B", 
"deviceType": "环网箱", "internalEndpointNo": 25, "terminalNo": 104841, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3405", "XLD-3625", "XLD-3474", "XLD-3640"]}
{"id": "XLD-3792", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"35D4", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105765, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3719", "ZSB-3019"]}
{"id": "XLD-3716", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"3582", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105751, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3719", "XB-3061"]}
{"id": "XLD-3720", "name": "绝缘线路段", "objectType": "线路段", "objectHandle": 
"3586", "deviceType": "绝缘", "internalEndpointNo": 0, "terminalNo": 105751, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3719", "ZSB-3018"]}
{"id": "DLFZX-3124", "name": "电缆分支箱", "objectType": "站房", "objectHandle": 
"322D", "deviceType": "电缆分支箱", "internalEndpointNo": 3, "terminalNo": 105545, 
"usage": "分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3638", "XLD-3540"]}
{"id": "XB-3076", "name": "箱变", "objectType": "站房", "objectHandle": "331F", 
"deviceType": "箱变", "internalEndpointNo": 4, "terminalNo": 104335, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3269"]}
{"id": "XLD-3668", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3552", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105624, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3082", "HWX-3006"]}
{"id": "XLD-4124", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"37D6", "deviceType": "电缆", "internalEndpointNo": 1, "terminalNo": 106794, 
"usage": "分支", "powerFlowDirection": -1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3082", "HWX-3013"]}
{"id": "XLD-3377", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"342F", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104750, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3082", "PDS-3091"]}
{"id": "XLD-3380", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3432", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 104773, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3082", "PDS-3047"]}
{"id": "XLD-3625", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3527", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105504, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3004", "DLFZX-3258"]}
{"id": "XLD-3474", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3490", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105036, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3004", "DLFZX-3248"]}
{"id": "XLD-3640", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"3536", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105553, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["HWX-3004", "DLFZX-3149"]}
{"id": "ZSB-3019", "name": "柱上变", "objectType": "用电接入点", "objectHandle": 
"339E", "deviceType": "柱上变", "internalEndpointNo": 0, "terminalNo": 105923, 
"usage": "", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3792"]}
{"id": "XB-3061", "name": "箱变", "objectType": "站房", "objectHandle": "32E7", 
"deviceType": "箱变", "internalEndpointNo": 10, "terminalNo": 105754, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3716"]}
{"id": "ZSB-3018", "name": "柱上变", "objectType": "用电接入点", "objectHandle": 
"339D", "deviceType": "柱上变", "internalEndpointNo": 0, "terminalNo": 105773, 
"usage": "", "powerFlowDirection": 0, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["XLD-3720"]}
{"id": "XLD-3540", "name": "电缆线路段", "objectType": "线路段", "objectHandle": 
"34D2", "deviceType": "电缆", "internalEndpointNo": 0, "terminalNo": 105225, 
"usage": "分支", "powerFlowDirection": 1, "belongSubstation": "中沙变", 
"belongFeeder": "10kV正泰192线", "connectedTo": ["DLFZX-3124", "DLFZX-3256"]}
{"id": "HWX-3006", "name": "环网箱", "objectType": "站房", "objectHandle": "3058", 
"deviceType": "环网箱", "internalEndpointNo": 25, "terminalNo": 105626, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3668"]}
{"id": "HWX-3013", "name": "环网箱", "objectType": "站房", "objectHandle": "3217", 
"deviceType": "环网箱", "internalEndpointNo": 21, "terminalNo": 106793, "usage": 
"主干", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-4124"]}
{"id": "PDS-3091", "name": "配电室", "objectType": "站房", "objectHandle": "32FB", 
"deviceType": "配电室", "internalEndpointNo": 19, "terminalNo": 104752, "usage": 
"分支", "powerFlowDirection": 0, "belongSubstation": "中沙变", "belongFeeder": 
"10kV正泰192线", "connectedTo": ["XLD-3377"]}



edge_connected_to.csv
id
from
to
label

edge_1
BDZ-3002
XLD-3445
CONNECTED_TO

edge_2
XLD-3445
HWX-3087
CONNECTED_TO

edge_3
HWX-3087
XLD-3258
CONNECTED_TO

edge_4
HWX-3087
XLD-3455
CONNECTED_TO

edge_5
XLD-3258
HWX-3109
CONNECTED_TO

edge_6
XLD-3455
XLKG-3019
CONNECTED_TO

edge_7
HWX-3109
XLD-3673
CONNECTED_TO

edge_8
HWX-3109
XLD-3699
CONNECTED_TO

edge_9
HWX-3109
XLD-3505
CONNECTED_TO

edge_10
XLKG-3019
XLD-3724
CONNECTED_TO

edge_11
XLD-3673
XB-3047
CONNECTED_TO

edge_12
XLD-3699
HWX-3112
CONNECTED_TO

edge_13
XLD-3505
XB-3091
CONNECTED_TO

edge_14
XLD-3724
XLD-3721
CONNECTED_TO

edge_15
XLD-3724
XLD-3722
CONNECTED_TO

edge_16
XLD-3724
XLD-3726
CONNECTED_TO

edge_17
HWX-3112
XLD-3437
CONNECTED_TO

edge_18
HWX-3112
XLD-3666
CONNECTED_TO

edge_19
XLD-3721
ZSB-3017
CONNECTED_TO

edge_20
XLD-3726
ZSB-3016
CONNECTED_TO

edge_21
XLD-3437
DLFZX-3136
CONNECTED_TO

edge_22
XLD-3666
HWX-3062
CONNECTED_TO

edge_23
DLFZX-3136
XLD-3484
CONNECTED_TO

edge_24
HWX-3062
XLD-3267
CONNECTED_TO

edge_25
HWX-3062
XLD-3264
CONNECTED_TO

edge_26
HWX-3062
XLD-3263
CONNECTED_TO

edge_27
XLD-3484
HWX-3085
CONNECTED_TO

edge_28
XLD-3267
DLFZX-3194
CONNECTED_TO

edge_29
XLD-3264
HWX-3063
CONNECTED_TO

edge_30
XLD-3263
HWX-3058
CONNECTED_TO

edge_31
HWX-3085
XLD-3257
CONNECTED_TO

edge_32
HWX-3085
XLD-3629
CONNECTED_TO

edge_33
HWX-3085
XLD-3788
CONNECTED_TO

edge_34
DLFZX-3194
XLD-3274
CONNECTED_TO

edge_35
HWX-3063
XLD-3265
CONNECTED_TO

edge_36
HWX-3058
XLD-3262
CONNECTED_TO

edge_37
XLD-3257
PDS-3068
CONNECTED_TO

edge_38
XLD-3629
HWX-3095
CONNECTED_TO

edge_39
XLD-3788
XB-3079
CONNECTED_TO

edge_40
XLD-3274
PDS-3008
CONNECTED_TO

edge_41
XLD-3265
DLFZX-3183
CONNECTED_TO

edge_42
XLD-3262
HWX-3059
CONNECTED_TO

edge_43
HWX-3095
XLD-3510
CONNECTED_TO

edge_44
HWX-3095
XLD-3383
CONNECTED_TO

edge_45
HWX-3095
XLD-3488
CONNECTED_TO

edge_46
DLFZX-3183
XLD-3266
CONNECTED_TO

edge_47
HWX-3059
XLD-3261
CONNECTED_TO

edge_48
XLD-3510
HWX-3143
CONNECTED_TO

edge_49
XLD-3383
HWX-3084
CONNECTED_TO

edge_50
XLD-3488
HWX-3105
CONNECTED_TO

edge_51
XLD-3266
DLFZX-3112
CONNECTED_TO

edge_52
XLD-3261
HWX-3061
CONNECTED_TO

edge_53
HWX-3143
XLD-3789
CONNECTED_TO

edge_54
HWX-3143
XLD-3790
CONNECTED_TO

edge_55
HWX-3143
XLD-3791
CONNECTED_TO

edge_56
HWX-3084
XLD-3659
CONNECTED_TO

edge_57
HWX-3105
XLD-3502
CONNECTED_TO

edge_58
HWX-3105
XLD-3622
CONNECTED_TO

edge_59
DLFZX-3112
XLD-3365
CONNECTED_TO

edge_60
HWX-3061
XLD-3576
CONNECTED_TO

edge_61
XLD-3789
XB-3048
CONNECTED_TO

edge_62
XLD-3790
XB-3090
CONNECTED_TO

edge_63
XLD-3791
XB-3086
CONNECTED_TO

edge_64
XLD-3659
HWX-3018
CONNECTED_TO

edge_65
XLD-3502
XB-3077
CONNECTED_TO

edge_66
XLD-3622
XB-3080
CONNECTED_TO

edge_67
XLD-3365
HWX-3055
CONNECTED_TO

edge_68
XLD-3576
HWX-3104
CONNECTED_TO

edge_69
HWX-3018
XLD-3450
CONNECTED_TO

edge_70
HWX-3055
XLD-3405
CONNECTED_TO

edge_71
HWX-3055
XLD-3719
CONNECTED_TO

edge_72
HWX-3055
XLD-3638
CONNECTED_TO

edge_73
HWX-3055
XLD-3269
CONNECTED_TO

edge_74
XLD-3450
HWX-3082
CONNECTED_TO

edge_75
XLD-3405
HWX-3004
CONNECTED_TO

edge_76
XLD-3719
XLD-3792
CONNECTED_TO

edge_77
XLD-3719
XLD-3716
CONNECTED_TO

edge_78
XLD-3719
XLD-3720
CONNECTED_TO

edge_79
XLD-3638
DLFZX-3124
CONNECTED_TO

edge_80
XLD-3269
XB-3076
CONNECTED_TO

edge_81
HWX-3082
XLD-3668
CONNECTED_TO

edge_82
HWX-3082
XLD-4124
CONNECTED_TO

edge_83
HWX-3082
XLD-3377
CONNECTED_TO

edge_84
HWX-3082
XLD-3380
CONNECTED_TO

edge_85
HWX-3004
XLD-3625
CONNECTED_TO

edge_86
HWX-3004
XLD-3474
CONNECTED_TO

edge_87
HWX-3004
XLD-3640
CONNECTED_TO

edge_88
XLD-3792
ZSB-3019
CONNECTED_TO

edge_89
XLD-3716
XB-3061
CONNECTED_TO

edge_90
XLD-3720
ZSB-3018
CONNECTED_TO

edge_91
DLFZX-3124
XLD-3540
CONNECTED_TO

edge_92
XLD-3668
HWX-3006
CONNECTED_TO

edge_93
XLD-4124
HWX-3013
CONNECTED_TO

edge_94
XLD-3377
PDS-3091
CONNECTED_TO

edge_95
XLD-3380
PDS-3047
CONNECTED_TO

edge_96
XLD-3625
DLFZX-3258
CONNECTED_TO

edge_97
XLD-3474
DLFZX-3248
CONNECTED_TO

edge_98
XLD-3640
DLFZX-3149
CONNECTED_TO

edge_99
XLD-3540
DLFZX-3256
CONNECTED_TO

edge_100
DLFZX-3258
XLD-3793
CONNECTED_TO

edge_101
DLFZX-3248
XLD-3422
CONNECTED_TO

edge_102
DLFZX-3149
XLD-3268
CONNECTED_TO

edge_103
DLFZX-3256
XLD-3283
CONNECTED_TO

edge_104
XLD-3793
PDS-3006
CONNECTED_TO

edge_105
XLD-3422
PDS-3004
CONNECTED_TO

edge_106
XLD-3268
PDS-3010
CONNECTED_TO

edge_107
XLD-3283
HWX-3009
CONNECTED_TO

vertex_linesegment-1.csv
id
name
objectType
objectHandle
deviceType
internalEndpointNo
terminalNo
usage
powerFlowDirection
belongSubstation
belongFeeder

XLD-3445
电缆
LineSegment
3473
电缆
0
104954
主干
1
中沙变
10kV正泰192线

XLD-3258
电缆
LineSegment
33B8
电缆
0
104279
主干
1
中沙变
10kV正泰192线

XLD-3455
电缆
LineSegment
347D
电缆
0
104989
分支
1
中沙变
10kV正泰192线

XLD-3673
电缆
LineSegment
3557
电缆
0
105637
分支
1
中沙变
10kV正泰192线

XLD-3699
电缆
LineSegment
3571
电缆
0
105703
主干
1
中沙变
10kV正泰192线

XLD-3505
电缆
LineSegment
34AF
电缆
0
105128
分支
1
中沙变
10kV正泰192线

XLD-3724
绝缘
LineSegment
358A
绝缘
0
105787
分支
1
中沙变
10kV正泰192线

XLD-3721
绝缘
LineSegment
3587
绝缘
0
105774
分支
1
中沙变
10kV正泰192线

XLD-3726
绝缘
LineSegment
358C
绝缘
0
105774
分支
1
中沙变
10kV正泰192线

XLD-3437
电缆
LineSegment
346B
电缆
1
104936
分支
-1
中沙变
10kV正泰192线

XLD-3666
电缆
LineSegment
3550
电缆
0
105619
主干
1
中沙变
10kV正泰192线

XLD-3484
电缆
LineSegment
349A
电缆
6
105074
分支
-1
中沙变
10kV正泰192线

XLD-3267
电缆
LineSegment
33C1
电缆
0
104325
分支
1
中沙变
10kV正泰192线

XLD-3264
电缆
LineSegment
33BE
电缆
0
104302
主干
1
中沙变
10kV正泰192线

XLD-3263
电缆
LineSegment
33BD
电缆
0
104299
分支
1
中沙变
10kV正泰192线

XLD-3257
电缆
LineSegment
33B7
电缆
0
104277
分支
1
中沙变
10kV正泰192线

XLD-3629
电缆
LineSegment
352B
电缆
0
105519
分支
1
中沙变
10kV正泰192线

XLD-3788
电缆
LineSegment
35D0
电缆
0
105915
分支
1
中沙变
10kV正泰192线

XLD-3274
电缆
LineSegment
33C8
电缆
0
104362
分支
1
中沙变
10kV正泰192线

XLD-3265
电缆
LineSegment
33BF
电缆
0
104309
主干
1
中沙变
10kV正泰192线

XLD-3262
电缆
LineSegment
33BC
电缆
0
104292
分支
1
中沙变
10kV正泰192线

XLD-3510
电缆
LineSegment
34B4
电缆
0
105149
分支
1
中沙变
10kV正泰192线

XLD-3383
电缆
LineSegment
3435
电缆
0
104779
分支
1
中沙变
10kV正泰192线

XLD-3488
电缆
LineSegment
349E
电缆
0
105084
分支
1
中沙变
10kV正泰192线

XLD-3266
电缆
LineSegment
33C0
电缆
0
104317
主干
1
中沙变
10kV正泰192线

XLD-3261
电缆
LineSegment
33BB
电缆
0
104287
分支
1
中沙变
10kV正泰192线

XLD-3789
电缆
LineSegment
35D1
电缆
1
105918
分支
-1
中沙变
10kV正泰192线

XLD-3790
电缆
LineSegment
35D2
电缆
1
105920
分支
-1
中沙变
10kV正泰192线

XLD-3791
电缆
LineSegment
35D3
电缆
1
105922
分支
-1
中沙变
10kV正泰192线

XLD-3659
电缆
LineSegment
3549
电缆
0
105603
分支
1
中沙变
10kV正泰192线

XLD-3502
电缆
LineSegment
34AC
电缆
0
105123
分支
1
中沙变
10kV正泰192线

XLD-3622
电缆
LineSegment
3524
电缆
0
105495
分支
1
中沙变
10kV正泰192线

XLD-3365
电缆
LineSegment
3423
电缆
0
104699
主干
1
中沙变
10kV正泰192线

XLD-3576
电缆
LineSegment
34F6
电缆
0
105350
分支
1
中沙变
10kV正泰192线

XLD-3450
电缆
LineSegment
3478
电缆
0
104971
分支
1
中沙变
10kV正泰192线

XLD-3405
电缆
LineSegment
344B
电缆
6
104847
主干
-1
中沙变
10kV正泰192线

XLD-3719
绝缘
LineSegment
3585
绝缘
0
105763
分支
1
中沙变
10kV正泰192线

XLD-3638
电缆
LineSegment
3534
电缆
0
105544
分支
1
中沙变
10kV正泰192线

XLD-3269
电缆
LineSegment
33C3
电缆
0
104332
分支
1
中沙变
10kV正泰192线

XLD-3792
绝缘
LineSegment
35D4
绝缘
0
105765
分支
1
中沙变
10kV正泰192线

XLD-3716
绝缘
LineSegment
3582
绝缘
0
105751
分支
1
中沙变
10kV正泰192线

XLD-3720
绝缘
LineSegment
3586
绝缘
0
105751
分支
1
中沙变
10kV正泰192线

XLD-3668
电缆
LineSegment
3552
电缆
0
105624
分支
1
中沙变
10kV正泰192线

XLD-4124
电缆
LineSegment
37D6
电缆
1
106794
分支
-1
中沙变
10kV正泰192线

XLD-3377
电缆
LineSegment
342F
电缆
0
104750
分支
1
中沙变
10kV正泰192线

XLD-3380
电缆
LineSegment
3432
电缆
0
104773
分支
1
中沙变
10kV正泰192线

XLD-3625
电缆
LineSegment
3527
电缆
0
105504
分支
1
中沙变
10kV正泰192线

XLD-3474
电缆
LineSegment
3490
电缆
0
105036
分支
1
中沙变
10kV正泰192线

XLD-3640
电缆
LineSegment
3536
电缆
0
105553
分支
1
中沙变
10kV正泰192线

XLD-3540
电缆
LineSegment
34D2
电缆
0
105225
分支
1
中沙变
10kV正泰192线

XLD-3793
电缆
LineSegment
35D5
电缆
2
105926
分支
-1
中沙变
10kV正泰192线

XLD-3422
电缆
LineSegment
345C
电缆
0
104893
分支
1
中沙变
10kV正泰192线

XLD-3268
电缆
LineSegment
33C2
电缆
0
104329
分支
1
中沙变
10kV正泰192线

XLD-3283
电缆
LineSegment
33D1
电缆
0
104386
分支
1
中沙变
10kV正泰192线

vertex_lineswitch-1.csv
id
name
objectType
objectHandle
deviceType
internalEndpointNo
terminalNo
usage
powerFlowDirection
belongSubstation
belongFeeder

XLKG-3019
分支开关
LineSwitch
33A1
分支开关
0
104990
分支
0
中沙变
10kV正泰192线

vertex_stationhouse-1.csv
id
name
objectType
objectHandle
deviceType
internalEndpointNo
terminalNo
usage
powerFlowDirection
belongSubstation
belongFeeder

HWX-3087
环网箱
StationHouse
322A
环网箱
30
104955
主干
0
中沙变
10kV正泰192线

HWX-3109
环网箱
StationHouse
3293
环网箱
23
104280
主干
0
中沙变
10kV正泰192线

DLFZX-3136
电缆分支箱
StationHouse
324E
电缆分支箱
7
104935
分支
0
中沙变
10kV正泰192线

HWX-3062
环网箱
StationHouse
31BB
环网箱
30
105620
主干
0
中沙变
10kV正泰192线

HWX-3085
环网箱
StationHouse
3226
环网箱
23
105073
分支
0
中沙变
10kV正泰192线

DLFZX-3194
电缆分支箱
StationHouse
32F9
电缆分支箱
8
104328
分支
0
中沙变
10kV正泰192线

HWX-3063
环网箱
StationHouse
31BC
环网箱
30
104308
主干
0
中沙变
10kV正泰192线

HWX-3058
环网箱
StationHouse
31B8
环网箱
14
104301
分支
0
中沙变
10kV正泰192线

HWX-3095
环网箱
StationHouse
3247
环网箱
23
105520
分支
0
中沙变
10kV正泰192线

DLFZX-3183
电缆分支箱
StationHouse
32D4
电缆分支箱
10
104316
主干
0
中沙变
10kV正泰192线

HWX-3059
环网箱
StationHouse
31B9
环网箱
14
104298
分支
0
中沙变
10kV正泰192线

HWX-3143
环网箱
StationHouse
3359
环网箱
34
105151
分支
0
中沙变
10kV正泰192线

HWX-3084
环网箱
StationHouse
3220
环网箱
25
104783
分支
0
中沙变
10kV正泰192线

HWX-3105
环网箱
StationHouse
327B
环网箱
1
105085
分支
0
中沙变
10kV正泰192线

DLFZX-3112
电缆分支箱
StationHouse
320A
电缆分支箱
9
104324
主干
0
中沙变
10kV正泰192线

HWX-3061
环网箱
StationHouse
31BA
环网箱
14
104291
分支
0
中沙变
10kV正泰192线

HWX-3018
环网箱
StationHouse
324F
环网箱
21
105604
分支
0
中沙变
10kV正泰192线

HWX-3055
环网箱
StationHouse
31A9
环网箱
28
104700
主干
0
中沙变
10kV正泰192线

HWX-3082
环网箱
StationHouse
3218
环网箱
30
104972
分支
0
中沙变
10kV正泰192线

HWX-3004
环网箱
StationHouse
301B
环网箱
25
104841
主干
0
中沙变
10kV正泰192线

DLFZX-3124
电缆分支箱
StationHouse
322D
电缆分支箱
3
105545
分支
0
中沙变
10kV正泰192线

DLFZX-3258
电缆分支箱
StationHouse
3395
电缆分支箱
6
105507
分支
0
中沙变
10kV正泰192线

DLFZX-3248
电缆分支箱
StationHouse
3375
电缆分支箱
7
105041
分支
0
中沙变
10kV正泰192线

DLFZX-3149
电缆分支箱
StationHouse
3272
电缆分支箱
7
105554
分支
0
中沙变
10kV正泰192线

DLFZX-3256
电缆分支箱
StationHouse
3393
电缆分支箱
4
105226
分支
0
中沙变
10kV正泰192线

vertex_substation-1.csv
id
name
objectType
objectHandle
deviceType
internalEndpointNo
terminalNo
usage
powerFlowDirection
belongSubstation
belongFeeder

BDZ-3002
110kV变电站
Substation
319E
110kV变电站
0
0
1
中沙变
10kV正泰192线



{
  "vertices": [
    {
      "label": "Substation",
      "input": {
        "type": "file",
        "path": 
"/loader/power_data/vertex_substation-1.csv",
        "format": "CSV",
        "header": ["id", "name", "objectType", 
"objectHandle", "deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder"],
        "charset": "UTF-8",
        "skipped_line": {
          "regex": "(^#|^//).*"
        }
      },
      "null_values": ["NULL", "null", ""]
    },
    {
      "label": "LineSwitch",
      "input": {
        "type": "file",
        "path": 
"/loader/power_data/vertex_lineswitch-1.csv",
        "format": "CSV",
        "header": ["id", "name", "objectType", 
"objectHandle", "deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder"],
        "charset": "UTF-8",
        "skipped_line": {
          "regex": "(^#|^//).*"
        }
      },
      "null_values": ["NULL", "null", ""]
    },
    {
      "label": "StationHouse",
      "input": {
        "type": "file",
        "path": 
"/loader/power_data/vertex_stationhouse-1.csv",
        "format": "CSV",
        "header": ["id", "name", "objectType", 
"objectHandle", "deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder"],
        "charset": "UTF-8",
        "skipped_line": {
          "regex": "(^#|^//).*"
        }
      },
      "null_values": ["NULL", "null", ""]
    },
    {
      "label": "LineSegment",
      "input": {
        "type": "file",
        "path": 
"/loader/power_data/vertex_linesegment-1.csv",
        "format": "CSV",
        "header": ["id", "name", "objectType", 
"objectHandle", "deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder"],
        "charset": "UTF-8",
        "skipped_line": {
          "regex": "(^#|^//).*"
        }
      },
      "null_values": ["NULL", "null", ""]
    }
  ],
  "edges": [
    {
      "label": "CONNECTED_TO",
      "source": ["id"],
      "target": ["id"],
      "input": {
        "type": "file",
        "path": "/loader/power_data/edge_connected_to.csv",
        "format": "CSV",
        "header": ["id", "from", "to", "label"],
        "charset": "UTF-8",
        "skipped_line": {
          "regex": "(^#|^//).*"
        }
      },
      "field_mapping": {
        "from": "id",
        "to": "id",
        "id": "id",
        "label": "label"
      },
      "null_values": ["NULL", "null", ""]
    }
  ]
}
=======================================================




// 1. 定义属性键(id已定义,无需改)
schema.propertyKey("id").asText().ifNotExist().create();
schema.propertyKey("name").asText().ifNotExist().create();
schema.propertyKey("objectType").asText().ifNotExist().create();
schema.propertyKey("objectHandle").asText().ifNotExist().create();
schema.propertyKey("deviceType").asText().ifNotExist().create();
schema.propertyKey("internalEndpointNo").asInt().ifNotExist().create();
schema.propertyKey("terminalNo").asInt().ifNotExist().create();
schema.propertyKey("usage").asText().ifNotExist().create();
schema.propertyKey("powerFlowDirection").asInt().ifNotExist().create();
schema.propertyKey("belongSubstation").asText().ifNotExist().create();
schema.propertyKey("belongFeeder").asText().ifNotExist().create();
schema.propertyKey("label").asText().ifNotExist().create();


// 2. 定义顶点标签(无需改)
schema.vertexLabel("Substation")
    .properties("id", "name", "objectType", "objectHandle", 
"deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder")
    .primaryKeys("id")
    .ifNotExist().create();


schema.vertexLabel("LineSegment")
    .properties("id", "name", "objectType", "objectHandle", 
"deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder")
    .primaryKeys("id")
    .ifNotExist().create();


schema.vertexLabel("LineSwitch")
    .properties("id", "name", "objectType", "objectHandle", 
"deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder")
    .primaryKeys("id")
    .ifNotExist().create();


schema.vertexLabel("StationHouse")
    .properties("id", "name", "objectType", "objectHandle", 
"deviceType", "internalEndpointNo", "terminalNo", "usage", 
"powerFlowDirection", "belongSubstation", "belongFeeder")
    .primaryKeys("id")
    .ifNotExist().create();


// 3. 定义索引(无需改)
schema.indexLabel("substationByFeeder").onV("Substation").by("belongFeeder").secondary().ifNotExist().create();
schema.indexLabel("lineSegmentByDeviceType").onV("LineSegment").by("deviceType").secondary().ifNotExist().create();
schema.indexLabel("stationHouseByDeviceType").onV("StationHouse").by("deviceType").secondary().ifNotExist().create();
schema.indexLabel("substationByBelongSubstation").onV("Substation").by("belongSubstation").secondary().ifNotExist().create();
schema.indexLabel("lineSegmentByBelongSubstation").onV("LineSegment").by("belongSubstation").secondary().ifNotExist().create();
schema.indexLabel("lineSwitchByBelongSubstation").onV("LineSwitch").by("belongSubstation").secondary().ifNotExist().create();
schema.indexLabel("stationHouseByBelongSubstation").onV("StationHouse").by("belongSubstation").secondary().ifNotExist().create();


// 4. 定义边标签(核心修正:添加id到properties里)
schema.edgeLabel("CONNECTED_TO")
    .sourceLabel("Substation")  // 1.7.0只能绑单个标签
    .targetLabel("Substation")
    .properties("id", "label")   // 加了id!和索引字段匹配
    .ifNotExist().create();


// 5. 边索引(现在id是边的属性,索引能创建了)
schema.indexLabel("connectedToById").onE("CONNECTED_TO").by("id").secondary().ifNotExist().create();
以上是导入成功但没有连接关系

或者说怎么对原数据进行处理,不一定要好几个csv,这样编写创建导入也可以的 只要能成功导入且有连接关系就可以,我们老板这几次开会都在问这个事儿

GitHub link: 
https://github.com/apache/incubator-hugegraph/discussions/2917#discussioncomment-15192570

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to