Revision 13809
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 739 | 739 |
|
| 740 | 740 |
CREATE FUNCTION bounding_box(latitude_range_deg range, longitude_range_deg range) RETURNS postgis.geometry |
| 741 | 741 |
LANGUAGE sql IMMUTABLE |
| 742 |
SET search_path TO postgis |
|
| 743 | 742 |
AS $_$ |
| 744 |
SELECT st_makebox2d( |
|
| 745 |
/*pointLowLeft=*/st_point(/*x_lon=*/$2.lower, /*y_lat=*/$1.lower) |
|
| 746 |
, /*pointUpRight=*/st_point(/*x_lon=*/$2.upper, /*y_lat=*/$1.upper) |
|
| 747 |
)::geometry |
|
| 743 |
/* don't use st_makebox2d() because it doesn't support geocoordinate wraparound |
|
| 744 |
(it is not SRID-aware) */ |
|
| 745 |
SELECT postgis.st_makeenvelope( |
|
| 746 |
/*xmin=*/$2.lower, /*ymin=*/$1.lower |
|
| 747 |
, /*xmax=*/$2.upper, /*ymax=*/$1.upper |
|
| 748 |
) |
|
| 748 | 749 |
$_$; |
| 749 | 750 |
|
| 750 | 751 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: bounding_box(): use st_makeenvelope() instead of st_makebox2d() because st_makebox2d() doesn't support geocoordinate wraparound (it is not SRID-aware)