Revision 13816
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 758 | 758 |
usage: |
| 759 | 759 |
SET search_path = util; -- for ~ operator |
| 760 | 760 |
SELECT util.bounding_box(lower_lat ~ upper_lat, lower_long ~ upper_long); |
| 761 |
|
|
| 762 |
**WARNING**: the geography type stores all edges as arcs of great circles, |
|
| 763 |
resulting in the latitude lines bulging outward from the true bounding box. |
|
| 764 |
this will create false positives above and below the bounding box. |
|
| 761 | 765 |
'; |
| 762 | 766 |
|
| 763 | 767 |
|
Also available in: Unified diff
schemas/util.sql: bounding_box(): documented that the geography type stores all edges as arcs of great circles, resulting in the latitude lines bulging outward from the true bounding box. this will create false positives above and below the bounding box.