1.0 - 8.00 - GeometryOverlay Example 3: Buffer (Single Input) - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

This example uses the buffer operator to expand the US or international gates by a distance of 2.

Input

Input tables are from GeometryOverlay Example 1: Intersection:

  • source: source_gatetype, which contains the geometrical coordinates of US and international gates in three airport terminals (A, B, and C)
  • reference: ref_terminal, which contains the terminal coordinates in WKT syntax

SQL Call

SELECT * FROM GeometryOverlay (
  ON source_gatetype AS source
  USING
  SourceLocationColumn ('boundary_coordinates')
  BoundaryOperator ('buffer')
  Distance (2)
  Accumulate ('boundary_name', 'id')
) AS dt ORDER BY 3;

Output

overlay_boundary boundary_name id
POLYGON ((10 8, 9.609819355967742 8.03842943919354, 9.234633135269819 8.152240934977428, 8.888859533960796 8.33706077539491, 8.585786437626904 8.585786437626904, 8.337060775394908 8.888859533960796, 8.152240934977426 9.23463313526982, 8.03842943919354 9.609819355967744, 8 10, 8 20, 8.03842943919354 20.390180644032256, 8.152240934977426 20.76536686473018, 8.33706077539491 21.111140466039203, 8.585786437626904 21.414213562373096, 8.888859533960796 21.66293922460509, 9.23463313526982 21.847759065022572, 9.609819355967744 21.96157056080646, 10 22, 20 22, 20.390180644032256 21.96157056080646, 20.76536686473018 21.847759065022572, 21.111140466039206 21.66293922460509, 21.414213562373096 21.414213562373096, 21.66293922460509 21.111140466039203, 21.847759065022572 20.76536686473018, 21.96157056080646 20.390180644032256, 22 20, 22 10, 21.96157056080646 9.609819355967744, 21.847759065022572 9.23463313526982, 21.66293922460509 8.888859533960796, 21.414213562373096 8.585786437626904, 21.111140466039206 8.33706077539491, 20.76536686473018 8.152240934977426, 20.390180644032256 8.03842943919354, 20 8, 10 8)) Domestic Gates 1
POLYGON ((50 48, 49.609819355967744 48.03842943919354, 49.23463313526982 48.15224093497743, 48.8888595339608 48.33706077539491, 48.58578643762691 48.58578643762691, 48.33706077539491 48.8888595339608, 48.15224093497743 49.23463313526982, 48.038429439193536 49.609819355967744, 48 50, 48 150, 48.038429439193536 150.39018064403226, 48.15224093497743 150.76536686473017, 48.33706077539491 151.11114046603922, 48.58578643762691 151.4142135623731, 48.8888595339608 151.66293922460508, 49.23463313526982 151.8477590650226, 49.609819355967744 151.96157056080645, 50 152, 150 152, 150.39018064403226 151.96157056080645, 150.76536686473017 151.8477590650226, 151.11114046603922 151.66293922460508, 151.4142135623731 151.4142135623731, 151.66293922460508 151.11114046603922, 151.8477590650226 150.76536686473017, 151.96157056080645 150.39018064403226, 152 150, 152 50, 151.96157056080645 49.609819355967744, 151.8477590650226 49.23463313526982, 151.66293922460508 48.8888595339608, 151.4142135623731 48.58578643762691, 151.11114046603922 48.33706077539491, 150.76536686473017 48.15224093497743, 150.39018064403226 48.038429439193536, 150 48, 50 48)) International Gates 2