This technical presentation offers a detailed walkthrough of Teradata's Geospatial features using basic geometry shapes. With points, lines and polygons, we demonstrate the power of our geospatial analytical functions using easy to understand SQL examples.

Key Points - Module 1

  • Teradata 13 integrates Geospatial features directly into the database that can be easily accessed with SQL
  • The new ST_Geometry field supports shapes such as points, lines, curves and polygons
  • Teradata also includes a powerful library of spatial functions such as calculating length, distance and areas as well as comparing spatial objects such as does one object contain another, do they intersect, etc.

Module 2

Module 2 takes the foundations learned in Module 1 and applies them to the real world. Geographic coordinates are introduced along with some background history on coordinate reference systems. The UTM mapping system is introduced as our means of transforming Longitude/Latitude coordinates into projects that can be used for calculating distance. Some real world scenarios are used as examples of how adding geospatial location and data to business data can yield valuable results.

Key Points - Module 2

  • Introduction to mapping and transformations
  • Retail and insurance examples
  • Importing/Exporting Data

Presenter: Michael Riordan, Product Manager - Teradata Corporation

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.
Course number:44884
Training URL:
Format:Recorded webcast
Credit hours:1.00