====== Datos Espaciales ======

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]]

<code sql>

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(); 

</code>

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

<code sql>


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
 

</code>


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

sql server spatial: 
  * [[https://www.bostongis.com/PrinterFriendly.aspx?content_name=sql2008_tut01]]