Top "Geography" questions

Geography is the science that deals with the study of the Earth and its lands, features, inhabitants, and phenomena.

Create geography polygon from points in T-SQL

In my SQL Server (2008 R2) on Azure, there's a table containing a lot of geographical Points (latitude/longitude): CREATE TABLE …

sql-server tsql sql-server-2008-r2 geography
How to find which points intersect with a polygon in geopandas?

I've been trying to use the "intersects" feature on a geodataframe, looking to see which points lie inside a polygon. …

python geography geopandas
How to read / write geography data using C#, Entity Framework and SQL Server 2008?

I have a form from which the user will be able to enter the latitude and longitude of a certain …

c# sql-server-2008 entity-framework gis geography
Geospatial coordinates and distance in kilometers

This is a followup to this question. I seem to be stuck on this. Basically, I need to be able …

geolocation geospatial distance geography
Convert geography to geometry SQL Server 2008R2

Hello, i have the following code in SQL Server, why if i want to calculate the sTArea of @geog fails …

sql geometry spatial geography
How to calculate distance between multiple points in SQL Server?

I have table with data from GPS, e.g.: Latitude, Longitude, Time, UserId How to aggregate total distance in specified …

sql-server distance geography
Is it possible to use SqlGeography with Linq to Sql?

I've been having quite a few problems trying to use Microsoft.SqlServer.Types.SqlGeography. I know full well that support …

c# sql-server linq-to-sql geography sqlgeography
SQL Geography point inside polygon not returning true on STIntersect (but returns true using Geometry)

I don't want to resort in converting my geography data to geometry just so it returns true in STIntersect. Here …

sql geometry polygon point geography
PHP/MySQL: Select locations close to a given location from DB

In PHP, I have the following code for calculating the distance between two locations: <?php function distance($lat1, $long1, $…

php mysql geolocation distance geography
Calculating Distance Between 2 Cities

How do you calculate the distance between 2 cities?

algorithm math trigonometry geography