3 ms·
When creating spacial geography point in sql server, the longitude comes first (lng, lat). I always thought it would be latitude then longitude. Interestingly,
by Fsp2WFuH 8y ago
When creating spacial geography point in sql server, the longitude comes first (lng, lat). I always thought it would be latitude then longitude.
Interestingly, some points that I've inserted passed the validation, but later I realized the values were swapped when I tried to query nearest neighbor and the points were no where near.
- NicoJuicy 8y agoThere is a geography data type https://docs.microsoft.com/en-us/sql/t-sql/spatial-geography/spatial-types-geography?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/t-sql/spatial-geography...