Design Microgrid (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
3
2
1
0

id
0

id
1
0
2

Layout Map

Description
Distribution Line
Service Drop Line
Obstacles where Poles Cannot be Placed
Obstacles where Lines Cannot be Placed
Battery

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 Pole Count

Distribution Pole Count

Service Drop Length in Meters (Sum)

1909.561640331768

Distribution Line Length in Meters (Sum)

4986.688708785709

Cost Summary

Description	Name	Value
Cost of one service drop pole	drop_pole_cost_per_pole	100
Number of service drop poles	drop_pole_count	21
Number of service drop poles that are off road	drop_pole_off_road_count	20
Percent of service drop poles that are off road	drop_pole_off_road_percent	96
Penalty for service drop poles located off road	drop_pole_off_road_penalty	0
Cost of service drop poles excluding off road penalty	drop_pole_raw_cost	2100
Cost of service drop poles including off road penalty	drop_pole_cost	2100
Cost per meter of service drop line	drop_line_cost_per_meter	10
Length of service drop line in meters	drop_line_length	1910
Cost of service drop lines	drop_line_cost	19096
Cost of one distribution pole	distribution_pole_cost_per_pole	200
Number of distribution poles	distribution_pole_count	26
Number of distribution poles that are off road	distribution_pole_off_road_count	26
Percent of distribution poles that are off road	distribution_pole_off_road_percent	100
Penalty for distribution poles located off road	distribution_pole_off_road_penalty	0
Cost of distribution poles excluding off road penalty	distribution_pole_raw_cost	5200
Cost of distribution poles including off road penalty	distribution_pole_cost	5200
Cost per meter of distribution line	distribution_line_cost_per_meter	20
Length of distribution line in meters	distribution_line_length	4987
Cost of distribution lines	distribution_line_cost	99734
Cost of service drop poles and lines excluding off road penalty	drop_pole_and_line_raw_cost	21196
Cost of service drop poles and lines including off road penalty	drop_pole_and_line_cost	21196
Cost of distribution poles and lines excluding off road penalty	distribution_pole_and_line_raw_cost	104934
Cost of distribution poles and lines including off road penalty	distribution_pole_and_line_cost	104934
Cost of poles and lines excluding off road penalty	pole_and_line_raw_cost	126130
Cost of poles and lines including off road penalty	pole_and_line_cost	126130

Service Drop Lines

Service Drop Line Map

id	pole_id	customer_id	length_in_meters
35.0	11.0	20.0	5.01835946255228
37.0	12.0	29.0	43.09861824176271
36.0	12.0	22.0	43.296050493445016
18.0	6.0	11.0	57.09574384443866
19.0	6.0	16.0	48.06894496921733
17.0	6.0	8.0	57.12294536537952
20.0	6.0	19.0	23.113501403988266
16.0	6.0	6.0	33.30530454829915
42.0	16.0	32.0	24.599359444936447
41.0	16.0	27.0	24.69422380752308
39.0	14.0	21.0	5.022651943236468
24.0	8.0	12.0	72.7135695739902
25.0	8.0	18.0	20.260973158911234
23.0	8.0	10.0	72.693579186765
0.0	0.0	0.0	5.044127177672479
38.0	13.0	46.0	5.028702499428388
21.0	7.0	9.0	19.30254372079482
22.0	7.0	30.0	19.440198938375765
15.0	5.0	5.0	5.0218063080774735
8.0	3.0	13.0	65.90405144235237
7.0	3.0	3.0	37.86921782662249
9.0	3.0	45.0	66.00131763917385
46.0	18.0	47.0	41.61901106307421
45.0	18.0	40.0	41.56309614588933
26.0	9.0	14.0	56.66121516141858
29.0	9.0	38.0	27.599281048837465
30.0	9.0	42.0	56.534422403368474
28.0	9.0	31.0	18.51225347885148
27.0	9.0	28.0	57.02437218183513
5.0	2.0	48.0	71.6319212636091
2.0	2.0	2.0	22.42386508780569
4.0	2.0	43.0	12.618287260048893
3.0	2.0	41.0	53.17338699925513
6.0	2.0	49.0	71.89639415893298
44.0	17.0	23.0	57.29715027568935
43.0	17.0	7.0	57.62487087320121
48.0	19.0	44.0	13.79400258367948
47.0	19.0	4.0	13.907309826137755
14.0	4.0	39.0	62.599161216881726
12.0	4.0	26.0	65.18542241883921
13.0	4.0	33.0	40.82158381373922
11.0	4.0	25.0	64.88611016601469
10.0	4.0	24.0	27.774372814364433
49.0	20.0	34.0	31.82564237631439
31.0	10.0	15.0	57.519060156232484
32.0	10.0	17.0	32.530993783338396
33.0	10.0	35.0	31.129716222379987
34.0	10.0	36.0	57.65136943378434
40.0	15.0	37.0	5.022120524509625
1.0	1.0	1.0	5.019456596792423

Customer Count

Service Drop Pole Count

Service Drop Length in Meters (Minimum)

5.01835946255228

Service Drop Length in Meters (Maximum)

72.71356957399021

Service Drop Length in Meters (Sum)

1909.561640331768

Service Drop Table

id	pole_id	customer_id	length_in_meters	wkt
0	0	0	5.044127177672479	LINESTRING (120.1067098517868 -10.17271875945505, 120.1066861233487 -10.17275779186248)
1	1	1	5.019456596792423	LINESTRING (120.1227017347072 -10.17057656610428, 120.122686385191 -10.17053384963384)
2	2	2	22.42386508780569	LINESTRING (120.1142442439317 -10.17142335701659, 120.1141222046301 -10.1712608363982)
3	2	41	53.17338699925513	LINESTRING (120.1142442439317 -10.17142335701659, 120.114641531577 -10.17114804053781)
4	2	43	12.618287260048893	LINESTRING (120.1142442439317 -10.17142335701659, 120.114359204562 -10.17141877748141)
5	2	48	71.6319212636091	LINESTRING (120.1142442439317 -10.17142335701659, 120.113811491863 -10.17093870135161)
6	2	49	71.89639415893298	LINESTRING (120.1142442439317 -10.17142335701659, 120.1148559946124 -10.17165677180053)
7	3	3	37.86921782662249	LINESTRING (120.1114587041448 -10.16639256869438, 120.1111294633982 -10.16649563477986)
8	3	13	65.90405144235237	LINESTRING (120.1114587041448 -10.16639256869438, 120.1110762429912 -10.16593339451144)
9	3	45	66.00131763917385	LINESTRING (120.1114587041448 -10.16639256869438, 120.1118309767146 -10.1668610088548)
10	4	24	27.774372814364433	LINESTRING (120.1168795672783 -10.17309199037512, 120.117084284914 -10.17294429379115)
11	4	25	64.88611016601469	LINESTRING (120.1168795672783 -10.17309199037512, 120.1167241101618 -10.17252644951133)
12	4	26	65.18542241883921	LINESTRING (120.1168795672783 -10.17309199037512, 120.1164768289987 -10.17352504500718)
13	4	33	40.82158381373922	LINESTRING (120.1168795672783 -10.17309199037512, 120.1165833476714 -10.17331527776671)
14	4	39	62.599161216881726	LINESTRING (120.1168795672783 -10.17309199037512, 120.1164100213646 -10.17277047657848)
15	5	5	5.0218063080774735	LINESTRING (120.1111400377773 -10.17393079513244, 120.1111482977054 -10.17397541428678)
16	6	6	33.30530454829915	LINESTRING (120.103794082691 -10.16665956752748, 120.1040254116784 -10.16646466223675)
17	6	8	57.12294536537952	LINESTRING (120.103794082691 -10.16665956752748, 120.1038500047133 -10.16614654645507)
18	6	11	57.09574384443866	LINESTRING (120.103794082691 -10.16665956752748, 120.1037372091573 -10.16717223869311)
19	6	16	48.06894496921733	LINESTRING (120.103794082691 -10.16665956752748, 120.1038375062177 -10.16622748669858)
20	6	19	23.113501403988266	LINESTRING (120.103794082691 -10.16665956752748, 120.1040036970922 -10.16668115490046)
21	7	9	19.30254372079482	LINESTRING (120.1109640195316 -10.16868036591288, 120.1109683634478 -10.16885467793386)
22	7	30	19.440198938375765	LINESTRING (120.1109640195316 -10.16868036591288, 120.1110285721884 -10.16851681674849)
23	8	10	72.693579186765	LINESTRING (120.1064574815992 -10.16503607014483, 120.1071166381098 -10.16510485222567)
24	8	12	72.7135695739902	LINESTRING (120.1064574815992 -10.16503607014483, 120.1058044210717 -10.1649228487647)
25	8	18	20.260973158911234	LINESTRING (120.1064574815992 -10.16503607014483, 120.1065629937415 -10.16518630250388)
26	9	14	56.66121516141858	LINESTRING (120.1140002906305 -10.17508134330679, 120.1137183301159 -10.17551023466998)
27	9	28	57.02437218183513	LINESTRING (120.1140002906305 -10.17508134330679, 120.1144748631337 -10.17487087394449)
28	9	31	18.51225347885148	LINESTRING (120.1140002906305 -10.17508134330679, 120.1141058330666 -10.17521184919934)
29	9	38	27.599281048837465	LINESTRING (120.1140002906305 -10.17508134330679, 120.1139296593351 -10.17532063446572)
30	9	42	56.534422403368474	LINESTRING (120.1140002906305 -10.17508134330679, 120.1140770392762 -10.1745763432592)
31	10	15	57.519060156232484	LINESTRING (120.1190976921702 -10.17142910912255, 120.1185871016772 -10.17154781484168)
32	10	17	32.530993783338396	LINESTRING (120.1190976921702 -10.17142910912255, 120.1188146761641 -10.17151707977034)
33	10	35	31.129716222379987	LINESTRING (120.1190976921702 -10.17142910912255, 120.1191019877883 -10.17171028204962)
34	10	36	57.65136943378434	LINESTRING (120.1190976921702 -10.17142910912255, 120.1196088571503 -10.17130762492612)
35	11	20	5.01835946255228	LINESTRING (120.1016200149109 -10.17053313505269, 120.1016471758129 -10.17049665355963)
36	12	22	43.296050493445016	LINESTRING (120.1035911276322 -10.1724245865087, 120.1039438652368 -10.17260019727661)
37	12	29	43.09861824176271	LINESTRING (120.1035911276322 -10.1724245865087, 120.1032361615062 -10.17225755621291)
38	13	46	5.028702499428388	LINESTRING (120.1099868794159 -10.16567555869149, 120.1099410565177 -10.16567397674094)
39	14	21	5.022651943236468	LINESTRING (120.1040400249393 -10.16607235989349, 120.1040763560389 -10.16604473890808)
40	15	37	5.022120524509625	LINESTRING (120.1199767686961 -10.17256995920855, 120.1199460032858 -10.17253635680929)
41	16	27	24.69422380752308	LINESTRING (120.1038529089425 -10.17074928940263, 120.1038513845075 -10.17052622624744)
42	16	32	24.599359444936447	LINESTRING (120.1038529089425 -10.17074928940263, 120.1038483801417 -10.17097145543611)
43	17	7	57.62487087320121	LINESTRING (120.1154518708836 -10.17223617408793, 120.1157331092468 -10.17179647746888)
44	17	23	57.29715027568935	LINESTRING (120.1154518708836 -10.17223617408793, 120.1151954469264 -10.17178522539983)
45	18	40	41.56309614588933	LINESTRING (120.1129940011233 -10.17681786981172, 120.1133242699168 -10.17663373139126)
46	18	47	41.61901106307421	LINESTRING (120.1129940011233 -10.17681786981172, 120.1126750828164 -10.17702163097823)
47	19	4	13.907309826137755	LINESTRING (120.1157106325837 -10.17390923752423, 120.1157733810214 -10.17380006723705)
48	19	44	13.79400258367948	LINESTRING (120.1157106325837 -10.17390923752423, 120.1156464547552 -10.17401640075639)
49	20	34	31.82564237631439	LINESTRING (120.1171236614599 -10.17318482608983, 120.117319582835 -10.17297275008094)

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.1355515999976	False	True	True	False	True	False	wide
21			1469.1065844551272	False	False	False	False	False	False	tall
12	2.0	2.0	1533.746452387682	False	False	True	False	False	True	wide
22			1439.9120348489694	False	False	False	False	False	False	tall
6	5.0	33.0	893.2890859455204	True	True	True	False	False	False	wide
23			1006.4862187862385	False	False	False	True	False	False	tall
24			1119.6833516288198	False	False	False	False	False	False	tall
25			1232.8804844695387	False	False	False	True	False	False	tall
16	2.0	4.0	1346.077617310257	False	False	True	True	False	True	wide
14	1.0	1.0	822.9094734198005	True	False	True	False	False	False	wide
26			1648.2760104886138	False	False	False	True	False	False	tall
27			678.4637234226353	True	False	False	True	False	False	wide
28			1762.8055685895756	False	False	False	False	False	False	tall
8	3.0	4.0	534.01797342547	True	True	True	False	False	False	wide
0	1.0	1.0	1877.335126690508	False	True	True	False	True	False	wide
29			402.84801808889335	True	False	False	True	False	False	wide
30			271.6780627526641	True	False	False	False	False	False	wide
13	1.0	7.0	140.50810741608746	True	False	True	True	False	False	wide
31			50.566952512519634	True	False	False	False	False	False	wide
7	2.0	9.0	298.38357048864736	True	False	True	False	False	True	wide
5	1.0	3.0	1729.1301996310556	False	False	True	False	True	False	wide
32			168.87888643958783	True	False	False	True	False	False	wide
3	3.0	11.0	39.374202392347065	True	True	True	False	False	True	wide
33			416.07731847374544	True	False	False	True	False	False	wide
34			1616.2761851595874	False	False	False	False	False	False	tall
35			533.7710664588435	True	True	True	False	False	False	wide
18	2.0	2.0	1612.231135712187	False	False	True	False	True	False	wide
36			1503.4221706887768	False	False	False	True	False	False	tall
37			651.4648144439417	True	False	False	True	False	False	wide
38			1501.3996459647547	False	False	False	False	False	False	tall
9	5.0	5.0	1390.5681562173081	False	True	True	False	False	True	wide
2	5.0	15.0	769.1585624290396	True	False	True	False	False	False	wide
39			849.2176727976885	True	False	False	True	False	False	wide
40			1276.5274658726896	False	False	False	True	False	False	tall
17	2.0	6.0	929.2767831663369	False	False	True	False	False	False	tall
19	2.0	10.0	1162.4867755280707	False	False	True	False	False	False	tall
41			1047.4218190072204	False	False	False	True	False	True	wide
4	5.0	6.0	1121.690108605289	False	True	True	False	False	False	tall
20	1.0	3.0	1150.3653734178893	False	False	True	False	False	False	tall
42			1221.7429742039333	False	False	False	False	False	False	tall
43			1321.9344570746962	False	False	False	True	False	False	tall
10	4.0	19.0	1505.1059006990224	False	True	True	False	True	False	wide
44			1422.1259399463288	False	False	False	False	False	True	wide
15	1.0	1.0	1505.4487100741917	False	False	True	False	False	True	wide
45			1629.2805823605865	False	False	False	True	False	False	tall
46			1753.1124546481244	False	False	False	False	False	False	tall
1	1.0	1.0	1876.944326934519	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	geometry_layer	wkt
0	1.0	1.0	1877.335126690508	False	True	True	False	True	False	wide	service drop pole	POINT (120.1067098517868 -10.17271875945505)
1	1.0	1.0	1876.944326934519	False	True	True	False	True	False	wide	service drop pole	POINT (120.1227017347072 -10.17057656610428)
2	5.0	15.0	769.1585624290396	True	False	True	False	False	False	wide	service drop pole	POINT (120.1142442439317 -10.17142335701659)
3	3.0	11.0	39.374202392347065	True	True	True	False	False	True	wide	service drop pole	POINT (120.1114587041448 -10.16639256869438)
4	5.0	6.0	1121.690108605289	False	True	True	False	False	False	tall	service drop pole	POINT (120.1168795672783 -10.17309199037512)
5	1.0	3.0	1729.1301996310556	False	False	True	False	True	False	wide	service drop pole	POINT (120.1111400377773 -10.17393079513244)
6	5.0	33.0	893.2890859455204	True	True	True	False	False	False	wide	service drop pole	POINT (120.103794082691 -10.16665956752748)
7	2.0	9.0	298.38357048864736	True	False	True	False	False	True	wide	service drop pole	POINT (120.1109640195316 -10.16868036591288)
8	3.0	4.0	534.01797342547	True	True	True	False	False	False	wide	service drop pole	POINT (120.1064574815992 -10.16503607014483)
9	5.0	5.0	1390.5681562173081	False	True	True	False	False	True	wide	service drop pole	POINT (120.1140002906305 -10.17508134330679)
10	4.0	19.0	1505.1059006990224	False	True	True	False	True	False	wide	service drop pole	POINT (120.1190976921702 -10.17142910912255)
11	1.0	9.0	1592.1355515999976	False	True	True	False	True	False	wide	service drop pole	POINT (120.1016200149109 -10.17053313505269)
12	2.0	2.0	1533.746452387682	False	False	True	False	False	True	wide	service drop pole	POINT (120.1035911276322 -10.1724245865087)
13	1.0	7.0	140.50810741608746	True	False	True	True	False	False	wide	service drop pole	POINT (120.1099868794159 -10.16567555869149)
14	1.0	1.0	822.9094734198005	True	False	True	False	False	False	wide	service drop pole	POINT (120.1040400249393 -10.16607235989349)
15	1.0	1.0	1505.4487100741917	False	False	True	False	False	True	wide	service drop pole	POINT (120.1199767686961 -10.17256995920855)
16	2.0	4.0	1346.077617310257	False	False	True	True	False	True	wide	service drop pole	POINT (120.1038529089425 -10.17074928940263)
17	2.0	6.0	929.2767831663369	False	False	True	False	False	False	tall	service drop pole	POINT (120.1154518708836 -10.17223617408793)
18	2.0	2.0	1612.231135712187	False	False	True	False	True	False	wide	service drop pole	POINT (120.1129940011233 -10.17681786981172)
19	2.0	10.0	1162.4867755280707	False	False	True	False	False	False	tall	service drop pole	POINT (120.1157106325837 -10.17390923752423)
20	1.0	3.0	1150.3653734178893	False	False	True	False	False	False	tall	service drop pole	POINT (120.1171236614599 -10.17318482608983)
21			1469.1065844551272	False	False	False	False	False	False	tall	distribution pole	POINT (120.1027364610188 -10.17064121403175)
22			1439.9120348489694	False	False	False	False	False	False	tall	distribution pole	POINT (120.1037220189297 -10.17158693809491)
23			1006.4862187862385	False	False	False	True	False	False	tall	distribution pole	POINT (120.1038087904884 -10.16768199804162)
24			1119.6833516288198	False	False	False	False	False	False	tall	distribution pole	POINT (120.1038234974628 -10.16870442852554)
25			1232.8804844695387	False	False	False	True	False	False	tall	distribution pole	POINT (120.1038382036142 -10.16972685897921)
26			1648.2760104886138	False	False	False	True	False	False	tall	distribution pole	POINT (120.1046307007928 -10.1725226472912)
27			678.4637234226353	True	False	False	True	False	False	wide	distribution pole	POINT (120.1052487547105 -10.16555421780028)
28			1762.8055685895756	False	False	False	False	False	False	tall	distribution pole	POINT (120.1056702755111 -10.17262070494002)
29			402.84801808889335	True	False	False	True	False	False	wide	distribution pole	POINT (120.1076339448245 -10.16524923679942)
30			271.6780627526641	True	False	False	False	False	False	wide	distribution pole	POINT (120.1088104107636 -10.16546239964839)
31			50.566952512519634	True	False	False	False	False	False	wide	distribution pole	POINT (120.1107227907816 -10.16603406429823)
32			168.87888643958783	True	False	False	True	False	False	wide	distribution pole	POINT (120.1112113632665 -10.16753646767494)
33			416.07731847374544	True	False	False	True	False	False	wide	distribution pole	POINT (120.1117840701218 -10.16936611536549)
34			1616.2761851595874	False	False	False	False	False	False	tall	distribution pole	POINT (120.1120934524618 -10.17431431335405)
35			533.7710664588435	True	True	True	False	False	False	wide	distribution pole	POINT (120.1126041243851 -10.17005186370059)
36			1503.4221706887768	False	False	False	True	False	False	tall	distribution pole	POINT (120.1130468700797 -10.17469782941227)
37			651.4648144439417	True	False	False	True	False	False	wide	distribution pole	POINT (120.1134241823217 -10.17073761091777)
38			1501.3996459647547	False	False	False	False	False	False	tall	distribution pole	POINT (120.113497147461 -10.17594960734179)
39			849.2176727976885	True	False	False	True	False	False	wide	distribution pole	POINT (120.1148480565581 -10.17182976590424)
40			1276.5274658726896	False	False	False	True	False	False	tall	distribution pole	POINT (120.1148554630071 -10.17449529197415)
41			1047.4218190072204	False	False	False	True	False	True	wide	distribution pole	POINT (120.116209520641 -10.17299484984544)
42			1221.7429742039333	False	False	False	False	False	False	tall	distribution pole	POINT (120.1177350047888 -10.17296366619218)
43			1321.9344570746962	False	False	False	True	False	False	tall	distribution pole	POINT (120.1185466427643 -10.17254825159142)
44			1422.1259399463288	False	False	False	False	False	True	wide	distribution pole	POINT (120.11935827905 -10.17213283438708)
45			1629.2805823605865	False	False	False	True	False	False	tall	distribution pole	POINT (120.1208850941435 -10.17190549842262)
46			1753.1124546481244	False	False	False	False	False	False	tall	distribution pole	POINT (120.1217934161472 -10.17124103405436)

Distribution Line Map

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

Distribution Line Length in Meters (Minimum)

28.67526481260025

Distribution Line Length in Meters (Maximum)

144.4457499971653

Distribution Line Length in Meters (Sum)

4986.688708785709

Line Table

id	pole1_id	pole2_id	length_in_meters	wkt
0	11	21	123.02896714487021	LINESTRING (120.1016200149109 -10.17053313505269, 120.1027364610188 -10.17064121403175)
1	21	16	123.02896714487021	LINESTRING (120.1027364610188 -10.17064121403175, 120.1038529089425 -10.17074928940263)
2	16	25	113.19713284071831	LINESTRING (120.1038529089425 -10.17074928940263, 120.1038382036142 -10.16972685897921)
3	16	22	93.83441753871237	LINESTRING (120.1038529089425 -10.17074928940263, 120.1037220189297 -10.17158693809491)
4	25	24	113.19713284071898	LINESTRING (120.1038382036142 -10.16972685897921, 120.1038234974628 -10.16870442852554)
5	24	23	113.19713284258113	LINESTRING (120.1038234974628 -10.16870442852554, 120.1038087904884 -10.16768199804162)
6	23	6	113.19713284071831	LINESTRING (120.1038087904884 -10.16768199804162, 120.103794082691 -10.16665956752748)
7	6	14	70.3796125257197	LINESTRING (120.103794082691 -10.16665956752748, 120.1040400249393 -10.16607235989349)
8	14	27	144.4457499971653	LINESTRING (120.1040400249393 -10.16607235989349, 120.1052487547105 -10.16555421780028)
9	27	8	144.4457499971653	LINESTRING (120.1052487547105 -10.16555421780028, 120.1064574815992 -10.16503607014483)
10	8	29	131.16995533657666	LINESTRING (120.1064574815992 -10.16503607014483, 120.1076339448245 -10.16524923679942)
11	29	30	131.16995533622924	LINESTRING (120.1076339448245 -10.16524923679942, 120.1088104107636 -10.16546239964839)
12	30	13	131.16995533657666	LINESTRING (120.1088104107636 -10.16546239964839, 120.1099868794159 -10.16567555869149)
13	13	31	89.9411549035678	LINESTRING (120.1099868794159 -10.16567555869149, 120.1107227907816 -10.16603406429823)
14	31	3	89.94115490440103	LINESTRING (120.1107227907816 -10.16603406429823, 120.1114587041448 -10.16639256869438)
15	3	32	129.50468404724072	LINESTRING (120.1114587041448 -10.16639256869438, 120.1112113632665 -10.16753646767494)
16	32	7	129.50468404905962	LINESTRING (120.1112113632665 -10.16753646767494, 120.1109640195316 -10.16868036591288)
17	7	33	117.69374798509804	LINESTRING (120.1109640195316 -10.16868036591288, 120.1117840701218 -10.16936611536549)
18	33	35	117.69374798509804	LINESTRING (120.1117840701218 -10.16936611536549, 120.1126041243851 -10.17005186370059)
19	35	37	117.69374798509804	LINESTRING (120.1126041243851 -10.17005186370059, 120.1134241823217 -10.17073761091777)
20	37	2	117.69374798509804	LINESTRING (120.1134241823217 -10.17073761091777, 120.1142442439317 -10.17142335701659)
21	2	39	80.05911036864875	LINESTRING (120.1142442439317 -10.17142335701659, 120.1148480565581 -10.17182976590424)
22	39	17	80.05911036864875	LINESTRING (120.1148480565581 -10.17182976590424, 120.1154518708836 -10.17223617408793)
23	17	41	118.14503584088342	LINESTRING (120.1154518708836 -10.17223617408793, 120.116209520641 -10.17299484984544)
24	41	19	115.06495652085025	LINESTRING (120.116209520641 -10.17299484984544, 120.1157106325837 -10.17390923752423)
25	4	41	74.26828959806849	LINESTRING (120.1168795672783 -10.17309199037512, 120.116209520641 -10.17299484984544)
26	22	12	93.83441753871237	LINESTRING (120.1037220189297 -10.17158693809491, 120.1035911276322 -10.1724245865087)
27	12	26	114.52955810093228	LINESTRING (120.1035911276322 -10.1724245865087, 120.1046307007928 -10.1725226472912)
28	26	28	114.52955810096128	LINESTRING (120.1046307007928 -10.1725226472912, 120.1056702755111 -10.17262070494002)
29	28	0	114.52955810093228	LINESTRING (120.1056702755111 -10.17262070494002, 120.1067098517868 -10.17271875945505)
30	5	34	112.85401447146864	LINESTRING (120.1111400377773 -10.17393079513244, 120.1120934524618 -10.17431431335405)
31	34	36	112.85401447081037	LINESTRING (120.1120934524618 -10.17431431335405, 120.1130468700797 -10.17469782941227)
32	36	9	112.85401447146864	LINESTRING (120.1130468700797 -10.17469782941227, 120.1140002906305 -10.17508134330679)
33	9	38	110.83148974744671	LINESTRING (120.1140002906305 -10.17508134330679, 120.113497147461 -10.17594960734179)
34	40	9	114.04069034461881	LINESTRING (120.1148554630071 -10.17449529197415, 120.1140002906305 -10.17508134330679)
35	38	18	110.83148974743244	LINESTRING (120.113497147461 -10.17594960734179, 120.1129940011233 -10.17681786981172)
36	19	40	114.04069034461881	LINESTRING (120.1157106325837 -10.17390923752423, 120.1148554630071 -10.17449529197415)
37	44	43	100.19148287163263	LINESTRING (120.11935827905 -10.17213283438708, 120.1185466427643 -10.17254825159142)
38	44	10	82.9799607526936	LINESTRING (120.11935827905 -10.17213283438708, 120.1190976921702 -10.17142910912255)
39	44	15	83.32277012786287	LINESTRING (120.11935827905 -10.17213283438708, 120.1199767686961 -10.17256995920855)
40	43	42	100.191482870763	LINESTRING (120.1185466427643 -10.17254825159142, 120.1177350047888 -10.17296366619218)
41	42	20	71.37760078604404	LINESTRING (120.1177350047888 -10.17296366619218, 120.1171236614599 -10.17318482608983)
42	20	4	28.67526481260025	LINESTRING (120.1171236614599 -10.17318482608983, 120.1168795672783 -10.17309199037512)
43	15	45	123.83187228639477	LINESTRING (120.1199767686961 -10.17256995920855, 120.1208850941435 -10.17190549842262)
44	45	46	123.8318722875377	LINESTRING (120.1208850941435 -10.17190549842262, 120.1217934161472 -10.17124103405436)
45	46	1	123.83187228639477	LINESTRING (120.1217934161472 -10.17124103405436, 120.1227017347072 -10.17057656610428)

Road Length in Meters (Sum)

6366.158145413532

Pole Obstacle Count

Line Obstacle Count

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.2890859455204	True	True	True	False	False	False	wide
14	1.0	1.0	822.9094734198005	True	False	True	False	False	False	wide
27			678.4637234226353	True	False	False	True	False	False	wide
8	3.0	4.0	534.01797342547	True	True	True	False	False	False	wide
29			402.84801808889335	True	False	False	True	False	False	wide
30			271.6780627526641	True	False	False	False	False	False	wide
13	1.0	7.0	140.50810741608746	True	False	True	True	False	False	wide
31			50.566952512519634	True	False	False	False	False	False	wide
7	2.0	9.0	298.38357048864736	True	False	True	False	False	True	wide
32			168.87888643958783	True	False	False	True	False	False	wide
3	3.0	11.0	39.374202392347065	True	True	True	False	False	True	wide
33			416.07731847374544	True	False	False	True	False	False	wide
35			533.7710664588435	True	True	True	False	False	False	wide
37			651.4648144439417	True	False	False	True	False	False	wide
2	5.0	15.0	769.1585624290396	True	False	True	False	False	False	wide
39			849.2176727976885	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.1355515999976	False	True	True	False	True	False	wide
6	5.0	33.0	893.2890859455204	True	True	True	False	False	False	wide
8	3.0	4.0	534.01797342547	True	True	True	False	False	False	wide
0	1.0	1.0	1877.335126690508	False	True	True	False	True	False	wide
3	3.0	11.0	39.374202392347065	True	True	True	False	False	True	wide
35			533.7710664588435	True	True	True	False	False	False	wide
9	5.0	5.0	1390.5681562173081	False	True	True	False	False	True	wide
4	5.0	6.0	1121.690108605289	False	True	True	False	False	False	tall
10	4.0	19.0	1505.1059006990224	False	True	True	False	True	False	wide
1	1.0	1.0	1876.944326934519	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.1355515999976	False	True	True	False	True	False	wide
12	2.0	2.0	1533.746452387682	False	False	True	False	False	True	wide
6	5.0	33.0	893.2890859455204	True	True	True	False	False	False	wide
16	2.0	4.0	1346.077617310257	False	False	True	True	False	True	wide
14	1.0	1.0	822.9094734198005	True	False	True	False	False	False	wide
8	3.0	4.0	534.01797342547	True	True	True	False	False	False	wide
0	1.0	1.0	1877.335126690508	False	True	True	False	True	False	wide
13	1.0	7.0	140.50810741608746	True	False	True	True	False	False	wide
7	2.0	9.0	298.38357048864736	True	False	True	False	False	True	wide
5	1.0	3.0	1729.1301996310556	False	False	True	False	True	False	wide
3	3.0	11.0	39.374202392347065	True	True	True	False	False	True	wide
35			533.7710664588435	True	True	True	False	False	False	wide
18	2.0	2.0	1612.231135712187	False	False	True	False	True	False	wide
9	5.0	5.0	1390.5681562173081	False	True	True	False	False	True	wide
2	5.0	15.0	769.1585624290396	True	False	True	False	False	False	wide
17	2.0	6.0	929.2767831663369	False	False	True	False	False	False	tall
19	2.0	10.0	1162.4867755280707	False	False	True	False	False	False	tall
4	5.0	6.0	1121.690108605289	False	True	True	False	False	False	tall
20	1.0	3.0	1150.3653734178893	False	False	True	False	False	False	tall
10	4.0	19.0	1505.1059006990224	False	True	True	False	True	False	wide
15	1.0	1.0	1505.4487100741917	False	False	True	False	False	True	wide
1	1.0	1.0	1876.944326934519	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.4862187862385	False	False	False	True	False	False	tall
25			1232.8804844695387	False	False	False	True	False	False	tall
16	2.0	4.0	1346.077617310257	False	False	True	True	False	True	wide
26			1648.2760104886138	False	False	False	True	False	False	tall
27			678.4637234226353	True	False	False	True	False	False	wide
29			402.84801808889335	True	False	False	True	False	False	wide
13	1.0	7.0	140.50810741608746	True	False	True	True	False	False	wide
32			168.87888643958783	True	False	False	True	False	False	wide
33			416.07731847374544	True	False	False	True	False	False	wide
36			1503.4221706887768	False	False	False	True	False	False	tall
37			651.4648144439417	True	False	False	True	False	False	wide
39			849.2176727976885	True	False	False	True	False	False	wide
40			1276.5274658726896	False	False	False	True	False	False	tall
41			1047.4218190072204	False	False	False	True	False	True	wide
43			1321.9344570746962	False	False	False	True	False	False	tall
45			1629.2805823605865	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.1355515999976	False	True	True	False	True	False	wide
12	2.0	2.0	1533.746452387682	False	False	True	False	False	True	wide
6	5.0	33.0	893.2890859455204	True	True	True	False	False	False	wide
16	2.0	4.0	1346.077617310257	False	False	True	True	False	True	wide
14	1.0	1.0	822.9094734198005	True	False	True	False	False	False	wide
27			678.4637234226353	True	False	False	True	False	False	wide
8	3.0	4.0	534.01797342547	True	True	True	False	False	False	wide
0	1.0	1.0	1877.335126690508	False	True	True	False	True	False	wide
29			402.84801808889335	True	False	False	True	False	False	wide
30			271.6780627526641	True	False	False	False	False	False	wide
13	1.0	7.0	140.50810741608746	True	False	True	True	False	False	wide
31			50.566952512519634	True	False	False	False	False	False	wide
7	2.0	9.0	298.38357048864736	True	False	True	False	False	True	wide
5	1.0	3.0	1729.1301996310556	False	False	True	False	True	False	wide
32			168.87888643958783	True	False	False	True	False	False	wide
3	3.0	11.0	39.374202392347065	True	True	True	False	False	True	wide
33			416.07731847374544	True	False	False	True	False	False	wide
35			533.7710664588435	True	True	True	False	False	False	wide
18	2.0	2.0	1612.231135712187	False	False	True	False	True	False	wide
37			651.4648144439417	True	False	False	True	False	False	wide
9	5.0	5.0	1390.5681562173081	False	True	True	False	False	True	wide
2	5.0	15.0	769.1585624290396	True	False	True	False	False	False	wide
39			849.2176727976885	True	False	False	True	False	False	wide
41			1047.4218190072204	False	False	False	True	False	True	wide
10	4.0	19.0	1505.1059006990224	False	True	True	False	True	False	wide
44			1422.1259399463288	False	False	False	False	False	True	wide
15	1.0	1.0	1505.4487100741917	False	False	True	False	False	True	wide
1	1.0	1.0	1876.944326934519	False	True	True	False	True	False	wide

Wide Pole Count

Algorithm

Service Drop Placement Execution Time in Seconds

183.21612215042114

Distribution Pole Placement Execution Time in Seconds

238.25498700141907

Battery Placement Execution Time in Seconds

9.853533267974854

Solar Panel Placement Execution Time in Seconds

0.12829327583312988

Street Lamp Placement Execution Time in Seconds

2.6326913833618164

Wifi Router Placement Execution Time in Seconds

7.9892308712005615

Download

execution time in seconds

448.2194516658783

Pay Tool Creator: Roy Hyunjin Han	125000
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

Cost

Service Drop Lines

Distribution Lines

Equipment

Algorithm