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 ...

Get Pro Spatial with SQL Server 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.