O'Reilly logo

Pro Spatial with SQL Server 2012 by Alastair Aitchison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  5

Importing Spatial Data

In the last chapter, we examined various methods that can be used to create individual items of geography or geometry data, for example, using a static method that accepts WKT or WKB input, or using one of the SqlGeometryBuilder or SqlGeographyBuilder classes. Each of these methods creates only a single item of data at a time. So what if you wanted to import an entire set of spatial data?

In this chapter, I will introduce you to some of the sources from which you can obtain publicly available sets of spatial information, examine the formats in which those datasets are commonly supplied, and teach you some of the techniques you can use to import that information into SQL Server.

Sources of Spatial Data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required