public void TestSTAffine2D()
{
var expected = new double[][]
{
new[] { 0.0, 0.0, 3.0 },
new[] { 0.0, 0.0, 3.0 },
};
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "LINESTRING(1 2 3, 1 4 3)";
db.TestGeometries.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromEWKT(Wkt))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STAffine(0, 0, 0, 0, 0, 0))
.Single() as NTSGS.LineString;
CheckLineEquals(expected, result, 1.0E-8);
var result2 = db
.Select(() => AffineTransformations.STAffine(Wkt, 0, 0, 0, 0, 0, 0)) as NTSGS.LineString;
CheckLineEquals(expected, result2, 1.0E-8);
}
}
public void TestSTRotate()
{
var expected = new double[][]
{
new[] { -50.0, -160.0 },
new[] { -50.0, -50.0 },
new[] { -100.0, -50.0 }
};
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "LINESTRING (50 160, 50 50, 100 50)";
db.TestGeometries
.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromEWKT(Wkt))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STRotate(Math.PI))
.Single() as NTSGS.LineString;
CheckLineEquals(expected, result, 1.0E-8);
var result2 = db
.Select(() => AffineTransformations.STRotate(Wkt, Math.PI)) as NTSGS.LineString;
CheckLineEquals(expected, result2, 1.0E-8);
}
}
public void TestSTScaleFalseOrigin()
{
var expected = new double[][]
{
new[] { 1.00, 1.00 },
new[] { 3.00, 3.00 },
};
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "LINESTRING(1 1, 2 2)";
db.TestGeometries
.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromEWKT(Wkt))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STScale(GeometryInput.STGeomFromEWKT("POINT(2 2)"), GeometryInput.STGeomFromEWKT("POINT(1 1)")))
.Single() as NTSGS.LineString;
CheckLineEquals(expected, result, 1.0E-8);
var result2 = db
.Select(() => AffineTransformations.STScale(
Wkt,
GeometryInput.STGeomFromEWKT("POINT(2 2)"),
GeometryInput.STGeomFromEWKT("POINT(1 1)"))) as NTSGS.LineString;
CheckLineEquals(expected, result2, 1.0E-8);
}
}
public void TestSTScaleXYZM()
{
var expected = new double[][]
{
new[] { 0.5, 1.5, 6.0, -4.0 },
new[] { 0.5, 0.75, 2.0, -1.0 },
};
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "LINESTRING(1 2 3 4, 1 1 1 1)";
db.TestGeometries
.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromEWKT(Wkt))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STScale(GeometryConstructors.STMakePoint(0.5, 0.75, 2, -1)))
.Single() as NTSGS.LineString;
CheckLineEquals(expected, result, 1.0E-8);
var result2 = db
.Select(() => AffineTransformations.STScale(Wkt, GeometryConstructors.STMakePoint(0.5, 0.75, 2, -1))) as NTSGS.LineString;
CheckLineEquals(expected, result2, 1.0E-8);
}
}
public void TestSTRotateOriginGeom()
{
var expected = new double[][]
{
new[] { 116.42245883568916, 130.67207346706593 },
new[] { 21.15966441940092, 75.67207346706593 },
new[] { 46.15966441940093, 32.370803277844 }
};
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "LINESTRING (50 160, 50 50, 100 50)";
db.TestGeometries
.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromEWKT(Wkt))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STRotate(-1.0 * Math.PI / 3.0, g.Geometry.STCentroid()))
.Single() as NTSGS.LineString;
CheckLineEquals(expected, result, 1.0E-8);
var origin = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STCentroid())
.Single() as NTSGS.Point;
var result2 = db
.Select(() => AffineTransformations.STRotate(Wkt, -1.0 * Math.PI / 3.0, origin)) as NTSGS.LineString;
CheckLineEquals(expected, result2, 1.0E-8);
}
}
public void TestSTTranslatedXYZ()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "POINT(0 0 0)";
db.TestGeometries.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromText(Wkt))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STTranslate(5, 12, 3))
.Select(g => GeometryOutput.STAsEWKT(g))
.Single();
Assert.AreEqual("POINT(5 12 3)", result);
var result2 = db
.Select(() => AffineTransformations.STTranslate(Wkt, 5, 12, 3).STAsEWKT());
Assert.AreEqual("POINT(5 12 3)", result2);
}
}
public void TestSTTranslatedXY()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "POINT(-71.01 42.37)";
db.TestGeometries
.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromText(Wkt, 4326))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STTranslate(1, 0).STAsText())
.Single();
Assert.AreEqual("POINT(-70.01 42.37)", result);
var result2 = db
.Select(() => AffineTransformations.STTranslate(Wkt, 1, 0).STAsText());
Assert.AreEqual("POINT(-70.01 42.37)", result2);
}
}
