Beginning Spatial with SQL Server 2008Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications. Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth. All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data. Every section is illustrated with code examples that you can use directly in SQL Server. All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express. What you’ll learn Understand the fundamental concepts involved in working with spatial data, including spatial references and coordinate systems. Apply these concepts in the collection and storage of spatial data in SQL Server 2008, using the new geometry and geography field types. Create different types of spatial data objects—points, lines, and polygons—and use these to describe real–world objects. Learn how to analyze spatial data using a range of supported methods, and be aware of a number of different practical applications for these methods. Be shown how to integrate SQL Server with other tools, such as Microsoft Virtual Earth, to display a visual representation of spatial data. Know how to ensure the performance of spatially enabled databases by creating appropriate spatial indexes. Who this book is forSQL Server developers who wish to use spatial data in Microsoft SQL Server 2008. |
Contents
Defining Spatial Information | 3 |
Implementing Spatial Data in SQL Server 2008 | 33 |
Working with Spatial Data in the NET Framework | 55 |
Creating Spatial Data Objects | 77 |
Marking Out Geometries Using Virtual Earth | 115 |
Importing Spatial Data | 137 |
Geocoding | 157 |
Syndicating Spatial Data | 181 |
Other editions - View all
Common terms and phrases
application binary browser byte CHAPTER column coordinate values database DECLARE defined describe element ellipsoid execute exterior ring following code following datatypes format geocoding geographic coordinate geographic coordinate system geography datatype geography instance geography or geometry geography SET geometry and geography Geometry Collection geometry datatype geometry instance geometry or geography geometry representing geometry SET GeoRSS feed GML representation Google Maps handler intersection item of spatial JavaScript JScript.js latitude and longitude LineString geometry MapPoint Web Service Microsoft MultiLineString MultiPoint MultiPolygon NET Framework parameters Point geometry Polygon geometry properties query reference ellipsoid SELECT shape shapefile spatial data spatial index spatial information SPATIAL OBJECTS spatial reference system Spatial Results tab specify SQL Server 2008 SRID static method STIntersects stored procedure Supported Datatypes syntax T-SQL type of geometry Virtual Earth Visual Studio WEB MAPPING SERVICES Web Service WKT representation xmlHttp