/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
/*
* Description  : Check Whether a Channel works after adding a new Index
* Expected Res : Success
* Date         : Apr 2018
* Author       : channels Jacobs
*/

use channels;

subscribe to EmergencyChannel("w2294u1") on brokerA;
subscribe to EmergencyChannel("t4321u1") on brokerA;
subscribe to EmergencyChannel("t3398u1") on brokerA;
subscribe to EmergencyChannel("w2488u1") on brokerA;
subscribe to EmergencyChannel("t3666u1") on brokerA;
subscribe to EmergencyChannel("t4489u1") on brokerA;
subscribe to EmergencyChannel("p78u1") on brokerA;
subscribe to EmergencyChannel("p544u1") on brokerA;
subscribe to EmergencyChannel("p711u1") on brokerA;
subscribe to EmergencyChannel("t2828u1") on brokerA;
subscribe to EmergencyChannel("t4796u1") on brokerA;
subscribe to EmergencyChannel("t4082u1") on brokerA;
subscribe to EmergencyChannel("t4923u1") on brokerA;
subscribe to EmergencyChannel("w2324u1") on brokerA;
subscribe to EmergencyChannel("c1339u1") on brokerA;
subscribe to EmergencyChannel("p520u1") on brokerA;
subscribe to EmergencyChannel("c1092u1") on brokerA;
subscribe to EmergencyChannel("t4979u1") on brokerA;
subscribe to EmergencyChannel("c1487u1") on brokerA;
subscribe to EmergencyChannel("t4330u1") on brokerA;
subscribe to EmergencyChannel("t3682u1") on brokerA;
subscribe to EmergencyChannel("p117u1") on brokerA;
subscribe to EmergencyChannel("w1741u1") on brokerA;
subscribe to EmergencyChannel("w2434u1") on brokerA;
subscribe to EmergencyChannel("t3833u1") on brokerA;
subscribe to EmergencyChannel("c1373u1") on brokerA;
subscribe to EmergencyChannel("p89u1") on brokerA;
subscribe to EmergencyChannel("t4003u1") on brokerA;
subscribe to EmergencyChannel("c910u1") on brokerA;
subscribe to EmergencyChannel("t4961u1") on brokerA;
subscribe to EmergencyChannel("t4475u1") on brokerA;
subscribe to EmergencyChannel("w1960u1") on brokerA;
subscribe to EmergencyChannel("p438u1") on brokerA;
subscribe to EmergencyChannel("c1362u1") on brokerA;
subscribe to EmergencyChannel("p588u1") on brokerA;
subscribe to EmergencyChannel("c902u1") on brokerA;
subscribe to EmergencyChannel("t4684u1") on brokerA;
subscribe to EmergencyChannel("c1609u1") on brokerA;
subscribe to EmergencyChannel("c1510u1") on brokerA;
subscribe to EmergencyChannel("t3851u1") on brokerA;
subscribe to EmergencyChannel("c1418u1") on brokerA;
subscribe to EmergencyChannel("t2559u1") on brokerA;
subscribe to EmergencyChannel("w1815u1") on brokerA;
subscribe to EmergencyChannel("t4924u1") on brokerA;
subscribe to EmergencyChannel("t3320u1") on brokerA;
subscribe to EmergencyChannel("p663u1") on brokerA;
subscribe to EmergencyChannel("t4571u1") on brokerA;
subscribe to EmergencyChannel("p781u1") on brokerA;
subscribe to EmergencyChannel("c919u1") on brokerA;
subscribe to EmergencyChannel("c1121u1") on brokerA;
subscribe to EmergencyChannel("p814u1") on brokerA;
subscribe to EmergencyChannel("t4006u1") on brokerA;
subscribe to EmergencyChannel("t2822u1") on brokerA;
subscribe to EmergencyChannel("t4953u1") on brokerA;
subscribe to EmergencyChannel("t3486u1") on brokerA;
subscribe to EmergencyChannel("t3107u1") on brokerA;
subscribe to EmergencyChannel("t2836u1") on brokerA;
subscribe to EmergencyChannel("w2003u1") on brokerA;
subscribe to EmergencyChannel("t3256u1") on brokerA;
subscribe to EmergencyChannel("t4762u1") on brokerA;
subscribe to EmergencyChannel("t4900u1") on brokerA;
subscribe to EmergencyChannel("p357u1") on brokerA;
subscribe to EmergencyChannel("t3630u1") on brokerA;
subscribe to EmergencyChannel("t3166u1") on brokerA;
subscribe to EmergencyChannel("t4687u1") on brokerA;
subscribe to EmergencyChannel("p817u1") on brokerA;
subscribe to EmergencyChannel("t4433u1") on brokerA;
subscribe to EmergencyChannel("t3426u1") on brokerA;
subscribe to EmergencyChannel("p582u1") on brokerA;
subscribe to EmergencyChannel("t3388u1") on brokerA;
subscribe to EmergencyChannel("t4823u1") on brokerA;
subscribe to EmergencyChannel("c1664u1") on brokerA;
subscribe to EmergencyChannel("t4051u1") on brokerA;
subscribe to EmergencyChannel("c857u1") on brokerA;
subscribe to EmergencyChannel("c1412u1") on brokerA;
subscribe to EmergencyChannel("t2521u1") on brokerA;
subscribe to EmergencyChannel("t3114u1") on brokerA;
subscribe to EmergencyChannel("p404u1") on brokerA;
subscribe to EmergencyChannel("p111u1") on brokerA;
subscribe to EmergencyChannel("t3006u1") on brokerA;
subscribe to EmergencyChannel("t2903u1") on brokerA;
subscribe to EmergencyChannel("t2823u1") on brokerA;
subscribe to EmergencyChannel("t4153u1") on brokerA;
subscribe to EmergencyChannel("t2589u1") on brokerA;
subscribe to EmergencyChannel("c1459u1") on brokerA;
subscribe to EmergencyChannel("p766u1") on brokerA;
subscribe to EmergencyChannel("p593u1") on brokerA;
subscribe to EmergencyChannel("p168u1") on brokerA;
subscribe to EmergencyChannel("t4253u1") on brokerA;
subscribe to EmergencyChannel("t4177u1") on brokerA;
subscribe to EmergencyChannel("p387u1") on brokerA;
subscribe to EmergencyChannel("t2571u1") on brokerA;
subscribe to EmergencyChannel("c1513u1") on brokerA;
subscribe to EmergencyChannel("p618u1") on brokerA;
subscribe to EmergencyChannel("t2735u1") on brokerA;
subscribe to EmergencyChannel("t4859u1") on brokerA;
subscribe to EmergencyChannel("w1848u1") on brokerA;
subscribe to EmergencyChannel("t3306u1") on brokerA;
subscribe to EmergencyChannel("t2558u1") on brokerA;
subscribe to EmergencyChannel("p180u1") on brokerA;

insert into Shelters (
[
{"shelterName" : "s5064" , "location" : point("2437.34,1330.59") },
{"shelterName" : "s5180" , "location" : point("2479.66,939.05") },
{"shelterName" : "s5025" , "location" : point("3343.08,1139.29") },
{"shelterName" : "s5218" , "location" : point("1361.85,795.99") },
{"shelterName" : "s5199" , "location" : point("3619.88,1245.75") },
{"shelterName" : "s5167" , "location" : point("2836.86,237.96") },
{"shelterName" : "s5068" , "location" : point("2580.27,881.71") },
{"shelterName" : "s5026" , "location" : point("2040.75,816.3") },
{"shelterName" : "s5080" , "location" : point("2785.14,1090.68") },
{"shelterName" : "s5190" , "location" : point("1296.09,1256.87") },
{"shelterName" : "s5126" , "location" : point("1121.37,1478.3") },
{"shelterName" : "s5075" , "location" : point("2679.51,488.23") },
{"shelterName" : "s5187" , "location" : point("2544.14,2464.15") },
{"shelterName" : "s5061" , "location" : point("1674.35,1265.46") },
{"shelterName" : "s5057" , "location" : point("1677.96,1151.83") },
{"shelterName" : "s5149" , "location" : point("2236.78,1068.51") },
{"shelterName" : "s5058" , "location" : point("2919.37,2055.98") },
{"shelterName" : "s5144" , "location" : point("731.17,1504.74") },
{"shelterName" : "s5099" , "location" : point("2594.22,1078.11") },
{"shelterName" : "s5030" , "location" : point("3678.46,978.38") },
{"shelterName" : "s5050" , "location" : point("2395.61,1332.9") },
{"shelterName" : "s5209" , "location" : point("3093.56,1833.18") },
{"shelterName" : "s5052" , "location" : point("3052.36,1076.89") },
{"shelterName" : "s5208" , "location" : point("1513.18,796.41") },
{"shelterName" : "s5027" , "location" : point("671.97,2004.72") },
{"shelterName" : "s5093" , "location" : point("2297.68,1933.79") },
{"shelterName" : "s5202" , "location" : point("2854.73,1153.14") },
{"shelterName" : "s5106" , "location" : point("1971.88,737.51") },
{"shelterName" : "s5192" , "location" : point("2638.68,1688.7") },
{"shelterName" : "s5128" , "location" : point("1970.48,2569.09") },
{"shelterName" : "s5098" , "location" : point("2596.02,1499.58") },
{"shelterName" : "s5038" , "location" : point("2297.07,995.53") },
{"shelterName" : "s5176" , "location" : point("1570.34,1701.0") },
{"shelterName" : "s5066" , "location" : point("820.41,2092.07") },
{"shelterName" : "s5108" , "location" : point("459.09,395.34") },
{"shelterName" : "s5162" , "location" : point("2543.99,1822.57") },
{"shelterName" : "s5195" , "location" : point("3190.14,979.74") },
{"shelterName" : "s5212" , "location" : point("2478.36,921.15") },
{"shelterName" : "s5217" , "location" : point("2411.71,807.77") },
{"shelterName" : "s5049" , "location" : point("447.77,1527.37") },
{"shelterName" : "s5163" , "location" : point("2356.91,1221.63") },
{"shelterName" : "s5048" , "location" : point("1495.47,1597.15") },
{"shelterName" : "s5154" , "location" : point("1503.31,884.66") },
{"shelterName" : "s5116" , "location" : point("1359.98,314.68") },
{"shelterName" : "s5143" , "location" : point("3000.77,1080.81") },
{"shelterName" : "s5073" , "location" : point("2404.16,1516.85") },
{"shelterName" : "s5032" , "location" : point("2370.75,1879.99") },
{"shelterName" : "s5152" , "location" : point("1091.19,706.09") },
{"shelterName" : "s5044" , "location" : point("2395.55,1378.92") },
{"shelterName" : "s5081" , "location" : point("2057.88,838.33") },
{"shelterName" : "s5130" , "location" : point("1511.27,1082.85") },
{"shelterName" : "s5142" , "location" : point("2634.22,1631.85") },
{"shelterName" : "s5071" , "location" : point("1799.13,2130.04") },
{"shelterName" : "s5051" , "location" : point("2414.52,807.3") },
{"shelterName" : "s5147" , "location" : point("1960.71,976.11") },
{"shelterName" : "s5021" , "location" : point("2659.55,1957.04") },
{"shelterName" : "s5139" , "location" : point("1863.26,1216.29") },
{"shelterName" : "s5062" , "location" : point("937.48,1608.88") },
{"shelterName" : "s5168" , "location" : point("2245.27,1012.57") },
{"shelterName" : "s5196" , "location" : point("2341.23,1883.0") },
{"shelterName" : "s5119" , "location" : point("1702.71,2557.47") },
{"shelterName" : "s5150" , "location" : point("1613.07,1804.66") },
{"shelterName" : "s5171" , "location" : point("2789.6,931.73") },
{"shelterName" : "s5102" , "location" : point("3483.61,1156.18") },
{"shelterName" : "s5091" , "location" : point("1081.51,1596.95") },
{"shelterName" : "s5132" , "location" : point("2099.11,1086.28") },
{"shelterName" : "s5104" , "location" : point("2896.78,461.73") },
{"shelterName" : "s5022" , "location" : point("1920.77,1657.89") },
{"shelterName" : "s5219" , "location" : point("2913.07,954.89") },
{"shelterName" : "s5088" , "location" : point("1831.54,2241.22") },
{"shelterName" : "s5166" , "location" : point("1087.15,2048.13") },
{"shelterName" : "s5203" , "location" : point("2543.5,1815.38") },
{"shelterName" : "s5136" , "location" : point("2503.29,1270.07") },
{"shelterName" : "s5194" , "location" : point("1595.1,1634.0") },
{"shelterName" : "s5060" , "location" : point("2230.74,818.1") },
{"shelterName" : "s5127" , "location" : point("2567.07,1104.86") },
{"shelterName" : "s5092" , "location" : point("1732.18,1170.23") },
{"shelterName" : "s5124" , "location" : point("2456.58,983.76") },
{"shelterName" : "s5201" , "location" : point("1875.2,1300.76") },
{"shelterName" : "s5029" , "location" : point("2581.92,690.14") },
{"shelterName" : "s5146" , "location" : point("2437.06,2491.18") },
{"shelterName" : "s5074" , "location" : point("1761.92,2035.44") },
{"shelterName" : "s5173" , "location" : point("1000.01,1488.16") },
{"shelterName" : "s5039" , "location" : point("2604.75,630.95") },
{"shelterName" : "s5020" , "location" : point("1920.62,670.07") },
{"shelterName" : "s5120" , "location" : point("1562.27,1045.02") },
{"shelterName" : "s5083" , "location" : point("964.22,1606.66") },
{"shelterName" : "s5122" , "location" : point("2253.13,1556.55") },
{"shelterName" : "s5103" , "location" : point("2023.99,2505.02") },
{"shelterName" : "s5155" , "location" : point("2996.58,390.66") },
{"shelterName" : "s5076" , "location" : point("1025.57,515.66") },
{"shelterName" : "s5086" , "location" : point("2384.13,886.5") },
{"shelterName" : "s5053" , "location" : point("1173.98,2173.29") },
{"shelterName" : "s5216" , "location" : point("2865.64,1182.0") },
{"shelterName" : "s5065" , "location" : point("2633.42,574.61") },
{"shelterName" : "s5055" , "location" : point("1236.87,876.11") },
{"shelterName" : "s5215" , "location" : point("2272.8,1115.83") },
{"shelterName" : "s5210" , "location" : point("1314.22,729.82") },
{"shelterName" : "s5200" , "location" : point("1776.8,1176.29") },
{"shelterName" : "s5165" , "location" : point("3485.44,980.34") },
{"shelterName" : "s5042" , "location" : point("1812.4,1252.84") }
]
);

insert into UserLocations (
[
{"userName" : "w2294u1" , "location" : circle("2683.3,480.84 100.0")},
{"userName" : "t4321u1" , "location" : circle("1990.77,754.24 100.0")},
{"userName" : "t3398u1" , "location" : circle("2791.2,962.92 100.0")},
{"userName" : "w2488u1" , "location" : circle("2040.19,767.35 100.0")},
{"userName" : "t3666u1" , "location" : circle("3968.68,1308.04 100.0")},
{"userName" : "t4489u1" , "location" : circle("1713.82,252.6 100.0")},
{"userName" : "p78u1" , "location" : circle("2588.34,735.72 100.0")},
{"userName" : "p544u1" , "location" : circle("1993.69,1465.29 100.0")},
{"userName" : "p711u1" , "location" : circle("3221.64,1062.22 100.0")},
{"userName" : "t2828u1" , "location" : circle("2534.49,978.95 100.0")},
{"userName" : "t4796u1" , "location" : circle("1752.58,323.55 100.0")},
{"userName" : "t4082u1" , "location" : circle("3571.17,1213.78 100.0")},
{"userName" : "t4923u1" , "location" : circle("1878.19,587.26 100.0")},
{"userName" : "w2324u1" , "location" : circle("2851.94,1429.02 100.0")},
{"userName" : "c1339u1" , "location" : circle("2881.61,956.95 100.0")},
{"userName" : "p520u1" , "location" : circle("2927.9,986.41 100.0")},
{"userName" : "c1092u1" , "location" : circle("1670.02,1019.43 100.0")},
{"userName" : "t4979u1" , "location" : circle("1856.46,543.47 100.0")},
{"userName" : "c1487u1" , "location" : circle("1757.21,745.68 100.0")},
{"userName" : "t4330u1" , "location" : circle("1596.34,59.37 100.0")},
{"userName" : "t3682u1" , "location" : circle("3557.22,1204.63 100.0")},
{"userName" : "p117u1" , "location" : circle("1717.46,1166.14 100.0")},
{"userName" : "w1741u1" , "location" : circle("2517.33,980.01 100.0")},
{"userName" : "w2434u1" , "location" : circle("527.29,1520.52 100.0")},
{"userName" : "t3833u1" , "location" : circle("3521.17,1180.97 100.0")},
{"userName" : "c1373u1" , "location" : circle("1733.98,742.36 100.0")},
{"userName" : "p89u1" , "location" : circle("3768.73,1013.03 100.0")},
{"userName" : "t4003u1" , "location" : circle("2945.36,952.79 100.0")},
{"userName" : "c910u1" , "location" : circle("1124.86,1275.91 100.0")},
{"userName" : "t4961u1" , "location" : circle("1575.25,0.0 100.0")},
{"userName" : "t4475u1" , "location" : circle("1607.59,79.94 100.0")},
{"userName" : "w1960u1" , "location" : circle("1768.23,2263.45 100.0")},
{"userName" : "p438u1" , "location" : circle("898.13,238.92 100.0")},
{"userName" : "c1362u1" , "location" : circle("1438.64,400.67 100.0")},
{"userName" : "p588u1" , "location" : circle("3206.01,1052.3 100.0")},
{"userName" : "c902u1" , "location" : circle("1615.16,1251.39 100.0")},
{"userName" : "t4684u1" , "location" : circle("1876.6,584.06 100.0")},
{"userName" : "c1609u1" , "location" : circle("2320.02,725.01 100.0")},
{"userName" : "c1510u1" , "location" : circle("2256.6,816.78 100.0")},
{"userName" : "t3851u1" , "location" : circle("3807.01,1304.1 100.0")},
{"userName" : "c1418u1" , "location" : circle("2273.25,815.93 100.0")},
{"userName" : "t2559u1" , "location" : circle("2297.49,1887.46 100.0")},
{"userName" : "w1815u1" , "location" : circle("1539.89,343.08 100.0")},
{"userName" : "t4924u1" , "location" : circle("1609.65,83.72 100.0")},
{"userName" : "t3320u1" , "location" : circle("2322.45,1277.89 100.0")},
{"userName" : "p663u1" , "location" : circle("2291.38,254.83 100.0")},
{"userName" : "t4571u1" , "location" : circle("2253.78,1090.84 100.0")},
{"userName" : "p781u1" , "location" : circle("1154.4,712.8 100.0")},
{"userName" : "c919u1" , "location" : circle("1721.46,485.13 100.0")},
{"userName" : "c1121u1" , "location" : circle("4171.58,1083.41 100.0")},
{"userName" : "p814u1" , "location" : circle("2176.13,990.55 100.0")},
{"userName" : "t4006u1" , "location" : circle("3977.9,1303.22 100.0")},
{"userName" : "t2822u1" , "location" : circle("3087.51,1849.01 100.0")},
{"userName" : "t4953u1" , "location" : circle("1923.91,676.56 100.0")},
{"userName" : "t3486u1" , "location" : circle("3832.72,1320.87 100.0")},
{"userName" : "t3107u1" , "location" : circle("2994.64,2023.92 100.0")},
{"userName" : "t2836u1" , "location" : circle("2307.27,2096.07 100.0")},
{"userName" : "w2003u1" , "location" : circle("1976.08,2279.1 100.0")},
{"userName" : "t3256u1" , "location" : circle("2161.32,1700.73 100.0")},
{"userName" : "t4762u1" , "location" : circle("1916.88,662.71 100.0")},
{"userName" : "t4900u1" , "location" : circle("2253.78,1090.84 100.0")},
{"userName" : "p357u1" , "location" : circle("1699.66,1976.29 100.0")},
{"userName" : "t3630u1" , "location" : circle("3778.3,1285.37 100.0")},
{"userName" : "t3166u1" , "location" : circle("2743.85,965.95 100.0")},
{"userName" : "t4687u1" , "location" : circle("1798.2,426.06 100.0")},
{"userName" : "p817u1" , "location" : circle("1446.92,909.48 100.0")},
{"userName" : "t4433u1" , "location" : circle("1805.69,441.15 100.0")},
{"userName" : "t3426u1" , "location" : circle("3055.08,945.53 100.0")},
{"userName" : "p582u1" , "location" : circle("1523.47,739.18 100.0")},
{"userName" : "t3388u1" , "location" : circle("2919.63,954.46 100.0")},
{"userName" : "t4823u1" , "location" : circle("2174.09,987.9 100.0")},
{"userName" : "c1664u1" , "location" : circle("1283.46,1099.95 100.0")},
{"userName" : "t4051u1" , "location" : circle("4047.21,1215.22 100.0")},
{"userName" : "c857u1" , "location" : circle("1270.33,664.46 100.0")},
{"userName" : "c1412u1" , "location" : circle("1279.63,1731.15 100.0")},
{"userName" : "t2521u1" , "location" : circle("2850.02,1040.64 100.0")},
{"userName" : "t3114u1" , "location" : circle("2294.53,995.82 100.0")},
{"userName" : "p404u1" , "location" : circle("3789.35,1022.15 100.0")},
{"userName" : "p111u1" , "location" : circle("2054.96,904.61 100.0")},
{"userName" : "t3006u1" , "location" : circle("3095.66,1781.54 100.0")},
{"userName" : "t2903u1" , "location" : circle("2449.83,984.17 100.0")},
{"userName" : "t2823u1" , "location" : circle("2116.91,1638.54 100.0")},
{"userName" : "t4153u1" , "location" : circle("3977.9,1303.22 100.0")},
{"userName" : "t2589u1" , "location" : circle("2075.58,1455.78 100.0")},
{"userName" : "c1459u1" , "location" : circle("2149.15,1104.3 100.0")},
{"userName" : "p766u1" , "location" : circle("3144.94,1042.37 100.0")},
{"userName" : "p593u1" , "location" : circle("3460.96,1141.22 100.0")},
{"userName" : "p168u1" , "location" : circle("1719.0,2688.66 100.0")},
{"userName" : "t4253u1" , "location" : circle("1575.25,0.0 100.0")},
{"userName" : "t4177u1" , "location" : circle("2185.18,1002.25 100.0")},
{"userName" : "p387u1" , "location" : circle("2351.74,811.8 100.0")},
{"userName" : "t2571u1" , "location" : circle("2307.49,1915.48 100.0")},
{"userName" : "c1513u1" , "location" : circle("3432.64,1067.27 100.0")},
{"userName" : "p618u1" , "location" : circle("1682.87,1962.44 100.0")},
{"userName" : "t2735u1" , "location" : circle("2999.73,1635.76 100.0")},
{"userName" : "t4859u1" , "location" : circle("1763.96,348.87 100.0")},
{"userName" : "w1848u1" , "location" : circle("2675.62,2150.98 100.0")},
{"userName" : "t3306u1" , "location" : circle("2274.48,1312.75 100.0")},
{"userName" : "t2558u1" , "location" : circle("2254.43,2174.64 100.0")},
{"userName" : "p180u1" , "location" : circle("1253.66,1771.06 100.0")}
]
);

insert into Reports
(
[
{"Etype" : "flood" , "location" : circle("846.5,2589.56 1000.0")},
{"Etype" : "crash" , "location" : circle("953.48,2504.12 100.0")},
{"Etype" : "flood" , "location" : circle("2313.19,1641.15 1000.0")},
{"Etype" : "fire" , "location" : circle("3014.66,2332.34 500.0")},
{"Etype" : "flood" , "location" : circle("1188.75,2307.52 1000.0")},
{"Etype" : "fire" , "location" : circle("3418.08,1090.2 500.0")},
{"Etype" : "fire" , "location" : circle("1364.9,1434.81 500.0")},
{"Etype" : "storm" , "location" : circle("1164.65,2088.5 2000.0")},
{"Etype" : "flood" , "location" : circle("3582.04,974.89 1000.0")},
{"Etype" : "flood" , "location" : circle("1016.15,846.6 1000.0")},
{"Etype" : "flood" , "location" : circle("1416.4,1483.13 1000.0")},
{"Etype" : "flood" , "location" : circle("2777.23,963.83 1000.0")},
{"Etype" : "fire" , "location" : circle("3082.74,1746.62 500.0")},
{"Etype" : "storm" , "location" : circle("1186.15,2283.96 2000.0")},
{"Etype" : "crash" , "location" : circle("1218.17,1591.68 100.0")},
{"Etype" : "fire" , "location" : circle("1141.24,1474.73 500.0")},
{"Etype" : "flood" , "location" : circle("1105.73,1875.44 1000.0")},
{"Etype" : "flood" , "location" : circle("1805.37,2346.03 1000.0")},
{"Etype" : "flood" , "location" : circle("1535.83,1546.66 1000.0")},
{"Etype" : "fire" , "location" : circle("4187.75,1064.17 500.0")}
]
);

insert into Reports
(
[
{"Etype" : "flood" , "location" : circle("846.5,2589.56 1000.0")},
{"Etype" : "crash" , "location" : circle("953.48,2504.12 100.0")},
{"Etype" : "flood" , "location" : circle("2313.19,1641.15 1000.0")},
{"Etype" : "fire" , "location" : circle("3014.66,2332.34 500.0")},
{"Etype" : "flood" , "location" : circle("1188.75,2307.52 1000.0")},
{"Etype" : "fire" , "location" : circle("3418.08,1090.2 500.0")},
{"Etype" : "fire" , "location" : circle("1364.9,1434.81 500.0")},
{"Etype" : "storm" , "location" : circle("1164.65,2088.5 2000.0")},
{"Etype" : "flood" , "location" : circle("3582.04,974.89 1000.0")},
{"Etype" : "flood" , "location" : circle("1016.15,846.6 1000.0")},
{"Etype" : "flood" , "location" : circle("1416.4,1483.13 1000.0")},
{"Etype" : "flood" , "location" : circle("2777.23,963.83 1000.0")},
{"Etype" : "fire" , "location" : circle("3082.74,1746.62 500.0")},
{"Etype" : "storm" , "location" : circle("1186.15,2283.96 2000.0")},
{"Etype" : "crash" , "location" : circle("1218.17,1591.68 100.0")},
{"Etype" : "fire" , "location" : circle("1141.24,1474.73 500.0")},
{"Etype" : "flood" , "location" : circle("1105.73,1875.44 1000.0")},
{"Etype" : "flood" , "location" : circle("1805.37,2346.03 1000.0")},
{"Etype" : "flood" , "location" : circle("1535.83,1546.66 1000.0")},
{"Etype" : "fire" , "location" : circle("4187.75,1064.17 500.0")}
]
);