public void TestSTAsEWKT() { using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString)) { Assert.AreEqual( "SRID=4326;POLYGON((0 0,0 1,1 1,1 0,0 0))", db.Select(() => GeometryOutput.STAsEWKT("0103000020E61000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000"))); Assert.AreEqual( "CIRCULARSTRING(220268 150415 1,220227 150505 2,220227 150406 3)", db.Select(() => GeometryOutput.STAsEWKT("0108000080030000000000000060E30A4100000000785C0241000000000000F03F0000000018E20A4100000000485F024100000000000000400000000018E20A4100000000305C02410000000000000840"))); Assert.IsNull(db.Select(() => GeometryOutput.STAsEWKT((NTSG)null))); // geography db.TestGeographies .Value(g => g.Id, 1) .Value(g => g.Geography, () => GeometryInput.STGeographyFromText("POINT(30 60)")) .Insert(); Assert.AreEqual( "SRID=4326;POINT(30 60)", db.TestGeographies .Where(g => g.Id == 1) .Select(g => g.Geography.STAsEWKT()) .Single()); } }
public void TestSTTranslatedXYZ() { using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString)) { const string geomText = "POINT(0 0 0)"; db.TestGeometries.Value(g => g.Id, 1).Value(p => p.Geometry, () => GeometryInput.STGeomFromText(geomText)).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); } }