Point inside a Polygon (Geospatial)

General
Fan

Point inside a Polygon (Geospatial)

Two questions:

1. What function can I use so that it would check if Location1 is inside Region1, and if yes return a value of 1 or 'True'? I am currently using Teradata 14.10.

Select

New ST_GEOMETRY('Point(149.5 -34.5)') As Location1,

New ST_GEOMETRY('Polygon((150 -35, 150 -34, 149 -34, 149 -35))') As Region1

 

2. If I have a table of points and a table of regions (a name field and a polygon field), how would I map all points to their respective regions?