GeometryOverlay Example: Buffer (Single Input) | Teradata Vantage - GeometryOverlay Example: Buffer (Single Input) - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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

Input

  • SourceTable: source_gatetype, which contains the geometrical coordinates of US and international gates in three airport terminals (A, B, and C), from GeometryOverlay Example: Intersection

SQL Call

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

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

Download a zip file of all examples and a SQL script file that creates their input tables.