Set your layer styling to Graduated based on your first field, and set the method to Size.
Click Classify to set your symbol size class breaks. Make note of this classification!
Open the Symbol Settings and select the Simple marker in the list of symbol layers. Set this to the half-circle symbol style, and choose your desired color.
Right click the layer in ...
Carto uses the Mustache templating system for popups. They are "logic-less" however you can implement a bit of logic by bracketing the content you want given some condition using tags with # for "is true", ^ for "is false", and / as the closing tag.
Given the following data
Another option to circumvent CORS errors in a local installation is to use domainless URLs like http://local-installation/user/username/: https://cartodb.readthedocs.io/en/latest/configuration.html#domainless-urls
If the cartoDB and the webserver can share the same hostname and port.
Pre-built docker images like https://github.com/sverhoeven/docker-cartodb make it very easy to setup cartodb. docker run -d -p 80:80 -h localhost sverhoeven/cartodb will start a local instance accessible with http://localhost
You would need to extract the_geom and distance range from the isochrone function (= data_range) and transform the seconds to minutes.
WITH isochrone_result AS (
SELECT my_points_table.longitude, my_points_table.latitude, iso.the_geom, iso.data_range / 60 as drive_time
SELECT the_geom, ST_X(the_geom) as longitude, ...
Unfortunately, the only way to get data from your layer is sending an SQL API call pointing to the dataset source if you are using v3.15.
On the other hand, CARTO.js v4 and CARTO VL allows you to get data views without the need to make an API call yourself.
Firstly GeoJSON API expects that the geometry part of the GeoJSON data will come from the column called the_geom.
Secondly Leaflet expects the geometry to be in WGS84 coordinates, unless specifically specified to be different.
To address the above points you need to use the_geom column as input to ST_MakeLine (since it’s in WGS84), aliasing it to the_geom