Tag: distance calculation
-
Convert Lat/Lng to X and Y Coordinates Using SQL: A Practical Guide
Learn how to project latitude/longitude coordinates into flat X/Y plane coordinates using SQL. Full T-SQL, PostgreSQL, MySQL, and SQLite examples with cosine correction and distance calculation.
-
🌎💻 Converting Lat Lng to XY Coordinates: A Guide
As someone who works with geographic data, I often need to manipulate latitudes and longitudes. Recently, a researcher requested that I convert a list of latitudes and longitudes to XY coordinates to obscure the actual location of the points while still allowing for analysis of the distance relationship between them. Here’s how I did it,…