Skip to content

Commit c752e65

Browse files
author
ricwilson
committed
Add utility powerapps data and update package.json for data generation script
- Created a new data file `utility_powerapps_table.txt` containing detailed information about various utility assets including meters, poles, and transformers with their respective attributes. - Updated `package.json` to include a new script for generating data using a Python script.
1 parent 4daa8cf commit c752e65

File tree

4 files changed

+649
-0
lines changed

4 files changed

+649
-0
lines changed

AzureMapsGrid/data/generate.py

Lines changed: 142 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,142 @@
1+
import csv
2+
import random
3+
import argparse
4+
import os
5+
6+
def generate_random_hex_color():
7+
return "#{:06X}".format(random.randint(0, 0xFFFFFF))
8+
9+
def generate_data(
10+
count,
11+
item_types,
12+
categories,
13+
lat_min,
14+
lat_max,
15+
long_min,
16+
long_max
17+
):
18+
records = []
19+
for i in range(1, count + 1):
20+
item_type = random.choice(item_types)
21+
category = random.choice(categories)
22+
lat = round(random.uniform(lat_min, lat_max), 6)
23+
lon = round(random.uniform(long_min, long_max), 6)
24+
color = generate_random_hex_color()
25+
name = f"{item_type}-{i:04d}"
26+
description = item_type
27+
records.append({
28+
"Name": name,
29+
"Description": description,
30+
"Lat": lat,
31+
"Long": lon,
32+
"Color": color,
33+
"Category": category
34+
})
35+
return records
36+
37+
def write_locations_csv(filename, records):
38+
with open(filename, mode='w', newline='') as csvfile:
39+
fieldnames = ["Name", "Description", "Lat", "Long", "Color", "Category"]
40+
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
41+
writer.writeheader()
42+
for record in records:
43+
writer.writerow(record)
44+
45+
def write_categories_csv(filename, categories):
46+
with open(filename, mode='w', newline='') as csvfile:
47+
writer = csv.writer(csvfile)
48+
writer.writerow(["Category"])
49+
for category in sorted(set(categories)):
50+
writer.writerow([category])
51+
52+
def write_powerapps_table(filename, records):
53+
with open(filename, mode='w') as txtfile:
54+
txtfile.write("Table(\n")
55+
for i, record in enumerate(records):
56+
line = (
57+
f' {{Name:"{record["Name"]}", Description:"{record["Description"]}", '
58+
f'Lat:{record["Lat"]}, Long:{record["Long"]}, Color:"{record["Color"]}", '
59+
f'Category:"{record["Category"]}"}}'
60+
)
61+
if i < len(records) - 1:
62+
line += ","
63+
txtfile.write(line + "\n")
64+
txtfile.write(")\n")
65+
66+
if __name__ == "__main__":
67+
parser = argparse.ArgumentParser(
68+
description="Generate synthetic utility asset data for testing."
69+
)
70+
parser.add_argument(
71+
"num_records",
72+
nargs="?",
73+
type=int,
74+
default=250,
75+
help="Number of records to generate"
76+
)
77+
parser.add_argument(
78+
"--item-types",
79+
nargs="+",
80+
default=["Pole", "Meter", "Transformer"],
81+
help="List of item types (default: Pole Meter Transformer)"
82+
)
83+
parser.add_argument(
84+
"--categories",
85+
nargs="+",
86+
default=["Active", "Maintenance", "Retired"],
87+
help="List of categories (default: Active Maintenance Retired)"
88+
)
89+
parser.add_argument(
90+
"--lat-min",
91+
type=float,
92+
default=38.4,
93+
help="Minimum latitude (default: 38.4)"
94+
)
95+
parser.add_argument(
96+
"--lat-max",
97+
type=float,
98+
default=41.98,
99+
help="Maximum latitude (default: 41.98)"
100+
)
101+
parser.add_argument(
102+
"--long-min",
103+
type=float,
104+
default=-84.82,
105+
help="Minimum longitude (default: -84.82)"
106+
)
107+
parser.add_argument(
108+
"--long-max",
109+
type=float,
110+
default=-80.52,
111+
help="Maximum longitude (default: -80.52)"
112+
)
113+
114+
args = parser.parse_args()
115+
116+
# --- GENERATE DATA ---
117+
data = generate_data(
118+
count=args.num_records,
119+
item_types=args.item_types,
120+
categories=args.categories,
121+
lat_min=args.lat_min,
122+
lat_max=args.lat_max,
123+
long_min=args.long_min,
124+
long_max=args.long_max
125+
)
126+
127+
# Determine script's own directory
128+
script_dir = os.path.dirname(os.path.abspath(__file__))
129+
130+
# Output paths
131+
LOCATIONS_OUTPUT_FILE = os.path.join(script_dir, "utility_locations.csv")
132+
CATEGORIES_OUTPUT_FILE = os.path.join(script_dir, "utility_categories.csv")
133+
POWERAPPS_TABLE_FILE = os.path.join(script_dir, "utility_powerapps_table.txt")
134+
135+
# --- SAVE FILES ---
136+
write_locations_csv(LOCATIONS_OUTPUT_FILE, data)
137+
write_categories_csv(CATEGORIES_OUTPUT_FILE, args.categories)
138+
write_powerapps_table(POWERAPPS_TABLE_FILE, data)
139+
140+
print(f"✅ Generated {args.num_records} location records and saved to '{LOCATIONS_OUTPUT_FILE}'")
141+
print(f"✅ Saved categories list to '{CATEGORIES_OUTPUT_FILE}'")
142+
print(f"✅ Saved PowerApps Table() definition to '{POWERAPPS_TABLE_FILE}'")
Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
Category
2+
Active
3+
Maintenance
4+
Retired
Lines changed: 251 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,251 @@
1+
Name,Description,Lat,Long,Color,Category
2+
Meter-0001,Meter,41.465539,-81.93902,#820A24,Active
3+
Pole-0002,Pole,39.910525,-84.378316,#F2F052,Retired
4+
Transformer-0003,Transformer,39.351291,-82.533233,#F59B65,Active
5+
Meter-0004,Meter,38.496202,-83.096695,#7AE722,Active
6+
Pole-0005,Pole,41.668887,-81.274083,#B71660,Active
7+
Pole-0006,Pole,40.625296,-84.645713,#7ADB9D,Retired
8+
Meter-0007,Meter,40.991971,-82.051258,#49DF21,Retired
9+
Transformer-0008,Transformer,40.551213,-82.050948,#D01E6A,Maintenance
10+
Meter-0009,Meter,41.39606,-82.632326,#A09680,Maintenance
11+
Transformer-0010,Transformer,38.42365,-82.085422,#048607,Maintenance
12+
Meter-0011,Meter,38.409919,-82.687055,#AADA0E,Active
13+
Pole-0012,Pole,39.648647,-84.413546,#B1F462,Maintenance
14+
Transformer-0013,Transformer,41.040799,-82.982978,#8D910F,Retired
15+
Pole-0014,Pole,40.52092,-82.318891,#74E440,Retired
16+
Meter-0015,Meter,39.390897,-82.321605,#317966,Maintenance
17+
Pole-0016,Pole,41.518437,-81.352028,#79B4AD,Retired
18+
Transformer-0017,Transformer,40.002544,-82.421122,#F2C496,Retired
19+
Transformer-0018,Transformer,39.191473,-81.577633,#F55921,Active
20+
Meter-0019,Meter,39.797345,-80.861863,#1C9261,Maintenance
21+
Pole-0020,Pole,38.559237,-81.262736,#406B17,Retired
22+
Pole-0021,Pole,38.988209,-82.429381,#5099A8,Maintenance
23+
Pole-0022,Pole,40.646484,-82.527557,#ACFEB6,Maintenance
24+
Meter-0023,Meter,39.29446,-82.645984,#A2CD13,Maintenance
25+
Transformer-0024,Transformer,39.191879,-80.977208,#D8D1A5,Retired
26+
Transformer-0025,Transformer,38.497429,-80.779003,#B3EF59,Retired
27+
Pole-0026,Pole,39.927018,-81.955837,#5D2830,Active
28+
Transformer-0027,Transformer,39.459577,-84.254492,#5A2FEC,Retired
29+
Pole-0028,Pole,40.663387,-83.463802,#262291,Maintenance
30+
Pole-0029,Pole,41.476512,-82.950813,#0CE4CC,Retired
31+
Transformer-0030,Transformer,41.524651,-84.380044,#907266,Retired
32+
Meter-0031,Meter,39.551712,-84.598028,#AC00A5,Active
33+
Pole-0032,Pole,41.704171,-80.820128,#5A3E44,Active
34+
Transformer-0033,Transformer,38.733824,-80.963196,#6EA237,Active
35+
Transformer-0034,Transformer,40.412346,-83.97299,#E9A1A0,Retired
36+
Meter-0035,Meter,39.366044,-84.121757,#7E3971,Maintenance
37+
Transformer-0036,Transformer,39.713363,-82.244173,#5AD322,Maintenance
38+
Meter-0037,Meter,41.526396,-80.613131,#ECFA79,Retired
39+
Meter-0038,Meter,39.242384,-83.454252,#0B6F92,Maintenance
40+
Pole-0039,Pole,39.847619,-82.359549,#E65B41,Active
41+
Pole-0040,Pole,40.78713,-84.187275,#96742A,Retired
42+
Transformer-0041,Transformer,38.535808,-81.609651,#42F39E,Active
43+
Meter-0042,Meter,39.828827,-84.630291,#C2335F,Retired
44+
Pole-0043,Pole,40.578651,-84.541086,#A83AAC,Retired
45+
Transformer-0044,Transformer,40.942935,-80.961598,#0D1F6A,Active
46+
Meter-0045,Meter,38.588986,-83.947926,#C75A64,Active
47+
Pole-0046,Pole,38.83638,-84.701179,#83A9B4,Maintenance
48+
Transformer-0047,Transformer,41.181622,-81.335054,#727F20,Active
49+
Transformer-0048,Transformer,39.225055,-81.132497,#DDA121,Active
50+
Transformer-0049,Transformer,39.488992,-82.11827,#960760,Retired
51+
Transformer-0050,Transformer,41.153307,-83.058342,#36A330,Retired
52+
Pole-0051,Pole,40.734009,-82.05389,#B47994,Active
53+
Meter-0052,Meter,41.910448,-84.260781,#BAC985,Active
54+
Transformer-0053,Transformer,40.508239,-83.758957,#840A3A,Maintenance
55+
Transformer-0054,Transformer,39.7624,-82.760736,#A127BA,Retired
56+
Transformer-0055,Transformer,38.491675,-82.820189,#34B46E,Maintenance
57+
Pole-0056,Pole,38.499905,-80.892234,#BE356A,Retired
58+
Pole-0057,Pole,39.834681,-84.118386,#C2229C,Active
59+
Meter-0058,Meter,40.332153,-81.240701,#03D469,Maintenance
60+
Meter-0059,Meter,38.478563,-83.286234,#2DF72E,Maintenance
61+
Pole-0060,Pole,40.915468,-81.403359,#B0FB46,Maintenance
62+
Meter-0061,Meter,40.302177,-82.714019,#AFDE51,Maintenance
63+
Transformer-0062,Transformer,38.85137,-83.603955,#E81779,Retired
64+
Meter-0063,Meter,39.284221,-84.799776,#F58207,Maintenance
65+
Pole-0064,Pole,39.868299,-83.378504,#EFF9E3,Retired
66+
Meter-0065,Meter,39.318836,-84.002635,#4E82B6,Maintenance
67+
Pole-0066,Pole,41.288419,-84.539445,#5BB118,Retired
68+
Pole-0067,Pole,40.376497,-82.92362,#F826C7,Retired
69+
Meter-0068,Meter,40.58126,-81.105749,#1769CC,Active
70+
Transformer-0069,Transformer,39.734816,-80.905523,#4CD2BD,Retired
71+
Pole-0070,Pole,40.855479,-82.915908,#F147E5,Retired
72+
Pole-0071,Pole,41.027567,-84.639068,#8D0BDE,Retired
73+
Meter-0072,Meter,40.201192,-81.441642,#9ACEAC,Retired
74+
Pole-0073,Pole,41.97671,-81.346366,#036508,Active
75+
Transformer-0074,Transformer,40.060595,-83.756997,#4374AE,Maintenance
76+
Pole-0075,Pole,39.590656,-80.574696,#94500C,Active
77+
Meter-0076,Meter,41.362999,-84.753712,#099794,Active
78+
Transformer-0077,Transformer,41.374375,-82.802844,#29DA72,Maintenance
79+
Meter-0078,Meter,40.632513,-84.413134,#4C082D,Active
80+
Transformer-0079,Transformer,41.881555,-83.355986,#A6A78B,Maintenance
81+
Transformer-0080,Transformer,39.021827,-84.483206,#C3336E,Retired
82+
Meter-0081,Meter,38.823598,-82.219093,#438062,Maintenance
83+
Pole-0082,Pole,38.884055,-84.618798,#364ED5,Retired
84+
Transformer-0083,Transformer,41.83313,-83.356387,#51393B,Active
85+
Pole-0084,Pole,40.787057,-84.550522,#CBA85F,Retired
86+
Meter-0085,Meter,40.40085,-82.044911,#066F96,Retired
87+
Meter-0086,Meter,41.625552,-80.868344,#AE306E,Active
88+
Pole-0087,Pole,39.794761,-80.526438,#DAD996,Retired
89+
Transformer-0088,Transformer,39.62341,-83.038475,#8B7262,Retired
90+
Transformer-0089,Transformer,39.655589,-83.524772,#1B8746,Active
91+
Pole-0090,Pole,39.930699,-84.315856,#DEA107,Active
92+
Meter-0091,Meter,41.080248,-81.591212,#C813E9,Maintenance
93+
Meter-0092,Meter,40.609849,-82.009104,#5539B9,Retired
94+
Transformer-0093,Transformer,40.377797,-80.560443,#DE0AA6,Active
95+
Transformer-0094,Transformer,38.877409,-82.605078,#E99B4C,Retired
96+
Pole-0095,Pole,38.680741,-81.505721,#842D49,Maintenance
97+
Transformer-0096,Transformer,39.870407,-81.540723,#B34D39,Retired
98+
Pole-0097,Pole,40.174571,-82.672643,#1C8A36,Active
99+
Pole-0098,Pole,38.443694,-80.619737,#B6609B,Maintenance
100+
Transformer-0099,Transformer,38.705085,-81.154314,#6AB786,Active
101+
Pole-0100,Pole,39.439457,-80.80989,#997219,Maintenance
102+
Transformer-0101,Transformer,40.020573,-84.0901,#2A297D,Retired
103+
Pole-0102,Pole,39.732568,-84.169861,#FCA777,Maintenance
104+
Transformer-0103,Transformer,39.087222,-83.549896,#947A45,Active
105+
Transformer-0104,Transformer,41.592097,-81.702183,#DC22BB,Maintenance
106+
Pole-0105,Pole,40.444922,-81.410956,#4DE8B3,Active
107+
Pole-0106,Pole,41.694853,-83.573823,#4E02C1,Active
108+
Pole-0107,Pole,38.663818,-82.658061,#061449,Active
109+
Transformer-0108,Transformer,39.630118,-81.705177,#E95710,Active
110+
Pole-0109,Pole,41.459634,-84.420926,#3164C9,Active
111+
Pole-0110,Pole,38.799517,-80.668222,#977A39,Retired
112+
Transformer-0111,Transformer,39.555715,-83.700614,#912E48,Retired
113+
Transformer-0112,Transformer,41.950305,-81.329888,#8B2A5F,Active
114+
Pole-0113,Pole,41.735767,-81.527707,#32AEC4,Maintenance
115+
Pole-0114,Pole,39.078811,-84.506997,#A4D269,Maintenance
116+
Pole-0115,Pole,38.772791,-84.5903,#92CFF1,Retired
117+
Pole-0116,Pole,41.239828,-84.599161,#714238,Retired
118+
Transformer-0117,Transformer,39.884869,-84.017431,#4827E4,Active
119+
Meter-0118,Meter,41.710747,-80.810385,#1A5696,Maintenance
120+
Transformer-0119,Transformer,38.997546,-83.999859,#8852C1,Maintenance
121+
Pole-0120,Pole,41.335592,-81.939944,#B478C0,Retired
122+
Transformer-0121,Transformer,38.670959,-83.732442,#78F907,Maintenance
123+
Transformer-0122,Transformer,40.064458,-80.776453,#4AA8B9,Active
124+
Meter-0123,Meter,40.881003,-84.352257,#469ACC,Maintenance
125+
Pole-0124,Pole,39.691768,-82.871814,#F568F7,Active
126+
Transformer-0125,Transformer,39.258718,-81.607513,#2FEDC0,Active
127+
Transformer-0126,Transformer,40.991314,-82.938882,#8A0939,Maintenance
128+
Meter-0127,Meter,38.829756,-82.088693,#D93A01,Maintenance
129+
Transformer-0128,Transformer,39.561298,-84.23286,#B0FFBF,Retired
130+
Pole-0129,Pole,41.310136,-80.977878,#DEDF7F,Maintenance
131+
Meter-0130,Meter,38.476997,-84.36577,#D376C1,Active
132+
Pole-0131,Pole,41.439634,-82.250321,#C877B3,Retired
133+
Pole-0132,Pole,40.053023,-82.343258,#FC6B74,Maintenance
134+
Transformer-0133,Transformer,40.307479,-80.595474,#250232,Active
135+
Transformer-0134,Transformer,40.269932,-81.851415,#2A5581,Retired
136+
Meter-0135,Meter,41.221783,-84.036996,#1DCB58,Maintenance
137+
Meter-0136,Meter,38.411364,-81.75948,#745640,Retired
138+
Meter-0137,Meter,38.477443,-84.793446,#001D09,Active
139+
Pole-0138,Pole,38.706145,-82.696423,#D7056A,Maintenance
140+
Transformer-0139,Transformer,39.986822,-81.272326,#C2FEF3,Maintenance
141+
Transformer-0140,Transformer,39.43983,-80.991494,#77A1B1,Active
142+
Pole-0141,Pole,39.423724,-82.757177,#D7ACCF,Retired
143+
Meter-0142,Meter,39.246284,-82.562801,#18C86C,Active
144+
Transformer-0143,Transformer,40.732666,-80.931576,#EE644E,Maintenance
145+
Transformer-0144,Transformer,40.444718,-80.789281,#DADFB9,Active
146+
Meter-0145,Meter,40.660586,-82.209004,#B8451C,Retired
147+
Pole-0146,Pole,41.479758,-83.09704,#45D282,Active
148+
Pole-0147,Pole,40.861986,-84.70095,#6ACDE6,Active
149+
Pole-0148,Pole,40.099707,-81.779475,#4901F8,Retired
150+
Transformer-0149,Transformer,40.750906,-81.11504,#78B4ED,Maintenance
151+
Meter-0150,Meter,39.87755,-80.563842,#762232,Maintenance
152+
Meter-0151,Meter,38.570679,-80.730134,#323C0B,Retired
153+
Pole-0152,Pole,41.693475,-81.200685,#14A3EC,Maintenance
154+
Transformer-0153,Transformer,38.64267,-81.564967,#C88580,Maintenance
155+
Transformer-0154,Transformer,41.534098,-80.809768,#46E9C0,Retired
156+
Meter-0155,Meter,40.887147,-83.093992,#AFCA2C,Active
157+
Pole-0156,Pole,39.303645,-80.631574,#CCE036,Active
158+
Transformer-0157,Transformer,39.952412,-80.959943,#DBDB54,Maintenance
159+
Meter-0158,Meter,38.464101,-82.574481,#190F78,Retired
160+
Meter-0159,Meter,39.536016,-82.089753,#ED234C,Retired
161+
Pole-0160,Pole,38.47531,-84.243858,#D92B08,Retired
162+
Pole-0161,Pole,41.873551,-81.759175,#54D2D3,Retired
163+
Pole-0162,Pole,40.854072,-80.851823,#FF7464,Active
164+
Pole-0163,Pole,38.567007,-83.164294,#79AA21,Maintenance
165+
Transformer-0164,Transformer,39.171176,-84.392172,#5359D0,Active
166+
Pole-0165,Pole,38.76816,-84.037526,#DA07C1,Maintenance
167+
Meter-0166,Meter,40.418402,-80.942086,#64E435,Maintenance
168+
Meter-0167,Meter,41.415187,-80.735386,#174F36,Maintenance
169+
Pole-0168,Pole,38.56445,-81.596694,#B68927,Maintenance
170+
Transformer-0169,Transformer,38.981591,-81.671346,#BDE3BE,Active
171+
Pole-0170,Pole,41.583455,-82.256774,#FDE564,Active
172+
Meter-0171,Meter,39.732482,-82.921276,#AC264D,Maintenance
173+
Pole-0172,Pole,38.957552,-82.67184,#2281C7,Active
174+
Pole-0173,Pole,41.213544,-84.123606,#782CFF,Maintenance
175+
Pole-0174,Pole,41.295025,-84.153248,#E1CE2F,Maintenance
176+
Transformer-0175,Transformer,40.100808,-82.10206,#FB5FDB,Active
177+
Meter-0176,Meter,40.887274,-84.366709,#4C7617,Maintenance
178+
Meter-0177,Meter,41.906657,-82.339371,#9CB47C,Retired
179+
Transformer-0178,Transformer,40.513393,-84.03012,#E69D00,Maintenance
180+
Meter-0179,Meter,41.092745,-81.191928,#77E829,Retired
181+
Meter-0180,Meter,39.932002,-81.781511,#F0B67E,Maintenance
182+
Transformer-0181,Transformer,40.257431,-82.783741,#BB6E91,Maintenance
183+
Meter-0182,Meter,38.694715,-83.131299,#238D7D,Retired
184+
Pole-0183,Pole,40.657816,-83.188837,#9B1234,Active
185+
Pole-0184,Pole,39.294408,-81.302653,#F6199E,Maintenance
186+
Transformer-0185,Transformer,38.401472,-84.386541,#0D415E,Active
187+
Meter-0186,Meter,39.80338,-83.027602,#297806,Maintenance
188+
Meter-0187,Meter,39.576579,-84.187374,#109704,Maintenance
189+
Pole-0188,Pole,41.189369,-83.418141,#3EC7A0,Maintenance
190+
Transformer-0189,Transformer,39.267255,-80.996003,#423211,Retired
191+
Transformer-0190,Transformer,38.917113,-83.544842,#74B186,Active
192+
Transformer-0191,Transformer,41.357593,-80.813804,#209442,Retired
193+
Meter-0192,Meter,41.696085,-81.053138,#FB1C89,Active
194+
Transformer-0193,Transformer,41.863704,-82.875605,#FA72D4,Active
195+
Meter-0194,Meter,39.202749,-83.874081,#9FD7A9,Maintenance
196+
Pole-0195,Pole,38.568715,-83.122786,#0F157F,Active
197+
Pole-0196,Pole,41.835565,-81.444498,#3A30AA,Retired
198+
Pole-0197,Pole,38.838622,-83.029612,#6E461B,Maintenance
199+
Pole-0198,Pole,40.049948,-83.139035,#EE9820,Active
200+
Transformer-0199,Transformer,40.821065,-81.32448,#5927B3,Maintenance
201+
Meter-0200,Meter,39.03264,-84.289776,#264D36,Retired
202+
Meter-0201,Meter,38.772486,-82.085127,#4A3376,Maintenance
203+
Transformer-0202,Transformer,41.493058,-84.561897,#E12DD6,Active
204+
Meter-0203,Meter,38.629545,-82.514258,#58EDEA,Active
205+
Transformer-0204,Transformer,41.01924,-83.780468,#838737,Maintenance
206+
Transformer-0205,Transformer,41.865045,-83.917951,#7BE61A,Active
207+
Transformer-0206,Transformer,40.793239,-81.177464,#D21407,Active
208+
Transformer-0207,Transformer,40.004218,-81.778659,#383298,Active
209+
Transformer-0208,Transformer,39.132143,-82.416461,#462A74,Maintenance
210+
Meter-0209,Meter,39.024189,-80.705138,#A0E191,Retired
211+
Transformer-0210,Transformer,40.788594,-84.38801,#527FEB,Active
212+
Pole-0211,Pole,41.082813,-81.640013,#DA9A51,Active
213+
Meter-0212,Meter,39.361808,-81.370686,#E495C6,Maintenance
214+
Meter-0213,Meter,39.655578,-82.147889,#036B46,Retired
215+
Transformer-0214,Transformer,39.294736,-81.155645,#76DEAA,Retired
216+
Transformer-0215,Transformer,41.236906,-80.575173,#4AC159,Active
217+
Transformer-0216,Transformer,39.326328,-82.120899,#3DD543,Active
218+
Transformer-0217,Transformer,39.964427,-80.86862,#24166A,Active
219+
Transformer-0218,Transformer,41.813159,-83.493623,#C46F66,Retired
220+
Pole-0219,Pole,40.788497,-82.514424,#565CB2,Maintenance
221+
Pole-0220,Pole,38.871946,-84.404504,#5A887E,Retired
222+
Pole-0221,Pole,40.359912,-80.824645,#9E62C7,Active
223+
Pole-0222,Pole,38.852297,-83.195017,#AFF1D7,Active
224+
Transformer-0223,Transformer,40.667467,-84.026095,#E3D4D7,Retired
225+
Transformer-0224,Transformer,39.640107,-84.785906,#B203B6,Active
226+
Pole-0225,Pole,41.776235,-81.07357,#4BEDB6,Retired
227+
Pole-0226,Pole,40.328443,-81.373295,#FE8CB1,Active
228+
Transformer-0227,Transformer,40.776514,-83.551347,#CE8CD2,Active
229+
Transformer-0228,Transformer,40.149025,-81.841441,#2607FC,Retired
230+
Transformer-0229,Transformer,39.933929,-83.680324,#8CEF48,Maintenance
231+
Pole-0230,Pole,39.970768,-81.258322,#7EE29E,Maintenance
232+
Pole-0231,Pole,41.460708,-81.498237,#E67A16,Active
233+
Pole-0232,Pole,41.637134,-84.022409,#FF3AC9,Retired
234+
Pole-0233,Pole,40.336162,-80.573301,#05B44D,Maintenance
235+
Transformer-0234,Transformer,40.861775,-84.096572,#30CDBA,Maintenance
236+
Meter-0235,Meter,40.595673,-81.198488,#0D8CAE,Active
237+
Meter-0236,Meter,41.751789,-83.927716,#81F706,Maintenance
238+
Meter-0237,Meter,39.599198,-83.806177,#0A4140,Retired
239+
Transformer-0238,Transformer,40.841475,-84.636184,#46DBC7,Retired
240+
Meter-0239,Meter,40.566503,-83.41496,#D18D41,Maintenance
241+
Pole-0240,Pole,38.792944,-81.270339,#6FFFB4,Retired
242+
Transformer-0241,Transformer,39.081349,-82.252683,#40726A,Active
243+
Meter-0242,Meter,41.880171,-81.576209,#0D02BD,Retired
244+
Meter-0243,Meter,40.297782,-83.48718,#003195,Retired
245+
Transformer-0244,Transformer,38.598645,-82.673085,#DA839F,Maintenance
246+
Transformer-0245,Transformer,41.728453,-82.692843,#7C8AB8,Retired
247+
Transformer-0246,Transformer,41.65112,-82.773184,#A18E43,Maintenance
248+
Pole-0247,Pole,41.735234,-81.823102,#E8362B,Maintenance
249+
Meter-0248,Meter,39.438052,-83.702679,#CC6DDC,Maintenance
250+
Meter-0249,Meter,39.620336,-84.523298,#27E029,Active
251+
Meter-0250,Meter,39.444785,-83.852897,#A573C0,Maintenance

0 commit comments

Comments
 (0)