The table that i want to perform this query has 3 columns: id, the_geom and seen_count.
The query i've been using to get points inside a bounding box is as follows:
SELECT id, ST_AsGeoJSON(the_geom) FROM table WHERE ST_Contains(ST_MakeEnvelope({0}, {1}, {2}, {3}, 4326), table.the_geom)
What i want to do is: selecting points, which are transformed to circles using their seen_count as radius, intersect with bounding box. Is it possible? If so, would it be an expensive query? Thanks in advance.