From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Store spatial data - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Store spatial data
- (Voiceover) In this chapter, were going to take a look at some the more advanced date types that SQL Server supports. First, I'd like to talk about Spatial Data. SQL Server includes two datatypes, will allow you to store geospatial information. These data types both describe Point, Line, and Polygon shapes that are used to describe features like those you would find on a map. Points can describe single (X,Y) coordinates. Lines link series of coordinates into features such as roads and rivers, and Polygons represent areas such as states, city boundaries, or building footprints. The Geometry datatype maps Points, Lines, and Polygons to a two-dimensional Euclidean plane. These are useful for simplifying measurements and calculations of area since location, distance, and area remain in the same units. The Geography datatype takes into account the curvature of the earth. It maps points onto a sphere. Features stored in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.