{"product_id":"9781430234920","title":"Pro Spatial with SQL Server 2012","description":"\u003cp\u003eMicrosoft SQL Server implements extensive support for location-based data. \u003cem\u003ePro Spatial with SQL Server 2012\u003c\/em\u003e 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.\u003c\/p\u003e\u003cp\u003eAuthor 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. \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eExplains spatial concepts from the ground up—no prior knowledge is necessary \u003c\/li\u003e\n\u003cli\u003eProvides 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 \u003c\/li\u003e\n\u003cli\u003eBrilliantly illustrated with code examples that run in SQL Server 2012, that you can adapt and use as the basis for your own projects. \u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e   \u003cli\u003eThe fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems \u003c\/li\u003e   \u003cli\u003eHow to create and store spatial data using the geometry and geography data types \u003c\/li\u003e   \u003cli\u003eHow to use of spatial indexes in the design of highly-performant databases \u003c\/li\u003e   \u003cli\u003eWrite spatial queries to answer practical, business questions \u003c\/li\u003e   \u003cli\u003ePass spatial data seamlessly between database and application layers using T-SQL and C# \u003c\/li\u003e   \u003cli\u003eOvercome common issues, including how to deal with invalid, imprecise, or erroneous spatial data \u003c\/li\u003e   \u003cli\u003eApply advanced techniques such as routefinding and clustering \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003ePro Spatial with SQL Server 2012\u003c\/em\u003e is the go-to book for anyone involved in spatial applications involving Microsoft SQL Server 2012. The book helps database administrators create and optimize the performance of spatial database. The book gives developers what they need to know in order to make effective use of the extensive support for location-based data provided by SQL Server, T-SQL, and C#.         \u003c\/p\u003e     Table of Contents1. Spatial Reference Systems\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  2. Spatial Features\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  3. Spatial Datatypes\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  4. Creating Spatial Data\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  5. Importing Spatial Data\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  6. Geocoding\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  7. Precision, Validity, and Errors\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  8. Transformation and Reprojection\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  9. Examining Spatial Properties\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  10. Modification and Simplification\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  11. Aggregation and Combination\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  12. Testing Spatial Relationships\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  13. Clustering and Distribution Analysis\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  14. Route Finding\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  15. Triangulation and Tesselation\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  16. Visualization and User Interface \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  17. Reporting Services\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  18. Indexing\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  19. \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e    \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47170915369200,"sku":"9781430234920","price":41.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430234920_p0.jpg?v=1763750812","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430234920","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}