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.
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.
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
19.
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.
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.
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
19.
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 19.
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.
![]() |
Ask a Question About this Product More... |
![]() |