CREATE TABLE SampleGeographyPoints ( item varchar(32), shape geography); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(-1.3623046874999962 44.527842798455495, 2.7685546874999915 43.96119063892025)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(2.6806640624999933 43.96119063892025, 6.591796874999988 44.74673324024679)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(6.591796874999988 44.74673324024679, 1.977539062500013 53.199451902831555)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(1.977539062500013 53.199451902831555, -1.450195312499994 44.68427737181225)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(5.0537109374999964 47.45780853075031, -1.186523433000001 45.67548217560646)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(3.955078124999993 49.43955695894084, -0.3515624999999904 47.84265762816536)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(3.0761718300000164 51.041393898126365, 0.3515624999999904 50.00773901463686)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(2.2412109330000057 52.48278022207821, 1.3183593749999975 51.998410382390325)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(5.7568359330000115 46.134170046243256, -0.0878906249999976 44.49650533109346)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(4.4824218300000115 48.54570549184745, -0.7031250000000143 46.980252355218816)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(3.4716796830000053 50.401515322782366, 0.2636718749999928 49.325121991040014)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(2.5488281249999973 51.91716758909015, 1.0546830000000046 51.289405902716794)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(1.5380859374999915 44.24519901522129, 1.450195312499994 43.16512263158295)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STLineFromText('LINESTRING(3.7353515624999986 44.24519901522129, 3.6474609330000013 43.61221676817571)', 4326)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(2.900390624999988 50.00773901463686)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(0.6152343300000168 48.86471476180279)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(-0.7031250000000143 47.04018214480665)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(2.1093300000000093 45.89000815866183)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(2.636718749999995 47.8721439688873)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(5.185546874999992 45.82879925192133)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(1.9335933000000142 44.653024159812)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(-0.5273437499999856 45.27488643704892)', 4326).STBuffer(30000)); INSERT INTO SampleGeographyPoints VALUES ('TreeComponent', geography::STPointFromText('POINT(1.1425781250000022 50.0641917366591)', 4326).STBuffer(30000)); SELECT shape FROM SampleGeographyPoints DROP TABLE SampleGeographyPoints