New answers tagged

2

Instead of a marker you can generate a buffer, setting each category (metro, tam and bus) to a numeric field (1000, 750 and 500). Then run the following queries: SELECT cartodb_id, ST_Transform( ST_Buffer(the_geom::geography, 1000)::geometry ,3857 ) AS the_geom_webmercator FROM table_name WHERE field_name ilike 'metro'; SELECT ...


1

Building your own solution might actually not be as hard as you think. All you would have to do is register a moveend event and then call getBounds() or getBoundsZoom() (in case the zoom level is important). Then you send this extent to your database and query all the points that fall within it. Of course you need a database that understands geospatial ...


1

This will not be ideal, but it will produce results, and you could refine it to produce something closer to an idea result with some custom code: add a column to your table ALTER TABLE foo ADD COLUMN geohash varchar populate it with the geohash UPDATE foo SET geohash = ST_Geohash(geom) query for different overview levels using substrings of the geohash ...



Top 50 recent answers are included