public static double Distance(Int16 carId, Int64 tripId) { DBController dbc = new DBController(); List<SpatialInformation> entries = dbc.GetMPointsByCarIdAndTripId(carId, tripId); dbc.Close(); double distance = 0; for (int i = 1; i < entries.Count - 1; i++) { distance += entries[i].MPoint.GetDistanceTo(entries[i - 1].MPoint); } return distance /= 1000; }
public static void GetMpointPlot(Int16 carId, Int64 tripId) { DBController dbc = new DBController(); List<SpatialInformation> spatialData = dbc.GetMPointsByCarIdAndTripId(carId, tripId); dbc.Close(); List<double> distances = new List<double>(); Dictionary<GeoCoordinate, GeoCoordinate> outliers = new Dictionary<GeoCoordinate, GeoCoordinate>(); for (int i = 1; i < spatialData.Count; i++) { distances.Add(spatialData[i].MPoint.GetDistanceTo(spatialData[i - 1].MPoint)); //TODO: Hvor kommer 250 fra??? if (spatialData[i].MPoint.GetDistanceTo(spatialData[i - 1].MPoint) > 250) { outliers.Add(spatialData[i].MPoint, spatialData[i - 1].MPoint); } } }