SBO | Spatial 2 geography

-- potrzebne poligony f,g,h z poprzedniego pliku

SELECT @f.STBuffer(1).ToString(), @g.STBuffer(1).ToString(), @h.STBuffer(1).ToString()

SELECT @f.STBuffer(1)
UNION ALL
SELECT @g.STBuffer(1)
UNION ALL
SELECT @h.STBuffer(1)



SELECT @f.STIntersection(@g)
UNION ALL
SELECT @f.STIntersection(@h)
UNION ALL
SELECT @h.STIntersection(@h)

SET @g = geometry::STGeomFromText('POINT(2 2)',  0)
SET @h = geometry::STGeomFromText('LINESTRING(0 0, 0 10, 10 10, 10 0, 0 0)', 0)


SELECT @g.STBuffer(1)
UNION ALL
SELECT @h





DECLARE @g geography;
DECLARE @poland geography;
SET @poland = (SELECT geom FROM DEU_Adm2 WHERE ID=243)
SET @g = geography::STGeomFromText('POINT(20 51.5)', 4326);

SELECT @poland
UNION ALL
SELECT @g.STBuffer(1000)

SELECT geom FROM DEU_adm0
UNION ALL
SELECT geom FROM POL_adm0