CartoDB is a cloud based mapping, analysis and visualization engine for mobile and web

learn more… | top users | synonyms

0
votes
1answer
21 views

CartoDB choropleth + bubble visualization legend

I have been trying to display two values simultaneously i.e. one absolute value displayed by bubble size (as with layer wizard: bubble) and one relative value displayed by color (as with layer wizard: ...
0
votes
1answer
18 views

CartoDB polygon data for postal codes in Spain

I have been testing CartoDB for a little while and I can't get maps by postal codes in Spain. The system says "no polygon data available for your selection". But then I see some maps for Spain ...
0
votes
1answer
25 views

how to insert area of polygon into a column named area in a polygon map in cartodb?

SELECT ST_Area(the_geom) FROM cartodb_query gives the area but trying to insert it into an area column using: UPDATE cartodb_query SET area = ST_Area(the_geom) doesn't work.
0
votes
1answer
14 views

How do you set the extent of a CartoDB 'embed' map?

Using the basic CartoDB 'embed' option, how is the extent stored / saved / set for a map? For example: 1 CartoDB map (formerly 'visualization') has three potential pages on my blog / website ...
0
votes
0answers
25 views

Torque heatmap on CartoDB with time control

I am interested in create a Torque Heatmap in which you can see the events occured every year in one step, for twelve years in total. Every event has a aggregation or ponderation value (they are the ...
0
votes
1answer
14 views

Synced Table, updating the

I importing live data to CartoDB using Synced table feature which is updated hourly. I also applied simple SQL to the live synced table. However, the selection coming from SQL query would not be ...
0
votes
0answers
43 views

Adding a layer switcher using cartodb.js

I am trying to add the layer control (L.control.layers) to an application using cartodb.js (v. 3.14). The last line in the following code L.control.layers(basemaps).addTo(map); breaks the entire ...
0
votes
1answer
21 views

Error loading heatmap layer using cartodb.js

I'm trying to load a heatmap layer using cartodb.js, but it is failing whether I use createVis or the manual way. Using createVis: cartodb.createVis('mapDIV', 'https://PATH/viz.json'); Building a ...
0
votes
1answer
16 views

Update field the_geom name city in CartoDB?

With "update table set the_geom = cdb_latlng (lat , lon ) " I update the_geom field through latitude and longitude, but I also interested to know if there is any chance that instead of passing a ...
0
votes
0answers
25 views

Toggling layers with legends in CartoDB.js?

I created a map on the CartoDB website with multiple layers, each with its own legend. I now wish to use CartoDB.js to be able to toggle between the layers, so the legend will toggle on with the ...
1
vote
0answers
18 views

Network Diffusion Map

I am working on an interactive map which I vision to have a similar structure to diffusion networks. I have data to pin point an event and I would like to show those involved with said event, and ...
0
votes
1answer
23 views

Cartodb Toggle Layer help

I am working on a map that i'd like to toggle 1 layer off/on. I followed this http://academy.cartodb.com/courses/03-cartodbjs-ground-up/lesson-2.html tutorial and it worked fine(w/ their data) and i ...
0
votes
1answer
24 views

Make markers iteractive to show infowindow on click

I've used in my html file: var layerSource = { user_name: 'username', type: 'cartodb', sublayers: [{ sql: "SELECT * FROM post", ...
1
vote
1answer
17 views

Using CartoDB to change projection of maps - then exporting as SVG

This seems like a fairly simple question, but I've looked everywhere for the answer and can't find it. I've imported geoJSON UK constituency data into CartoDB and it looks great. I now want to export ...
0
votes
1answer
34 views

CartoDB basemaps using CartoDB.js with createLayer

I've created a map on the CartoDB site and now wish to add some interactivity using CartoDB.js. I'd like the interactive map to have the same basemap as on the CartoDB site, Nokia Hybrid Day. The ...
0
votes
0answers
18 views

TIFF image sequence in CartoDB?

I was wondering if it was possible to show a sequence of TIFF images (or similar format) in CartoDB as a backdrop to a heatmap of points.
0
votes
1answer
8 views

CartoDB - color polygons based on 2nd layer lat and long

I have nyc PLUTO map as layer one (parcel map showing polygons of building outlines) I have a second layer with Lat and Long identifying categories of buildings. I would like my layer one polygons to ...
0
votes
1answer
20 views

CartoDB Update API

Im uploading a csv with the following command: (attached) curl -v -F file=@/var/www/html/map.csv "https://account.cartodb.com/api/v1/imports/?api_key={apiKey}" I had item_queue_id from the response ...
0
votes
1answer
93 views

Am I thinking about layers all wrong?

I work for a non-profit health organization and I am currently testing out some GIS software to basically see what usefulness it might serve. My skill set with this software is pretty elementary, but ...
0
votes
2answers
42 views

Count number of points within certain ranges from a set of points

I have the following, which gives me the number of customers within 10000 meters of any store location: SELECT COUNT(*) as customer_count FROM customer_table c WHERE EXISTS( SELECT 1 FROM ...
0
votes
2answers
53 views

Points on Map overlapping/covering city and town names

I have a map with many points, these points map incidences of landmine accidents in Colombia. There are thousands of points and cover up parts of city and town names, in some cases the entire lables ...
0
votes
1answer
22 views

Get percentage based on counts

I have the following query which gives me two columns store and customer_count...one row per store. SELECT a.id AS store,count(b.*) AS customer_count FROM stores a, customers b WHERE ...
2
votes
1answer
76 views

Find number of points within certain radius of a set of points

I have two tables. One is a list of stores (with lat/long). The other is a list of customer addresses (with lat/long). What I want is a query that will return the number of customers within a certain ...
1
vote
0answers
14 views

cartodb edit markers

I'm using cartodb.js in my html file. I have this code: var layerSource = { user_name: 'myuser', type: 'cartodb', sublayers: [{ sql: "SELECT * FROM ...
0
votes
1answer
29 views

Adding spaces to CartoDB HTML

Is there a way to add a non-breaking space to CartoDB legends or info windows? For instance, I have the following legend: But now I would like to add some spaces to that legend. I used the ...
0
votes
0answers
33 views

Why won't my custom infowindows in cartodb work?

I'm trying to put custom infowindows on my Cartodb map, which is called by its vis.json in a web page. When the map first displays with "select * from p" the infowindows work, but after a query ...
0
votes
0answers
27 views

CartoDB example for Airport routes?

I am a developer and I wanted to make a website where I can draw route from on Airport location to another airport location. But the route should be using D3.js or carto db. I am new in this ...
0
votes
0answers
26 views

CartoDB map with charts dashboard

I'm trying to accomplish a very similar example like this one (map with charts on dashboards) http://bl.ocks.org/ohasselblad/33e5f5f6c72f2ec45e87 The only thing is that my values are strings and not ...
0
votes
1answer
24 views

Different color points with Torque

So! Really basic question. I want to make a Torque map – easy enough – but I want it to display the various datapoints in different colors depending on the value of annual_irr. Here's what I thought ...
0
votes
0answers
30 views

georeference at CartoDB

If I georeference New York (I do not have a country column) it only finds New York in the UK. This happens to a lot of other cities. What can I do to change that (except adding a country column)? Is ...
1
vote
1answer
26 views

Removing Dashed Borders of CartoDB Polygons

I've created a CartoDB map with a bunch of different multipolygons and it is displayed with a CartoCSS color ramp I created. However I've noticed that I cannot rid my map of the dashed lines that ...
2
votes
1answer
29 views

Reporting map mistake in Positron?

While displaying a Positron map from cartoDB, I noticed a mistake about a name (CAYENNE) which is bigger than it should be. CAYENNE is only a street name, there are no cities called CAYENNE in this ...
0
votes
0answers
17 views

CartoDB Error loading rows, check your SQL query

and this is the error i get when i inspect element net::ERR_CONNECTION_REFUSEDcdb.js:4 J.support.ajax.J.ajaxTransport.sendcdb.js:4 J.extend.ajaxmodels.js:3 ...
0
votes
0answers
51 views

Some cities refuse to georeference in CartoDB?

My dataset includes two columns, "City" and "Country." The cities are all major world cities, nothing obscure. All are georeferencing fine in CartoDB, except Rome, Italy, and Moscow, Russia. I've even ...
0
votes
2answers
42 views

How to add rows from a Dataset to another?

The DB I have is divided in many datasets (shape format, each .zip I send to CartodDB consist of 4 files, .dbf, .prj, .shp, .shx). The problem is that the free account only allows 4 datasets, each one ...
0
votes
0answers
16 views

CartoDB.js: Sql UPDATE table from a infowindow menu

I about to create a infowindow menu. When the user click on a link (image), i want to send a UPDATE table SET category = 3 query to the table to change the category of that point. This is quick and ...
0
votes
0answers
38 views

Display heat map using Json on Cesium with CartoDB

I want to create a heat map by using Json data on Cesium. And I want to use a CartoDB layer filled with Jquery's way of getting Json. And display the data on the Cesium 3D Globe. Most of work is done ...
0
votes
1answer
23 views

“Too many points” when using gdal2tiles.py in EPSG:4326

I want to put a custom map onto cartodb, which, I believes, requires EPSG 4326. When I try making tiles with gdal2tiles, using a 4326 georeferenced image, I get the following error: ERROR 1: Too many ...
0
votes
1answer
18 views

Must I use “date” data type to animate data by year?

I'm trying to animate the opening and closing of businesses by year but my data column is set to "number" not "date". The animation is not working in that all the data points show up at once, rather ...
1
vote
1answer
27 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 ...
0
votes
1answer
19 views

Connect MATLAB to cartoDB using Database Explorer?

I set up a database on cartoDB. I'm trying to use MATLAB to connect to the database using Database Explorer. I've downloaded the PostgreSQL driver. MATLAB asks for connection Parameters: Server ...
0
votes
1answer
36 views

How to change timeslider step in CartoDB/torque?

I am using CartoDB and I have a torque map that I am using for a course. The visualization only covers three months of time. I would like the timeslider to show each day, but right now it shows ...
0
votes
1answer
21 views

different popup window styles for different tiered locations

New to cartodb, how can I have 1 map with multiple locations, and they can all have different amounts of popup data depending on the plan they purchased to get featured on our map?
0
votes
1answer
75 views

Why would geocoding by street address have ~96% failure rate?

I attempted to use CartoDBs Geolocate By Street Address functionality. I used 3 columns: street address, City (Austin), and State (TX). I manually set the country to USA. Of the 30 rows, only two ...
0
votes
1answer
9 views

In embedded map - can I temp disable all hoverwindows while any infowindow is open

I have CartoDB map with hover and infowindows for 1000 polygons. When user click we want to open infowindow for processing (update able form) and want: stop hover windows from working until user ...
0
votes
1answer
38 views

Insert rows into CartoDB from code

I have a simple web page where i show my cartoDB map and a dataset. I want to know if there is any way to insert new rows into my cartoDB dataset from code, so external users can add points to the map ...
1
vote
1answer
25 views

Torque map: dates by year; year in slider text

I would like to put the year in the slider text and for the data to be scrolled through via year. Apparently it was working until three weeks ago, and now doesn't. In particular the slider now ...
0
votes
1answer
41 views

How to show hours and minutes in the time slider on CartoDB?

CartoDB automatically display only days and months on my custom map. However, I would like to show the following format (included in my data): dd-mm hh-mm. What should I do? I can't find any ...
0
votes
0answers
22 views

Polygons (world countries) over 180 degrees gets broken in rendering

I have a table with world country polygons, and some polygons (as in real life) cross 180 degree longitude line, so they have both 179... and -179... coordinates. As long as it is in PostGIS or ...
1
vote
0answers
41 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 ...