1 Reply Latest reply: Aug 2, 2013 7:16 AM by Marwim RSS

    Need to find the distance between calls is less than 2 KM

    986570

      Hi,

       

       

      Cdr table :

       

      LATITUDELONGITUDELOCATIONNAMEMOBILE_NOCALLDATECALLTIME
      28.6504777.160329patel nagar989180211701-Jun-1308:25:00
      28.632877.2197CP989180211701-Jun-1312:00:13
      28.661777.2108karol bagh989180211701-Jun-1309:35:00
      28.632877.2197CP989180211701-Jun-1312:50:13
      28.632877.2197CP989180211701-Jun-1312:03:23
      28.632877.2197CP989180211701-Jun-1313:00:13
      28.6413977.12119rajori garden989180211701-Jun-1308:15:13
      28.6413977.12119rajori garden989180211701-Jun-1308:20:33
      28.632877.2197CP989180211701-Jun-1310:00:13
      28.5976177.211168race course995808391901-Jun-1309:36:00
      28.632877.2197CP995808391901-Jun-1312:30:13
      28.513177.185635qutubminar995808391901-Jun-1308:06:07

       

      Filter conditions :

       

      no's : 9891802117, 9958083919

      Date : 01-Jun-2013

      Time between 11:00:00 to 13:00:00

      Range between latitude and longitude id less than 2 Km

       

      using function :

       

      Result :

       

      LATITUDELONGITUDELOCATIONNAMEMOBILE_NOCALLDATE

      CALLTIME

      28.632877.2197CP989180211701-Jun-1312:00:13
      28.632877.2197CP995808391901-Jun-1312:30:13

       

       

      Please help