Optimize Solar Microgrid Layout 20180426-0214

Optimize the placement of the following components of a solar microgrid in a region without electricity infrastructure:

  • Service Drop Poles
  • Distribution Poles
  • Solar Panels
  • Battery

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.
  • Increase No Road Pole Cost to favor connections that place distribution poles near roads.
  • The following features have not yet been implemented:

    • Distribution Pole Obstacle Avoidance
    • Distribution Line Obstacle Avoidance
    • Street Lamp Placement
    • Wifi Router 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 entities 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

Upload
idmin_kwh_per_day
root00
root11
root210
root3100

Layout

Cost

Optimization

Anyone with the link

Pay Tool Creator: Roy Hyunjin Han187500
Set Visibility: Hidden0
Total0
description
line_length = 3702.167083864978 meters
root_distance = 653.5128618571266 meters
root_distance = 577.6341023199346 meters
root_distance = 483.8695146600038 meters
root_distance = 390.10492700007296 meters
root_distance = 296.3403393389448 meters
root_distance = 202.5757516790139 meters
root_distance = 108.81116401906073 meters
root_distance = 15.046576359129865 meters
root_type_id = root0
root_distance = 78.71801130234759 meters
root_distance = 172.48259896227847 meters
root_distance = 266.24718662220937 meters
root_distance = 343.22203446446173 meters
root_distance = 648.3742571769559 meters
root_distance = 420.19688230502413 meters
root_distance = 497.1717301472638 meters
root_distance = 574.1465779895161 meters
root_distance = 638.8514113013537 meters
type_iddemandid
root0330.00
1
type_iddemand_in_kwh_per_dayidwktgeometry_objectgeometry_proj4geometry_layer
root0330.00POINT (120.1128959515667 -10.1694752412637)POINT (120.1128959515667 -10.1694752412637)+proj=longlat +datum=WGS84 +no_defs
pole1_idpole2_idlength
6.08.097.50364877812048
8.09.097.50364877956602
9.010.097.50364877812048
10.011.097.5036487795473
11.012.097.50364877813918
12.013.097.5036487795473
13.014.097.50364877812048
7.015.075.87875953719193
14.016.097.50364877956602
15.017.075.8787595359946
16.018.097.50364877812048
17.018.075.87875953719193
18.019.093.76458765993087
19.020.093.76458765993087
20.021.093.7645876611282
21.022.093.76458765993087
22.023.093.76458765995318
23.024.093.76458765993087
2.025.076.38318591853799
25.026.076.38318591709883
24.027.093.7645876611282
26.028.076.38318591851916
27.029.093.76458765993087
28.03.076.38318591853799
29.04.093.76458765993087
3.030.074.22767918743978
30.033.074.22767918662966
4.031.076.97484784225234
31.032.076.97484784056243
33.035.074.22767918743978
32.034.076.97484784223968
34.035.076.97484784225234
36.035.064.70483331183755
0.036.064.70483331186375
37.00.072.79902397698399
38.037.072.7990239786192
1.038.072.79902397698399
39.01.094.8657943576312
40.039.094.8657943576312
41.040.094.86579435760277
42.041.094.86579435803141
43.042.094.8657943576312
5.043.094.8657943576312
64.70483331183755
97.50364877956602
3702.167083864979
pole1_idpole2_idlength_in_meterswktgeometry_objectgeometry_proj4geometry_layer
6897.50364877812048LINESTRING (120.103694009932 -10.17211216448912, 120.1042715497445 -10.17144255609843)LINESTRING (120.103694009932 -10.17211216448912, 120.1042715497445 -10.17144255609843)+proj=longlat +datum=WGS84 +no_defs
8997.50364877956602LINESTRING (120.1042715497445 -10.17144255609843, 120.1048490870385 -10.17077294599704)LINESTRING (120.1042715497445 -10.17144255609843, 120.1048490870385 -10.17077294599704)+proj=longlat +datum=WGS84 +no_defs
91097.50364877812048LINESTRING (120.1048490870385 -10.17077294599704, 120.1054266218142 -10.17010333418517)LINESTRING (120.1048490870385 -10.17077294599704, 120.1054266218142 -10.17010333418517)+proj=longlat +datum=WGS84 +no_defs
101197.50364877954729LINESTRING (120.1054266218142 -10.17010333418517, 120.1060041540719 -10.16943372066302)LINESTRING (120.1054266218142 -10.17010333418517, 120.1060041540719 -10.16943372066302)+proj=longlat +datum=WGS84 +no_defs
111297.5036487781392LINESTRING (120.1060041540719 -10.16943372066302, 120.1065816838117 -10.1687641054308)LINESTRING (120.1060041540719 -10.16943372066302, 120.1065816838117 -10.1687641054308)+proj=longlat +datum=WGS84 +no_defs
121397.50364877954729LINESTRING (120.1065816838117 -10.1687641054308, 120.1071592110337 -10.1680944884887)LINESTRING (120.1065816838117 -10.1687641054308, 120.1071592110337 -10.1680944884887)+proj=longlat +datum=WGS84 +no_defs
131497.50364877812048LINESTRING (120.1071592110337 -10.1680944884887, 120.1077367357383 -10.16742486983696)LINESTRING (120.1071592110337 -10.1680944884887, 120.1077367357383 -10.16742486983696)+proj=longlat +datum=WGS84 +no_defs
141697.50364877956602LINESTRING (120.1077367357383 -10.16742486983696, 120.1083142579256 -10.16675524947574)LINESTRING (120.1077367357383 -10.16742486983696, 120.1083142579256 -10.16675524947574)+proj=longlat +datum=WGS84 +no_defs
161897.50364877812048LINESTRING (120.1083142579256 -10.16675524947574, 120.1088917775957 -10.16608562740529)LINESTRING (120.1083142579256 -10.16675524947574, 120.1088917775957 -10.16608562740529)+proj=longlat +datum=WGS84 +no_defs
71575.87875953719194LINESTRING (120.1073138215147 -10.16474982804413, 120.1078398053508 -10.16519509495209)LINESTRING (120.1073138215147 -10.16474982804413, 120.1078398053508 -10.16519509495209)+proj=longlat +datum=WGS84 +no_defs
151775.87875953599459LINESTRING (120.1078398053508 -10.16519509495209, 120.1083657907111 -10.16564036140583)LINESTRING (120.1078398053508 -10.16519509495209, 120.1083657907111 -10.16564036140583)+proj=longlat +datum=WGS84 +no_defs
171875.87875953719194LINESTRING (120.1083657907111 -10.16564036140583, 120.1088917775957 -10.16608562740529)LINESTRING (120.1083657907111 -10.16564036140583, 120.1088917775957 -10.16608562740529)+proj=longlat +datum=WGS84 +no_defs
181993.76458765993088LINESTRING (120.1088917775957 -10.16608562740529, 120.1095417500442 -10.16663584904122)LINESTRING (120.1088917775957 -10.16608562740529, 120.1095417500442 -10.16663584904122)+proj=longlat +datum=WGS84 +no_defs
192093.76458765993088LINESTRING (120.1095417500442 -10.16663584904122, 120.1101917248203 -10.16718606998302)LINESTRING (120.1095417500442 -10.16663584904122, 120.1101917248203 -10.16718606998302)+proj=longlat +datum=WGS84 +no_defs
202193.7645876611282LINESTRING (120.1101917248203 -10.16718606998302, 120.1108417019243 -10.16773629023052)LINESTRING (120.1101917248203 -10.16718606998302, 120.1108417019243 -10.16773629023052)+proj=longlat +datum=WGS84 +no_defs
212293.76458765993088LINESTRING (120.1108417019243 -10.16773629023052, 120.1114916813562 -10.16828650978343)LINESTRING (120.1108417019243 -10.16773629023052, 120.1114916813562 -10.16828650978343)+proj=longlat +datum=WGS84 +no_defs
222393.7645876599532LINESTRING (120.1114916813562 -10.16828650978343, 120.1121416631161 -10.16883672864158)LINESTRING (120.1114916813562 -10.16828650978343, 120.1121416631161 -10.16883672864158)+proj=longlat +datum=WGS84 +no_defs
232493.76458765993088LINESTRING (120.1121416631161 -10.16883672864158, 120.1127916472042 -10.16938694680474)LINESTRING (120.1121416631161 -10.16883672864158, 120.1127916472042 -10.16938694680474)+proj=longlat +datum=WGS84 +no_defs
242793.7645876611282LINESTRING (120.1127916472042 -10.16938694680474, 120.1134416336205 -10.16993716427272)LINESTRING (120.1127916472042 -10.16938694680474, 120.1134416336205 -10.16993716427272)+proj=longlat +datum=WGS84 +no_defs
272993.76458765993088LINESTRING (120.1134416336205 -10.16993716427272, 120.1140916223652 -10.17048738104526)LINESTRING (120.1134416336205 -10.16993716427272, 120.1140916223652 -10.17048738104526)+proj=longlat +datum=WGS84 +no_defs
29493.76458765993088LINESTRING (120.1140916223652 -10.17048738104526, 120.1147416134383 -10.17103759712217)LINESTRING (120.1140916223652 -10.17048738104526, 120.1147416134383 -10.17103759712217)+proj=longlat +datum=WGS84 +no_defs
43176.97484784225234LINESTRING (120.1147416134383 -10.17103759712217, 120.1150412331783 -10.1716663909514)LINESTRING (120.1147416134383 -10.17103759712217, 120.1150412331783 -10.1716663909514)+proj=longlat +datum=WGS84 +no_defs
313276.97484784056243LINESTRING (120.1150412331783 -10.1716663909514, 120.1153408538251 -10.17229518480794)LINESTRING (120.1150412331783 -10.1716663909514, 120.1153408538251 -10.17229518480794)+proj=longlat +datum=WGS84 +no_defs
323476.97484784223968LINESTRING (120.1153408538251 -10.17229518480794, 120.1156404753787 -10.17292397869176)LINESTRING (120.1153408538251 -10.17229518480794, 120.1156404753787 -10.17292397869176)+proj=longlat +datum=WGS84 +no_defs
343576.97484784225234LINESTRING (120.1156404753787 -10.17292397869176, 120.1159400978393 -10.17355277260282)LINESTRING (120.1156404753787 -10.17292397869176, 120.1159400978393 -10.17355277260282)+proj=longlat +datum=WGS84 +no_defs
22576.38318591853799LINESTRING (120.1122828067577 -10.17650008489393, 120.1127380990615 -10.17597793953306)LINESTRING (120.1122828067577 -10.17650008489393, 120.1127380990615 -10.17597793953306)+proj=longlat +datum=WGS84 +no_defs
252676.38318591709883LINESTRING (120.1127380990615 -10.17597793953306, 120.1131933898213 -10.17545579311482)LINESTRING (120.1127380990615 -10.17597793953306, 120.1131933898213 -10.17545579311482)+proj=longlat +datum=WGS84 +no_defs
262876.38318591851916LINESTRING (120.1131933898213 -10.17545579311482, 120.1136486790371 -10.17493364563926)LINESTRING (120.1131933898213 -10.17545579311482, 120.1136486790371 -10.17493364563926)+proj=longlat +datum=WGS84 +no_defs
28376.38318591853799LINESTRING (120.1136486790371 -10.17493364563926, 120.114103966709 -10.1744114971065)LINESTRING (120.1136486790371 -10.17493364563926, 120.114103966709 -10.1744114971065)+proj=longlat +datum=WGS84 +no_defs
33074.22767918743979LINESTRING (120.114103966709 -10.1744114971065, 120.1147160112625 -10.17412525705712)LINESTRING (120.114103966709 -10.1744114971065, 120.1147160112625 -10.17412525705712)+proj=longlat +datum=WGS84 +no_defs
303374.22767918662966LINESTRING (120.1147160112625 -10.17412525705712, 120.1153280549726 -10.17383901555587)LINESTRING (120.1147160112625 -10.17412525705712, 120.1153280549726 -10.17383901555587)+proj=longlat +datum=WGS84 +no_defs
333574.22767918743979LINESTRING (120.1153280549726 -10.17383901555587, 120.1159400978393 -10.17355277260282)LINESTRING (120.1153280549726 -10.17383901555587, 120.1159400978393 -10.17355277260282)+proj=longlat +datum=WGS84 +no_defs
54394.8657943576312LINESTRING (120.1230820619759 -10.17028555077978, 120.1222356581679 -10.17046224123014)LINESTRING (120.1230820619759 -10.17028555077978, 120.1222356581679 -10.17046224123014)+proj=longlat +datum=WGS84 +no_defs
434294.8657943576312LINESTRING (120.1222356581679 -10.17046224123014, 120.1213892540128 -10.17063892923017)LINESTRING (120.1222356581679 -10.17046224123014, 120.1213892540128 -10.17063892923017)+proj=longlat +datum=WGS84 +no_defs
424194.86579435803141LINESTRING (120.1213892540128 -10.17063892923017, 120.1205428495109 -10.17081561477976)LINESTRING (120.1213892540128 -10.17063892923017, 120.1205428495109 -10.17081561477976)+proj=longlat +datum=WGS84 +no_defs
414094.86579435760277LINESTRING (120.1205428495109 -10.17081561477976, 120.1196964446621 -10.17099229787877)LINESTRING (120.1205428495109 -10.17081561477976, 120.1196964446621 -10.17099229787877)+proj=longlat +datum=WGS84 +no_defs
403994.8657943576312LINESTRING (120.1196964446621 -10.17099229787877, 120.1188500394668 -10.17116897852711)LINESTRING (120.1196964446621 -10.17099229787877, 120.1188500394668 -10.17116897852711)+proj=longlat +datum=WGS84 +no_defs
39194.8657943576312LINESTRING (120.1188500394668 -10.17116897852711, 120.1180036339251 -10.17134565672465)LINESTRING (120.1188500394668 -10.17116897852711, 120.1180036339251 -10.17134565672465)+proj=longlat +datum=WGS84 +no_defs
13872.79902397698399LINESTRING (120.1180036339251 -10.17134565672465, 120.1176714708781 -10.17191501476436)LINESTRING (120.1180036339251 -10.17134565672465, 120.1176714708781 -10.17191501476436)+proj=longlat +datum=WGS84 +no_defs
383772.7990239786192LINESTRING (120.1176714708781 -10.17191501476436, 120.1173393064629 -10.17248437212499)LINESTRING (120.1176714708781 -10.17191501476436, 120.1173393064629 -10.17248437212499)+proj=longlat +datum=WGS84 +no_defs
37072.79902397698399LINESTRING (120.1173393064629 -10.17248437212499, 120.1170071406794 -10.17305372880646)LINESTRING (120.1173393064629 -10.17248437212499, 120.1170071406794 -10.17305372880646)+proj=longlat +datum=WGS84 +no_defs
03664.70483331186375LINESTRING (120.1170071406794 -10.17305372880646, 120.1164736195798 -10.17330325125616)LINESTRING (120.1170071406794 -10.17305372880646, 120.1164736195798 -10.17330325125616)+proj=longlat +datum=WGS84 +no_defs
363564.70483331183755LINESTRING (120.1164736195798 -10.17330325125616, 120.1159400978393 -10.17355277260282)LINESTRING (120.1164736195798 -10.17330325125616, 120.1159400978393 -10.17355277260282)+proj=longlat +datum=WGS84 +no_defs
customersdemandidhas_paneldistancetype_idhas_wifihas_lamphas_corner
1.01.0601455.1669413287825a000
801357.663292550662a000
901260.159643771096a000
1001162.6559949929754a000
1101065.152346213428a000
120967.6486974352889a000
130870.1450486557416a000
1.02.070805.2703809303132a000
140772.6413998776211a000
150729.3916213931212a000
160675.1377510980551a000
171653.5128618571266a000
181577.6341023199346a000
191483.8695146600038a000
201390.10492700007296a000
211296.3403393389448a000
221202.5757516790139a000
231108.81116401906073a000
1.0100.0201102.3623592237193a000
2501025.9791733051813a000
24115.046576359129865a000
260949.5959873880824a000
27178.71801130234759a000
280873.2128014695633a000
291172.48259896227847a000
1.0100.030796.8296155510253a000
300722.6019363635855a000
1.03.041266.24718662220937a000
311343.22203446446173a000
331648.3742571769559a000
321420.19688230502413a000
341497.1717301472638a000
351574.1465779895161a000
361638.8514113013537a000
2.09.000703.5562446132174a000
370776.3552685902014a000
380849.1542925688206a000
2.0107.010921.9533165458046a000
3901016.8191109034358a000
4001111.684905261067a000
4101206.5506996186696a000
4201301.416493976701a000
4301396.2822883343322a000
1.08.0501491.1480826919633a000
17
36
8
customer_countdemand_in_kwh_per_dayidhas_solar_panelroot_distance_in_meterstype_idhas_wifihas_lamphas_cornerwktgeometry_objectgeometry_proj4geometry_layer
2.09.00False703.5562446132174aFalseFalseFalsePOINT (120.1170071406794 -10.17305372880646)POINT (120.1170071406794 -10.17305372880646)+proj=longlat +datum=WGS84 +no_defs
2.0107.01False921.9533165458046aFalseFalseFalsePOINT (120.1180036339251 -10.17134565672465)POINT (120.1180036339251 -10.17134565672465)+proj=longlat +datum=WGS84 +no_defs
1.0100.02False1102.362359223719aFalseFalseFalsePOINT (120.1122828067577 -10.17650008489393)POINT (120.1122828067577 -10.17650008489393)+proj=longlat +datum=WGS84 +no_defs
1.0100.03False796.8296155510252aFalseFalseFalsePOINT (120.114103966709 -10.1744114971065)POINT (120.114103966709 -10.1744114971065)+proj=longlat +datum=WGS84 +no_defs
1.03.04True266.24718662220937aFalseFalseFalsePOINT (120.1147416134383 -10.17103759712217)POINT (120.1147416134383 -10.17103759712217)+proj=longlat +datum=WGS84 +no_defs
1.08.05False1491.1480826919633aFalseFalseFalsePOINT (120.1230820619759 -10.17028555077978)POINT (120.1230820619759 -10.17028555077978)+proj=longlat +datum=WGS84 +no_defs
1.01.06False1455.1669413287823aFalseFalseFalsePOINT (120.103694009932 -10.17211216448912)POINT (120.103694009932 -10.17211216448912)+proj=longlat +datum=WGS84 +no_defs
1.02.07False805.2703809303133aFalseFalseFalsePOINT (120.1073138215147 -10.16474982804413)POINT (120.1073138215147 -10.16474982804413)+proj=longlat +datum=WGS84 +no_defs
8False1357.663292550662aFalseFalseFalsePOINT (120.1042715497445 -10.17144255609843)POINT (120.1042715497445 -10.17144255609843)+proj=longlat +datum=WGS84 +no_defs
9False1260.159643771096aFalseFalseFalsePOINT (120.1048490870385 -10.17077294599704)POINT (120.1048490870385 -10.17077294599704)+proj=longlat +datum=WGS84 +no_defs
10False1162.6559949929754aFalseFalseFalsePOINT (120.1054266218142 -10.17010333418517)POINT (120.1054266218142 -10.17010333418517)+proj=longlat +datum=WGS84 +no_defs
11False1065.152346213428aFalseFalseFalsePOINT (120.1060041540719 -10.16943372066302)POINT (120.1060041540719 -10.16943372066302)+proj=longlat +datum=WGS84 +no_defs
12False967.6486974352887aFalseFalseFalsePOINT (120.1065816838117 -10.1687641054308)POINT (120.1065816838117 -10.1687641054308)+proj=longlat +datum=WGS84 +no_defs
13False870.1450486557416aFalseFalseFalsePOINT (120.1071592110337 -10.1680944884887)POINT (120.1071592110337 -10.1680944884887)+proj=longlat +datum=WGS84 +no_defs
14False772.6413998776212aFalseFalseFalsePOINT (120.1077367357383 -10.16742486983696)POINT (120.1077367357383 -10.16742486983696)+proj=longlat +datum=WGS84 +no_defs
15False729.3916213931212aFalseFalseFalsePOINT (120.1078398053508 -10.16519509495209)POINT (120.1078398053508 -10.16519509495209)+proj=longlat +datum=WGS84 +no_defs
16False675.1377510980551aFalseFalseFalsePOINT (120.1083142579256 -10.16675524947574)POINT (120.1083142579256 -10.16675524947574)+proj=longlat +datum=WGS84 +no_defs
17True653.5128618571266aFalseFalseFalsePOINT (120.1083657907111 -10.16564036140583)POINT (120.1083657907111 -10.16564036140583)+proj=longlat +datum=WGS84 +no_defs
18True577.6341023199346aFalseFalseFalsePOINT (120.1088917775957 -10.16608562740529)POINT (120.1088917775957 -10.16608562740529)+proj=longlat +datum=WGS84 +no_defs
19True483.8695146600038aFalseFalseFalsePOINT (120.1095417500442 -10.16663584904122)POINT (120.1095417500442 -10.16663584904122)+proj=longlat +datum=WGS84 +no_defs
20True390.10492700007296aFalseFalseFalsePOINT (120.1101917248203 -10.16718606998302)POINT (120.1101917248203 -10.16718606998302)+proj=longlat +datum=WGS84 +no_defs
21True296.34033933894483aFalseFalseFalsePOINT (120.1108417019243 -10.16773629023052)POINT (120.1108417019243 -10.16773629023052)+proj=longlat +datum=WGS84 +no_defs
22True202.5757516790139aFalseFalseFalsePOINT (120.1114916813562 -10.16828650978343)POINT (120.1114916813562 -10.16828650978343)+proj=longlat +datum=WGS84 +no_defs
23True108.81116401906073aFalseFalseFalsePOINT (120.1121416631161 -10.16883672864158)POINT (120.1121416631161 -10.16883672864158)+proj=longlat +datum=WGS84 +no_defs
24True15.046576359129865aFalseFalseFalsePOINT (120.1127916472042 -10.16938694680474)POINT (120.1127916472042 -10.16938694680474)+proj=longlat +datum=WGS84 +no_defs
25False1025.9791733051813aFalseFalseFalsePOINT (120.1127380990615 -10.17597793953306)POINT (120.1127380990615 -10.17597793953306)+proj=longlat +datum=WGS84 +no_defs
26False949.5959873880824aFalseFalseFalsePOINT (120.1131933898213 -10.17545579311482)POINT (120.1131933898213 -10.17545579311482)+proj=longlat +datum=WGS84 +no_defs
27True78.71801130234759aFalseFalseFalsePOINT (120.1134416336205 -10.16993716427272)POINT (120.1134416336205 -10.16993716427272)+proj=longlat +datum=WGS84 +no_defs
28False873.2128014695633aFalseFalseFalsePOINT (120.1136486790371 -10.17493364563926)POINT (120.1136486790371 -10.17493364563926)+proj=longlat +datum=WGS84 +no_defs
29True172.48259896227847aFalseFalseFalsePOINT (120.1140916223652 -10.17048738104526)POINT (120.1140916223652 -10.17048738104526)+proj=longlat +datum=WGS84 +no_defs
30False722.6019363635855aFalseFalseFalsePOINT (120.1147160112625 -10.17412525705712)POINT (120.1147160112625 -10.17412525705712)+proj=longlat +datum=WGS84 +no_defs
31True343.22203446446173aFalseFalseFalsePOINT (120.1150412331783 -10.1716663909514)POINT (120.1150412331783 -10.1716663909514)+proj=longlat +datum=WGS84 +no_defs
32True420.196882305024aFalseFalseFalsePOINT (120.1153408538251 -10.17229518480794)POINT (120.1153408538251 -10.17229518480794)+proj=longlat +datum=WGS84 +no_defs
33True648.3742571769559aFalseFalseFalsePOINT (120.1153280549726 -10.17383901555587)POINT (120.1153280549726 -10.17383901555587)+proj=longlat +datum=WGS84 +no_defs
34True497.1717301472638aFalseFalseFalsePOINT (120.1156404753787 -10.17292397869176)POINT (120.1156404753787 -10.17292397869176)+proj=longlat +datum=WGS84 +no_defs
35True574.1465779895161aFalseFalseFalsePOINT (120.1159400978393 -10.17355277260282)POINT (120.1159400978393 -10.17355277260282)+proj=longlat +datum=WGS84 +no_defs
36True638.8514113013538aFalseFalseFalsePOINT (120.1164736195798 -10.17330325125616)POINT (120.1164736195798 -10.17330325125616)+proj=longlat +datum=WGS84 +no_defs
37False776.3552685902014aFalseFalseFalsePOINT (120.1173393064629 -10.17248437212499)POINT (120.1173393064629 -10.17248437212499)+proj=longlat +datum=WGS84 +no_defs
38False849.1542925688207aFalseFalseFalsePOINT (120.1176714708781 -10.17191501476436)POINT (120.1176714708781 -10.17191501476436)+proj=longlat +datum=WGS84 +no_defs
39False1016.8191109034358aFalseFalseFalsePOINT (120.1188500394668 -10.17116897852711)POINT (120.1188500394668 -10.17116897852711)+proj=longlat +datum=WGS84 +no_defs
40False1111.6849052610671aFalseFalseFalsePOINT (120.1196964446621 -10.17099229787877)POINT (120.1196964446621 -10.17099229787877)+proj=longlat +datum=WGS84 +no_defs
41False1206.5506996186693aFalseFalseFalsePOINT (120.1205428495109 -10.17081561477976)POINT (120.1205428495109 -10.17081561477976)+proj=longlat +datum=WGS84 +no_defs
42False1301.416493976701aFalseFalseFalsePOINT (120.1213892540128 -10.17063892923017)POINT (120.1213892540128 -10.17063892923017)+proj=longlat +datum=WGS84 +no_defs
43False1396.2822883343322aFalseFalseFalsePOINT (120.1222356581679 -10.17046224123014)POINT (120.1222356581679 -10.17046224123014)+proj=longlat +datum=WGS84 +no_defs
pole_idcustomerlengthid
6.08.010.0095925852601428.0
7.07.010.0095925852601429.0
2.03.010.0095925852601424.0
3.05.010.0095925852601425.0
4.06.010.0095925852601426.0
0.09.030.7262144906745361.0
0.00.021.9998131359171330.0
1.04.034.151213031608763.0
1.02.041.47538114757912.0
5.01.010.0095925852601427.0
10.009592585260142
41.4753811475791
188.4101773173404
pole_idcustomer_idlength_in_metersidwktgeometry_objectgeometry_proj4geometry_layer
0021.9998131359171330LINESTRING (120.1170071406794 -10.17305372880646, 120.1172007307673 -10.17300166693765)LINESTRING (120.1170071406794 -10.17305372880646, 120.1172007307673 -10.17300166693765)+proj=longlat +datum=WGS84 +no_defs
0930.7262144906745331LINESTRING (120.1170071406794 -10.17305372880646, 120.1167367649391 -10.17312645382021)LINESTRING (120.1170071406794 -10.17305372880646, 120.1167367649391 -10.17312645382021)+proj=longlat +datum=WGS84 +no_defs
1241.47538114757912LINESTRING (120.1180036339251 -10.17134565672465, 120.1183629112747 -10.17122870652354)LINESTRING (120.1180036339251 -10.17134565672465, 120.1183629112747 -10.17122870652354)+proj=longlat +datum=WGS84 +no_defs
1434.151213031608763LINESTRING (120.1180036339251 -10.17134565672465, 120.1177078009571 -10.17144195260134)LINESTRING (120.1180036339251 -10.17134565672465, 120.1177078009571 -10.17144195260134)+proj=longlat +datum=WGS84 +no_defs
2310.0095925852601424LINESTRING (120.1122828067577 -10.17650008489393, 120.1122157465268 -10.17656141927779)LINESTRING (120.1122828067577 -10.17650008489393, 120.1122157465268 -10.17656141927779)+proj=longlat +datum=WGS84 +no_defs
3510.0095925852601425LINESTRING (120.114103966709 -10.1744114971065, 120.1140369072708 -10.17447283208723)LINESTRING (120.114103966709 -10.1744114971065, 120.1140369072708 -10.17447283208723)+proj=longlat +datum=WGS84 +no_defs
4610.0095925852601426LINESTRING (120.1147416134383 -10.17103759712217, 120.114674554972 -10.17109893247244)LINESTRING (120.1147416134383 -10.17103759712217, 120.114674554972 -10.17109893247244)+proj=longlat +datum=WGS84 +no_defs
5110.0095925852601427LINESTRING (120.1230820619759 -10.17028555077978, 120.1230150048235 -10.17034688832581)LINESTRING (120.1230820619759 -10.17028555077978, 120.1230150048235 -10.17034688832581)+proj=longlat +datum=WGS84 +no_defs
6810.0095925852601428LINESTRING (120.103694009932 -10.17211216448912, 120.1036269497066 -10.17217349692373)LINESTRING (120.103694009932 -10.17211216448912, 120.1036269497066 -10.17217349692373)+proj=longlat +datum=WGS84 +no_defs
7710.0095925852601429LINESTRING (120.1073138215147 -10.16474982804413, 120.1072467637078 -10.16481116186146)LINESTRING (120.1073138215147 -10.16474982804413, 120.1072467637078 -10.16481116186146)+proj=longlat +datum=WGS84 +no_defs
iddemandpole_id
customer81.06.0
customer72.07.0
customer3100.02.0
customer5100.03.0
customer63.04.0
customer90.00.0
customer09.00.0
customer4100.01.0
customer27.01.0
customer18.05.0
iddemand_in_kwh_per_daypole_idwktgeometry_objectgeometry_proj4geometry_layer
customer09.00.0POINT (120.1172007307673 -10.17300166693765)POINT (120.1172007307673 -10.17300166693765)+proj=longlat +datum=WGS84 +no_defs
customer18.05.0POINT (120.1230150048235 -10.17034688832581)POINT (120.1230150048235 -10.17034688832581)+proj=longlat +datum=WGS84 +no_defs
customer27.01.0POINT (120.1183629112747 -10.17122870652354)POINT (120.1183629112747 -10.17122870652354)+proj=longlat +datum=WGS84 +no_defs
customer3100.02.0POINT (120.1122157465268 -10.17656141927779)POINT (120.1122157465268 -10.17656141927779)+proj=longlat +datum=WGS84 +no_defs
customer4100.01.0POINT (120.1177078009571 -10.17144195260134)POINT (120.1177078009571 -10.17144195260134)+proj=longlat +datum=WGS84 +no_defs
customer5100.03.0POINT (120.1140369072708 -10.17447283208723)POINT (120.1140369072708 -10.17447283208723)+proj=longlat +datum=WGS84 +no_defs
customer63.04.0POINT (120.114674554972 -10.17109893247244)POINT (120.114674554972 -10.17109893247244)+proj=longlat +datum=WGS84 +no_defs
customer72.07.0POINT (120.1072467637078 -10.16481116186146)POINT (120.1072467637078 -10.16481116186146)+proj=longlat +datum=WGS84 +no_defs
customer81.06.0POINT (120.1036269497066 -10.17217349692373)POINT (120.1036269497066 -10.17217349692373)+proj=longlat +datum=WGS84 +no_defs
customer90.00.0POINT (120.1167367649391 -10.17312645382021)POINT (120.1167367649391 -10.17312645382021)+proj=longlat +datum=WGS84 +no_defs
10
6366.158145413532
1
3
0.8569545745849609
0.5834171772003174
1.6631159782409668
0.09868216514587402
Download
7.4625701904296875