-- Name: bounding_box__no_dateline(range, range); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION bounding_box__no_dateline(latitude_range_deg range, longitude_range_deg range) RETURNS postgis.geometry

    LANGUAGE sql IMMUTABLE

    AS $_$

/* don't use st_makebox2d() because it doesn't support geocoordinate wraparound

(it is not SRID-aware) */

SELECT postgis.st_makeenvelope(

  /*xmin=*/$2.lower, /*ymin=*/$1.lower

, /*xmax=*/$2.upper, /*ymax=*/$1.upper

, /*WGS84*/4326

)

$_$;

--

-- Name: FUNCTION bounding_box__no_dateline(latitude_range_deg range, longitude_range_deg range); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION bounding_box__no_dateline(latitude_range_deg range, longitude_range_deg range) IS '

the generated bounding box is more accurate than util.bounding_box() (latitude

lines will be straight), but geocoordinate wraparound is not supported

usage:

SET search_path = util; -- for ~ operator

SELECT util.bounding_box__no_dateline(lower_lat ~ upper_lat, lower_long ~ upper_long);

';

--