spatial data types
TRANSCRIPT
Geography Data Type• Added with SQL Server 2008• GPS/Round-Earth Coordinates• Requires:– Latitude– Longitude– SRID – Spatial Reference ID• What mapping system the coordinates belong to
Geometry Data Type• Added with SQL Server 2008• Flat-Plane (Euclidean) Coordinates• Multiple Options – Points, Lines, Curves, Collections