Pro Spatial with SQL Server 2012
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’l...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[New York] :
Apress
c2012.
|
| Edición: | 1st ed. 2012. |
| Colección: | Expert's voice in databases.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628233306719 |
Tabla de Contenidos:
- 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
