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.
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?