Query a Bounding Box in PostGIS

Jan 25, 2019

To query all records within a bounding box you can use the

SELECT
  *
FROM mytable
WHERE "location"
  && ST_MakeEnvelope ( xmin, ymin, xmax, ymax, 4326 );