Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro Spatial with SQL Server 2012

  • Book
  • © 2012

Overview

Authors:
  1. Alastair Aitchison
    View author publications

    You can also search for this author in PubMed   Google Scholar

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

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 69.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 89.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (18 chapters)

  1. Front Matter

    Pages i-xxviii
    Download chapter 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
    Download chapter PDF
Back to top

About this book

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.

About the author

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.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation