|
Beginning Spatial with SQL Server 2008 |  | Author: Alastair Aitchison
Publisher: Apress
Category: Book
List Price: $49.99
Buy New: $40.05
as of 7/30/2010 03:43 CDT details
You Save: $9.94 (20%)
New (20) Used (7) from $40.05
Seller: best_bargain_books3
Rating:  10 reviews
Sales Rank: 77399
Media: Paperback
Edition: 1
Pages: 456
Number Of Items: 1
Shipping Weight (lbs): 1.5
Dimensions (in): 9.1 x 6.9 x 1
ISBN: 1430218290
Dewey Decimal Number: 005
EAN: 9781430218296
ASIN: 1430218290
Publication Date: January 21, 2009
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications. Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth. - All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data.
- Every section is illustrated with code examples that you can use directly in SQL Server.
- All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express.
What you’ll learn - Understand the fundamental concepts involved in working with spatial data, including spatial references and coordinate systems.
- Apply these concepts in the collection and storage of spatial data in SQL Server 2008, using the new geometry and geography field types.
- Create different types of spatial data objects—points, lines, and polygons—and use these to describe real–world objects.
- Learn how to analyze spatial data using a range of supported methods, and be aware of a number of different practical applications for these methods.
- Be shown how to integrate SQL Server with other tools, such as Microsoft Virtual Earth, to display a visual representation of spatial data.
- Know how to ensure the performance of spatially enabled databases by creating appropriate spatial indexes.
Who is this book for? SQL Server developers who wish to use spatial data in Microsoft SQL Server 2008. About the Apress Beginning Series The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to know—but without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!
|
| Customer Reviews:
Showing reviews 1-5 of 10
 Beginning Spatial with SQL Server 2008 Review June 7, 2010
Jerry R. Lloyd (Bellevue Wa, USA)
Excellent book that starts with a good background on the concepts of the various geographies in the world. This background is expanded in a logical manner to cover the end to end concept of developing applications for use of spatial data. The reader is provided with good examples for processing with the myriad of data sources, visual and datasets, that exist on the internet.
The fact that the examples are developed using the Microsoft Express products for Visual Studio and SQL Server 2008 allows a user to test the examples without additonal cost is an additional plus.
 Good beginning to intermediate SQL Server spatial book May 17, 2010
Chad Cooper (Houston, TX USA)
I've been doing GIS work for 8 years now, pretty much solely using the ESRI software stack (SDE on SQL Server 2003/2005, coding with Python and C#). At a conference recently, I learned of ways to supposedly bypass the ESRI stack and update your GIS layers base tables using SQL Server 2008. I ran across this book at the conference bookstore and later ordered it. This book and the methodologies it provides have completely revolutionized how I update my GIS data in SQL Server. What would normally take many, many minutes (if not hours) to do programmatically through the ESRI stack (using Python, or ArcObjects through VBA or .NET) now takes seconds to just a few minutes to do by utilizing the power of the native SQL Server geometry and geography datatypes in stored procedures. This book does a good job of explaining the basics of geographic data and provides good working examples to get anyone even remotely familiar with SQL up and running with the SQL spatial data types. Alastair has a great informal writing style that makes this technical book easy to read. If you work with spatial data in ArcSDE on SQL Server 2008 and want to get introduced to the native spatial capabilities that your database can provide to you, this book is for you.
Alastair, write a "Advanced" book on this topic and I'll buy it!
Good as a starter May 13, 2010
Magnus Salgo (Stockholm Sweden)
1 out of 1 found this review helpful
I think this book is good for someone new to GIS. The feeling I get is that the author is paid by number of pages so we get some additional things like creating Web applications in Visual Studio which maybe could have been left for another book and instead focus on SQL Server 2008 and the functionality.....
SRP => focus on SQL Server 2008 is my wish....
Summary worth reading to get started but where is the next step......
Beginning Spatial with SQL Server 2008 April 16, 2010
Ryan Schiller (Eastern SD)
Very good book. Has introduced us to and explained some of the basic concepts that we needed to understand as we begin to utilize spatial data in our environment.
Spatial Analysis for Databases March 18, 2010
David M. Kulpanowski (Fort Myers)
I would give this book a high recommendation. Using this book I was able to take GPS data of ambulances travelling around our county and import it into SQL Server 2008, spatialize the tables and write queries against it. Examples of my queries are; what is the distance between standby locations and the subsequent dispatch location? How far away are emergency incidents from the fire station? By hour of day, where are emergency incidents happening within the county? Where in the county are we NOT meeting our response time standard?
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.
Showing reviews 1-5 of 10
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
