I am trying to create a map where I have added a layer with place names. There are thousands of those in the database, and I am looking for a way to show only the most important ones on the lower zoom levels.
The CartoDB introduction has a good example of the problem with my map (notice that there are so many dots that the map can't be used for anything but seeing where people have given names to geographic features or where they live) http://docs.cartodb.com/tutorials/create_map_cartodbjs.html
In my database there is a column for place types, and I have added a min_zoom and a max_zoom column which I would like to use for filtering. The more you zoom in, the more place names are shown - based on the min and max zoom levels defined in the database.
Ideally I would be able to get zoom level as a variable to send to the database query.