Design Microgrid (Solar) 20180515-1500 Defaults

Run this computational tool to place the following components of a solar microgrid:

  • Service Drop Poles
  • Service Drop Lines
  • Distribution Poles
  • Distribution Lines

The algorithm makes the following optimizations:

  • Place distribution poles near roads when it is more cost effective to do so.
  • Avoid pole obstacles when placing service drop poles and distribution poles.
  • Avoid line obstacles when placing service drop line and distribution line.

Relevant Industries

  • Energy > Microgrid > Renewable

Target Applications

  • Microgrid Site Design

Pricing Notes

  • Pricing is on a per-site basis.
  • Please contact billing@crosscompute.com for special rates.

Usage Notes

  • Choose a sufficient amount of memory and time to run the algorithm.
  • You can influence the algorithm to put more distribution poles near roads by increasing Off Road Cost Multiplier.
  • The following features are not included in this version:
    • Battery Placement
    • Solar Panel Placement
    • Wifi Router Placement
    • Street Lamp Placement
    • Power Meter Placement
    • Pole Type Assignment
  • The algorithm is also available as an API for easier automation and integration into your workflow.

Acknowledgments

Thank you to the following groups that made this work possible:

Geography

The algorithm expects an attribute called demand or demand_in_kwh_per_day for each customer (see Electricity).

Upload
iddemand_in_kwh_per_day
customer81.0
customer72.0
customer3
customer5
customer63.0
customer90.0
customer09.0
customer4
customer27.0
customer18.0
Upload
id
road3
road2
road1
road0
Upload
id
pole-obstacle0
Upload
id
line-obstacle1
line-obstacle0
line-obstacle2

Electricity

Layout

Cost

Anyone with the link

Pay Tool Creator: Roy Hyunjin Han1250000
Set Visibility: Hidden0
Total0
Description
3764.4980584890104 meters
49.30497529920328 meters
314255.8645239252 square meters
14444.459784781739 square meters
  • Obstacles where Poles cannot be Placed (Orange)
  • Obstacles where Lines cannot be Placed (Red)
  • Service Drop Lines (Yellow Green)
  • Distribution Lines (Dark Green)
10
33
49.30497529920328
3764.4980584890086
DescriptionValue
Cost of one service drop pole100.0
Number of service drop poles10.0
Cost of all service drop poles without off road penalty1000.0
Percent of service drop poles that are off road90.0
Penalty cost for service drop poles located off road900.0
Cost of all service drop poles including off road penalty1900.0
-
Cost per meter of service drop line10.0
Length of service drop line in meters50.0
Cost of service drop line494.0
-
Cost of one distribution pole200.0
Number of distribution poles33.0
Cost of all distribution poles without considering off road penalty6600.0
Percent of distribution poles that are considered to be off road94.0
Penalty cost for distribution poles located off road6200.0
Cost of all distribution poles including off road penalty12800.0
-
Cost per meter of distribution line20.0
Length of distribution line in meters3765.0
Cost of distribution line75290.0
-
Cost of all poles and lines excluding off road penalty83384.0
Cost of all poles and lines including off road penalty90484.0

Service Drop Lines

pole_idcustomer_idlength_in_metersid
4.08.05.2702064316150624.0
3.07.09.9921109534546283.0
9.03.08.2252275641358559.0
1.05.01.07708983742424771.0
2.06.04.636774608855652.0
5.09.04.0816675426146485.0
6.00.09.9882005324562046.0
0.04.02.01123260895651470.0
8.02.02.01123260895651478.0
7.01.02.0112326107339577.0
10
10
1.0770898374242477
9.992110953454626
49.30497529920328
pole_idcustomer_idlength_in_metersidwkt
042.01123260895651470LINESTRING (120.117712132921 -10.1714596065392, 120.1177078009571 -10.17144195260134)
151.07708983742424771LINESTRING (120.1140322024868 -10.17448137265035, 120.1140369072708 -10.17447283208723)
264.636774608855652LINESTRING (120.1147066454011 -10.17107166287888, 120.114674554972 -10.17109893247244)
379.9921109534546283LINESTRING (120.1072706570837 -10.16489826366139, 120.1072467637078 -10.16481116186146)
485.2702064316150624LINESTRING (120.1036136159847 -10.17212775943849, 120.1036269497066 -10.17217349692373)
594.0816675426146485LINESTRING (120.1167324657906 -10.17308982965915, 120.1167367649391 -10.17312645382021)
609.9882005324562046LINESTRING (120.117119031685 -10.17296179718251, 120.1172007307673 -10.17300166693765)
712.0112326107339577LINESTRING (120.1230193371014 -10.17036454227049, 120.1230150048235 -10.17034688832581)
822.01123260895651478LINESTRING (120.1183672432775 -10.17124636046203, 120.1183629112747 -10.17122870652354)
938.2252275641358559LINESTRING (120.1122753535964 -10.17651632582005, 120.1122157465268 -10.17656141927779)

Distribution Lines

customer_countdemand_in_kwh_per_dayidhas_solar_panelhas_wifihas_lamphas_meterhas_cornertype_id
1.01.04FalseFalseFalseFalseFalse
10FalseFalseFalseFalseFalse
11FalseFalseFalseFalseFalse
12FalseFalseFalseFalseFalse
13FalseFalseFalseFalseFalse
14FalseFalseFalseFalseFalse
15FalseFalseFalseFalseFalse
16FalseFalseFalseFalseFalse
17FalseFalseFalseFalseFalse
18FalseFalseFalseFalseFalse
20FalseFalseFalseFalseFalse
19FalseFalseFalseFalseFalse
21FalseFalseFalseFalseFalse
22FalseFalseFalseFalseFalse
1.02.03FalseFalseFalseFalseFalse
23FalseFalseFalseFalseFalse
24FalseFalseFalseFalseFalse
25FalseFalseFalseFalseFalse
26FalseFalseFalseFalseFalse
27FalseFalseFalseFalseFalse
28FalseFalseFalseFalseFalse
1.01.09FalseFalseFalseFalseFalse
29FalseFalseFalseFalseFalse
30FalseFalseFalseFalseFalse
1.01.01FalseFalseFalseFalseFalse
1.03.02FalseFalseFalseFalseFalse
31FalseFalseFalseFalseFalse
32FalseFalseFalseFalseFalse
33FalseFalseFalseFalseFalse
34FalseFalseFalseFalseFalse
35FalseFalseFalseFalseFalse
36FalseFalseFalseFalseFalse
1.00.05FalseFalseFalseFalseFalse
1.09.06FalseFalseFalseFalseFalse
37FalseFalseFalseFalseFalse
1.01.00FalseFalseFalseFalseFalse
1.07.08FalseFalseFalseFalseFalse
38FalseFalseFalseFalseFalse
39FalseFalseFalseFalseFalse
40FalseFalseFalseFalseFalse
41FalseFalseFalseFalseFalse
42FalseFalseFalseFalseFalse
1.08.07FalseFalseFalseFalseFalse
33
customer_countdemand_in_kwh_per_dayidhas_solar_panelhas_wifihas_lamphas_meterhas_cornertype_idwkt
1.01.00FalseFalseFalseFalseFalsePOINT (120.117712132921 -10.1714596065392)
1.01.01FalseFalseFalseFalseFalsePOINT (120.1140322024868 -10.17448137265035)
1.03.02FalseFalseFalseFalseFalsePOINT (120.1147066454011 -10.17107166287888)
1.02.03FalseFalseFalseFalseFalsePOINT (120.1072706570837 -10.16489826366139)
1.01.04FalseFalseFalseFalseFalsePOINT (120.1036136159847 -10.17212775943849)
1.00.05FalseFalseFalseFalseFalsePOINT (120.1167324657906 -10.17308982965915)
1.09.06FalseFalseFalseFalseFalsePOINT (120.117119031685 -10.17296179718251)
1.08.07FalseFalseFalseFalseFalsePOINT (120.1230193371014 -10.17036454227049)
1.07.08FalseFalseFalseFalseFalsePOINT (120.1183672432775 -10.17124636046203)
1.01.09FalseFalseFalseFalseFalsePOINT (120.1122753535964 -10.17651632582005)
10FalseFalseFalseFalseFalsePOINT (120.1040199637219 -10.17132448653565)
11FalseFalseFalseFalseFalsePOINT (120.1043085028983 -10.1727101886632)
12FalseFalseFalseFalseFalsePOINT (120.1044263089992 -10.17052121253107)
13FalseFalseFalseFalseFalsePOINT (120.1048326518169 -10.16971793742492)
14FalseFalseFalseFalseFalsePOINT (120.1050033924549 -10.17329261708833)
15FalseFalseFalseFalseFalsePOINT (120.1052389921752 -10.16891466121727)
16FalseFalseFalseFalseFalsePOINT (120.1056453300743 -10.1681113839083)
17FalseFalseFalseFalseFalsePOINT (120.1056982846547 -10.17387504471363)
18FalseFalseFalseFalseFalsePOINT (120.1060516655145 -10.16730810549808)
19FalseFalseFalseFalseFalsePOINT (120.106457998496 -10.16650482598678)
20FalseFalseFalseFalseFalsePOINT (120.1063931794979 -10.17445747153883)
21FalseFalseFalseFalseFalsePOINT (120.106864329019 -10.1657015453745)
22FalseFalseFalseFalseFalsePOINT (120.1070880769844 -10.17503989756368)
23FalseFalseFalseFalseFalsePOINT (120.1077829771146 -10.1756223227879)
24FalseFalseFalseFalseFalsePOINT (120.1085006539276 -10.17590830677726)
25FalseFalseFalseFalseFalsePOINT (120.1092555917622 -10.17602991376283)
26FalseFalseFalseFalseFalsePOINT (120.1100105306464 -10.17615151915996)
27FalseFalseFalseFalseFalsePOINT (120.1107654705803 -10.17627312296857)
28FalseFalseFalseFalseFalsePOINT (120.1115204115637 -10.17639472518863)
29FalseFalseFalseFalseFalsePOINT (120.1128609724801 -10.17583800985332)
30FalseFalseFalseFalseFalsePOINT (120.1134465887768 -10.17515969213)
31FalseFalseFalseFalseFalsePOINT (120.114707270083 -10.1741334896094)
32FalseFalseFalseFalseFalsePOINT (120.1153429572255 -10.17150112436998)
33FalseFalseFalseFalseFalsePOINT (120.1153823364991 -10.17378560476381)
34FalseFalseFalseFalseFalsePOINT (120.1159792709406 -10.17193058508052)
35FalseFalseFalseFalseFalsePOINT (120.116057401735 -10.17343771811368)
36FalseFalseFalseFalseFalsePOINT (120.1166155865465 -10.1723600450103)
37FalseFalseFalseFalseFalsePOINT (120.1171638604634 -10.17190982645179)
38FalseFalseFalseFalseFalsePOINT (120.1191425927855 -10.1710993958545)
39FalseFalseFalseFalseFalsePOINT (120.1199179420787 -10.17095242921045)
40FalseFalseFalseFalseFalsePOINT (120.120693291157 -10.17080546052994)
41FalseFalseFalseFalseFalsePOINT (120.1214686400204 -10.17065848981304)
42FalseFalseFalseFalseFalsePOINT (120.1222439886685 -10.17051151705988)
pole1_idpole2_idlength_in_meters
4.010.099.46684426339694
10.012.099.46684426506954
11.04.099.82638670937092
12.013.099.46684426339694
13.015.099.46684426506954
14.011.099.82638670937092
15.016.099.46684426338409
16.018.099.46684426506954
17.014.099.82638670937092
18.019.099.46684426339694
20.017.099.82638670937092
19.021.099.46684426506954
21.03.099.46684426339694
22.020.099.82638670937092
23.022.099.82638670937092
24.023.084.83773980681022
25.024.083.88295056766673
26.025.083.88295056766673
27.026.083.88295056741299
28.027.083.88295056766673
9.028.083.88295056766673
29.09.098.81082917972051
30.029.098.81082918116549
1.030.098.81082917972051
31.01.083.45335906459341
32.02.084.44155595370604
33.031.083.45335906371916
34.032.084.44155595471679
35.033.083.45335906371916
36.034.084.44155595370604
36.06.086.52238173799286
36.037.078.10059545980381
5.035.083.45335906459341
6.05.044.702032922689455
37.00.078.10059545860247
0.08.075.62659417889068
8.038.086.57714263232971
38.039.086.57714263199198
39.040.086.57714263232971
40.041.086.57714263232971
41.042.086.57714263199198
42.07.086.57714263232971
44.70203292268945
99.82638670937092
3764.4980584890086
pole1_idpole2_idlength_in_meterswkt
36686.52238173799286LINESTRING (120.1166155865465 -10.1723600450103, 120.117119031685 -10.17296179718251)
363484.44155595370604LINESTRING (120.1166155865465 -10.1723600450103, 120.1159792709406 -10.17193058508052)
363778.10059545980381LINESTRING (120.1166155865465 -10.1723600450103, 120.1171638604634 -10.17190982645179)
6544.702032922689455LINESTRING (120.117119031685 -10.17296179718251, 120.1167324657906 -10.17308982965915)
53583.45335906459341LINESTRING (120.1167324657906 -10.17308982965915, 120.116057401735 -10.17343771811368)
353383.45335906371916LINESTRING (120.116057401735 -10.17343771811368, 120.1153823364991 -10.17378560476381)
333183.45335906371916LINESTRING (120.1153823364991 -10.17378560476381, 120.114707270083 -10.1741334896094)
31183.45335906459341LINESTRING (120.114707270083 -10.1741334896094, 120.1140322024868 -10.17448137265035)
13098.81082917972051LINESTRING (120.1140322024868 -10.17448137265035, 120.1134465887768 -10.17515969213)
302998.81082918116549LINESTRING (120.1134465887768 -10.17515969213, 120.1128609724801 -10.17583800985332)
29998.81082917972051LINESTRING (120.1128609724801 -10.17583800985332, 120.1122753535964 -10.17651632582005)
92883.88295056766673LINESTRING (120.1122753535964 -10.17651632582005, 120.1115204115637 -10.17639472518863)
282783.88295056766673LINESTRING (120.1115204115637 -10.17639472518863, 120.1107654705803 -10.17627312296857)
272683.88295056741299LINESTRING (120.1107654705803 -10.17627312296857, 120.1100105306464 -10.17615151915996)
262583.88295056766673LINESTRING (120.1100105306464 -10.17615151915996, 120.1092555917622 -10.17602991376283)
252483.88295056766673LINESTRING (120.1092555917622 -10.17602991376283, 120.1085006539276 -10.17590830677726)
242384.83773980681022LINESTRING (120.1085006539276 -10.17590830677726, 120.1077829771146 -10.1756223227879)
232299.82638670937092LINESTRING (120.1077829771146 -10.1756223227879, 120.1070880769844 -10.17503989756368)
222099.82638670937092LINESTRING (120.1070880769844 -10.17503989756368, 120.1063931794979 -10.17445747153883)
201799.82638670937092LINESTRING (120.1063931794979 -10.17445747153883, 120.1056982846547 -10.17387504471363)
171499.82638670937092LINESTRING (120.1056982846547 -10.17387504471363, 120.1050033924549 -10.17329261708833)
141199.82638670937092LINESTRING (120.1050033924549 -10.17329261708833, 120.1043085028983 -10.1727101886632)
11499.82638670937092LINESTRING (120.1043085028983 -10.1727101886632, 120.1036136159847 -10.17212775943849)
41099.46684426339694LINESTRING (120.1036136159847 -10.17212775943849, 120.1040199637219 -10.17132448653565)
101299.46684426506954LINESTRING (120.1040199637219 -10.17132448653565, 120.1044263089992 -10.17052121253107)
121399.46684426339694LINESTRING (120.1044263089992 -10.17052121253107, 120.1048326518169 -10.16971793742492)
131599.46684426506954LINESTRING (120.1048326518169 -10.16971793742492, 120.1052389921752 -10.16891466121727)
151699.46684426338409LINESTRING (120.1052389921752 -10.16891466121727, 120.1056453300743 -10.1681113839083)
161899.46684426506954LINESTRING (120.1056453300743 -10.1681113839083, 120.1060516655145 -10.16730810549808)
181999.46684426339694LINESTRING (120.1060516655145 -10.16730810549808, 120.106457998496 -10.16650482598678)
192199.46684426506954LINESTRING (120.106457998496 -10.16650482598678, 120.106864329019 -10.1657015453745)
21399.46684426339694LINESTRING (120.106864329019 -10.1657015453745, 120.1072706570837 -10.16489826366139)
343284.44155595471679LINESTRING (120.1159792709406 -10.17193058508052, 120.1153429572255 -10.17150112436998)
32284.44155595370604LINESTRING (120.1153429572255 -10.17150112436998, 120.1147066454011 -10.17107166287888)
37078.10059545860247LINESTRING (120.1171638604634 -10.17190982645179, 120.117712132921 -10.1714596065392)
0875.62659417889068LINESTRING (120.117712132921 -10.1714596065392, 120.1183672432775 -10.17124636046203)
83886.57714263232971LINESTRING (120.1183672432775 -10.17124636046203, 120.1191425927855 -10.1710993958545)
383986.57714263199198LINESTRING (120.1191425927855 -10.1710993958545, 120.1199179420787 -10.17095242921045)
394086.57714263232971LINESTRING (120.1199179420787 -10.17095242921045, 120.120693291157 -10.17080546052994)
404186.57714263232971LINESTRING (120.120693291157 -10.17080546052994, 120.1214686400204 -10.17065848981304)
414286.57714263199198LINESTRING (120.1214686400204 -10.17065848981304, 120.1222439886685 -10.17051151705988)
42786.57714263232971LINESTRING (120.1222439886685 -10.17051151705988, 120.1230193371014 -10.17036454227049)
6366.158145413532
1
3

Algorithm

24.83673620223999
2.518113613128662
1.9073486328125e-06
0.0004093647003173828
0.00036644935607910156
0.0003597736358642578
Download
31.772225856781006