Questions tagged [carto]

CARTO empowers any organization and individual to discover and predict key insights through location data. With CARTO’s intuitive location intelligence platform anyone can build self-service location based apps that help optimize operational performance, strategic investments, and everyday decisions.

Filter by
Sorted by
Tagged with
2
votes
3answers
1k views

how to enable interactivity on named map in cartodb

I have created a named map that gets data from a private table. I can load it into a Leaflet map and can change its marker-fill color placeholder using layer.setParams. However, I cannot get ...
2
votes
1answer
202 views

CartoDB: Can I use some “if..then” structure or “loop” structure in popup custom HTML?

In CartoDB (https://carto.com/)'s popup CustomHTML, can I use some logic like "If..then", "loop" or so? I want to use it for usecase something like below: Avoiding representation if attributes are ...
1
vote
2answers
402 views

How could you calculate the distance between multiple associated points, specifically a list of structures serving specific addresses within CartoDB?

I have loaded two point datasets into CartoDB. The first is a list of structures serving specific addresses, each structure has a unique code associated to it as well as the location of the structure ...
1
vote
2answers
76 views

BC Dates on cartodb.com?

I'm trying to use historical dates to build a torque map on Cartodb.com, with data going back to 8000 BC. But the date format doesn't seem to convert anything bellow 0100 01 01 (1st Jan 100 AD), and I'...
1
vote
1answer
222 views

how to combine chloropleth, bubble and cluster designs in CARTO?

To be concrete, I have a map of election results by precinct. As I do not have shapefiles for the precincts, I geocoded the polling places, but many precincts share polling places. I have the ...
1
vote
4answers
1k views

Unable to make infowindow work in CartoDB runtime layer

I'm trying to personalize a layer created with CartoDB. The layer is created at runtime and the problem is that I cannot make work even easy things like custom infowindow or legends or click ...
1
vote
2answers
1k views

Moving legend with CartoDB.js?

I'm wondering if it's possible to move the position of legend when using CartoDB.js. I can see in the layer api I can turn it on or off, but ideally I'd like to be able to specify a div for it to be ...
1
vote
1answer
521 views

Why is torque not working with large polygons?

It seems that torque isn't working with a "big" polygon. By "big" I mean the size of a french department. Could you confirm that? I would like to show the evolution of jobless rate during the last 30 ...
1
vote
2answers
2k views

Dynamic content in infoWindow

I am trying to add some dynamic content to my infoWindow. The following code writes the string 'bar' to the element. However this works for the infoWindow of some points, but not for others (content ...
0
votes
1answer
758 views

Migrating from CARTO Editor TO CARTO Builder and problem with odyssey.js (viz.json)

In odyssey.js you have: -vizjson: URL like this "//username.cartodb.com/u/usernanme/api/v2/viz/key/viz.json" The first thing we want to do is bring the CartoDB Visualization we created into the ...
0
votes
1answer
291 views

Dynamic rendering on a layer with a long SQL query

I have a question on dynamic rendering with the CartoDB APIs. These APIs are new for me. Data is a big layer stored in CartoDB (about 30 000 polygons). In my application the default rendering of ...
0
votes
1answer
2k views

How to set the visibility range of layers on CartoDB using CartoCSS?

I would like to customise the visibility of different layers on a CartoDB webmap so that they appear and disappear at distinct zoom levels. How is this achieved?
0
votes
1answer
613 views

Setting a polygon-fill ramp to have minimum and maximum values

Using the Carto web-tool I've set up a map to fill polygons based on the value of one of its attributes. However, due to outliers in the data the attributes range in values from 0 to >600, where as I ...
5
votes
1answer
2k views

Adding CartoDB basemap in OpenLayers 3?

I'm trying to add a CartoDB basemap to my OpenLayers map but I can't get it to work. Here is the code I use to declare the basemap variable: const carto = new ol.layer.Tile({ source: new ol....
4
votes
1answer
857 views

Getting distance from point to nearest line string

I am trying to use st_distance to find the nearest line string to a point. I have two tables in cartodb one is a table of points and the other table is poly lines. To see if I had the logic right I ...
4
votes
2answers
350 views

Overwrite a table in CartoDB

I need to overwrite a table in CartoDB using the Import API, but the system instead of overwriting the table, it creates another one with the same name and attaches an id auto-generated. For instance:...
4
votes
2answers
450 views

Text codes keep coming in as numbers, stripping out leading zeros

I'm trying to merge census tract data with a census tract shapefile in CartoDB. Despite saving the tract ID codes as text/string in both .csv and .xlsx (including reimporting the .csv as text into ...
3
votes
1answer
2k views

Create links between points on CartoDB

I have two tables on CartoDB. The first one (with name "points_table") has 4 columns. Country Name (name: country) Lat (name: lat) Long (name: long) the_geom (lat + long) The second one (with name "...
3
votes
2answers
184 views

How to make a fixed block of text in cartodb instead of infowindows?

I started to use CartoDB today for a school project, it is here : https://elenab.cartodb.com/viz/3c08e76a-ec4a-11e5-8d14-0ecfd53eb7d3/public_map But what I would like to do is to have a block of text ...
3
votes
1answer
205 views

Does CartoDB support alphabets other than Latin?

Does anyone know if CartoDB supports alphabets other than Latin? I'm trying to upload some data with Cyrillic characters but have had no success.
3
votes
1answer
277 views

Can I get a .jpg from a CartoDB map created in the editor without using a browser?

Edit I'm actually starting to suspect that I can't get a .jpg image from a map created with the UI editor without using a browser. I think I might have to use the API to re-create the map my ...
3
votes
1answer
1k views

Leaflet Maps Sync problem

I am trying to sync 3 maps (BaseMapd, overlayMap, tiledMap) side by side however these maps don't sync together immediately but it works sometimes during different multiple browsers (Chrome, Firefox &...
2
votes
1answer
240 views

Why would an SVG output from CartoDB look “squished” when the map doesn't?

I have a map of zipcodes in San Francisco that I plotted on CartoDB.The CartoDB view looks about like I expected: But when I had CartoDB generate an SVG, the proportions are way off. I took the ...
2
votes
1answer
300 views

Build legend in CartoDB using createLayer

I'm not using createVis, but rather createLayer to generate my maps on the fly, but can't seem to figure out how to add a legend using something simple like legends: true, which is available when ...
2
votes
2answers
344 views

Is there a way in Cartodb.js to include an autcomplete search bar?

I am using the code below to add a search bar to my mapping application, is there a way to include an autocomplete search bar? Something that would provide suggestions based on what the user is typing?...
2
votes
1answer
762 views

How does one use leaflet layergroups with CartoDB layers?

I'm trying to use leaflet layergroups with a cartodb layer, ala: http://leafletjs.com/reference.html#layergroup but haven't been able to successfully do it. This is what I have so far: var map = ...
2
votes
1answer
527 views

Ordering Cartodb torque visualization over Google Maps heatmap layer

I am attempting to create a map with two layers: a CartoDB Torque visualization on top and a Google heatmap layer underneath. So far I have only been able to get them to draw in the opposite order I'...
2
votes
1answer
747 views

How to include data from other tables in the info-window in CartoDB

I have 3 layers(table_1,table_2,table_3) of data. In the info-window, which was created for the second layer. I would like to display one column of data from table_1 . When I used {{table_1.name}}to ...
2
votes
2answers
867 views

Example of how to display a Cartodb layer (using the layergroupid) after initializing a named map?

I have successfully created a named map. I can initialize the map (as seen here), and I do get the correct response. Now, to my problem. How do I show this layer (using the layergroupid I got as a ...
2
votes
1answer
155 views

Sunlight layer into CartoDB

I have a list of tweets on a torque map made with CartoDB. I want to add an additional layer that shows the sunlight around the world at certain times, similar to the Twitter #sunrise map found here. ...
2
votes
3answers
9k views

How do I reformat numbers to only show a certain number of significant digits in CartoDB?

I need to round numbers that are in my table in CartoDB, so that in the Map visualization infowindows I only show results to two decimal digits rather than the long decimals that are currently showing....
2
votes
1answer
332 views

Can I cross the dateline in CartoDB?

I've created a lovely route map in CartoDB, but one of the lines crosses the dateline (from Colorado to Guam, FWIW) and finds its way there by hitting the dateline north of Alaska, bouncing back ...
2
votes
1answer
474 views

How to find layergroupid

Somebody else in our CartoDB organisation has created a map. I need to use the Static Maps API to get a .jpg image from the map, as described here. I'll be storing the .jpg locally and serving it ...
1
vote
1answer
2k views

Using Aggregate and Infowindow in CartoDB

I'd like to use CartoDb to map historic addresses of a city (link to demo). Individual addresses are mapped as points on the map. Detailed information for each address point should be displayed in ...
1
vote
1answer
696 views

How to define Z dimension on table with PostGIS for import in TileMill?

I'm trying to reproduce the idea behind this blogpost from Mapbox, but with other data, for example the ne_10m_populated_places_simple dataset from Natural Earth. By adding a z-dimension to the data (...
1
vote
0answers
398 views

How to set interactivity on multiple columns in CartoDB?

I'm trying to create a sublayer with interactivity on it for a tooltip. The tooltip is going to need data from a column named plant_name. So I am setting the interactivity property as I create the ...
1
vote
1answer
682 views

Adding timeline play button in CARTO Builder?

I am using the new CARTO builder, trying to add a timeline with the time series widget. (something like this one: http://bl.ocks.org/csobier/cebdd47242d7ca98ec5e) However, a bar chart shows up, which ...
1
vote
1answer
2k views

In cartodb, how can I insert a new row in a table via API?

We've discovered cartodb and we want to use it in our project, but in the API documentation we've only seen the sql.execute() method (docs) in order to insert a now row in a table. Is this the way to ...
1
vote
1answer
302 views

Getting info from multiple rows in single popup of CartoDB?

If you have a table like this: Name | Item | State ---------|--------|----------- Alice | Apple | Alabama Ben | Banana | Alabama Caitlin | Cherry | California Assuming you have ...
1
vote
1answer
481 views

Carto: Markers being offset or cut-off on polygon & marker map

I am seeing artifacts and markers are getting cut-off on my map. Zooming in and out can also leave an 'imprint' of what the map looked like before - either for a few seconds or until you refresh the ...
1
vote
1answer
130 views

Is this a CartoDB named map?

I am a complete beginner with CartoDB. Somebody else in our organisation has created a CartoDB map of New Zealand. They created the map by interacting with the CartoDB web site. They didn't upload ...
1
vote
1answer
506 views

CartoDB, Choropleth and bucket numbers in skewed data sets

How can I maximise the number of buckets in the choropleth map? We have a data set range from 1-14 and 7 is the most # of buckets available in the wizard. Unfortunately, most of the data occurs ...
1
vote
2answers
459 views

Count of points within range of another point is all or nothing

I'm using this query in CartoDB to find the number of locations within a certain range of a set point: SELECT COUNT(*) FROM location_fusion_table where ST_DWithin(location_fusion_table.the_geom, ...
1
vote
1answer
997 views

How can you change the bubbles size on Torque in CartoDB

Is there any way to change the size of the bubbles on Torque (min-max)?
1
vote
1answer
434 views

vary bubble size and color in CartoDB Torque Cat

I'm trying to make an animated map using the Torque Cat feature in CartoDB editor. But I could not figure out how to edit the cartoCSS to vary both bubble size and color based on my dataset. I want ...
1
vote
1answer
367 views

Can we hide/show a Torque layer and/or set SQL?

Is it possible to select a Torque layer that is part of a visualization? I am using CreateVis and creating button and layer selector so that the user can choose what appears on the map. However, the ...
1
vote
1answer
621 views

How to make infobox contents appear on mouseclick instead of mouseover

I'm using CartoJS to put one of my CartoDB maps on a div in an HTML file. When a user mouses over a dot on the map, info appears in the div next to the map container div. I want to change this so the ...
1
vote
1answer
156 views

CartoDB Infowindow createLayer with Layersource

I replicated an example of a layer with customized infowindows, but when I changed the source to a layer source object, the layers are loaded but the infowindow fails to show up. Any pointers.. http://...
1
vote
1answer
214 views

Synced CSV File Google Drive - Not Filling out Georeference field for visual

I Have a JS account on Cartodb with the sync option for data. I have created code to upload CSV file to Google Drive of all login activity of our Google Accounts for the last day. If I select this ...
1
vote
1answer
867 views

Adding multiple cartodb layers in viz.json to Leaflet layer control?

I have create a visualisation in cartodb with 4 layers. The resulting viz.json is added to a leaflet map as follows: cartodb.createLayer(cartomap, [url], {https:true}) .addTo(cartomap)...