- Series: Beginning
- Paperback: 456 pages
- Publisher: Apress; 1st ed. edition (January 15, 2009)
- Language: English
- ISBN-10: 1430218290
- ISBN-13: 978-1430218296
- Product Dimensions: 7 x 1 x 9.2 inches
- Shipping Weight: 2 pounds (View shipping rates and policies)
- Average Customer Review: 16 customer reviews
- Amazon Best Sellers Rank: #2,023,061 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Other Sellers on Amazon
+ $3.99 shipping
Beginning Spatial with SQL Server 2008 Paperback – January 15, 2009
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
What other items do customers buy after viewing this item?
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
"...the earth is still not a regular shape. In fact, it is so unique that geophysicists have a specific word solely used to describe the shape of the earth--the geoid."
Alastair lays a foundation with simple definitions like this one, that he then builds on to explain even more complex concepts like "reference ellipsoids", "datum", and "projection", to name a few. Beginning with chapter 2 the author discusses the SQL Server 2008 geometry and geography data types in great detail. Alastair discusses the power of the spatial data types and he gives you insight into the limitations and "implementation quirks" of the different types. Consider the ring orientation limitation of polygons defined using the geography data type:
"To resolve this ambiguity [defining the inside of a polygon], when you define the points of a Polygon using the geography datatype, SQL Server 2008 treats the area on the 'left' of the path drawn between the points of a ring as being contained within the interior of the Polygon, and excludes any points that lie on the 'right' side of the ring."
Alastair excels at framing complex problems in simple terms that beginners can understand, and then building increasingly advanced and fully functional code samples. This book is a powerful reference that I keep nearby at all times. I only hope Alastair follows up with an advanced level book to share his knowledge of the more complex and complicated tasks that can be performed with geospatial databases.
Alastair, write a "Advanced" book on this topic and I'll buy it!
The book is very clearly written. All the examples I tried worked. As I said before, Mr. Aitchison does a great job of explaining very difficult concepts so that even someone completely new to the topic will understand. That's the goal of a beginners book and it is very well met.
Now I want to see Intermediate Spatial please?
I used to use ArcInfo for this type of work, but processing all the spatial data within SQL Server makes a lot of sense. It eliminates several steps such as exporting the data out of the database, importing it into ArcGIS and making points, then doing point in polygon overlays. Beginning Spatial with SQL Server 2008 goes a long way towards helping me perform operational planning for Fire Services and Emergency Medical Services. This book helps me solve real-world problems. Mr. Aitchison has a clear writing style and the book covers topics that are useful for solving geographic issues.
So many issues in business and government have a spatial component such as: which schools in Detroit to close, where to locate a new fire station in Fort Myers, where are customers relative to my stores, etc. This book goes a long way in helping you analyze your spatial data.
Once again, I would give this book a high recommendation.
Most recent customer reviews
The author goes into great detail and covers most
aspects of the topic.Read more