So the problem is that I have a set of multipolygons and points and I need to be able to query the data with a given point to check which ones are within 'x' km.
Initially my SRID was 4283 but I was unable to figure out a way to use the PtDistWithin function with meters as it used degrees. I tried loading the data with a SRID of 3577 which should be in meters and querying but I don't get a sensible result. The query below is my attempt to get the data with 3577 SRID data.
select * from geotable where PtDistWithin(Transform(PointFromText('POINT(144.963, -37.8136)', 4283), 3577), geotable.geom, 10000);
This however does not return any result when I know there should be a number of results returned within 10 km of this point.
Note: I know there is an approximate conversion between degrees and meters but am looking for a cleaner solution.