How can I represent overlapping geometries located at the same position
There are many solutions to solve the “overlapping points problem” in CARTO Builder. Points can be aggregated using hexbin, square, or administrative regions styling methods and intersect analysis, or group them, getting the centroids by categories or geometries. More complicated hacks, involving SQL and CartoCSS involve stacking them as casino chips and aggregating them using json_agg
PostgreSQL function.