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....

learn more… | top users | synonyms (1)

1
vote
1answer
19 views

make Carto torque points change over time start from begin date and disappear at end date

First time use the torque function... I have variables: IDnumber,start_date, end_date, size, longitude, latitude. Anyone know how to make carto torque points change depends on different dates? I want ...
0
votes
0answers
20 views

Combine cluster and categorical mapping on Cartodb

I came across this map that shows clusters but when you zoom in, the they split into points reflecting categorical data. How do I replicate this on cartodb?
0
votes
0answers
17 views

Updating dataset in Carto? [on hold]

I'm building a system where our users periodically add data to the system - it's "almost never" an update, but an ADD. If I was writing this in T-SQL or something I would create a temporary table ...
0
votes
0answers
10 views

Error while creating development user CartoDB

While creating development user I get this error: [pool] Found a connection for localhost:cartodb_dev_user_ec9cc5c4-2863-4fc6-acbf-95bcb52ea902_db:5432:postgres:sequel (4) (0.000178s) BEGIN PG::Error:...
0
votes
1answer
27 views

Odbc_fdw.control is missing

I am using cartoDB and Postgres 9.3 including PostGIS. When I try to create development user in cartoDB I get this error: 'CREATE EXTENSION IF NOT EXISTS odbc_fdw SCHEMA public;' ERROR: could not ...
-1
votes
0answers
10 views

Infowindow with various information

I have a data file with columns of cities and their data For example, Mexico / Contents 1 / Address1 Mexico / Contents 2 / Address2 Rio de Janeiro / Contents 3 / Address3 Rio de Janeiro / Contents 4/...
0
votes
1answer
22 views

Filling Colors for Some Countries in Carto

I imported the "world borders" from the data set library in Carto. I want to fill/highlight some countries (say United States, Africa and Europe) with the same color but not all countries. How can I ...
0
votes
0answers
10 views

Command Line/Postico access to CartoDB's hosted Postgres instance

I'm using CartoDB's hosted offering; and wanted to know if ... I can connect via a tool such as Postico or TOAD to connect directly to the Postgres server? ... I can create triggers and stored ...
0
votes
1answer
30 views

Make certain countries visible on Carto map

I want to show only APAC countries on the carto map. I re-wrote my SQL query (see below) and clicked 'create a dataset from query'. Although the countries specified were coded in colors, those outside ...
0
votes
1answer
31 views

carto.com when 2 points have the same location

Carto.com: We are mapping homicides and when two deaths occur at the same location, how do I prevent 2 points with the same lat, lon from overwriting each other? I want to be able to view each point ...
1
vote
0answers
42 views

Georeference a dataset in Carto with imported data

I have a number of datasets (in CSV format) that I would like to upload into Carto - the issue is that the dataset with the postal code/georeference data is separate. I would like to upload my data ...
1
vote
1answer
32 views

Carto, Import API: Create/Delete datasets

I've been doing a lot of things lately with Carto, but I haven't been able to find the way to create or upload and delete datasets from my user. In the API I just can see how to add a dataset to my ...
0
votes
1answer
27 views

Cartodb - How to insert geojson data to table using SQL api?

I am currently using leaflet.js to generate polygons and I would like to add them to my table in cartodb. I.e. a geojson object : { "type": "Feature", "properties": { "name": "wing1" }, "...
0
votes
1answer
32 views

Cartodb Torque map

I cannot figure out how to use the torque map: A typical row of my data, which is named torquedata3, looks like : [nodenumber, lat,long,time,value]. I have multiple rows at the same time with each ...
0
votes
1answer
34 views

CartoDB- popup window not working

I am working on a project, and I have not worked with cartodb long, but there is something wrong with this code. It is supposed to display a little pop window showing the school district for that ...
0
votes
1answer
38 views

In cartodb, how to automatically update the_geom with new longitude and latitude?

I am currently posting new table row using the cartodb sql api with the following commands: update {table_name} set geom = ST_Transform(ST_SetSRID(ST_MakePoint(latitude, longitude),4326) latitude and ...
0
votes
1answer
18 views

Unable to import base layer onto Cartodb

I have been trying to import basemap (crm_hillshade) from this website http://www.ngdc.noaa.gov/wiki/index.php/WMS_Service_List onto Cartodb but it keeps showing error and the basemap is unable to ...
0
votes
2answers
59 views

Displaying Wales, England & N.Ireland instead of UK in CartoDB?

This might sound like a stupid question to you, but i'm struggling quite hard at the moment. I'm a journalist, and i would like to create a map to explain some things (about the countries that are ...
1
vote
1answer
41 views

Is there a stats dashboard on cartoDB (now carto)

I've been looking for an overview of map stats (how many views etc) on cartoDB (now carto). All I can find is the bar charts for each map in the gallery. Is there a page on the site that brings these ...
1
vote
1answer
49 views

Converting coordinates into Longitude/Latatitude form that CartoDB understands?

Does anyone know how to convert this infomation into longitude/latitude coordinates for georeferencing on cartodb? UTC: Posn: 03:00N – 105:10E LT: Posn: 01:28.0S – 116:48.0E LT: Posn: 08:44.7S - 013:...
2
votes
2answers
52 views

Changing color of pin icon marker on CartoDB?

I am interested to use the pin icon (see attached image) in my cartodb map (cluster type). Can someone tell me how do I change the color of the pin to reflect categorical data? I tried to click img ...
1
vote
2answers
28 views

Change Carto basemap font size?

I'm using the CartoDB static Maps API. I need to change the font size of the street names. E.g. in the image below the street name "Stanhope Road" needs to be bigger. Here's what my Json config ...
0
votes
1answer
26 views

Creating a basemap in WGS84

I am trying to create a base map suitable for overlaying data that is in SRS EPSG:4326 using CartoDB following the projections tutorial. I have other projections working, but not one for this. So ...
1
vote
1answer
33 views

CartoDB with KoboToolbox, Open Data Kit (ODK), Enketo, or Ona source data?

I'm trying to use survey data collected by Kobotoolbox with CartoDB. I've reviewed the API's docs (https://kc.kobotoolbox.org/api/v1/), and I'm doing my best to follow them to connect my survey's data,...
-1
votes
0answers
18 views

CartoDB Torque Cat

I've uploaded a dataset that includes a time column. In the wizard I can select and configure a Torque map and it works as expected. When I switch to a Torque Cat map the markers disappear. The legend ...
1
vote
0answers
21 views

Georeferencing postcodes into bubble map with Cartodb

I have recently discovered Cartodb and I am trying to create a bubble/thematic map of postcodes. I have a csv document with one column of postcodes from around the UK. I have uploaded the dataset and ...
1
vote
1answer
40 views

How to insert new data points into CartoDB map?

I'm using NASA api data to populate my database in CartoDB's website to load places where meteorites have fallen. In JavaScript I'm currently creating a specific collection of meteorites I want to ...
-3
votes
1answer
36 views

Updating CSV file in CartoDB?

How can I update a csv-file in cartoDB? When a csv-file is loaded into cartodb, it might contain errors in the data. E.g. some fields partially contain a wrong formtted date. After having cleaned ...
1
vote
1answer
28 views

Switching from “layer selector” to buttons to toggle between layers in CartoDB

As of now, we have a map that you can toggle between layers using the "layer selector". We want to instead have buttons on the map that, by clicking on one, you can switch between layers. In our's, ...
3
votes
0answers
34 views

CartoDB.js/Leaflet map - how can I click between multipolygons cleanly?

Here's my map: https://jsfiddle.net/Sidders/4exf969e/3/ I want to apply a click and hover effect to the polygons. So a polygon/multipolygon highlights on hover, and is selected with one click. The ...
0
votes
1answer
24 views

Carto DB city border polygons issue?

I want to visualize some statistical data about my country and I'm using the CartoDB geocoder. I've city names and I want to see cities as polygons but CartoDB says it has no polygon data, it can only ...
2
votes
2answers
66 views

How do I detect when “Map data not yet available”?

My app uses the CartoDB static map API to get a "center" map at zoom level 19 or 20. Most times it gets a good map, but depending where it's looking it sometimes gets a "Map data not yet available" ...
3
votes
1answer
44 views

Sync GeoJson to cartoDB?

Is there a way to sync GeoJSON files to my cartoDB table? If this is not yet supported, what would be the best way of implementing this feature (syncing the data frequently with the existing cartoDB ...
0
votes
1answer
30 views

CartoDB: Trigger InfoWindow from inside another InfoWindow

Is there a easy way (maybe even generic solution) to trigger opening the InfoWindow of Marker 1 from inside the InfoWindow of Marker 0? The goal would be to «jump» from marker to marker right from ...
1
vote
1answer
21 views

Can I split my data based on the polygons in a different layer?

Carto has a built-in dataset with polygon data for UK administrative regions. I have put another layer over this, containing several thousand data points (postcodes). Is there an easy way to find out ...
1
vote
1answer
56 views

Any ZXY satellite basemaps covering New Zealand at zoom 19?

I need a good satellite base map to use with CartoDB. It has to cover all of New Zealand at zoom 19, [edit:] and be as recent as possible so we can show recently-built properties. It doesn't have to ...
0
votes
1answer
30 views

Showing only 1 layer at a time in CartoDB

Is there a way in the free CartoDB to set the layer selector so that you can only select 1 layer at a time? When one layer is selected, deselect all other layers.
2
votes
0answers
15 views

-torque-resolution equivalent for static CartoDB maps

I'm trying to create a Torque map with tooltips. I couldn't see a way to create tooltips on Torque layers, so as a workaround I've created a separate static layer than can be toggled. Toggling this ...
1
vote
1answer
22 views

Cartodb-Displaying Mode and Averages in Infowindow

I have some Boolean and string variables that I want to display in the info window on carto db. But it seems to be only showing one individual data point. How do I get it to show modes or averages of ...
1
vote
1answer
24 views

Edit table or map metadata programmatically via API in CartoDB

I'm trying to automate the creation of datasets and maps with CartoDB. Now I would like to add the metadata information (source, attribution, description, etc). Is it possibile? I don't find this in ...
-1
votes
1answer
25 views

Cartodb Issues Regarding Toolbars

For some reason, the Cartodb software I'm using has no toolbar one the top left of the screen (the one with Add Element, etc.), and no toolbar on the bottom of the screen, where you can edit your map ...
2
votes
0answers
16 views

How to get road labels on Stamen Watercolor basemap in Cartodb

basic question here. I want to use the Stamen Watercolor basemap on CartoDB, but want the road and locality labels displayed on it, as at http://openlayers.org/en/latest/examples/stamen.html?q=...
2
votes
1answer
83 views

Adding CartoDB basemap to QGIS

I am trying to add a CartoDB basemap to QGIS and am 1) trying to figure out if it is possible and 2) trying to figure out how to do it. I've installed the QGIS CartoDB plug-in and have connected to ...
2
votes
1answer
39 views

Sync Google spreadsheet in Cartodb

I would like to syncronize a Google spreadsheet in my account in the CartoDB.com service, but the sync options are not available. I have found this in the documentation of Cartodb, but I have no ...
2
votes
1answer
33 views

Named map created with CartoDB Maps API not appearing in web interface dashboard

I am trying to learn how to use CartoDB and the CartoDB APIs - in particular the Maps API. I'm following along with the Named Maps Tutorial but I'm experiencing some confusion. When I create a named ...
1
vote
1answer
35 views

Using createLayer in CartoDB isn't working

So, the scenario is I have a situation where users can look up multiple tables worth of data, and want to view them in an aggregate fashion. Based on certain filters, I get a list of tables then want ...
1
vote
1answer
33 views

Mustache functions possible in CartoDB tooltip templates?

CartoDB.js uses the mustache.js library to render tooltip windows. One of the features of mustache.js is allows functions to be defined, which are called when the template is rendered. An example is ...
1
vote
1answer
24 views

How do I use orthophotos as basemap in CartoDB?

I have seen a java example of how to use a raster overlay in CartoDB, but what about replacing the basemap entirely with orthophotos? In the web GUI for selecting basemap there is an option for the ...
1
vote
1answer
87 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 ...
0
votes
1answer
20 views

Retaining custom CSS parts when editing using CartoDB GUI?

I have set a bunch of zoom-level settings in a cartdb map layer, i change opacity, line thickness, etc. however, when i go into the web GUI and do something simple like change the colour of a line, ...