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;
SELECT hb.`OGR_FID`, hb.`SHAPE`
FROM boundaries hb
WHERE ST_Within(Point(43.670913, -79.346739), hb.`SHAPE`);
Should yield the shape ID and Shape that contains the point. It however returns no matches.
Any idea what I'm doing wrong here?
Well, found the solution myself. Seems I had the lat/lng backwords. Point() requires the parameters Point(lng, lat)
This topic is now archived. It is frozen and cannot be changed in any way.