
Analytics Toolbox for BigQuery
s2
Our S2 module is based on a port of the official s2 geometry library created by Google. For more information about S2 check the library’s website or the Overview section of this documentation.
S2_BOUNDARY
Description
Returns the boundary for a given S2 cell ID. We extract the boundary by getting the corner longitudes and latitudes, then enclose it in a GeoJSON and finally transform it into geography.
id
:INT64
S2 cell ID to get the boundary geography from.
Return type
GEOGRAPHY
Example
|
|
S2_FROMGEOGPOINT
Description
Returns the S2 cell ID of a given point at a given level of detail.
point
:GEOGRAPHY
point to get the ID from.resolution
:INT64
level of detail or zoom.
Return type
INT64
Example
|
|
S2_FROMHILBERTQUADKEY
Description
Returns the conversion of a Hilbert quadkey (a.k.a Hilbert curve quadtree ID) into a S2 cell ID.
hquadkey
:STRING
Hilbert quadkey to be converted.
Return type
INT64
Example
|
|
S2_FROMLONGLAT
Description
Returns the S2 cell ID for a given longitude, latitude and zoom resolution.
longitude
:FLOAT64
horizontal coordinate on the map.latitude
:FLOAT64
vertical coordinate on the map.resolution
:INT64
level of detail or zoom.
Return type
INT64
Example
|
|
S2_FROMTOKEN
Description
Returns the conversion of a token into a S2 cell ID.
token
:STRING
S2 cell hexified ID.
Return type
INT64
Example
|
|
S2_FROMUINT64REPR
Description
Returns the cell ID from a UINT64 representation.
uid
:STRING
UINT64 representation of a S2 cell ID.
Return type
INT64
Example
|
|
S2_TOHILBERTQUADKEY
Description
Returns the conversion of a S2 cell ID into a Hilbert quadkey (a.k.a Hilbert curve quadtree ID).
id
:INT64
S2 cell ID to be converted.
Return type
STRING
Example
|
|
S2_TOTOKEN
Description
Returns the conversion of a S2 cell ID into a token (S2 cell hexified ID).
id
:INT64
S2 cell ID.
Return type
STRING
Example
|
|
S2_TOUINT64REPR
Description
Returns the UINT64 representation of a cell ID.
id
:INT64
S2 cell ID.
Return type
STRING
Example
|
|

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.