assuming I use the following query to match the locations to a poi within 10km distance:
SELECTpoi.poi_id,h.loc_id,(ST_Distance(poi.geom,h.geom)*111.111) as distanceinkmFROM iut_poi_transl AS poi, hrs_loc as hWHERE poi.poigr_id != 30 AND ST_DWithin(poi.geom,h.geom,0.09)Data is SRID 4326.
Does...