|
Size: 2097
Comment:
|
Size: 2584
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 31: | Line 31: |
| * Longitude - 0-180 degrees east or west | * Longitude - 0-180 degrees east or west of the prime meridian |
| Line 34: | Line 34: |
=== Projected Coordinate Systems === Because we carry maps on flat surfaces (instead of geoids), the area of the world that we want to see on the map needs to be projected onto the Cartesian coordinate plane. '''Universal Transverse Mercator Projection''' is a grid composed of many projections laid side by side. Globe is sliced (north/south) into 60 strips (of 6 degrees each). Each strip is divided at the equator. E.g. Chattanooga, TN is in Zone 16N. |
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.
Spatial Reference Systems (SRS)
- 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 |
The above table demonstrates the Size/Shape characteristics of a SRS.
To complete the package we need reference points to place the ellipsoid in the correct position relative to the earth.
Definition [Spatial Reference System] A geodetic datum is made up of a reference ellipsoid and a set of reference points to position the ellipsoid relative to the earth.
Geographic Coordinate Systems
- Latitude - 0 degrees at equator, 90 degrees at the north pole, -90 degrees at the south pole.
- Longitude - 0-180 degrees east or west of the prime meridian
![[ATTACH]](/GeographicInformationSystems?action=AttachFile&do=upload_form&ticket=006859dc68.7b201087e5408092e536abde1f1ae82fbac969af&target=latlong.png "[ATTACH]"){kind=small}
Projected Coordinate Systems
Because we carry maps on flat surfaces (instead of geoids), the area of the world that we want to see on the map needs to be projected onto the Cartesian coordinate plane.
Universal Transverse Mercator Projection is a grid composed of many projections laid side by side. Globe is sliced (north/south) into 60 strips (of 6 degrees each). Each strip is divided at the equator. E.g. Chattanooga, TN is in Zone 16N.