We have a SQL Server 2008R2 database where point coordinates are stored as decimal degrees.
I want to create an Esri map service which shows those points.
As the point data is dynamic I decided to use query layer to the table with coordinates and convert coordinates to SQL Server spatial type on the fly.
I tested both spatial types - geometry
and geography
and both allow to display points in ArcMap. Both types use WGS84 coordinate system because coordinates are longitude and latitude, but map service is in Web Mercator (3857).
What is should be preffered type of SQL Server spatial type to use to display longitude and latitude on the fly in Esri map service?
geography
.geometry
with geographic coordinates?