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 it use the geometry or the geography type?
If uses geometry how do I have to change the query to get use geography type?
أكثر...
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 it use the geometry or the geography type?
If uses geometry how do I have to change the query to get use geography type?
أكثر...