Place Equipment (Solar) 20180603-0800 Default

id	demand_in_kwh_per_day
20.0	9.0
29
11
16.0	8.0
8.0	7.0
27
32.0	3.0
22
19.0	9.0
6.0	8.0
21
12
18.0	2.0
0
10
46.0	7.0
9.0	8.0
3
13
30
5.0	3.0
45.0	9.0
47.0	1.0
40
48.0	3.0
14
38
42
31
2
28
43.0	4.0
41
49.0	6.0
23
7.0	5.0
44.0	9.0
4
39
26
33.0	2.0
25
24
34.0	3.0
15.0	2.0
17.0	5.0
35.0	5.0
36.0	7.0
37
1

id
0

id
1
0
2

id	customer_count	demand_in_kwh_per_day
11.0	1.0	9.0
21
12.0	2.0	2.0
22
6.0	5.0	33.0
23
24
25
16.0	2.0	4.0
14.0	1.0	1.0
26
27
28
8.0	3.0	4.0
0.0	1.0	1.0
29
30
13.0	1.0	7.0
31
7.0	2.0	9.0
5.0	1.0	3.0
32
3.0	3.0	11.0
33
34
35
18.0	2.0	2.0
36
37
38
9.0	5.0	5.0
2.0	5.0	15.0
39
40
17.0	2.0	6.0
19.0	2.0	10.0
41
4.0	5.0	6.0
20.0	1.0	3.0
42
43
10.0	4.0	19.0
44
15.0	1.0	1.0
45
46
1.0	1.0	1.0

id	pole1_id	pole2_id	length_in_meters
0.0	11.0	21.0	123.02896714487021
1.0	21.0	16.0	123.02896714487021
27.0	12.0	26.0	114.52955810093228
26.0	22.0	12.0	93.83441753871237
7.0	6.0	14.0	70.3796125257197
6.0	23.0	6.0	113.19713284071831
5.0	24.0	23.0	113.19713284258113
4.0	25.0	24.0	113.19713284071898
3.0	16.0	22.0	93.83441753871237
2.0	16.0	25.0	113.19713284071831
8.0	14.0	27.0	144.4457499971653
28.0	26.0	28.0	114.52955810096128
9.0	27.0	8.0	144.4457499971653
29.0	28.0	0.0	114.52955810093228
10.0	8.0	29.0	131.16995533657666
11.0	29.0	30.0	131.16995533622924
12.0	30.0	13.0	131.16995533657666
13.0	13.0	31.0	89.9411549035678
14.0	31.0	3.0	89.94115490440103
17.0	7.0	33.0	117.69374798509804
30.0	5.0	34.0	112.85401447146864
16.0	32.0	7.0	129.50468404905962
15.0	3.0	32.0	129.50468404724072
18.0	33.0	35.0	117.69374798509804
31.0	34.0	36.0	112.85401447081037
19.0	35.0	37.0	117.69374798509804
32.0	36.0	9.0	112.85401447146864
20.0	37.0	2.0	117.69374798509804
35.0	38.0	18.0	110.83148974743244
33.0	9.0	38.0	110.83148974744671
21.0	2.0	39.0	80.05911036864875
22.0	39.0	17.0	80.05911036864875
34.0	40.0	9.0	114.04069034461881
23.0	17.0	41.0	118.14503584088342
36.0	19.0	40.0	114.04069034461881
24.0	41.0	19.0	115.06495652085025
25.0	4.0	41.0	74.26828959806849
42.0	20.0	4.0	28.67526481260025
41.0	42.0	20.0	71.37760078604404
40.0	43.0	42.0	100.191482870763
37.0	44.0	43.0	100.19148287163263
38.0	44.0	10.0	82.9799607526936
39.0	44.0	15.0	83.32277012786287
43.0	15.0	45.0	123.83187228639477
44.0	45.0	46.0	123.8318722875377
45.0	46.0	1.0	123.83187228639477

Layout Map

Description
Distribution Line
Obstacles where Poles Cannot be Placed
Obstacles where Lines Cannot be Placed
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Battery
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole
Pole

Obstacles where Poles cannot be Placed (Orange)
Obstacles where Lines cannot be Placed (Red)
Battery (Brown)
Distribution Lines (Dark Green)
Service Drop Lines (Yellow Green)

Layout Diagram

Service Drop Lines

Customer Count

Service Drop Pole Count

Distribution Lines

Pole Map

id	customer_count	demand_in_kwh_per_day	battery_distance_in_meters	has_panel	has_lamp	has_meter	has_router	has_end	has_corner	type_id
11	1.0	9.0	1592.1355515955715	False	True	True	False	True	False	wide
21			1469.1065844436855	False	False	False	False	False	False	tall
12	2.0	2.0	1533.7464523803367	False	True	True	False	False	True	wide
22			1439.912034842182	False	False	False	False	False	False	tall
6	5.0	33.0	893.2890859399226	True	True	True	False	False	False	wide
23			1006.4862187805546	False	False	False	True	False	False	tall
24			1119.6833516231527	False	False	False	False	False	False	tall
25			1232.8804844638953	False	False	False	True	False	False	tall
16	2.0	4.0	1346.0776173044976	False	True	True	True	False	True	wide
14	1.0	1.0	822.909473414683	True	False	True	False	False	False	wide
26			1648.2760104777021	False	False	False	True	False	False	tall
27			678.4637234126754	True	False	False	True	False	False	wide
28			1762.805568574198	False	False	False	False	False	False	tall
8	3.0	4.0	534.0179734157762	True	True	True	False	False	False	wide
0	1.0	1.0	1877.3351266740574	False	True	True	False	True	False	wide
29			402.8480180915009	True	False	False	True	False	False	wide
30			271.67806275200286	True	False	False	False	False	False	wide
13	1.0	7.0	140.50810741029338	True	True	True	True	False	False	wide
31			50.56695250856168	True	False	False	False	False	False	wide
7	2.0	9.0	298.38357048909893	True	True	True	False	False	True	wide
5	1.0	3.0	1729.130199628832	False	True	True	False	True	False	wide
32			168.87888643897597	True	False	False	True	False	False	wide
3	3.0	11.0	39.37420239287456	True	True	True	False	False	True	wide
33			416.07731847769236	True	False	False	True	False	False	wide
34			1616.276185164102	False	False	False	False	False	False	tall
35			533.7710664646279	True	True	True	False	False	False	wide
18	2.0	2.0	1612.231135711847	False	True	True	False	True	False	wide
36			1503.4221706825751	False	False	False	True	False	False	tall
37			651.4648144496363	True	False	False	True	False	False	wide
38			1501.3996459634018	False	False	False	False	False	False	tall
9	5.0	5.0	1390.5681562184946	False	True	True	False	False	True	wide
2	5.0	15.0	769.1585624266229	True	True	True	False	False	False	wide
39			849.217672799219	True	False	False	True	False	False	wide
40			1276.527465875731	False	False	False	True	False	False	tall
17	2.0	6.0	929.2767831688124	False	False	True	False	False	False	tall
19	2.0	10.0	1162.486775529352	False	False	True	False	False	False	tall
41			1047.4218190088284	False	False	False	True	False	True	wide
4	5.0	6.0	1121.6901086046478	False	True	True	False	False	False	tall
20	1.0	3.0	1150.3653734194836	False	False	True	False	False	False	tall
42			1221.7429742093968	False	False	False	False	False	False	tall
43			1321.9344570836342	False	False	False	True	False	False	tall
10	4.0	19.0	1505.1059007005524	False	True	True	False	True	False	wide
44			1422.1259399475198	False	False	False	False	False	True	wide
15	1.0	1.0	1505.4487100761455	False	False	True	False	False	True	wide
45			1629.280582362052	False	False	False	True	False	False	tall
46			1753.112454654939	False	False	False	False	False	False	tall
1	1.0	1.0	1876.9443269375427	False	True	True	False	True	False	wide

Distribution Pole Count

Pole Table

id	customer_count	demand_in_kwh_per_day	battery_distance_in_meters	has_panel	has_lamp	has_meter	has_router	has_end	has_corner	type_id	wkt
0	1.0	1.0	1877.3351266740574	False	True	True	False	True	False	wide	POINT (120.1067098517868 -10.17271875945505)
1	1.0	1.0	1876.9443269375427	False	True	True	False	True	False	wide	POINT (120.1227017347072 -10.17057656610428)
2	5.0	15.0	769.1585624266229	True	True	True	False	False	False	wide	POINT (120.1142442439317 -10.1714233570166)
3	3.0	11.0	39.37420239287456	True	True	True	False	False	True	wide	POINT (120.1114587041448 -10.16639256869438)
4	5.0	6.0	1121.6901086046478	False	True	True	False	False	False	tall	POINT (120.1168795672783 -10.17309199037512)
5	1.0	3.0	1729.130199628832	False	True	True	False	True	False	wide	POINT (120.1111400377773 -10.17393079513244)
6	5.0	33.0	893.2890859399226	True	True	True	False	False	False	wide	POINT (120.103794082691 -10.16665956752748)
7	2.0	9.0	298.38357048909893	True	True	True	False	False	True	wide	POINT (120.1109640195316 -10.16868036591288)
8	3.0	4.0	534.0179734157762	True	True	True	False	False	False	wide	POINT (120.1064574815992 -10.16503607014483)
9	5.0	5.0	1390.5681562184946	False	True	True	False	False	True	wide	POINT (120.1140002906305 -10.17508134330679)
10	4.0	19.0	1505.1059007005524	False	True	True	False	True	False	wide	POINT (120.1190976921702 -10.17142910912255)
11	1.0	9.0	1592.1355515955715	False	True	True	False	True	False	wide	POINT (120.1016200149109 -10.17053313505269)
12	2.0	2.0	1533.7464523803367	False	True	True	False	False	True	wide	POINT (120.1035911276322 -10.1724245865087)
13	1.0	7.0	140.50810741029338	True	True	True	True	False	False	wide	POINT (120.1099868794159 -10.16567555869149)
14	1.0	1.0	822.909473414683	True	False	True	False	False	False	wide	POINT (120.1040400249393 -10.16607235989349)
15	1.0	1.0	1505.4487100761455	False	False	True	False	False	True	wide	POINT (120.1199767686961 -10.17256995920855)
16	2.0	4.0	1346.0776173044976	False	True	True	True	False	True	wide	POINT (120.1038529089425 -10.17074928940263)
17	2.0	6.0	929.2767831688124	False	False	True	False	False	False	tall	POINT (120.1154518708836 -10.17223617408793)
18	2.0	2.0	1612.231135711847	False	True	True	False	True	False	wide	POINT (120.1129940011233 -10.17681786981172)
19	2.0	10.0	1162.486775529352	False	False	True	False	False	False	tall	POINT (120.1157106325837 -10.17390923752423)
20	1.0	3.0	1150.3653734194836	False	False	True	False	False	False	tall	POINT (120.1171236614599 -10.17318482608983)
21			1469.1065844436855	False	False	False	False	False	False	tall	POINT (120.1027364610188 -10.17064121403175)
22			1439.912034842182	False	False	False	False	False	False	tall	POINT (120.1037220189297 -10.17158693809491)
23			1006.4862187805546	False	False	False	True	False	False	tall	POINT (120.1038087904884 -10.16768199804162)
24			1119.6833516231527	False	False	False	False	False	False	tall	POINT (120.1038234974628 -10.16870442852554)
25			1232.8804844638953	False	False	False	True	False	False	tall	POINT (120.1038382036142 -10.16972685897921)
26			1648.2760104777021	False	False	False	True	False	False	tall	POINT (120.1046307007928 -10.1725226472912)
27			678.4637234126754	True	False	False	True	False	False	wide	POINT (120.1052487547105 -10.16555421780028)
28			1762.805568574198	False	False	False	False	False	False	tall	POINT (120.1056702755111 -10.17262070494002)
29			402.8480180915009	True	False	False	True	False	False	wide	POINT (120.1076339448245 -10.16524923679942)
30			271.67806275200286	True	False	False	False	False	False	wide	POINT (120.1088104107636 -10.16546239964839)
31			50.56695250856168	True	False	False	False	False	False	wide	POINT (120.1107227907816 -10.16603406429823)
32			168.87888643897597	True	False	False	True	False	False	wide	POINT (120.1112113632665 -10.16753646767494)
33			416.07731847769236	True	False	False	True	False	False	wide	POINT (120.1117840701218 -10.16936611536549)
34			1616.276185164102	False	False	False	False	False	False	tall	POINT (120.1120934524618 -10.17431431335405)
35			533.7710664646279	True	True	True	False	False	False	wide	POINT (120.1126041243851 -10.17005186370059)
36			1503.4221706825751	False	False	False	True	False	False	tall	POINT (120.1130468700797 -10.17469782941227)
37			651.4648144496363	True	False	False	True	False	False	wide	POINT (120.1134241823217 -10.17073761091777)
38			1501.3996459634018	False	False	False	False	False	False	tall	POINT (120.113497147461 -10.17594960734179)
39			849.217672799219	True	False	False	True	False	False	wide	POINT (120.1148480565581 -10.17182976590424)
40			1276.527465875731	False	False	False	True	False	False	tall	POINT (120.1148554630071 -10.17449529197415)
41			1047.4218190088284	False	False	False	True	False	True	wide	POINT (120.116209520641 -10.17299484984544)
42			1221.7429742093968	False	False	False	False	False	False	tall	POINT (120.1177350047888 -10.17296366619218)
43			1321.9344570836342	False	False	False	True	False	False	tall	POINT (120.1185466427643 -10.17254825159142)
44			1422.1259399475198	False	False	False	False	False	True	wide	POINT (120.11935827905 -10.17213283438708)
45			1629.280582362052	False	False	False	True	False	False	tall	POINT (120.1208850941435 -10.17190549842262)
46			1753.112454654939	False	False	False	False	False	False	tall	POINT (120.1217934161472 -10.17124103405436)

Equipment

Battery Demand in kWh per Day

152.0

Solar Panel Poles

id	customer_count	demand_in_kwh_per_day	battery_distance_in_meters	has_panel	has_lamp	has_meter	has_router	has_end	has_corner	type_id
6	5.0	33.0	893.2890859399226	True	True	True	False	False	False	wide
14	1.0	1.0	822.909473414683	True	False	True	False	False	False	wide
27			678.4637234126754	True	False	False	True	False	False	wide
8	3.0	4.0	534.0179734157762	True	True	True	False	False	False	wide
29			402.8480180915009	True	False	False	True	False	False	wide
30			271.67806275200286	True	False	False	False	False	False	wide
13	1.0	7.0	140.50810741029338	True	True	True	True	False	False	wide
31			50.56695250856168	True	False	False	False	False	False	wide
7	2.0	9.0	298.38357048909893	True	True	True	False	False	True	wide
32			168.87888643897597	True	False	False	True	False	False	wide
3	3.0	11.0	39.37420239287456	True	True	True	False	False	True	wide
33			416.07731847769236	True	False	False	True	False	False	wide
35			533.7710664646279	True	True	True	False	False	False	wide
37			651.4648144496363	True	False	False	True	False	False	wide
2	5.0	15.0	769.1585624266229	True	True	True	False	False	False	wide
39			849.217672799219	True	False	False	True	False	False	wide

Solar Panel Pole Count

Street Lamp Poles

id	customer_count	demand_in_kwh_per_day	battery_distance_in_meters	has_panel	has_lamp	has_meter	has_router	has_end	has_corner	type_id
11	1.0	9.0	1592.1355515955715	False	True	True	False	True	False	wide
12	2.0	2.0	1533.7464523803367	False	True	True	False	False	True	wide
6	5.0	33.0	893.2890859399226	True	True	True	False	False	False	wide
16	2.0	4.0	1346.0776173044976	False	True	True	True	False	True	wide
8	3.0	4.0	534.0179734157762	True	True	True	False	False	False	wide
0	1.0	1.0	1877.3351266740574	False	True	True	False	True	False	wide
13	1.0	7.0	140.50810741029338	True	True	True	True	False	False	wide
7	2.0	9.0	298.38357048909893	True	True	True	False	False	True	wide
5	1.0	3.0	1729.130199628832	False	True	True	False	True	False	wide
3	3.0	11.0	39.37420239287456	True	True	True	False	False	True	wide
35			533.7710664646279	True	True	True	False	False	False	wide
18	2.0	2.0	1612.231135711847	False	True	True	False	True	False	wide
9	5.0	5.0	1390.5681562184946	False	True	True	False	False	True	wide
2	5.0	15.0	769.1585624266229	True	True	True	False	False	False	wide
4	5.0	6.0	1121.6901086046478	False	True	True	False	False	False	tall
10	4.0	19.0	1505.1059007005524	False	True	True	False	True	False	wide
1	1.0	1.0	1876.9443269375427	False	True	True	False	True	False	wide

Street Lamp Histogram

Street Lamp Pole Count

Power Meter Poles

id	customer_count	demand_in_kwh_per_day	battery_distance_in_meters	has_panel	has_lamp	has_meter	has_router	has_end	has_corner	type_id
11	1.0	9.0	1592.1355515955715	False	True	True	False	True	False	wide
12	2.0	2.0	1533.7464523803367	False	True	True	False	False	True	wide
6	5.0	33.0	893.2890859399226	True	True	True	False	False	False	wide
16	2.0	4.0	1346.0776173044976	False	True	True	True	False	True	wide
14	1.0	1.0	822.909473414683	True	False	True	False	False	False	wide
8	3.0	4.0	534.0179734157762	True	True	True	False	False	False	wide
0	1.0	1.0	1877.3351266740574	False	True	True	False	True	False	wide
13	1.0	7.0	140.50810741029338	True	True	True	True	False	False	wide
7	2.0	9.0	298.38357048909893	True	True	True	False	False	True	wide
5	1.0	3.0	1729.130199628832	False	True	True	False	True	False	wide
3	3.0	11.0	39.37420239287456	True	True	True	False	False	True	wide
35			533.7710664646279	True	True	True	False	False	False	wide
18	2.0	2.0	1612.231135711847	False	True	True	False	True	False	wide
9	5.0	5.0	1390.5681562184946	False	True	True	False	False	True	wide
2	5.0	15.0	769.1585624266229	True	True	True	False	False	False	wide
17	2.0	6.0	929.2767831688124	False	False	True	False	False	False	tall
19	2.0	10.0	1162.486775529352	False	False	True	False	False	False	tall
4	5.0	6.0	1121.6901086046478	False	True	True	False	False	False	tall
20	1.0	3.0	1150.3653734194836	False	False	True	False	False	False	tall
10	4.0	19.0	1505.1059007005524	False	True	True	False	True	False	wide
15	1.0	1.0	1505.4487100761455	False	False	True	False	False	True	wide
1	1.0	1.0	1876.9443269375427	False	True	True	False	True	False	wide

Power Meter Pole Count

Wifi Router Poles

id	customer_count	demand_in_kwh_per_day	battery_distance_in_meters	has_panel	has_lamp	has_meter	has_router	has_end	has_corner	type_id
23			1006.4862187805546	False	False	False	True	False	False	tall
25			1232.8804844638953	False	False	False	True	False	False	tall
16	2.0	4.0	1346.0776173044976	False	True	True	True	False	True	wide
26			1648.2760104777021	False	False	False	True	False	False	tall
27			678.4637234126754	True	False	False	True	False	False	wide
29			402.8480180915009	True	False	False	True	False	False	wide
13	1.0	7.0	140.50810741029338	True	True	True	True	False	False	wide
32			168.87888643897597	True	False	False	True	False	False	wide
33			416.07731847769236	True	False	False	True	False	False	wide
36			1503.4221706825751	False	False	False	True	False	False	tall
37			651.4648144496363	True	False	False	True	False	False	wide
39			849.217672799219	True	False	False	True	False	False	wide
40			1276.527465875731	False	False	False	True	False	False	tall
41			1047.4218190088284	False	False	False	True	False	True	wide
43			1321.9344570836342	False	False	False	True	False	False	tall
45			1629.280582362052	False	False	False	True	False	False	tall

Wifi Router Pole Count

Wide Poles

id	customer_count	demand_in_kwh_per_day	battery_distance_in_meters	has_panel	has_lamp	has_meter	has_router	has_end	has_corner	type_id
11	1.0	9.0	1592.1355515955715	False	True	True	False	True	False	wide
12	2.0	2.0	1533.7464523803367	False	True	True	False	False	True	wide
6	5.0	33.0	893.2890859399226	True	True	True	False	False	False	wide
16	2.0	4.0	1346.0776173044976	False	True	True	True	False	True	wide
14	1.0	1.0	822.909473414683	True	False	True	False	False	False	wide
27			678.4637234126754	True	False	False	True	False	False	wide
8	3.0	4.0	534.0179734157762	True	True	True	False	False	False	wide
0	1.0	1.0	1877.3351266740574	False	True	True	False	True	False	wide
29			402.8480180915009	True	False	False	True	False	False	wide
30			271.67806275200286	True	False	False	False	False	False	wide
13	1.0	7.0	140.50810741029338	True	True	True	True	False	False	wide
31			50.56695250856168	True	False	False	False	False	False	wide
7	2.0	9.0	298.38357048909893	True	True	True	False	False	True	wide
5	1.0	3.0	1729.130199628832	False	True	True	False	True	False	wide
32			168.87888643897597	True	False	False	True	False	False	wide
3	3.0	11.0	39.37420239287456	True	True	True	False	False	True	wide
33			416.07731847769236	True	False	False	True	False	False	wide
35			533.7710664646279	True	True	True	False	False	False	wide
18	2.0	2.0	1612.231135711847	False	True	True	False	True	False	wide
37			651.4648144496363	True	False	False	True	False	False	wide
9	5.0	5.0	1390.5681562184946	False	True	True	False	False	True	wide
2	5.0	15.0	769.1585624266229	True	True	True	False	False	False	wide
39			849.217672799219	True	False	False	True	False	False	wide
41			1047.4218190088284	False	False	False	True	False	True	wide
10	4.0	19.0	1505.1059007005524	False	True	True	False	True	False	wide
44			1422.1259399475198	False	False	False	False	False	True	wide
15	1.0	1.0	1505.4487100761455	False	False	True	False	False	True	wide
1	1.0	1.0	1876.9443269375427	False	True	True	False	True	False	wide

Wide Pole Count

Algorithm

Battery Placement Execution Time in Seconds

9.223156452178955

Solar Panel Placement Execution Time in Seconds

0.12687993049621582

Street Lamp Placement Execution Time in Seconds

4.875015735626221

Wifi Router Placement Execution Time in Seconds

7.6534364223480225

pole obstacle count

line obstacle count

Download

execution time in seconds

27.756311655044556

Pay Tool Creator: Roy Hyunjin Han	37500
Pay Worker Creator: User for Manual Worker	?
Set Visibility: Hidden	0
Set Container: Numerical CPU with TINY Memory for 10 Minutes	0
Total	0

Relevant Industries

Target Applications

Pricing Notes

Usage Notes

Acknowledgments

Geography

Electricity

Layout

Service Drop Lines

Distribution Lines

Equipment

Algorithm