Heatmap Troubleshooting

Heatmaps that Work

Model - Head

http://localhost:5212/api/HeatMap/node/csv?currentTime=1391485200&attribute=Head&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%5D

NodeHydrId,Head,Demand,Pressure,XCoord,YCoord
T-1,745.0608416521707,66.39582753517377,42.86673368788556,-85.6173252,38.0272756
T-2,764.8748999999999,0,36.52718999999998,-85.5703734,38.0344664
T-3,802.99998,0,38.455799634000016,-85.5438611,38.0519223
T-4,795.0000200000001,0,30.899151626000023,-85.5154309,38.0545221
I-Pump-1,489.86550000000227,0,6.4548267700009925,-85.5502666,38.075216
I-Pump-2,489.74895540274866,0,6.5776046660110055,-85.5493335,38.0757335
J-1,746.437953933629,2.23851,58.51640842944149,-85.5760438,38.0490411
J-10,744.5703071483196,1.47436,86.07626133736686,-85.644547,38.0193252

min	max	avg	p25	median	p75	p90	p95	count
489.72	829.43	766.02	745.98	769.27	784.55	796.79	802.24	1208077

[HEAD]: [0, 0.2, 0.7, 0.995, 1],

[HEAD]: { radius: 100, minWeight: 0, maxWeight: 1500, maxDensity: 0.75, minDensity: 0.1 },

Model - Demand

http://localhost:5212/api/HeatMap/node/csv?currentTime=1391485200&attribute=Demand&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%5D

NodeHydrId,Head,Demand,Pressure,XCoord,YCoord
T-1,745.0608416521707,66.39582753517377,42.86673368788556,-85.6173252,38.0272756
T-2,764.8748999999999,0,36.52718999999998,-85.5703734,38.0344664
T-3,802.99998,0,38.455799634000016,-85.5438611,38.0519223
T-4,795.0000200000001,0,30.899151626000023,-85.5154309,38.0545221
I-Pump-1,489.86550000000227,0,6.4548267700009925,-85.5502666,38.075216
I-Pump-2,489.74895540274866,0,6.5776046660110055,-85.5493335,38.0757335
J-1,746.437953933629,2.23851,58.51640842944149,-85.5760438,38.0490411
J-10,744.5703071483196,1.47436,86.07626133736686,-85.644547,38.0193252

min	max	avg	p25	median	p75	p90	p95	count
-1382	1423	2.659e-07	0.225	0.607	1.331	2.52	3.63	1208077

[DEMAND]: [0, 0.001, 0.02, 0.1, 1],

[DEMAND]: { radius: 100, minWeight: 0, maxWeight: 1500, maxDensity: 0.1, minDensity: 0 },

Model - Pressure

http://localhost:5212/api/HeatMap/node/csv?currentTime=1391485200&attribute=Pressure&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%5D

NodeHydrId,Head,Demand,Pressure,XCoord,YCoord
T-1,745.0608416521707,66.39582753517377,42.86673368788556,-85.6173252,38.0272756
T-2,764.8748999999999,0,36.52718999999998,-85.5703734,38.0344664
T-3,802.99998,0,38.455799634000016,-85.5438611,38.0519223
T-4,795.0000200000001,0,30.899151626000023,-85.5154309,38.0545221
I-Pump-1,489.86550000000227,0,6.4548267700009925,-85.5502666,38.075216
I-Pump-2,489.74895540274866,0,6.5776046660110055,-85.5493335,38.0757335
J-1,746.437953933629,2.23851,58.51640842944149,-85.5760438,38.0490411
J-10,744.5703071483196,1.47436,86.07626133736686,-85.644547,38.0193252

min	max	avg	p25	median	p75	p90	p95	count
0	153.76	52.74	38.26	49.49	63.92	83.61	93.91	1208077

[PRESSURE]: [0, 0.075, 0.6, 0.9, 1],

[PRESSURE]: { radius: 100, minWeight: 0, maxWeight: 1500, maxDensity: 0.1, minDensity: 0 },

Model - Flow

http://localhost:5212/api/HeatMap/link/csv?currentTime=1391485200&attribute=Flow&scenarioId=1&entityTypes=%5B%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

LinkId,Flow,Headloss,Power,XCoord,YCoord
P-1,27.742376484735345,0.1310301009422119,0,-85.57336515,38.04826815
P-10,24.95388453970356,0.0018704917682725863,0,-85.55613485,38.0668882
P-100,0.3685900018132406,1.6644921288389014E-05,0,-85.64499775,38.01895345

min	max	avg	p25	median	p75	p90	p95	count
-1486	1432	-16.55	-8.617	0.129	5.557	31.202	61.177	1429579

[FLOW]: [0, 0.001, 0.3, 0.4, 1],

[FLOW]: { radius: 100, minWeight: 0, maxWeight: 1500, maxDensity: 0.1, minDensity: 0 },

Model - Headloss

http://localhost:5212/api/HeatMap/link/csv?currentTime=1391485200&attribute=Headloss&scenarioId=1&entityTypes=%5B%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

LinkId,Flow,Headloss,Power,XCoord,YCoord
P-1,27.742376484735345,0.1310301009422119,0,-85.57336515,38.04826815
P-10,24.95388453970356,0.0018704917682725863,0,-85.55613485,38.0668882
P-100,0.3685900018132406,1.6644921288389014E-05,0,-85.64499775,38.01895345

min	max	avg	p25	median	p75	p90	p95	count
-339.608	23.528	-0.152	2.612e-05	0.0021	0.03526	0.1988	0.5136	1429579

[HEADLOSS]: [0, 0.01, 0.02, 0.04, 1],

[HEADLOSS]: { radius: 100, minWeight: 0, maxWeight: 1500, maxDensity: 0.1, minDensity: 0 },

Model - Chlorine

http://localhost:5212/api/HeatMap/quality/csv?currentTime=1391485200&attribute=Chlorine&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%2C%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

EntityId,EntityType,Chlorine,XCoord,YCoord
I-Pump-1,Junction,0.55,-85.550267,38.075216
I-Pump-2,Junction,0.6,-85.549334,38.075734
J-1,Junction,0.55,-85.576044,38.049041

min	max	avg	p25	median	p75	p90	p95	count
0.507217	1.197	0.5565	0.53129	0.55667	0.5829	0.5934	0.5967	2,637,656

[CHLORINE]: [0, 0.56, 0.57, 0.58, 0.59],

[CHLORINE]: { radius: 50, minWeight: 0, maxWeight: 1500, maxDensity: 0.005, minDensity: 0.0005 },

Model - TR1

http://localhost:5212/api/HeatMap/quality/csv?currentTime=1391485200&attribute=TR1&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%2C%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

EntityId,EntityType,TR1,XCoord,YCoord
I-Pump-1,Junction,1,-85.550267,38.075216
I-Pump-2,Junction,1,-85.549334,38.075734
J-1,Junction,1,-85.576044,38.049041

min	max	avg	p25	median	p75	p90	p95	count
0.9999999999999961	1.0000000000000036	1	1	1	1	1	1	2,637,656

Heatmaps that do NOT Work

Model - Level

http://localhost:5212/api/HeatMap/node/csv?currentTime=1391485200&attribute=Level&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%5D

Level doesn't exist in the CSV!

Model - TankVolume

http://localhost:5212/api/HeatMap/node/csv?currentTime=1391485200&attribute=TankVolume&scenarioId=1&entityTypes=%5B%22Tank%22%5D

TankVolume doesn't exist in the CSV!

Model - Status

http://localhost:5212/api/HeatMap/link/csv?currentTime=1391485200&attribute=Status&scenarioId=1&entityTypes=%5B%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

Status doesn't exist in the CSV!

Model - Power

http://localhost:5212/api/HeatMap/link/csv?currentTime=1391485200&attribute=Power&scenarioId=1&entityTypes=%5B%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

LinkId,Flow,Headloss,Power,XCoord,YCoord
P-1,27.742376484735345,0.1310301009422119,0,-85.57336515,38.04826815
P-10,24.95388453970356,0.0018704917682725863,0,-85.55613485,38.0668882
P-100,0.3685900018132406,1.6644921288389014E-05,0,-85.64499775,38.01895345

min	max	avg	p25	median	p75	p90	p95	count
0	0	0	0	0	0	0	0	1429579

Model - Velocity

http://localhost:5212/api/HeatMap/link/csv?currentTime=1391485200&attribute=Velocity&scenarioId=1&entityTypes=%5B%22Valve%22%5D

Velocity doesn't exist in the CSV!

Model - Setting

NA - no entity types... Query never runs.

Model - Conductivity

http://localhost:5212/api/HeatMap/quality/csv?currentTime=1391485200&attribute=Conductivity&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%2C%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

EntityId,EntityType,Conductivity,XCoord,YCoord
I-Pump-1,Junction,200,-85.550267,38.075216
I-Pump-2,Junction,200,-85.549334,38.075734
J-1,Junction,200,-85.576044,38.049041

min	max	avg	p25	median	p75	p90	p95	count
199.99999	275	200.12556	200	200	200	200	200	2,637,656

Model - Age

http://localhost:5212/api/HeatMap/quality/csv?currentTime=1391485200&attribute=Age&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%2C%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

EntityId,EntityType,Age,XCoord,YCoord
I-Pump-1,Junction,22.75,-85.550267,38.075216
I-Pump-2,Junction,0.06,-85.549334,38.075734
J-1,Junction,22.75,-85.576044,38.049041

min	max	avg	p25	median	p75	p90	p95	count
0	119.999	22.3439	8.333	21.5	34.87888	42.91666	45.666	2,637,656

[AGE]: [0.0, 8.3333, 21.5, 34.8789, 120.0],

[AGE]: {radius: 50, minWeight: 0, maxWeight: 120, minDensity: 0.001, maxDensity: 0.01},

Model - THM

http://localhost:5212/api/HeatMap/quality/csv?currentTime=1391485200&attribute=THM&scenarioId=1&entityTypes=%5B%22Tank%22%2C%22Junction%22%2C%22Reservoir%22%2C%22Pipe%22%2C%22Pump%22%2C%22Valve%22%5D

EntityId,EntityType,THM,XCoord,YCoord
I-Pump-1,Junction,70.49,-85.550267,38.075216
I-Pump-2,Junction,65.02,-85.549334,38.075734
J-1,Junction,70.49,-85.576044,38.049041

min	max	avg	p25	median	p75	p90	p95	count
65	75.581	70.176	67.1205	70.1936	73.03	74.6007	75.1036	2,637,656

[THM]: [65.0, 67.1205, 70.1936, 73.0301, 75.5813],

[THM]: {radius: 40, minWeight: 65, maxWeight: 76, minDensity: 0.001, maxDensity: 0.01 }

Heatmap Troubleshooting

Heatmaps that Work​

Model - Head​

Model - Demand​

Model - Pressure​

Model - Flow​

Model - Headloss​

Model - Chlorine​

Model - TR1​

Heatmaps that do NOT Work​

Model - Level​

Model - TankVolume​

Model - Status​

Model - Power​

Model - Velocity​

Model - Setting​

Model - Conductivity​

Model - Age​

Model - THM​