private static List <long?> GetRouteMeetingConditionsAndPointIds(List <int> indexesOfDurationList, List <DbModel.LocalizationPointDto> pointsInsideIsochrone, double maxInnerDistance, double maxInnerTime, out RouteModel route)
{
var sortedPointsByDuration = new List <DbModel.LocalizationPointDto>();
foreach (int index in indexesOfDurationList)
{
sortedPointsByDuration.Add(pointsInsideIsochrone.ElementAt(index));
}
bool doesRouteMeetParameters = false;
route = null;
while (!doesRouteMeetParameters)
{
OsrmJsonRouteModel routeJson = OsrmAPIHelper.GetOptimalRoute(sortedPointsByDuration.Select(x => (Position)x.Point.Coordinates).ToArray());
if (routeJson == null)
{
route = null;
return(null);
}
route = routeJson.ToRouteModel();
doesRouteMeetParameters = DoesInnerRouteMeetParameters(route, maxInnerDistance, maxInnerTime);
if (!doesRouteMeetParameters)
{
sortedPointsByDuration.RemoveAt(sortedPointsByDuration.Count() - 1);
}
}
var pointIds = sortedPointsByDuration.Select(x => x.PointId).ToList();
return(pointIds);
}
private List <ViewModel.Polyline> GetDifferencePolyline()
{
GeoJSON.Net.Geometry.Position warszawa = new GeoJSON.Net.Geometry.Position(52.229941, 21.011105);
GeoJSON.Net.Geometry.Position mlawa = new GeoJSON.Net.Geometry.Position(53.112154, 20.382377);
GeoJSON.Net.Geometry.Position plock = new GeoJSON.Net.Geometry.Position(52.546665, 19.687432);
OsrmJsonRouteModel parsed = OsrmAPIHelper.GetOptimalRoute(warszawa, mlawa);
var route = parsed.ToRouteModel();
var jsonNew = OsrmAPIHelper.GetOptimalRoute(warszawa, mlawa, plock);
var newRoute = jsonNew.ToRouteModel();
//var oldRouteGMultiLineString = route.MultiLineString.ToSqlGeography();
//var newRouteGMultiLineString = newRoute.MultiLineString.ToSqlGeography();
//var difference = newRouteGMultiLineString.STDifference(oldRouteGMultiLineString);
//var oldRouteG = route.LineString.ToSqlGeography();
//var newRouteG = newRoute.LineString.ToSqlGeography().MakeValidIfInvalid();
//string isValid = newRouteG.IsValidDetailed();
//var difference = newRouteG.STDifference(oldRouteG);
Microsoft.SqlServer.Types.SqlGeography oldRouteGeography = route.MultiPointGeoJsonNet.ToSqlGeography();
Microsoft.SqlServer.Types.SqlGeography newRouteGeography = newRoute.MultiPointGeoJsonNet.ToSqlGeography();
Microsoft.SqlServer.Types.SqlGeography bufferOld = oldRouteGeography.STBuffer(1000);
Microsoft.SqlServer.Types.SqlGeography bufferNew = newRouteGeography.STBuffer(1000);
var difference = bufferNew.STDifference(bufferOld);
double diffArea = (double)difference.STArea();
double oldArea = (double)bufferOld.STArea();
double newArea = (double)bufferNew.STArea();
double howDifferent = diffArea / oldArea;
List <ViewModel.Polyline> lines = new List <ViewModel.Polyline>();
//lines.Add(GetFromSqlGeography(oldRouteGeography));
//lines.Add(GetFromSqlGeography(newRouteGeography));
//lines.Add(GetFromSqlGeography(difference));
//lines.Add(GetFromSqlGeography(bufferNew));
//lines.Add(GetFromSqlGeography(bufferOld));
//lines.Add(GetFromSqlGeography(oldRouteG));
//lines.Add(GetFromSqlGeography(newRouteG));
//lines.Add(GetFromSqlGeography(difference));
//lines.Add(GetFromSqlGeography(newRouteGMultiLineString));
//lines.Add(GetFromSqlGeography(oldRouteGMultiLineString));
var polylines = GetFromSqlGeographies(difference);
foreach (var line in polylines)
{
lines.Add(line);
}
return(lines);
}
private List <ViewModel.Polyline> GetBufferPolyline()
{
GeoJSON.Net.Geometry.Position pos1 = new GeoJSON.Net.Geometry.Position(52.218703, 21.005044);
GeoJSON.Net.Geometry.Position pos2 = new GeoJSON.Net.Geometry.Position(54.182346, 16.189145);
OsrmJsonRouteModel parsed = OsrmAPIHelper.GetOptimalRoute(pos1, pos2);
var route = parsed.ToRouteModel();
Microsoft.SqlServer.Types.SqlGeography sqlGeography = route.MultiPointGeoJsonNet.ToSqlGeography();
Microsoft.SqlServer.Types.SqlGeography buffer = sqlGeography.STBuffer(100000);
List <ViewModel.Polyline> lines = new List <ViewModel.Polyline>();
lines.Add(GetFromSqlGeography(sqlGeography));
lines.Add(GetFromSqlGeography(buffer));
return(lines);
}
