Pro Spatial with SQL Server 2012

1. Front Matter

   Pages i-xxviii

   PDF

2. Spatial Reference Systems

   • Alastair Aitchison

   Pages 1-20

3. Spatial Features

   • Alastair Aitchison

   Pages 21-49

4. Spatial Datatypes

   • Alastair Aitchison

   Pages 51-76

5. Creating Spatial Data

   • Alastair Aitchison

   Pages 77-100

6. Importing Spatial Data

   • Alastair Aitchison

   Pages 101-137

7. Geocoding

   • Alastair Aitchison

   Pages 139-161

8. Precision, Validity, and Errors

   • Alastair Aitchison

   Pages 163-186

9. Transformation and Reprojection

   • Alastair Aitchison

   Pages 187-210

10. Examining Spatial Properties

    • Alastair Aitchison

    Pages 211-252

11. Modification and Simplification

    • Alastair Aitchison

    Pages 253-271

12. Aggregation and Combination

    • Alastair Aitchison

    Pages 273-292

13. Testing Spatial Relationships

    • Alastair Aitchison

    Pages 293-325

14. Clustering and Distribution Analysis

    • Alastair Aitchison

    Pages 327-352

15. Route Finding

    • Alastair Aitchison

    Pages 353-386

16. Triangulation and Tesselation

    • Alastair Aitchison

    Pages 387-418

17. Visualization and User Interface

    • Alastair Aitchison

    Pages 419-444

18. Reporting Services

    • Alastair Aitchison

    Pages 445-470

19. Indexing

    • Alastair Aitchison

    Pages 471-497

20. Back Matter

    Pages 499-531

    PDF

Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server’s spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You’ll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth.

Author Alastair Aitchison first introduces you to SQL Server’s spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You’ll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you'll find helpful code examples that you can adopt and extend as a basis for your own projects.

• Explains spatial concepts from the ground up—no prior knowledge is necessary
• Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer
• Brilliantly illustrated with code examples that run in SQL Server 2012, that you can adapt and use as the basis for your own projects.

Alastair Aitchison has more than eight years of experience as a management information consultant, specializing in the design and deployment of online reporting systems. For the last three years, he has been employed as a reporting and analysis manager at Aviva, the world's fifth largest insurance group. In this role, he has championed the use of spatial data in corporate applications including the geographic analysis of risk patterns, plotting the success of regional marketing campaigns, and understanding the impact of major weather incidents. Alastair is a Microsoft Office Specialist Master Instructor and has delivered numerous training courses to individuals and small groups on a range of software packages.

Policies and ethics