CREATE FUNCTION [dbo].[KoordsAreaInText] (@koords geography, @radius_action int)
 RETURNS nvarchar(max)
 AS
 BEGIN
 DECLARE @area geography;
 DECLARE @areaText nvarchar(max);
 SET @area=@koords.STBuffer(@radius_action);
 SET @areaText=@area.STAsText();
 RETURN(@areaText);
 END
 GO

CREATE TABLE GeographicalKoordinates (
	Id_GeographicalKoordinates int NOT NULL IDENTITY (1,1) PRIMARY KEY,
	Koordinate geography NOT NULL,
	TypeKoordinates NVARCHAR(50) NULL CHECK (TypeKoordinates IN ('POINT','LINESTRING','POLYGON','Other')),
	SRID INT NULL,
	RadiusAction INT NULL,
	HeighSeaLevel decimal(18,6) NULL,
	AllKoordinatesArea AS Koordinate.STBuffer(RadiusAction) PERSISTED,
	KoordinateText AS Koordinate.STAsText() PERSISTED,
	AllKoordinatesAreaTxt AS dbo.KoordsAreaInText(Koordinate,RadiusAction) PERSISTED,
	description nvarchar(50) NULL);
	GO