ST_AsOverpassBbox

Signature

VARCHAR ST_AsOverpassBbox(GEOMETRY geom);

Description

Return a string representation of the envelope of geom, conform to the Overpass API format : South, West, North, East → Y_Min, X_Min, Y_Max, X_Max.

Examples

With a `POINT`

SELECT ST_AsOverpassBbox('POINT(1 2)');
-- Answer: 2.0,1.0,2.0,1.0

With a `LINESTRING`

SELECT ST_AsOverpassBbox('LINESTRING(1 1, 5 5)');
-- Answer: 1.0,1.0,5.0,5.0

With a `LINESTRING` parallel to the x-axis

SELECT ST_AsOverpassBbox('LINESTRING(1 1, 5 1, 9 1)');
-- Answer: 1.0,1.0,1.0,9.0

With a `MULTIPOINT`

SELECT ST_AsOverpassBbox('MULTIPOINT(1 2, 3 1, 2 1, 5 1, 1 -1)');
-- Answer: -1.0,1.0,2.0,5.0

With a `GEOMETRYCOLLECTION`

SELECT ST_AsOverpassBbox('GEOMETRYCOLLECTION(
                               MULTIPOINT(1 2, 2 1, 1 -1),
                               LINESTRING(3 -1, 5 1),
                               POLYGON((2 2, 4 3, 3 1, 2 2)))');
-- Answer: -1.0,1.0,3.0,5.0

With SRID in the query

select ST_AsOverpassBbox(ST_Expand('SRID=4326;POINT(-2.781140 47.643182)'::GEOMETRY, 10))

-- Answer: 37.643182,-12.78114,57.643182,7.218859999999999

See also

OSMRead, ST_OSMMapLink, ST_OSMDownloader, ST_OverpassDownloader

Source code