Design Microgrid (Solar) 20180712-1400: Demo Default

This demo is restricted to an example customer dataset.

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

  • Service Drop Poles
  • Service Drop Lines
  • Battery
  • Distribution Poles
  • Distribution Lines
  • Solar Panels
  • Street Lamps
  • Power Meters
  • Wifi Routers
  • Wide Poles

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 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).

  • Customers must be polygons or points.
  • Roads must be lines.
  • Pole obstacles must be polygons.
  • Line obstacles must be polygons.
  • Battery areas must be polygons.

This demo is restricted to an example customer dataset.

Upload
id
3
2
1
0
Upload
id
0
Upload
id
1
0
2
Upload

Electricity

Layout

Cost

Algorithm

Anyone with the link

Pay Tool Creator: Roy Hyunjin Han0
Set Visibility: Hidden0
Total0
Description
Service Drop Line
Distribution 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)
9
22
165.80837865231405
3843.7037324665707
DescriptionNameValue
Cost of one service drop poledrop_pole_cost_per_pole100
Number of service drop polesdrop_pole_count9
Number of service drop poles that are off roaddrop_pole_off_road_count9
Percent of service drop poles that are off roaddrop_pole_off_road_percent100
Penalty for service drop poles located off roaddrop_pole_off_road_penalty0
Cost of service drop poles excluding off road penaltydrop_pole_raw_cost900
Cost of service drop poles including off road penaltydrop_pole_cost900
Cost per meter of service drop linedrop_line_cost_per_meter10
Length of service drop line in metersdrop_line_length166
Cost of service drop linesdrop_line_cost1659
Cost of one distribution poledistribution_pole_cost_per_pole200
Number of distribution polesdistribution_pole_count22
Number of distribution poles that are off roaddistribution_pole_off_road_count21
Percent of distribution poles that are off roaddistribution_pole_off_road_percent96
Penalty for distribution poles located off roaddistribution_pole_off_road_penalty0
Cost of distribution poles excluding off road penaltydistribution_pole_raw_cost4400
Cost of distribution poles including off road penaltydistribution_pole_cost4400
Cost per meter of distribution linedistribution_line_cost_per_meter20
Length of distribution line in metersdistribution_line_length3844
Cost of distribution linesdistribution_line_cost76875
Cost of service drop poles and lines excluding off road penaltydrop_pole_and_line_raw_cost2559
Cost of service drop poles and lines including off road penaltydrop_pole_and_line_cost2559
Cost of distribution poles and lines excluding off road penaltydistribution_pole_and_line_raw_cost81275
Cost of distribution poles and lines including off road penaltydistribution_pole_and_line_cost81275
Cost of poles and lines excluding off road penaltypole_and_line_raw_cost83833
Cost of poles and lines including off road penaltypole_and_line_cost83833

Service Drop Lines

idpole_idcustomer_idlength_in_meters
7.06.08.014.372870923115206
6.06.06.014.434661685195616
0.00.00.03.018988616145016
9.08.09.03.18616323673885
3.03.03.03.0283135832116894
5.05.05.03.021462406136044
2.02.02.061.87552159836895
8.07.07.056.80898978667647
4.04.04.03.035866106468873
1.01.01.03.0255407102573453
10
9
3.0189886161450157
61.87552159836895
165.80837865231405
idpole_idcustomer_idlength_in_meterswkt
0003.018988616145016LINESTRING (120.1067086931645 -10.17287232036588, 120.1067054478642 -10.17284523931185)
1113.0255407102573453LINESTRING (120.1226118812632 -10.1704213707626, 120.1226138399173 -10.17044863259416)
22261.87552159836895LINESTRING (120.1148222361484 -10.17128133822394, 120.1142791498771 -10.17112992746852)
3333.0283135832116894LINESTRING (120.1109218518042 -10.16648266069533, 120.1109423226533 -10.16650101849859)
4443.035866106468873LINESTRING (120.115829031491 -10.17368804710356, 120.1158083565867 -10.1737062825119)
5553.021462406136044LINESTRING (120.1111774534693 -10.17395852475867, 120.1111660980964 -10.17398339215974)
66614.434661685195616LINESTRING (120.103924613373 -10.16625328439671, 120.1040201518492 -10.16634296626012)
76814.372870923115206LINESTRING (120.103924613373 -10.16625328439671, 120.1038500047133 -10.16614654645507)
87756.80898978667647LINESTRING (120.1154682944476 -10.17223773772674, 120.1157418469966 -10.17180196292369)
9893.18616323673885LINESTRING (120.1109002442772 -10.16882755386121, 120.1109009612956 -10.16885632657278)

Distribution Lines

idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
62.015.01435.8640701275046FalseFalseTrueFalseTrueFalsewide
91307.8897258848453FalseFalseFalseFalseFalseFalsetall
101179.9153816421856FalseFalseFalseTrueFalseFalsetall
01.01.0952.1491205931343FalseFalseTrueFalseTrueFalsewide
111051.941037399497FalseFalseFalseFalseFalseFalsetall
12818.264090225636FalseFalseFalseFalseFalseFalsetall
13923.9666931568373FalseFalseFalseTrueFalseFalsetall
14687.8821562390393FalseFalseFalseTrueFalseFalsetall
15795.9923489141779FalseFalseFalseFalseFalseFalsetall
16557.5002222517312FalseFalseFalseFalseFalseFalsetall
81.08.0408.42317543535705FalseFalseTrueTrueFalseTruewide
17538.2205900534376FalseFalseFalseTrueFalseFalsetall
31.01.0668.0180046715184FalseFalseTrueFalseFalseTruewide
51.03.0427.11828826513437FalseFalseTrueTrueFalseTruewide
18272.28211695727873FalseFalseFalseFalseFalseFalsetall
19284.7455255096228FalseFalseFalseFalseFalseFalsetall
20136.1410584780783TrueFalseFalseTrueFalseFalsewide
21142.3727627555116FalseFalseFalseTrueFalseFalsetall
220.0TrueFalseFalseFalseFalseTruewide
23119.91829111951651TrueFalseFalseFalseFalseFalsewide
21.01.0111.67234256260492TrueFalseTrueTrueFalseTruewide
24239.83658223759025FalseFalseFalseFalseFalseFalsetall
71.05.0239.06909439698967FalseFalseTrueTrueTrueFalsewide
41.01.0359.7548733571067FalseFalseTrueFalseFalseTruewide
25465.6330006414029FalseFalseFalseFalseFalseFalsetall
26571.5111279256993FalseFalseFalseFalseFalseFalsetall
27677.3892552099953FalseFalseFalseTrueFalseFalsetall
28812.1973032448449FalseFalseFalseFalseFalseFalsetall
29947.0053512797223FalseFalseFalseTrueFalseFalsetall
301081.8133993140923FalseFalseFalseFalseFalseFalsetall
11.01.01216.6214473489415FalseFalseTrueFalseTrueFalsewide
22
idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_idgeometry_layerwkt
01.01.0952.1491205931343FalseFalseTrueFalseTrueFalsewideservice drop polePOINT (120.1067086931645 -10.17287232036588)
11.01.01216.6214473489415FalseFalseTrueFalseTrueFalsewideservice drop polePOINT (120.1226118812632 -10.1704213707626)
21.01.0111.67234256260492TrueFalseTrueTrueFalseTruewideservice drop polePOINT (120.1148222361484 -10.17128133822394)
31.01.0668.0180046715184FalseFalseTrueFalseFalseTruewideservice drop polePOINT (120.1109218518042 -10.16648266069533)
41.01.0359.7548733571067FalseFalseTrueFalseFalseTruewideservice drop polePOINT (120.115829031491 -10.17368804710356)
51.03.0427.11828826513437FalseFalseTrueTrueFalseTruewideservice drop polePOINT (120.1111774534693 -10.17395852475867)
62.015.01435.8640701275046FalseFalseTrueFalseTrueFalsewideservice drop polePOINT (120.103924613373 -10.16625328439671)
71.05.0239.06909439698967FalseFalseTrueTrueTrueFalsewideservice drop polePOINT (120.1154682944476 -10.17223773772674)
81.08.0408.42317543535705FalseFalseTrueTrueFalseTruewideservice drop polePOINT (120.1109002442772 -10.16882755386121)
91307.8897258848453FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1050908161619 -10.16629152399168)
101179.9153816421856FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1062570203979 -10.16632975950199)
111051.941037399497FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1074232260807 -10.16636799092756)
12818.264090225636FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1078933919989 -10.17258053006029)
13923.9666931568373FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1085894332096 -10.16640621826834)
14687.8821562390393FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1089880751736 -10.17303986444242)
15795.9923489141779FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1097556417843 -10.16644444152429)
16557.5002222517312FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1100827623305 -10.17349919600873)
17538.2205900534376FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1109110486816 -10.16765510732582)
18272.28211695727873FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1118724481801 -10.16959220592248)
19284.7455255096228FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1120572645527 -10.1730128553856)
20136.1410584780783TrueFalseFalseTrueFalseFalsewidedistribution polePOINT (120.1128446570193 -10.17035685633637)
21142.3727627555116FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1129370703278 -10.17206718216655)
220.0TrueFalseFalseFalseFalseTruewidedistribution polePOINT (120.1138168707951 -10.17112150510216)
23119.91829111951651TrueFalseFalseFalseFalseFalsewidedistribution polePOINT (120.1144875877013 -10.17197701953441)
24239.83658223759025FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1151583079331 -10.17283253353498)
25465.6330006414029FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.116502522064 -10.17300280091326)
26571.5111279256993FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1171760097365 -10.1723175525181)
27677.3892552099953FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1178494945088 -10.17163230191836)
28812.1973032448449FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.119040092869 -10.17132957657121)
29947.0053512797223FalseFalseFalseTrueFalseFalsetalldistribution polePOINT (120.1202306901152 -10.17102684626261)
301081.8133993140923FalseFalseFalseFalseFalseFalsetalldistribution polePOINT (120.1214212862467 -10.17072411099296)
idpole1_idpole2_idlength_in_meters
13.09.06.0127.97434424265951
12.010.09.0127.97434424265951
11.011.010.0127.9743442426886
19.012.00.0133.8850303674986
10.013.011.0127.97434424265951
18.014.012.0130.38193398659686
9.015.013.0127.97434424265951
17.016.014.0130.38193398730795
6.08.017.0129.7974146180806
7.017.03.0129.7974146180806
8.03.015.0127.97434424265951
16.05.016.0130.38193398659686
5.018.08.0136.1410584780783
15.019.05.0142.3727627555116
4.020.018.0136.14105847920044
14.021.019.0142.37276275411125
0.022.020.0136.1410584780783
1.022.021.0142.3727627555116
3.022.02.0111.67234256260492
2.023.022.0119.91829111951651
29.02.07.0127.39675183438476
28.024.023.0119.91829111807372
27.04.024.0119.91829111951651
26.025.04.0105.87812728429623
25.026.025.0105.87812728429623
24.027.026.0105.87812728429623
23.028.027.0134.80804803484932
22.029.028.0134.80804803487746
21.030.029.0134.8080480343703
20.01.030.0134.80804803484932
105.87812728429624
142.3727627555116
3843.7037324665707
idpole1_idpole2_idlength_in_meterswkt
02220136.1410584780783LINESTRING (120.1138168707951 -10.17112150510216, 120.1128446570193 -10.17035685633637)
12221142.3727627555116LINESTRING (120.1138168707951 -10.17112150510216, 120.1129370703278 -10.17206718216655)
22322119.91829111951651LINESTRING (120.1144875877013 -10.17197701953441, 120.1138168707951 -10.17112150510216)
3222111.67234256260492LINESTRING (120.1138168707951 -10.17112150510216, 120.1148222361484 -10.17128133822394)
42018136.14105847920044LINESTRING (120.1128446570193 -10.17035685633637, 120.1118724481801 -10.16959220592248)
5188136.1410584780783LINESTRING (120.1118724481801 -10.16959220592248, 120.1109002442772 -10.16882755386121)
6817129.7974146180806LINESTRING (120.1109002442772 -10.16882755386121, 120.1109110486816 -10.16765510732582)
7173129.7974146180806LINESTRING (120.1109110486816 -10.16765510732582, 120.1109218518042 -10.16648266069533)
8315127.97434424265951LINESTRING (120.1109218518042 -10.16648266069533, 120.1097556417843 -10.16644444152429)
91513127.97434424265951LINESTRING (120.1097556417843 -10.16644444152429, 120.1085894332096 -10.16640621826834)
101311127.97434424265951LINESTRING (120.1085894332096 -10.16640621826834, 120.1074232260807 -10.16636799092756)
111110127.9743442426886LINESTRING (120.1074232260807 -10.16636799092756, 120.1062570203979 -10.16632975950199)
12109127.97434424265951LINESTRING (120.1062570203979 -10.16632975950199, 120.1050908161619 -10.16629152399168)
1396127.97434424265951LINESTRING (120.1050908161619 -10.16629152399168, 120.103924613373 -10.16625328439671)
142119142.37276275411125LINESTRING (120.1129370703278 -10.17206718216655, 120.1120572645527 -10.1730128553856)
15195142.3727627555116LINESTRING (120.1120572645527 -10.1730128553856, 120.1111774534693 -10.17395852475867)
16516130.38193398659686LINESTRING (120.1111774534693 -10.17395852475867, 120.1100827623305 -10.17349919600873)
171614130.38193398730795LINESTRING (120.1100827623305 -10.17349919600873, 120.1089880751736 -10.17303986444242)
181412130.38193398659686LINESTRING (120.1089880751736 -10.17303986444242, 120.1078933919989 -10.17258053006029)
19120133.8850303674986LINESTRING (120.1078933919989 -10.17258053006029, 120.1067086931645 -10.17287232036588)
20130134.80804803484932LINESTRING (120.1226118812632 -10.1704213707626, 120.1214212862467 -10.17072411099296)
213029134.8080480343703LINESTRING (120.1214212862467 -10.17072411099296, 120.1202306901152 -10.17102684626261)
222928134.80804803487746LINESTRING (120.1202306901152 -10.17102684626261, 120.119040092869 -10.17132957657121)
232827134.80804803484932LINESTRING (120.119040092869 -10.17132957657121, 120.1178494945088 -10.17163230191836)
242726105.87812728429623LINESTRING (120.1178494945088 -10.17163230191836, 120.1171760097365 -10.1723175525181)
252625105.87812728429623LINESTRING (120.1171760097365 -10.1723175525181, 120.116502522064 -10.17300280091326)
26254105.87812728429623LINESTRING (120.116502522064 -10.17300280091326, 120.115829031491 -10.17368804710356)
27424119.91829111951651LINESTRING (120.115829031491 -10.17368804710356, 120.1151583079331 -10.17283253353498)
282423119.91829111807372LINESTRING (120.1151583079331 -10.17283253353498, 120.1144875877013 -10.17197701953441)
2927127.39675183438476LINESTRING (120.1148222361484 -10.17128133822394, 120.1154682944476 -10.17223773772674)
6366.158145413532
1
3

Equipment

36.0
idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
20136.1410584780783TrueFalseFalseTrueFalseFalsewide
220.0TrueFalseFalseFalseFalseTruewide
23119.91829111951651TrueFalseFalseFalseFalseFalsewide
21.01.0111.67234256260492TrueFalseTrueTrueFalseTruewide
4
0
idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
62.015.01435.8640701275046FalseFalseTrueFalseTrueFalsewide
01.01.0952.1491205931343FalseFalseTrueFalseTrueFalsewide
81.08.0408.42317543535705FalseFalseTrueTrueFalseTruewide
31.01.0668.0180046715184FalseFalseTrueFalseFalseTruewide
51.03.0427.11828826513437FalseFalseTrueTrueFalseTruewide
21.01.0111.67234256260492TrueFalseTrueTrueFalseTruewide
71.05.0239.06909439698967FalseFalseTrueTrueTrueFalsewide
41.01.0359.7548733571067FalseFalseTrueFalseFalseTruewide
11.01.01216.6214473489415FalseFalseTrueFalseTrueFalsewide
9
idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
101179.9153816421856FalseFalseFalseTrueFalseFalsetall
13923.9666931568373FalseFalseFalseTrueFalseFalsetall
14687.8821562390393FalseFalseFalseTrueFalseFalsetall
81.08.0408.42317543535705FalseFalseTrueTrueFalseTruewide
17538.2205900534376FalseFalseFalseTrueFalseFalsetall
51.03.0427.11828826513437FalseFalseTrueTrueFalseTruewide
20136.1410584780783TrueFalseFalseTrueFalseFalsewide
21142.3727627555116FalseFalseFalseTrueFalseFalsetall
21.01.0111.67234256260492TrueFalseTrueTrueFalseTruewide
71.05.0239.06909439698967FalseFalseTrueTrueTrueFalsewide
27677.3892552099953FalseFalseFalseTrueFalseFalsetall
29947.0053512797223FalseFalseFalseTrueFalseFalsetall
12
idcustomer_countdemand_in_kwh_per_daybattery_distance_in_metershas_panelhas_lamphas_meterhas_routerhas_endhas_cornertype_id
62.015.01435.8640701275046FalseFalseTrueFalseTrueFalsewide
01.01.0952.1491205931343FalseFalseTrueFalseTrueFalsewide
81.08.0408.42317543535705FalseFalseTrueTrueFalseTruewide
31.01.0668.0180046715184FalseFalseTrueFalseFalseTruewide
51.03.0427.11828826513437FalseFalseTrueTrueFalseTruewide
20136.1410584780783TrueFalseFalseTrueFalseFalsewide
220.0TrueFalseFalseFalseFalseTruewide
23119.91829111951651TrueFalseFalseFalseFalseFalsewide
21.01.0111.67234256260492TrueFalseTrueTrueFalseTruewide
71.05.0239.06909439698967FalseFalseTrueTrueTrueFalsewide
41.01.0359.7548733571067FalseFalseTrueFalseFalseTruewide
11.01.01216.6214473489415FalseFalseTrueFalseTrueFalsewide
12

Algorithm

87.54881572723389
14.765247344970703
126.78411221504211
0.06839466094970703
3.762199878692627
2 more lamp pole(s) needed
Download
240.74863386154175