So I have a table of points and a table of polygons (geometry types).
In my php, I will have a given point and need to find the corresponding shape. So logically doing something like;
Should yield the shape ID and Shape that contains the point. It however returns no matches.Code:SELECT hb.`OGR_FID`, hb.`SHAPE` FROM boundaries hb WHERE ST_Within(Point(43.670913, -79.346739), hb.`SHAPE`);
Any idea what I'm doing wrong here?