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

learn more… | top users | synonyms

0
votes
0answers
10 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
14 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
14 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
7 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
28 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
15 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
13 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
10 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
23 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
37 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
39 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
29 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
16 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
24 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
39 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
24 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
13 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
35 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
33 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
39 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
20 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
30 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
36 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
98 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
18 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
34 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
25 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
20 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
28 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
42 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
40 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 ...
0
votes
2answers
49 views

U.S. States as Polygons

I am new to CartoDB and geo-data analysis in general. I have a set of data from the different U.S. states (i.e. I have a column called state that serves as the ID/key variable). I think I need to ...
0
votes
1answer
46 views

Cartodb: How to make dates appear in Torque time slider

I am trying to use my date column as a time-slider in my cartodb map. But it doesn't appear or seem to be an option. What am I doing wrong? Here's my map: Map Here's my data: Thanks.
2
votes
1answer
119 views

CartoDB “Error loading rows, check your SQL query” & “There is a pb with your connection”

I have been trying to install my own CartoDB server for a few weeks. I succeeded to install each part with no error (after few corrections) with this tutorial. Make check with CartoDB-SQL-API and ...
0
votes
0answers
30 views

Taking 10 minutes to import File in CartoDB Local Instance

I am using local instance of Cartodb in my system.I followed the github instructions from following site<CartoDB Installation Procedure> And everything installed properly.But when I upload file it ...
0
votes
1answer
24 views

CartoDB layer selector template

I would like to create a HTML file where I have a layer selector dropdown list that would be able to display one layer from a specific CartoDB visualization (this visualization has several layers in ...
1
vote
1answer
57 views

Trying to use SQL API from Oracle PL/SQL to CartoDB

I am trying to make an http call from within an Oracle server to CartoDB. To do so I have developed a custom PL/SQL package that will generate the SQL and make the calls. A sample API call is below. ...
1
vote
1answer
28 views

CartoDB Runtime Visualization on Local Instance

I'm trying to create a runtime visualization on a local instance of CartoDB. Here's the relevant code: cartodb.createLayer(map, { user_name: 'testuser2', type:'cartodb', ...