Pro Spatial with SQL Server 2012

  • Authors
  • Alastair Aitchison

Table of contents

  1. Front Matter
    Pages i-xxviii
  2. Alastair Aitchison
    Pages 1-20
  3. Alastair Aitchison
    Pages 21-49
  4. Alastair Aitchison
    Pages 51-76
  5. Alastair Aitchison
    Pages 77-100
  6. Alastair Aitchison
    Pages 101-137
  7. Alastair Aitchison
    Pages 139-161
  8. Alastair Aitchison
    Pages 163-186
  9. Alastair Aitchison
    Pages 187-210
  10. Alastair Aitchison
    Pages 211-252
  11. Alastair Aitchison
    Pages 253-271
  12. Alastair Aitchison
    Pages 273-292
  13. Alastair Aitchison
    Pages 293-325
  14. Alastair Aitchison
    Pages 327-352
  15. Alastair Aitchison
    Pages 353-386
  16. Alastair Aitchison
    Pages 387-418
  17. Alastair Aitchison
    Pages 419-444
  18. Alastair Aitchison
    Pages 445-470
  19. Alastair Aitchison
    Pages 471-497
  20. Back Matter
    Pages 499-531

About this book

Introduction

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.

Bibliographic information