Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

GEOMETRY and GEOGRAPHY difference SQL Server 2008

Tags:

sql

sql-server

What is difference between GEOMETRY and GEOGRAPHY in SQL Server 2008?

like image 373
saran Avatar asked Feb 14 '11 11:02

saran

People also ask

What is difference between geography and geometry in SQL Server?

Geometry : Stores data based on a flat (Euclidean) coordinate system. The data type is often used to store the X and Y coordinates that represent lines, points, and polygons in two-dimensional spaces. Geography : Stores data based on a round-earth coordinate system.

What is the difference between geometry and geography?

Geometry, where it assumes all of your data lives on a Cartesian plane (like a map projection); Geography, where it assumes that your data is made up of points on the earth's surface, as specified by latitudes and longitudes.

What is geography in SQL Server?

The geography spatial data type, geography, is implemented as a . NET common language runtime (CLR) data type in SQL Server. This type represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.

What are SQL Server spatial types?

SQL Server supports two spatial data types: the geometry data type and the geography data type. The geometry type represents data in a Euclidean (flat) coordinate system. The geography type represents data in a round-earth coordinate system.

1 Answers

GEOMETRY is for planar spatial data (that is, data on a flat surface)

GEOGRAPHY is for terrestrial spatial data (that is, data on the (curved) surface of the Earth)

See eg here, here for more.

like image 65
AakashM Avatar answered Sep 24 '22 21:09

AakashM
Sign in to Comment

Related questions

Passing multiple parameters to controller in ASP.NET MVC; also, generating on-the-fly queries in LINQ-to-SQL
converting Epoch timestamp to sql server(human readable format)
How to insert Arabic characters into SQL database?
Mysql Convert Column to row (Pivot table )
SQL Server Convert integer to binary string
Convert a string date into datetime in Oracle
CHECK CONSTRAINT on multiple columns
Renaming Columns in an SQL SELECT Statement
Execute SQL command in Entity Framework Core 2.0 to delete all data in a table
SQL Server Maximum rows that can be inserted in a single insert statment
Search XML with a LIKE or similar full search operation
Insert into from CTE
Learning SQL. Where to get started? [closed]
How to get the value of autoincrement of last row at the insert
Rails PG::UndefinedTable: ERROR: missing FROM-clause entry for table
Mysql::Error: Specified key was too long; max key length is 1000 bytes
Truncate date to only hour / minute
Use CASE statement to check if column exists in table - SQL Server
Mapping values in SQL select?
Description of columns in a DB2 table

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!