Solution 1. Enter the following in the CartoDB editor's "CSS" tab
#your_data_layer{
marker-line-width: 0;
marker-line-opacity: 0;
marker-fill-opacity: 1;
marker-fill: #FF6600;
marker-type: ellipse;
marker-width: 8;
marker-allow-overlap: true;
[zoom > 10] {
[zoom = 11] { marker-width: 16;}
[zoom = 12] { marker-width: 32;}
[zoom = 13] { marker-width: 64;}
[zoom = 14] { marker-width: 128;}
[zoom = 15] { marker-width: 256;}
[zoom = 16] { marker-width: 512;}
[zoom = 17] { marker-width: 1024;}
[zoom >= 18] { marker-width: 2048;}
}
}
This makes the marker for the data the same size (in map units) when the user is zoomed in past the 10 level. Every zoom level is a doubling of the map scale (i.e. the same distance on the ground takes up twice as much distance on the screen as the preceding lower zoom level), therefore you have to double the size of the markers (which are specified in pixels) with every higher zoom level in order that the marker remain the same size in map units.
Solution 2, enter this in the CartoDB editor's "CSS" tab:
#your_data_layer{
marker-line-width: 0;
marker-line-opacity: 0;
marker-fill-opacity: 1;
marker-fill: #FF6600;
marker-type: ellipse;
marker-width: 8;
marker-allow-overlap: true;
[zoom > 10] {
marker-fill-opacity: 0;
}
}
This simply does not render the data (because we have set the opacity to zero) when the user is zoomed in too close (> zoom level 10 in this example).