SQL Server 2008 was a major upgrade and one of its new features was support for new data types such as spatial data types. Spatial data types will be increasingly adopted in dealing with globalization and handling the distributed nature of resources and events. Presently it supports 2D data with a possible 3D addition in the future.
Spatial data is basically of two types, the geometry type for flat-earth situations that can be handled by Euclidean geometry principles and the other the Geography type for situations dealing with locations on the ellipsoid or round-earth handled by spherical geometry.
In the hyper-linked article a clear guide to understanding spatial coordinates is presented in five easy to follow steps.
Step 1: Gather the resources
Step 2: Create a database
Step 3: Create a table to hold geography data type
Step 4: Populate the table with sample data
Step 5: Populating the geography data type the table's column
With this you can do some geocalculations.
EASY GUIDE TO GEOGRAPHY DATA TYPE IN SQL SERVER 2008
P.s: You can read it for free by becoming a guest.
Subscribe to:
Post Comments (Atom)
What is SQLOISIM? What is it used for in SQL Server?
SQLIOSIM is a tool for simulating SQL Server IO. SQLIOSIM performs reliability and integrity tests on the disk systems that SQL Server uti...
-
This post provides a tutorial approach to authoring a report with Microsoft PowerBI using data on a SQL Server 2012. PowerBI is Microsof... -
Although some of the new connectors are generally available, some are in BETA. Here is a complete picture of the data connectors available... -
Linked servers offer the following advantages as noted in MSDN documentation: •The ability to access data from outside of SQL Server. •T...
No comments:
Post a Comment