
Analytics Toolbox for Snowflake
quadkey
You can learn more about quadkeys and quandints in the Overview section of the documentation.
QUADINT_BBOX
Description
Returns an array with the boundary box of a given quadint. This boundary box contains the minimum and maximum longitude and latitude. The output format is [West-South, East-North] or [min long, min lat, max long, max lat].
quadint
:BIGINT
quadint to get the bbox from.
Return type
ARRAY
Example
|
|
QUADINT_BOUNDARY
Description
Returns the boundary for a given quadint. We extract the boundary in the same way as when we calculate its QUADINT_BBOX, then enclose it in a GeoJSON and finally transform it into a geography.
quadint
:BIGINT
quadint to get the boundary geography from.
Return type
GEOGRAPHY
Example
|
|
QUADINT_FROMGEOGPOINT
Description
Returns the quadint of a given point at a given level of detail.
point
:GEOGRAPHY
point to get the quadint from.resolution
:INT
level of detail or zoom.
Return type
BIGINT
Example
|
|
QUADINT_FROMLONGLAT
Description
Returns the quadint representation for a given level of detail and geographic coordinates.
longitude
:DOUBLE
horizontal coordinate of the map.latitude
:DOUBLE
vertical coordinate of the map.resolution
:INT
level of detail or zoom.
Return type
BIGINT
Example
|
|
QUADINT_FROMQUADKEY
Description
Returns the quadint equivalent to the input quadkey.
quadkey
:STRING
quadkey to be converted to quadint.
Return type
BIGINT
Example
|
|
QUADINT_FROMZXY
Description
Returns a quadint from z
, x
, y
coordinates.
z
:INT
zoom level.x
:INT
horizontal position of a tile.y
:INT
vertical position of a tile.
Constraints
Tile coordinates x
and y
depend on the zoom level z
. For both coordinates, the minimum value is 0, and the maximum value is two to the power of z
, minus one (2^z - 1
).
Return type
BIGINT
Example
|
|
QUADINT_KRING
Description
Returns all cell indexes in a filled square k-ring centered at the origin in no particular order.
origin
:BIGINT
quadint index of the origin.size
:INT
size of the ring (distance from the origin).
Return type
ARRAY
Example
|
|
QUADINT_KRING_DISTANCES
Description
Returns all cell indexes and their distances in a filled square k-ring centered at the origin in no particular order.
origin
:BIGINT
quadint index of the origin.size
:INT
size of the ring (distance from the origin).
Return type
ARRAY
Example
|
|
QUADINT_POLYFILL
Description
Returns an array of quadints that intersect with the given geography at a given level of detail.
geography
:GEOGRAPHY
geography to extract the quadints from.resolution
:INT
level of detail or zoom.
Return type
ARRAY
Example
|
|
QUADINT_SIBLING
Description
Returns the quadint directly next to the given quadint at the same zoom level. The direction must be sent as argument and currently only horizontal/vertical movements are allowed.
quadint
:BIGINT
quadint to get the sibling from.direction
:STRING
‘right’|‘left’|‘up’|‘down’
direction to move in to extract the next sibling.
Return type
BIGINT
Example
|
|
QUADINT_TOCHILDREN
Description
Returns an array with the children quadints of a given quadint for a specific resolution. A children quadint is a quadint of higher level of detail that is contained within the current quadint. Each quadint has four children by definition.
quadint
:BIGINT
quadint to get the children from.resolution
:INT
resolution of the desired children.
Return type
ARRAY
Example
|
|
QUADINT_TOPARENT
Description
Returns the parent quadint of a given quadint for a specific resolution. A parent quadint is the smaller resolution containing quadint.
quadint
:BIGINT
quadint to get the parent from.resolution
:INT
resolution of the desired parent.
Return type
BIGINT
Example
|
|
QUADINT_TOQUADKEY
Description
Returns the quadkey equivalent to the input quadint.
quadint
:BIGINT
quadint to be converted to quadkey.
Return type
STRING
Example
|
|
QUADINT_TOZXY
Description
Returns the zoom level z
and coordinates x
, y
for a given quadint.
quadint
:BIGINT
quadint we want to extract tile information from.
Return type
OBJECT
Example
|
|