Logo - springer
Slogan - springer

Computer Science - Database Management & Information Retrieval | Pro Spatial with SQL Server 2012

Pro Spatial with SQL Server 2012

Aitchison, Alastair

2012, XXVIII, 560 p.

A product of Apress
Available Formats:

Springer eBooks may be purchased by end-customers only and are sold without copy protection (DRM free). Instead, all eBooks include personalized watermarks. This means you can read the Springer eBooks across numerous devices such as Laptops, eReaders, and tablets.

You can pay for Springer eBooks with Visa, Mastercard, American Express or Paypal.

After the purchase you can directly download the eBook file or read it online in our Springer eBook Reader. Furthermore your eBook will be stored in your MySpringer account. So you can always re-download your eBooks.


(net) price for USA

ISBN 978-1-4302-3492-0

digitally watermarked, no DRM

Included Format: PDF

download immediately after purchase

learn more about Springer eBooks

add to marked items


Softcover (also known as softback) version.

You can pay for Springer Books with Visa, Mastercard, American Express or Paypal.

Standard shipping is free of charge for individual customers.


(net) price for USA

ISBN 978-1-4302-3491-3

free shipping for individuals worldwide

usually dispatched within 3 to 5 business days

add to marked items

    • Only book on the market to cover SQL Server's spatial feature set
    • Written by a 4½ star author who is a Microsoft Master Instructor with more a decade's worth of experience in location-based computing
    • Covers the entire gamut of location-based computing from concepts to database through to the application layer
    • Grabs readers' attention through compelling, visual examples
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. 

Content Level » Popular/general

Related subjects » Database Management & Information Retrieval

Table of contents 

1. Spatial Reference Systems

2. Spatial Features

3. Spatial Datatypes

4. Creating Spatial Data

5. Importing Spatial Data

6. Geocoding

7. Precision, Validity, and Errors

8. Transformation and Reprojection

9. Examining Spatial Properties

10. Modification and Simplification

11. Aggregation and Combination

12. Testing Spatial Relationships

13. Clustering and Distribution Analysis

14. Route Finding

15. Triangulation and Tesselation

16. Visualization and User Interface 

17. Reporting Services

18. Indexing



Popular Content within this publication 



Read this Book on Springerlink

Services for this book

New Book Alert

Get alerted on new Springer publications in the subject area of Database Management.