public override void WriteMultiPoint(Microsoft.SqlServer.Types.SqlGeometry geom)
{
for (int i = 1; i <= geom.STNumPoints().Value; i++)
{
this.WritePoint(geom.STPointN(i));
}
}
private ViewModel.Polyline GetFromSqlGeometry(Microsoft.SqlServer.Types.SqlGeometry multiPoint)
{
var result = new ViewModel.Polyline()
{
Locations = new LocationCollection()
};
for (int i = 1; i <= multiPoint.STNumPoints(); i++)
{
Microsoft.SqlServer.Types.SqlGeometry point = multiPoint.STPointN(i);
result.Locations.Add(new Location((double)point.STY, (double)point.STX));
}
return(result);
}
public static Dictionary <string, object> LineStringToJson(Microsoft.SqlServer.Types.SqlGeometry lineString)
{
Dictionary <string, object> geometry = new Dictionary <string, object>();
geometry.Add("type", "LineString");
List <object> coordinates = new List <object>();
int points = (int)lineString.STNumPoints();
for (int i = 1; i <= points; i++)
{
List <object> coordinate = new List <object>();
coordinate.Add(Convert.ToDouble(lineString.STPointN(i).STX.Value));
coordinate.Add(Convert.ToDouble(lineString.STPointN(i).STY.Value));
coordinates.Add(coordinate);
}
geometry.Add("coordinates", coordinates);
return(geometry);
}
public override void WriteMultiPoint(Microsoft.SqlServer.Types.SqlGeometry geom)
{
try
{
List <double[]> ptCoords = new List <double[]>();
for (int i = 1; i < geom.STNumPoints().Value; i++)
{
ptCoords.Add(this.ConvertPoint(geom.STPointN(i)));
}
GeoJson.MultiPoint multiPt = new GeoJson.MultiPoint();
multiPt.coordinates = ptCoords.ToArray();
_features.Add(new GeoJson.Feature()
{
geometry = multiPt
});
}
catch (Exception)
{
throw;
}
}