Skip to content

Instantly share code, notes, and snippets.

View weber87na's full-sized avatar
πŸ’©
πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’©

ε–‡θ³½ηš„δΊΊ weber87na

πŸ’©
πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’© πŸŒΉπŸ’©
View GitHub Profile
@matt40k
matt40k / GetGeoJSON.sql
Created November 29, 2015 20:57
Turns SQL Server Geography to GeoJSON
CREATE FUNCTION GetGeoJSON (@geo geography)
RETURNS varchar(max)
WITH SCHEMABINDING
/*
* Reference: http://stackoverflow.com/questions/6506720/reformat-sqlgeography-polygons-to-json
*/
AS
BEGIN
DECLARE @Result varchar(max)
SELECT @Result = '{' +