|
Size: 1493
Comment:
|
Size: 288
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| == Spatial Reference Systems == * Spatial Reference Systems - coordinate system to identify particular points on the earth (e.g. WGS84) * geoid - the word used to describe the shape of the earth. * reference ellipsoid - a smooth model used by scientists to approximate the shape of the earth. * oblate spheroid - most commonly used reference ellipsoid * Most reference ellipsoids aren't meant to model the entire earth, but some such as the World Geodetic System 1984 do. * SQL Server 2012 recognizes spatial reference systems based on a number of different reference ellipsoids. || Ellipsoid Name || Semi-Major Axis (m) || Semi-Minor Axis (m) || Inverse Flattening || Area of Use || || Airy (1830) || 6,377,563.396 || 6,356,256.909 || 299.3249646 || Great Britain || || Bessel (1841) || 6,377,397.155 || 6,356,078.963 || 299.1528128 || Czechoslovakia, Japan, South Korea || || Clarke (1880) || 6,378,249.145 || 6,356,514.87 || 293.465 || Africa || || NAD 27 || 6,378,206.4 || 6,356,583.8 || 294.9786982 || North America|| || NAD 83 || 6,378,137 || 6,356,752.3 || 298.2570249 || North America|| || WGS 84 || 6,378,137 || 6,356,752.314 || 298.2572236 || Global|| |
* Chapter 1: /SpatialReferenceSystems * Chapter 2: /SpaitalFeatures * Chapter 3: /SpatialDataTypes |
Geographic Information Systems Notes
In 2014, CPTR 521 used Pro Spatial with SQL Server 2012 to study spatial data in SQL Server 2012. This page documents that experience.
Chapter 1: /SpatialReferenceSystems
Chapter 2: /SpaitalFeatures
Chapter 3: /SpatialDataTypes