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

learn more… | top users | synonyms

1
vote
0answers
13 views

How to add multiple cartodb layers in viz.json to a 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}) ...
1
vote
0answers
7 views

Display linestring on Cartodb with SQL

I have a Cartodb api for a separate map, I need to display a linestring for each time the sql is run, but not store the linestring in the database.
1
vote
0answers
18 views

Displaying multiple records in CartoDB with common zip code

I am uploading multiple records and want to use five digit zip code as the georeference. I would like to display each of those records on a map. Some of the records have identical zip code fields, ...
0
votes
1answer
14 views

What to do in CartoDB so that null/zero values are not shown on the map?

I've created a map and want to present some data with the bubbles (supply-demand), but in some locations the supply is zero. I don't want the bubble to be on the map in those cases. How can I do it? ...
0
votes
1answer
27 views

Are there templates for adding a search filter on a CartoDB embed?

I'm looking for any examples of an embedded CartoDB map with a search filter built in. So, a map of schools, say, with a pulldown that will let you select one school and then zoom to it. Or a map of ...
0
votes
1answer
14 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 ...
0
votes
0answers
9 views

cartodb visualization ownership transfer

I have a visualization created in my cartodb personal account. Can I transfer this viz to my company's enterprise account without recreating it there?
0
votes
0answers
11 views

Failing to get wkt to reference for a multiline

I apologize, I'm quite new to WKT (and most everything else). I have a shape that I've exported to csv. & geoJson to be loaded into CartoDB. Unfortunately, the geoJson doesn't work so I am trying ...
0
votes
1answer
24 views

Setting the Geometry with sql query

I am trying to merge data from a U.S. states shapefile with data on each state. I used this SQL query which is supposed to work: SELECT * FROM child_poverty_by_state UPDATE child_poverty_by_state ...
0
votes
1answer
19 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 ...
0
votes
0answers
8 views

Inserting full bleed images in browser background instead of maps using CartoDB?

I am building a product that will utilize high fidelity photography. I would like to show my photos in a slideshow format that takes up the entire area of the browser. CartoDB and the Odysssey.js ...
1
vote
1answer
30 views

How to add a new permanent column that contains result from ST_AREA select queries

I am a total newbie here, I have a bunch of polygons in my cartodb map, and I want to create a new column called "AREA" in the table MY_TABLE that contains values from my area calculation query: ...
0
votes
0answers
16 views

How can I Georeference a column of multiple zip codes? [duplicate]

I'm looking for a way to easily visualize a collection of zip codes. I work for a chapter-based organization, and the chapter boundaries are based on zip codes. I'd love to use CartoDB to display the ...
1
vote
0answers
19 views

connecting cartodb to existing mysql database

I'm trying to create a simple heat map based on longitudinal and latitudinal map coordinates that can be transferred from a database on mysql that I've created. I read that cartodb can be connected to ...
0
votes
1answer
11 views

How to Change Torque Map Slider Text

I am new to CartoDB and NOT a programmer. I am trying to make a simple torque map that changes by year and I do not want the slider text to include or display the month, just the year. Is this ...
0
votes
1answer
28 views

How to reduce the opacity of a Google Maps layer in CartoDB.js

I have a CartoDB.js-App where I load my vis using cartodb.createVis (I do not manually define Leaflet layers). How can I reduce the opacity of the Google Maps base layer? I tried the following, as ...
0
votes
0answers
7 views

Setting the extent in cartodb to the sublayer bounds

How do you set the extent of a sublayer to fit all of the points? I've been trying to use this bounds function, but it doesn't work: sql.getBounds('select * from table').done(function(bounds) { ...
0
votes
0answers
10 views

Uisng Directed force graphic to connect terminals in CartoDB?

I am starting using SQL for my internship, we are creating a map for terminals (points representating a port, train station or logistic centre) and what I would like to do is use the Directed force ...
0
votes
1answer
38 views

Custom OSM tiles with Mapbox and/or CartoDB

For a newspaper, we would like to use CartoDB's editor to produce quick overview maps with small amounts of geometry and information such as tooltips etc. For this job, the CartoDB editor seems to be ...
1
vote
1answer
42 views

How do I display NYC community specific data on an interactive map without longitude/latitude coordinates?

I have downloaded the NY Department of Sanitation's Monthly Tonnage Collection data from https://data.cityofnewyork.us/City-Government/DSNY-Monthly-Tonnage-Data/ebb7-mvp5#revert and I want to use this ...
1
vote
1answer
32 views

Start and End Dates for CartoDB Torque

I was wondering if there is a way to have CartoDB's torque read end dates for point files, the same way that ArcGIS desktop can. I am trying to plot the foundation of certain cities, and then remove ...
1
vote
1answer
20 views

layer priority over basemap

Hello I was trying to but together a quick and dirty bing/osm map using leaflet and leaflet plugin. My problem comes in when adding a layer from cartodb.The points do not show and I am not getting ...
0
votes
1answer
19 views

How can I get a list of tables in my CartoDB account by size?

The CartoDB dashboard only sorts tables by date modified or created. I would like a list of tables sorted by size.
0
votes
1answer
47 views

what is the visualization technology behind cartoDB?

does cartoDB uses mapserver/geoserver/other? what is the technology behind its visualization? thanks allot!
0
votes
1answer
26 views

Get CartoDB query by distance to work

Has anyone tried this tutorial: Query by distance ? This is a copy of the final code which they use for the map: <html> <head> <link rel="stylesheet" ...
0
votes
0answers
9 views

Cartodb torque chart stop from playing on page load

Is there a way to use a cartodb torque chart such that the chart does not automatically play upon page load? Thanks.
0
votes
2answers
40 views

How do you insert a cartoDB map using Cartodb.js into a wordpress site?

I've been looking at http://developers.cartodb.com/documentation/cartodb-js.html so that I can put a customized map into a wordpress site. I've been copying and pasting the following code into the ...
0
votes
1answer
25 views

Is there a way to show pop-up infowindow for every new point in torque map without clicking or hovering on it?

Trying to work with torque map, but I want to show a small story behind every point... Thank you for your help
0
votes
1answer
14 views

CartoDB Visualization refresh in legends does not work until you switch template

When changing the settings through the wizard, for example of the Bubble visuatlization, the legend does not update automatically. I managed to update the legend by changing the template to 'custom' ...
0
votes
1answer
36 views

accent-insenstitive text in CartoDB - PostGreSQL unaccent function missing?

I am trying to do accent-insensitive text matching, but PostGreSQL's unaccent function doesn’t appear to be available SELECT unaccent('Hôtel'); function unaccent(unknown) does not exist Is this ...
0
votes
0answers
21 views

How to view a raster in CartoDB?

What is the easiest way to view a raster in CartoDB? From the list of formats that you can upload into CartoDB, I noticed that .tif is available, so I've tried adding a GeoTIFF, but it says that ...
0
votes
0answers
17 views

How do you visualize change in rasters over time in CartoDB?

I have a series of satellite image rasters. I need to show the change over time of these rasters. Would the best way be to change the basemap with the click of a button for each? Has anyone got an ...
0
votes
1answer
37 views

Is there a way to display more than 10 categories in cartodb?

I'm creating a map in CartoDB. I have roughly 18 categories, but each of those has a sub-category, which is 'yes' or 'no'. Currently I am displaying the 18 categories in two different layers to get ...
0
votes
1answer
42 views

fitBounds on points after feature selection

I am trying to follow some of the examples I have found here and in Google Groups about fitBounds for points. Most of the examples are for polygons and don't seem to work for points. I think I've ...
0
votes
1answer
18 views

Link to an individual info window in CartoDB?

I'm a new user, so thanks for your patience and assistance. I just published a very large parcel dataset on CartoDB. Another website would like to link their parcel dataset to ours. Meaning, if you ...
0
votes
1answer
27 views

Can Cartodb map show only United States?

I have made my map with cartodb, showing where certain work is going on throughout the United States. I want to send it out, but would prefer the map to only show the United States--whereas now it ...
1
vote
2answers
22 views

How to use CartoDB for citizen comment collection?

I'm wondering what would considerations I should make for using CartoDB as a tool for collecting geo-located citizen comments. Currently we're using a javascript / bootstrap application that uses a ...
0
votes
1answer
32 views

CartoDB.js SQL API editing geometry

Is there anyway you can allow users to edit the geometry of shapes (e.g. move an existing point) using the CartoDB.js or CartDB SQL API libraries. I realise you can do this directly in the CartoDB ...
0
votes
1answer
38 views

CartoDB or Leaflet.js get coordinates of point clicked?

Using CartoDB or Leaflet.js is it possible to retrieve the coordinates of the point on the map clicked when opening an infowindow?
1
vote
1answer
108 views

How to import .csv file to CartoDB using SQL?

How to import .csv file to CartoDB using SQL, the data given below : POINT | TOP_dm | BOTTOM_dm | X_RD | Y_RD 35AP7600 | 4418 | 4368 | 262053 | 467223 35AP7601 | ...
0
votes
1answer
26 views

CartoDB toggle map view - can I share the map as an iFrame?

I followed the tutorial - toggle map view and have successfully made the map. I'm now wondering what is the best way to share this map? I'd like to be able to give a client an iFrame, can I do this ...
0
votes
1answer
20 views

Loading Tiger & ACS Data Into CartoDB

Does anyone have experience loading the pre-joined TIGER shape files and ACS 5 year data files by block group into CartoDB? I have downloaded the data from ...
0
votes
2answers
24 views

Trigger event on right-click

I want to, on right-click on a feature in a layer, have an action execute. I need to know 1 thing: What layer was right-clicked. Does anybody know how I can get this functionality? The API doesn't ...
0
votes
1answer
37 views

CartoDB: Import Error: host and port must be set

I have setup cartodb in one of the server (CentOS). Everything worked fine in development environment, but when I move to production environment I couldn't import any file. Getting the below error in ...
0
votes
0answers
27 views

KML - Importing Data into a CartoDB Table

I´m trying to load a KML file into a CartoDB Table. That's ok, but, when I see the data, it's empty, it has loaded polygono coordinates as a geometry field, but other fields do not appear. My KML ...
0
votes
0answers
21 views

CartoDB: custom sorting infowindow entries

I am trying to create a visualization at runtime like explained in the Cartodb documentation: Then I add infowindows for each entry with this command: cdb.vis.Vis.addInfowindow(map, ...
0
votes
1answer
29 views

CartoDB: Info window from multiple layers, one geo, one supporting data

I want to have one table (readonly_table) with supporting non-geo data (e.g. project code, name, manager, etc.) and another table (write_table) with geo point, project code, perhaps a few other user ...
1
vote
1answer
47 views

CartoDB - How would I customize my legend to not be white and have blocks instead of bullets?

First off, CartoDB is amazing. I am trying to modify the look of my legend to look something like the one as seen on the "Elephant Movement in a Human Landscape" example on the CartoDB website. ...
1
vote
1answer
42 views

How to generate routes that follow underlying road network?

I have a set of points (~2300 bus stops) and I have a network of roads that these bus stops lie on. When I have a bus route that goes from A to B, how do I generate the route such that it follows the ...
0
votes
0answers
11 views

CartoDB table seems to be corrupt

Have 218 rows in a table in the free version of CartoDB. Suddenly behaving strangely - not accepting edits to fields in existing rows, only showing 200 rows when sorted Descending on row number (but ...