Place Service Drop Poles 20180603-0800 Defaults

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

  • Service Drop Poles
  • Service Drop Lines

The algorithm makes the following optimizations:

  • Place service drop poles near roads.
  • Avoid pole obstacles when placing service drop poles.
  • Avoid line obstacles when placing service drop line.

Relevant Industries

  • Energy > Grid
  • Energy > Microgrid

Target Applications

  • Grid Extension
  • 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).

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

{ panel_min_count_per_kwh : Solar Panel Minimum Count per kWh ? Minimum number of solar panel poles required per kWh of demand }

Layout

Cost

Algorithm

Anyone with the link

Pay Tool Creator: Roy Hyunjin Han1250000
Set Visibility: Hidden0
Total0
Description
Service Drop Line
Obstacles where Poles Cannot be Placed
Obstacles where Lines Cannot be Placed
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)
10
49.304975299203285
DescriptionNameValue
Cost of one service drop poledrop_pole_cost_per_pole100
Number of service drop polesdrop_pole_count10
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_percent90
Penalty for service drop poles located off roaddrop_pole_off_road_penalty900
Cost of service drop poles excluding off road penaltydrop_pole_raw_cost1000
Cost of service drop poles including off road penaltydrop_pole_cost1900
Cost per meter of service drop linedrop_line_cost_per_meter10
Length of service drop line in metersdrop_line_length50
Cost of service drop linesdrop_line_cost494
Cost of service drop poles and lines excluding off road penaltydrop_pole_and_line_raw_cost1494
Cost of service drop poles and lines including off road penaltydrop_pole_and_line_cost2394

Service Drop Lines

idpole_idcustomer_idlength_in_meters
8.08.08.05.270206431615062
7.07.07.09.992110953454628
3.03.03.08.225227564135855
5.05.05.01.0770898374242477
6.06.06.04.63677460885565
9.09.09.04.081667542614648
0.00.00.09.988200532456204
4.04.04.02.0112326089565147
2.02.02.02.0112326089565147
1.01.01.02.011232610733957
10
10
1.0770898374242477
9.992110953454626
49.304975299203285
idpole_idcustomer_idlength_in_meterswkt
0009.988200532456204LINESTRING (120.117119031685 -10.17296179718251, 120.1172007307673 -10.17300166693765)
1112.011232610733957LINESTRING (120.1230193371014 -10.17036454227049, 120.1230150048235 -10.17034688832581)
2222.0112326089565147LINESTRING (120.1183672432775 -10.17124636046203, 120.1183629112747 -10.17122870652354)
3338.225227564135855LINESTRING (120.1122753535964 -10.17651632582005, 120.1122157465268 -10.17656141927779)
4442.0112326089565147LINESTRING (120.117712132921 -10.1714596065392, 120.1177078009571 -10.17144195260134)
5551.0770898374242477LINESTRING (120.1140322024868 -10.17448137265035, 120.1140369072708 -10.17447283208723)
6664.63677460885565LINESTRING (120.1147066454011 -10.17107166287888, 120.114674554972 -10.17109893247244)
7779.992110953454628LINESTRING (120.1072706570837 -10.16489826366139, 120.1072467637078 -10.16481116186146)
8885.270206431615062LINESTRING (120.1036136159847 -10.17212775943849, 120.1036269497066 -10.17217349692373)
9994.081667542614648LINESTRING (120.1167324657906 -10.17308982965915, 120.1167367649391 -10.17312645382021)

Service Drop Poles

idcustomer_countdemand_in_kwh_per_day
8.01.01.0
7.01.02.0
3.01.01.0
5.01.01.0
6.01.03.0
9.01.00.0
0.01.09.0
4.01.01.0
2.01.07.0
1.01.08.0
idcustomer_countdemand_in_kwh_per_daywkt
019.0POINT (120.117119031685 -10.17296179718251)
118.0POINT (120.1230193371014 -10.17036454227049)
217.0POINT (120.1183672432775 -10.17124636046203)
311.0POINT (120.1122753535964 -10.17651632582005)
411.0POINT (120.117712132921 -10.1714596065392)
511.0POINT (120.1140322024868 -10.17448137265035)
613.0POINT (120.1147066454011 -10.17107166287888)
712.0POINT (120.1072706570837 -10.16489826366139)
811.0POINT (120.1036136159847 -10.17212775943849)
910.0POINT (120.1167324657906 -10.17308982965915)
6366.158145413532
1
3

Algorithm

1.3817827701568604
Download
6.977911710739136