Pro Spatial with SQL Server 2012 / Alastair Aitchison ; technical reviewer, Jason Horner.

Format:

Book

Author/Creator:

Aitchison, Alastair.

Contributor:

Horner, Jason.

Series:

Expert's voice in databases.

The expert's voice in databases

Language:

English

Subjects (All):

Spatial analysis (Statistics).

SQL server.

Physical Description:

1 online resource (552 p.)

Edition:

1st ed. 2012.

Other Title:

Spatial with SQL Server 2012

Place of Publication:

[New York] : Apress, c2012.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

Title Page; Copyright Page; Contents at a Glance; Table of Contents; Foreword; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; About This Book; Chapter Overview; What You Need to Use This Book; About the Code Samples; CHAPTER 1 Spatial Reference Systems; What Is a Spatial Reference System?; Modeling the Earth; Approximating the Geoid; Regional Variations in Ellipsoids; Realizing a Reference Ellipsoid Model with a Reference Frame; Geographic Coordinate Systems; Geographic Units of Measurement; Defining the Origin of a Geographic Coordinate System

Projected Coordinate SystemsCreating Map Projections; Hammer-Aitoff Projection; Mercator Projection; Equirectangular Projection; Universal Transverse Mercator Projection; Projection Parameters; Projected Units of Measurement; Putting It All Together: Components of a Spatial Reference System; Spatial Reference Identifiers (SRIDs); Well-Known Text of a Spatial Reference System; Contrasting a Geographic and a Projected Spatial Reference; Summary; CHAPTER 2 Spatial Features; Geometry Hierarchy; Interiors, Exteriors, and Boundaries; Points; Example Point Usage; Defining a Point

Defining Points in 3- and 4-Dimensional SpaceCharacteristics of Points; LineStrings; Example LineString Usage; Defining a LineString; Characteristics of LineStrings; LineStrings and Self-Intersection; CircularStrings; Example CircularString Usage; Defining a CircularString; Characteristics of CircularStrings; Drawing Complete Circles; Choosing Between LineString and CircularString; CompoundCurves; Example CompundCurve Usage; Defining a CompoundCurve; Characteristics of CompoundCurves; Polygons; Example Polygon Usage; Exterior and Interior Rings; Defining a Polygon; Characteristics of Polygons

CurvePolygonsExample CurvePolygon Usage; Defining a CurvePolygon; Characteristics of CurvePolygons; MultiPoints; Example MultiPoint Usage; Defining A MultiPoint; Characteristics of MultiPoints; Many Single Points, or One Multipoint?; MultiLineStrings; Example MultiLineString Usage; Defining a MultiLineString; Characteristics of MultiLineStrings; MultiPolygons; Example MultiPolygon Usage; Defining a MultiPolygon; Characteristics of MultiPolygons; GeometryCollections; Example GeometryCollection Usage; Defining a GeometryCollection; Characteristics of Geometry Collections; FullGlobe

Defining a FullGlobeCharacteristics of the FullGlobe geometry are as follows.; Empty Geometries; Defining an Empty Geometry; Characteristics of Empty Geometries; Choosing the Correct Geometry; Summary; CHAPTER 3 Spatial Datatypes; SQLCLR Foundations; Methods and Properties; Static Methods; Instance Methods; Properties; Spatial Libraries; The geography Datatype; Spatial Reference Systems for the geography Datatype; Correct Ring Orientation for geography Polygons; The geometry Datatype; Spatial Reference Systems for the geometry Datatype; Storing Nongeodetic Data

The Insignificance of Ring Orientation in a geometry Polygon

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

9781430234920

143023492X

OCLC:

831116398