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

learn more… | top users | synonyms

0
votes
2answers
27 views

Create a named map in CartoDB

I'm trying to create a template map following this tutorial from the cartoDB's maps API. My template.json file { version: "0.0.1", name: "template_1", // embedded authorization certificate ...
0
votes
1answer
34 views

tables created with “create table …” in CartDB

Edited I observed the following: when I create a table with "create table mytable ..." in the SQL tab of the UI, the table is created under the public schema. I can see these tables only using: ...
0
votes
0answers
17 views

Trouble Using jQuery UI Range Slider with Cartodb

I am trying to use a jQuery UI range slider to create a filter the markers displayed on my map - similar to this post office example. The problem I am having is that on load, sometimes I get the ...
2
votes
1answer
21 views

How to add line to CartoDB map?

According to the CartoDB tutorial on how to add and edit geometries, using the CartoDB editor, when we click Add Feature, we should get a popup box with three options: Add point Add line Add polygon ...
0
votes
0answers
19 views

How to create a geotagged map using place names? [closed]

I have a list of schools and I cannot for the life of me get any geotag results from it. Do I need to have anything else? I also tried, city, state and that didn't work.
0
votes
1answer
26 views

How to set the zIndex of the CartoDB.js layer on top of Google Map's GroundOverlay?

I am trying to combine the Google Maps API Ground Overlay example with CartoDB.js example using Google Maps. It appears both APIs are displaying their layers correctly. However, the ground overlay ...
0
votes
0answers
29 views

Google Streetview Images in infowindow

I have followed the instructions on this blog post on adding streetview images to the infowindow: http://blog.cartodb.com/a-picture-is-worth-1-000-attributes-infowindows-with/ I can do it without a ...
2
votes
0answers
41 views

I would like to reverse Geocode from the infowindow

I am just learning the ropes with CartoDB and am curious to know if this is possible. I have a CartoDB map with points and I am entering data into this map through the CartoDB editor. I would like ...
0
votes
1answer
31 views

How to update a CartoDB table at a certain time of day

I have a table in CartoDB 'inland' that I would like to have automatically update each day at 8pm PST. I know that PostgreSQL has no internal function to run an UPDATE COLUMN function at a certain ...
2
votes
2answers
30 views

Are CartoDB Map views by month or by year?

We have 10000 map views with the free version of CartoDB. Are they reset every month or is it the maximum views for the all utilisation ?
1
vote
0answers
25 views

Time Slider in CartoDB

I once again have a question regarding this map project I'm working on. I'm trying to add a time slider to my CartoDB map, and the slider appears, but instead of displaying the correct dates and the ...
2
votes
0answers
17 views

z-index issue with infowindow

I currently have a map where my map div covers 60% of the page and 40% is a fixed Infowindow. My problem happens with cartodb css and its z-index of div.cartodb-infowindow. Currently my information ...
2
votes
1answer
40 views

CartoD3 chart not displaying - CartoDB

I have tornados table with columns damage,date,month . I used the following code to create a barchart . <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" ...
1
vote
0answers
8 views

cartodb search box when creating a visualization at runtime

I know that it is possible to add the CartoDB search box when you link to a visualization such as this. However, I have a map which is created at runtime, using the same method as here. Does anybody ...
1
vote
2answers
50 views

How to setup a SQL trigger in CartoDB

I need to setup 2 SQL triggers in CartoDB that will update my inland and coastal tables each time my obs table is updated. I have never setup a SQL trigger but I have looked at the documentation and ...
1
vote
1answer
24 views

Why doesn't a CartoDB layer (using cartodb.js) on top of Google Map in Firefox on Ubuntu work?

I'm creating a layer using CartoDB.js and putting it on a Google Map base layer. This works on every other browser and platform I have access to (IE, Chrome, Firefox on OS X), but does not work on ...
2
votes
1answer
21 views

Add minutes contained in a column to a date

In CartoDB I want to add minutes contained in a column of data type number to a date. e.g. SELECT my_initial_date + 'xx minute'::INTERVAL as my_date FROM table What is working is: SELECT ...
2
votes
1answer
26 views

Adding Facebook and Twitter sharing to CartoDB infowindows

Trying to add share buttons to output something like: {{region}} text {{region_variable}} text www.google.com The below works very intermittently for Twitter, but when I share the URL, the map won't ...
1
vote
2answers
34 views

Can CartoDB provide Web Mapping Service (WMS)?

Does cartodb implements a wms service? If not, is there a way to contribute to the project to implement it?
1
vote
1answer
46 views

Option to auto refresh map every [n] seconds in CartoDB?

Is it possible to make a CartoDB map auto-refresh using the latest data every [n] seconds using the web interface? I am using the SQL API to update with new positions and would like to see them ...
0
votes
0answers
23 views

Morris Chart X Axis labels disappear

I have created a chart using cartodb and Morris chart library and I have been having problems with the x axis labeling. Originally I used the chart with bootstrap and only one label showed up. So I ...
1
vote
0answers
21 views

How to query the data using SQL in the infowindow of CartoDB

I want to use a SQL join to merge data from 2 tables and display it in the info-window. When I give my query Select table_2.hos_name,table_2.revenue from table_1,table_2 where table_1.area_name = ...
0
votes
1answer
29 views

Update column in CartoDB with value from another table

I am trying to update the column 'lt_dispatch_level' in my table "inland" with the values from another table "current_obs" that has a corresponding column 'lt_dispatch_level'. However when I run this ...
2
votes
0answers
26 views

Showing Linestring from SQL statement with CartoDB

I have cartodb sql statement to return what polygons are intersected by a linestring, but I'd like to have the linestring visualized over the polygons on the results. Also not add the linestring to ...
2
votes
0answers
12 views

CartoDB multiple sublayers toggle? [duplicate]

CartoDB LayerActions Toggle Is there a way to make one button that shows a sublayer on one click, then hides on the next click. So one button per sublayer which turns the layer on and turns the layer ...
1
vote
0answers
25 views

How to include data from other tables in the info-window in CartoDB

I have 3 layers(table_1,table_2,table_3) of data. In the info-window, which was created for the second layer. I would like to display one column of data from table_1 . When I used {{table_1.name}}to ...
0
votes
0answers
7 views

Why did my Visualization tools disappear from the CartoDB Sidebar?

I was working with the "Intensity" visualization tool yesterday. Using the same data, I created a new map, and now I can only access: Simple, Choropleth, Category, and Bubble. Where did Intensity, ...
1
vote
0answers
19 views

Linestring to CartoDB api

I want to add a linestring to a CartoDB API web app for one time use, I have SQL statement being ran at the same time and just want the linestring in the SQL statement to be displayed.
2
votes
0answers
17 views

Differentiating between children and adults depending on AGE using Cartodb Torque wizard?

I'm trying to differentiate between children and adults depending on AGE, The age of these individuals are contained under the Column "palestinian_civilians" .I'm using Carto Torque wizard.Below is a ...
0
votes
0answers
30 views

Can Torque animate markers along polylines?

I found that torque is currently designed to animate markers along a table of points. I'd like to extend torque to animate markers along the polylines of a table's row. This would allow torque to ...
1
vote
3answers
68 views

Hide layers by default on CartoDB visualization

I'm loading a CartoDB visualization and I want all layers to be switched off as the default setting, so users have to switch them on using the layer selector loaded with the visualization. I'm ...
2
votes
2answers
36 views

Rotating labels in cartocss with controlling the rotation basepoint

I am trying to rotate multiple text labels in cartodb/cartocss. I am offseting each label so that they appear to be stacked using text-dx and text-dy. Using text-horizontal-alignment: left; and ...
1
vote
1answer
40 views

My self-hosted CartoDB map references /api/v1/map — No route matches

I'm using a self-hosted install of CartoDB. When I try to publish a visualization using the sample Europe data the visualization page references /api/v1/map which results in a routing error. ...
1
vote
1answer
32 views

CartoDB/SQL Console?

Lacking much programming experience, I've spent a lot of time familiarizing myself with HTML, CSS, and SQL over the past couple of days so that I could make a layer selector for a CartoDB ...
1
vote
0answers
24 views

Append georeferenced data from one table to another table in CartoDB

I have two tables with an identical structure of columns in CartoDB. Both are georeferenced. I'd like to combine the date of the two tables into one table. In the options menu of CartoDB there is an ...
1
vote
1answer
42 views

Can 3rd party javascript libraries be used with CartoDB?

I'd like to build some functionality (search, sliders, etc.) in a 3rd party javascript library (jquery mobile), and integrate it with CartoDB. Can this be done? Are there any examples available or ...
-1
votes
0answers
31 views

How to toggle/query multiple layers? [duplicate]

I'm a newbie trying to create a multi-layer map where I'd like to toggle queries on each layer independent of one another. For example, one layer is a point .shp and I want to toggle different sets of ...
1
vote
1answer
23 views

Street-view Image not rendering in CartoDB infoWindow

Following instructions on Infowindows with Google Street View Images, I'm trying to add this feature to a visualization Instead of an image, I'm simply getting the link to the image via the SQL query ...
1
vote
1answer
54 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
18 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
31 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, ...
1
vote
1answer
32 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? ...
1
vote
1answer
54 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 ...
1
vote
1answer
32 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 ...
1
vote
0answers
13 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
12 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 ...
1
vote
1answer
29 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
43 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
16 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
34 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: ...