Geometry and Geography – An Introduction to Geospatial Processing in SQL Server 2008
Steven Griffith of the Department of Planning and Building for the County of San Luis Obispo will share with us these new and powerful features of SQL Server that were added in Microsoft SQL Server 2005. Steven provided us with a synopsis and outline of what we can look forward to learning:
Geospatial technologies have touched everyone - from Google Maps to iPhone apps, this technology is making itself felt in new and interesting ways. Microsoft introduced "baked in" support for geospatial data processing with the Geometry and Geography User Defined Data types in SQL 2005 and 2008. We’ll take a quick look at these two new data types, what they are, what they represent and a peek behind the curtain of how to use them.
- Introduction to Geospatial Processing
a. Real world examples
b. Standards – Open Geospatial Consortium
- The Basics
a. Point, LineString and Polygon
b. MultiLineString, MultiPolygon
- What’s the difference?
a. SQLGeometry
b. SQLGeography
i. SRIDs
- Creating Spatial Data
a. Create table
b. Data Formats
i. Well-Known Text
ii. Well-Known Binary
iii. GML
- Basic Spatial Operations
a. Envelope & Buffers
b. Intersections
c. Access methods
- SQL Extended Functions
a. IsValid and MakeValid
- Creating a Spatial Index
Time: 5:30pm to 8:30pm
Location: Promega Biosciences
Address: 277 Granada Dr. - SLO
Google Map