PostGIS 3.6.2dev-r@@SVN_REVISION@@
Loading...
Searching...
No Matches

◆ ST_TileEnvelope()

Datum ST_TileEnvelope ( PG_FUNCTION_ARGS  )

Definition at line 2064 of file lwgeom_functions_basic.c.

2065{
2066 GSERIALIZED *bounds;
2067 uint32_t zoomu;
2068 int32_t x, y, zoom;
2069 uint32_t worldTileSize;
2070 double tileGeoSizeX, tileGeoSizeY;
2071 double boundsWidth, boundsHeight;
2072 double x1, y1, x2, y2;
2073 double margin;
2074 /* This is broken, since 3857 doesn't mean "web mercator", it means
2075 the contents of the row in spatial_ref_sys with srid = 3857.
2076 For practical purposes this will work, but in good implementation
2077 we should de-reference in spatial ref sys to confirm that the
2078 srid of the object is EPSG:3857. */
2079 int32_t srid;
2080 GBOX bbox;
2081 LWGEOM *g = NULL;
2082
2083 POSTGIS_DEBUG(2, "ST_TileEnvelope called");
2084
2085 zoom = PG_GETARG_INT32(0);
2086 x = PG_GETARG_INT32(1);
2087 y = PG_GETARG_INT32(2);
2088
2089 bounds = PG_GETARG_GSERIALIZED_P(3);
2090 /*
2091 * We deserialize the geometry and recalculate the bounding box here to get
2092 * 64b floating point precision. The serialized bbox has 32b float is not
2093 * precise enough with big numbers such as the ones used in the default
2094 * parameters, e.g: -20037508.3427892 is transformed into -20037510
2095 */
2096 g = lwgeom_from_gserialized(bounds);
2097 if (lwgeom_calculate_gbox(g, &bbox) != LW_SUCCESS)
2098 elog(ERROR, "%s: Unable to compute bbox", __func__);
2099 srid = g->srid;
2100 lwgeom_free(g);
2101
2102 /* Avoid crashing with old signature (old sql code with 3 args, new C code with 4) */
2103 margin = PG_NARGS() < 4 ? 0 : PG_GETARG_FLOAT8(4);
2104 /* shrinking by more than 50% would eliminate the tile outright */
2105 if (margin < -0.5)
2106 elog(ERROR, "%s: Margin must not be less than -50%%, margin=%f", __func__, margin);
2107
2108 boundsWidth = bbox.xmax - bbox.xmin;
2109 boundsHeight = bbox.ymax - bbox.ymin;
2110 if (boundsWidth <= 0 || boundsHeight <= 0)
2111 elog(ERROR, "%s: Geometric bounds are too small", __func__);
2112
2113 if (zoom < 0 || zoom >= 32)
2114 elog(ERROR, "%s: Invalid tile zoom value, %d", __func__, zoom);
2115
2116 zoomu = (uint32_t)zoom;
2117 worldTileSize = 0x01u << (zoomu > 31 ? 31 : zoomu);
2118
2119 if (x < 0 || (uint32_t)x >= worldTileSize)
2120 elog(ERROR, "%s: Invalid tile x value, %d", __func__, x);
2121 if (y < 0 || (uint32_t)y >= worldTileSize)
2122 elog(ERROR, "%s: Invalid tile y value, %d", __func__, y);
2123
2124 tileGeoSizeX = boundsWidth / worldTileSize;
2125 tileGeoSizeY = boundsHeight / worldTileSize;
2126
2127 /*
2128 * 1 margin (100%) is the same as a single tile width
2129 * if the size of the tile with margins span more than the total number of tiles,
2130 * reset x1/x2 to the bounds
2131 */
2132 if ((1 + margin * 2) > worldTileSize)
2133 {
2134 x1 = bbox.xmin;
2135 x2 = bbox.xmax;
2136 }
2137 else
2138 {
2139 x1 = bbox.xmin + tileGeoSizeX * (x - margin);
2140 x2 = bbox.xmin + tileGeoSizeX * (x + 1 + margin);
2141 }
2142
2143 y1 = bbox.ymax - tileGeoSizeY * (y + 1 + margin);
2144 y2 = bbox.ymax - tileGeoSizeY * (y - margin);
2145
2146 /* Clip the final tile bounds to the bounds of the tile plane */
2147 if (y1 < bbox.ymin) y1 = bbox.ymin;
2148 if (y2 > bbox.ymax) y2 = bbox.ymax;
2149 if (x1 < bbox.xmin) x1 = bbox.xmin;
2150 if (x2 > bbox.xmax) x2 = bbox.xmax;
2151
2152 PG_RETURN_POINTER(
2153 geometry_serialize(
2156 srid, x1, y1, x2, y2))));
2157}
LWGEOM * lwgeom_from_gserialized(const GSERIALIZED *g)
Allocate a new LWGEOM from a GSERIALIZED.
void lwgeom_free(LWGEOM *geom)
Definition lwgeom.c:1218
#define LW_SUCCESS
Definition liblwgeom.h:97
LWPOLY * lwpoly_construct_envelope(int32_t srid, double x1, double y1, double x2, double y2)
Definition lwpoly.c:98
int lwgeom_calculate_gbox(const LWGEOM *lwgeom, GBOX *gbox)
Calculate bounding box of a geometry, automatically taking into account whether it is cartesian or ge...
Definition lwgeom.c:755
LWGEOM * lwpoly_as_lwgeom(const LWPOLY *obj)
Definition lwgeom.c:329
double ymax
Definition liblwgeom.h:357
double xmax
Definition liblwgeom.h:355
double ymin
Definition liblwgeom.h:356
double xmin
Definition liblwgeom.h:354
int32_t srid
Definition liblwgeom.h:460

References LW_SUCCESS, lwgeom_calculate_gbox(), lwgeom_free(), lwgeom_from_gserialized(), lwpoly_as_lwgeom(), lwpoly_construct_envelope(), LWGEOM::srid, GBOX::xmax, GBOX::xmin, GBOX::ymax, and GBOX::ymin.

Here is the call graph for this function: