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

learn more… | top users | synonyms

0
votes
0answers
15 views

Choropleth map turns one color when filtered, sql error

My data is generating a choropleth map perfectly but when I try to filter (both in the filter tab and by writing my own SQL) it turns all one color and tells me I have an SQL error. This happens even ...
0
votes
1answer
10 views

In CartoBD, how can i get add a hyperlink to a field in a pop up box?

In CartoBD, how can i get add a hyperlink to a field in a pop up box?
0
votes
0answers
6 views

How to do a POST instead of GET when calling sql.execute()?

I am calling the CartoDB sql.execute() function with a rather large WKT geometry in the SQL query and this is causing a "414 Request-URI Too Large" error on the server b/c it is making a GET request. ...
0
votes
0answers
9 views

Using Well-Known Text and geocoding on Load

So, I have tested adding columns with the WKT format into Carto, and it has always worked great (I tried 1 row, then 1000 random rows from our data). I geocoded it on load by naming the column with ...
1
vote
1answer
23 views

Why doesn't CartoDB display my data?

I have loaded a table into CartoDB with a column for latitude, longitude, date/time and a number. CartoDB says that the data is georeferenced by the designated columns but when I open the map, I see ...
1
vote
0answers
5 views

Linebreaks in CartoDB info window?

I have a "notes" field in my CartoDB table, that I tried to populate with multi-line texts, but there doesn't seem to be a way to add line breaks. If I use <br /> I just end up with a literal ...
0
votes
0answers
5 views

Draw line drawn from point to an open infowindow?

I want the infowindows on my map to be in a fixed location, but that sometimes makes it hard to tell which point was clicked (which point is associated with the infowindow displayed). Is there a way ...
0
votes
0answers
9 views

CartoDB - Infowindow issues on fullscreen / iPad

We're just about ready to go with our first ever CartoDB visualisation, namely a map of the museums in Britain. Unfortunately I'm having a rather large issue with infowindow positioning in either ...
0
votes
0answers
29 views

Changing basemaps from cartodb.js

Is there a good way to change leaflet basemaps from cartodb.js or leaflet.js? I am able to grab the map object and basemap layer from the layers property in the done() promise. ...
0
votes
1answer
11 views

CartoDB: Can't find where to change Google Drive log in credentials

I'm trying to create a new table in CartoDB. I click New Table I click the Google Drive data tab I click the connect with gdrive button At this point it seems to be automatically logging in to the ...
0
votes
0answers
4 views

CartoDB get rows in initialized map

Is possible to get the data in this example? I mean something like: map = cartodb.createVis ... map.data.each ... ? Or, where in documentation can I find something about it? or, which keyword ...
0
votes
1answer
14 views

How do I show the created_at column at my infowindow?

Fields like created_at, updated_at or cartodb_id are a greyed out thus not allowing us to add it to the info window. Is there a way to extract the data from default fields in cartodb?
1
vote
1answer
19 views

CartoDB SQL string as integer

Because data is imported as string, I need to query string values as if they were integers, is there something I could use to cast values to string? Where could I find documentation for this SQL in ...
0
votes
0answers
7 views

CartoDB SQL API to Layer

How to use SQL API output to create a layer in a map? I thought it could be achieved with createLayer passing the data directly, i.e. not with URL as second argument, but the data I am getting from ...
2
votes
1answer
21 views

Animate a Choropleth Map in CartoDB?

I used Torque to animate points over time in CartoDB I have a map of polygons and I want to animate the changing colors. Over five years the intensity of the type of incident I'm mapping changes. I ...
1
vote
1answer
34 views

CartoDB/Javascript - Layer Selection Buttons help

I'm trying to make my own layer selector (due to the CartoDB one not appearing on mobile devices) and I'm having issues, mainly due to my lack of experience with Javascript. The issue seems to be ...
2
votes
1answer
24 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 = ...
0
votes
1answer
28 views

Videos (as headers) in CartoDB Infowindows

I need to know how to embed a video (YouTube or Vimeo) into an infowindow in CartoDB in the same way that an image appears as an image header. Potentially more complicated, when there is no video link ...
0
votes
0answers
10 views

Videos in CartoDB Infowindows [duplicate]

I need to know how to embed a video (YouTube or Vimeo) into an infowindow in CartoDB in the same way that an image appears as an image header. Potentially more complicated, when there is no video link ...
2
votes
2answers
56 views

Mapping the European Debt Crisis

I'm a journalist based in Paris, and for a project I'm working on, I would like to display how public debt rose dramatically across Europe during the crisis. My plan is to show each country's ratio of ...
1
vote
0answers
15 views

Info from multiple rows in single popup

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

generic “There is a problem with your connection” error in CartoDB

I changed the cartoCSS for a visualization, but in a pretty straightforward way (fyi: changed some numerical cutoffs to other numbers, did not touch anything else). I am getting a "There is a problem ...
0
votes
0answers
14 views

why is the CDB_QuantileBins function not found in cartoDB?

What is wrong with the following SQL query on my data? I found pretty clear documentation (1,2) that the function is supposed to work. SELECT CDB_QuantileBins(array_agg(numeric_column_of_mine), 10) ...
0
votes
1answer
30 views

How is device-responsive layer selection working for you? [closed]

I ran into problems getting layer selection to work with data categories that I didn't document well in this process, but I would just like to show my results here in case people are interested in ...
0
votes
1answer
18 views

Placeholder Text in search box - Cartodb

I am trying to add placeholder text to the Cartodb searchbox using the following DOM code document.getElementsByClassName('text')[0].placeholder='Search Your Constituency'; It actually does not ...
0
votes
1answer
16 views

Relating Tables in CartoDB

Is there a way to relate tables in CartoDB? More specifically, is there a way to have a single row in one table associated with multiple rows in another table without having to actually join them?
0
votes
1answer
27 views

how to run a PostgreSQL query on CartoDB tables?

I want to run a VACUUM FULL on my table, but I don't think it's working. Simply sandorl.cartodb.com/api/v2/sql?q=VACUUM&api_key={MYKEY} results in long output, apparently only repeating for ...
0
votes
1answer
18 views

CartoDB simple process

I'm attempting to create a simple process with CartoDB, I have a layer with number of polygons, I want to to run a SQL with a multipoint line to report which polygons were intersected.
0
votes
0answers
12 views

Can I Manually Add Wizards to a Map on CartoDB?

Some of my locations are not getting geocoded in spite of my checking spellings etc.. For instance, I'm trying to load some data on Chhattisgarh, an eastern Indian state and Lakshadweep, an island in ...
0
votes
0answers
15 views

How can I insert images in infowindows in #CartoDB?

I followed all the instrux to insert images into a CartoDB infowindow, but it hasn't worked? Can someone help me with how I can make it work? Thanks.
0
votes
2answers
39 views

url completion in cartoDB info windows

By far the most of my data is taken up a column of long strings pointing to the source of the data for each point. I need to keep that. However, it would be neat if CartoDB could use this information ...
1
vote
2answers
47 views

cartodb runs out of space *after* shrinking the data in the tables?

I try to work in CartoDB with data I import from CSVs (or xlsx, see below). The data is 24.1 MB in ASCII CSV, 10 MB in xlsx. I spent quite some time shrinking my data's size, and I was happy to ...
7
votes
1answer
162 views

online map of 242,888 locations: which service to use? (what if temporal heat map?)

I have a 161.8 MB large CSV file with geocoded locations (with latitude and longitude) for 242,888 lines. I want to have an embeddable online map of all this. I wonder which service could deal with ...
3
votes
2answers
88 views

Populating D3 Graph with Cartodb

I have been looking at D3 and following along with their basic tutorials. In the documentation you can use json files to create graphs, however I am confused on how to make the connection from my ...
1
vote
1answer
32 views

Query data without opening up database?

I have a bunch of polygon data that I want users to be able to sort/filter based on certain criteria. I have the data in a CartoDB table, and can pretty easily use some SQL calls to achieve what I ...
1
vote
0answers
19 views

Why aren't the info windows showing up on my cartodb layers?

I made a cartodb map with 2 layers. The layers draw from the same table but I use filters to display some of the data in one layer and some of the data in another. Without the layers my info windows ...
0
votes
0answers
49 views

The Hobbit Visualisation - Separate Infowindows

I'm being pushed to the max of my (albeit limited) Javascript skills so any help would be most appreciated! Forking from the the Hobbit Visualisation at ...
0
votes
0answers
27 views

Georeferencing a column doesn't work in my local instance of CartoDB

I'm installing a instance of cartodb in AWS/Ubuntu 12.04, and I'm having a hard time trying to georeference a column with textual addresses. I know that the data I'm trying to georeferencing is ok ...
0
votes
1answer
48 views

Help with adding a time slider to my map

I'm trying to create a map with a time slider, basically duplicating this example: http://bl.ocks.org/javisantana/f9b073869fdd3b696f93. I must not be entering in my info correctly because when I copy ...
1
vote
1answer
47 views

CartoDb - Aggregate and Infowindow

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 the ...
0
votes
1answer
21 views

Styling based on hex color codes within table?

I have a table of polygons named 'testtable'. Within it is a column 'color', which has hex codes. I want to style the polygons based on the hexcode values.. is this possible? I was trying something ...
1
vote
1answer
37 views

Can I automate State Plane to Lat/Lon conversion in CartoDB?

Reading this: How do I convert State Plane coordinates to latitude-longitude? but ... I'm using CartoDB and wondering if there's a straightforward way to convert New York-Long Island State Plane ...
0
votes
1answer
17 views

CartoDB API to make a table public after an import?

I am currently using the import API to import my layer data into CartoDB from another application. My question is whether there is a way to make this table PUBLIC using an API instead of the UI?
0
votes
1answer
22 views

How do I get a JSON list of all the visualizations in my CartoDB account?

I'd like to integrate all my CartoDB visualizations on a website, is there a way I can make a call and get them back as JSON?
1
vote
1answer
28 views

CartoDB: Question about map loading indicator

We are using the CartoDB.js API to create our visualizations at runtime using a pre-exsiting Google map. Everything seems to be working fine so far, except that we would like to show some sort of ...
0
votes
1answer
14 views

Torque cumulative creates grid

How can I get Torque's cumulative setting to draw the data points in their correct locations versus artificial grids? http://cdb.io/OAgzRD My dataset of global locations looks fine under ...
0
votes
1answer
27 views

Superimposition of label in CartoDB

I'm currently doing a carte with CartoDB where I use CSS in order to show label but my issue is that I have entities which are very close and their label are difficult to read because of their ...
0
votes
0answers
15 views

Cartodb error: ETHON: performed EASY url= response_code=0 return_code=couldnt_connect total_time=0.000113

I have installed cartodb (master) on local ubuntu and I am able to import data / add new tables etc. When I click on VISUALIZE link and fill in the details, press ok, the window waits there for ever. ...
1
vote
0answers
27 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 ...
0
votes
0answers
28 views

torque cartodb heatmap at higer zoom levels

I am trying to use cartodb torque to display overtime location data using Cartodb Torque. Vizualization works great at zoom level 9, but when i zoom in further to level 13 instead of the intensity i ...