anotaciones:

• https://www.compose.com/articles/geofile-pgadmin-4-and-the-geometry-viewer/
• https://dbeaver.com/product/version.xml
• https://github.com/dbeaver/dbeaver/releases/tag/6.0.2

google y sql server 2008:

• https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9645b2dc-bc64-46a6-9efc-4ed5fc91b235/integrate-sql-server-2008-spatial-with-google-maps?forum=sqlspatial

MAPAS para report service:

• http://blog.datainspirations.com/2010/08/31/do-it-yourself-map-gallery-in-sql-server-2008-r2-reporting-services/
• https://www.red-gate.com/simple-talk/sql/learn-sql-server/gis-and-sql-server-2008-making-maps-with-your-data/
• https://blogs.msdn.microsoft.com/querysimon/2012/06/17/bi-data-on-maps-in-sql-server-2012-part-1/
• https://www.mssqltips.com/sqlservertip/2174/maps-in-sql-server-2008-r2-reporting-services/
• https://www.red-gate.com/simple-talk/dotnet/asp-net/mapping-your-data-with-bing-maps-and-sql-server-2008/

Buenos ejemplos:

• https://stackoverflow.com/questions/30322924/how-to-store-longitude-latitude-as-a-geography-in-sql-server-2014
• http://www.sql-server-helper.com/sql-server-2008/convert-latitude-longitude-to-geography-point.aspx
• https://docs.microsoft.com/en-us/sql/t-sql/spatial-geometry/stgeomfromtext-geometry-data-type?view=sql-server-2017

Libro :

• https://books.google.com.pe/books?id=pphCAwAAQBAJ&pg=PT582&lpg=PT582&dq=Open+Geospatial+Consortium+sql+server+2008&source=bl&ots=PX1BOM84rP&sig=ACfU3U07ll2nyeNEaxEQ4z-t9mh4Db6Q-g&hl=es-419&sa=X&ved=2ahUKEwjclpqv1qjjAhVPx1kKHTdhA50Q6AEwBXoECDEQAQ#v=onepage&q=Open%20Geospatial%20Consortium%20sql%20server%202008&f=false
• http://www.opengeospatial.org/pressroom/pressreleases/781
• https://docs.microsoft.com/en-us/sql/t-sql/spatial-geometry/stgeomfromtext-geometry-data-type?view=sql-server-2017

Dbeaver:

• https://github.com/dbeaver/dbeaver/issues/4222

SELECT geography::STGeomFromText('POINT(-122.34720 47.65100)', 4326);
 
SELECT geography::STGeomFromText('POINT(-122.34720 47.65100)', 4326).STAsText()
 
DECLARE @g geography;
DECLARE @h geography;
SET @g = geography::STGeomFromText('POINT(-122.35900 47.65129)', 4326);
SET @h = geography::STGeomFromText('POINT(-122.34720 47.65100)', 4326);
SELECT @g.STDistance(@h);
 
DECLARE @geo Geography, @Lat VARCHAR(10), @long VARCHAR(10)
SET @Lat = '34.738925' SET @Long = '-92.39764'
SET @geo= geography::Point(@LAT, @LONG, 4326)
SELECT @geo
 
 
DECLARE @Origin GEOGRAPHY,
    -- distance defined in meters
    @Distance INTEGER = 2000;        
 
DECLARE @Origin GEOGRAPHY,
SET @Origin = GEOGRAPHY::STGeomFromText('POINT(17.482477 78.546871)', 4326);
 -- return all rows from events in 2km radius
SELECT *,GeoLocation.STDistance(@Origin) Distance FROM dbo.Locations WHERE @Origin.STDistance(GeoLocation) <= @Distance;
 
 
DECLARE @g geometry;  
SET @g = geometry::STGeomFromText('LINESTRING (100 100, 20 180, 180 180)', 0);  
--SELECT @g.ToString(); 
SELECT @g--.ToString();

Funciona en SQL SERVER 2008 r2, se debe decir a la columna que es geospacial

 
SELECT  geography::Point(IE.STL_LATITUD,IE.STL_LONGITUD, 4326).STAsText(),
IE.STL_CODBAR, IE.STL_FECMOV, IE.STL_HORMOV, CL.STL_RAZSOC FROM STL_INTEGRACION_ESTADOS_VISITAS AS IE
LEFT JOIN STL_ENVIOS AS EN
	ON EN.STL_IDORDSER = IE.STL_IDORDSER AND
		EN.STL_IDENVIO = IE.STL_IDENVIO
LEFT JOIN STL_CLIENTES AS CL
	ON CL.STL_IDCLIENTE = EN.STL_IDCLIENTE
WHERE CONVERT(VARCHAR(10),IE.STL_FECREG,112) > '20190915' AND EN.STL_IDENVIO IS NOT NULL
 AND STL_LATITUD IS NOT NULL

https://sites.google.com/site/geoglink/geodatabase

sql server spatial:

• https://www.bostongis.com/PrinterFriendly.aspx?content_name=sql2008_tut01