Question: How can I get the range to query (like in the Carto blog)

[ethlo]

Having a bounding box I want to limit by, how do I get the quadkey range to use for the SQL query?

SELECT count(1)
FROM a2
WHERE ((quadkey >= 1013670044871163904) AND (quadkey <= 1013670049166131200)) AND ((pow(pickup_longitude - -73.985195, 2) + pow(pickup_latitude - 40.75896, 2)) < pow((180 * 300) / ((6371 * 1000) * pi()), 2))

https://carto.com/blog/inside/geospatial-processing-with-clickhouse/