# Analytics Toolbox for Snowflake

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].

Return type

ARRAY

Example

 1 2 3 4 5 SELECT carto.QUADINT_BBOX(4388); -- 22.5 -- -21.943045533438177 -- 45.0 -- 0.0

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.

Return type

GEOGRAPHY

Example

 1 2 SELECT carto.QUADINT_BOUNDARY(4388); -- POLYGON((22.5 0, 22.5 -21.9430455334382, 22.67578125 ...

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

 1 2 SELECT carto.QUADINT_FROMGEOGPOINT(ST_POINT(40.4168, -3.7038), 4); -- 4388

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

 1 2 SELECT carto.QUADINT_FROMLONGLAT(40.4168, -3.7038, 4); -- 4388

Description

Return type

BIGINT

Example

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

 1 2 SELECT carto.QUADINT_FROMZXY(4, 9, 8); -- 4388

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

 1 2 3 4 5 6 7 8 9 10 SELECT carto.QUADINT_KRING(4388, 1); -- 3844 -- 3876 -- 3908 -- 4356 -- 4388 -- 4420 -- 4868 -- 4900 -- 4932

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

 1 2 3 4 5 6 7 8 9 10 SELECT carto.QUADINT_KRING_DISTANCES(4388, 1); -- {"index": "4388", "distance": "0"} -- {"index": "4932", "distance": "1"} -- {"index": "4900", "distance": "1"} -- {"index": "4868", "distance": "1"} -- {"index": "4420", "distance": "1"} -- {"index": "4356", "distance": "1"} -- {"index": "3908", "distance": "1"} -- {"index": "3876", "distance": "1"} -- {"index": "3844", "distance": "1"}

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

 1 2 3 4 5 6 7 SELECT carto.QUADINT_POLYFILL(ST_MAKEPOLYGON(TO_GEOGRAPHY('LINESTRING(-3.71219873428345 40.4133653490709, -3.71440887451172 40.4096566128639, -3.70659828186035 40.4095259047756, -3.71219873428345 40.4133653490709)')), 17); -- 207301334801 -- 207305529105 -- 207305529073 -- 207305529137 -- 207305529169 -- 207301334833

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.

• direction: STRING ‘right’|‘left’|‘up’|‘down’ direction to move in to extract the next sibling.

Return type

BIGINT

Example

 1 2 SELECT carto.QUADINT_SIBLING(4388, 'up'); -- 3876

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.

• resolution: INT resolution of the desired children.

Return type

ARRAY

Example

 1 2 3 4 5 SELECT carto.QUADINT_TOCHILDREN(1155, 4); -- 4356 -- 4868 -- 4388 -- 4900

Description

• resolution: INT resolution of the desired parent.

Return type

BIGINT

Example

 1 2 SELECT carto.QUADINT_TOPARENT(4388, 3); -- 1155

Description

Return type

STRING

Example

Description

Returns the zoom level z and coordinates x, y for a given quadint.