CartoDB PLpgSQL

INTRODUCTION

CartoDB uses a number of custom PLpgSQL functions to perform a few magical things. Those functions are accessible to users on CartoDB as well, so we would like to document what they are and what they do here.

Spatial functions

CDB_HexagonGrid - create hexagonal grid from extent and size

CDB_MakeHexagon - make a hexagon with given center and side

CDB_RectangleGrid - fill given extent with a rectangular coverage

Tile pyramid based

CDB_XYZ_Extent - Find the extent of a tile by XYZ

CDB_XYZ_Resolution - Find the pixel resolution of tiles

Statistical functions