CartoDB is a Software as a Service (SaaS) cloud computing platform that provides location intelligence and data visualization.

learn more… | top users | synonyms

0
votes
0answers
4 views

Styling a heat map based on point attribute, not density

I have a point dataset generated from getting the centroid points from a fishnet/polygon grid. I combined these points using a spatial join to give them an attribute of 'pressure' which is an integer ...
0
votes
1answer
36 views

Highlight feature below mouse-overed track in Leaflet

Currently, on http://velo300.free.fr/debug, feature highlights on 'featureOver' creating a white new feature on top of mouse-overed feature. Problem: i need also to work with 'featureclick' for ...
1
vote
1answer
27 views

Leaflet display only clicked element of a loaded map layer (polyline)

I am creating a web mapping application that will return appropriate routes based upon ST_length query on a cartoDB dataset. So far, the code below successfully maps those routes with individual ...
2
votes
1answer
21 views

CartoDB SQL API styling individual polyline returns

I am creating a web mapping application that will return appropriate routes based upon ST_length query on a cartoDB dataset. So far, the code below successfully maps those routes (and clears any ...
1
vote
0answers
14 views

How to Change CartoDB Torque Cat Map Slider Range

Map slider range includes 83 month/years (2017, 2018, and 2019 are not there) but actual data only has 57 month/years see: https://sildeag.cartodb.com/viz/1e7ee1c6-0cbc-11e6-9822-0e787de82d45/map Is ...
0
votes
0answers
30 views

Can't get a very simple CartoDB.JS map to work. Having problems adding my data?

I'm having difficulty with a really basic CartoDB map. I'm trying to use CartoDB.JS to create a very simple choropleth map, just to get a feel for how CartoDB.JS works. I can initialize the base map, ...
0
votes
1answer
15 views

Create Choropleth Style Map in CartoDB programmatically

I am trying to create a choropleth map for a school project I am working on. Based off user input, I will create a csv file that I will then upload to CartoDB using their Import API. By setting the ...
1
vote
1answer
31 views

Area of influence with CartoDB

I am working on a city transport map, and for fun (and practice) I try to make an area of influence of transport station. But, whatever I try, something gets wrong. So two questions. 1 - How can I ...
0
votes
1answer
28 views

CartoDB Core with Leaflet

I just recently experimented with CartoDB. I have an existing Leaflet Map with lots of Plugins and dependencies. Just adding the CartoDB.js does not work (I think there is a version conflict, but I am ...
0
votes
1answer
23 views

CartoDB - random points being added to map

I'm working on a tool that allows users to draw geometries on a Leaflet map, which are then sent to CartoDB. However, I've noticed an odd behavior... after a polygon has been added, a varying number ...
0
votes
1answer
18 views

Georeference Canadian postal codes in CartoDB

I'm having issues trying to map by Canadian postal code. I'm prompted with "No rows geocoded in test_cartodb dataset" I mapped by "administrative area".
-3
votes
0answers
13 views

“Peer authentication failed for user ”postgres" Error When installing cartoDB [closed]

I am trying to install cartoDB locally following these installation steps http://cartodb.readthedocs.org/en/latest/install.html. However, after editing /etc/postgresql/9.3/main/pg_hba.conf to look ...
0
votes
1answer
31 views

Why do I get a 503 error when pushing data to the CartoDB SQL API

I'm using ogr2ogr to push a large (200,000 feature) dataset to the CartoDB API. I'm using where_clauses to upload 500 features at a time, and sleeping every 20,000 features for a minute to give the ...
0
votes
1answer
23 views

CartoDB - inserting polygons

I am new to using PostGIS and CartoDB, and I am doing some test SQL inserts into both using PHP. I've had no problem with points, but polygons are proving to be a bit tricky - my SQL insert works ...
1
vote
1answer
35 views

How to change position of CartoDB legend in Editor?

I have a map here that I'm building in Editor with some custom CSS. I'm having trouble positioning my legend in the place I want it on the screen. I referred to this post, and tried following the ...
0
votes
1answer
18 views

CartoDB static maps API and named placeholders

Is it possible to use static maps API using named maps placeholders? I've a private dataset and I need to enhance some features at the output. In more details, I've a layer of land uses and I need ...
0
votes
0answers
13 views

How to put two time sliders on one CartoDB map?

I am trying to add two time sliders to my CartoDB map (one for the year a text was written, another for the year the described journey was taken). I would like the map's user to be able to filter the ...
1
vote
1answer
32 views

How to draw or mark an area without having any data of that area?

I'm doing some market research to start a business in Amsterdam. The City consists of 8 city area's which I'd like to map in my map as one of the layers and then add data to it. I already called to ...
0
votes
0answers
26 views

CartoDB OnPremise - Unable to download .svg marker image

i have one CartoDB Onpremise in one Ubuntu 12 and one error i try to explain here but 'gis stackexchange' say i try to put spam because i want to put all the logs and all the info ¯_(ツ)_/¯ I post ...
1
vote
0answers
11 views

Cartodb - Show/Hide Toggle within Infowindow

is there a way to use a show/hide button within the infowindow to work in a div outside the infowindow to display image/text? My javascript/css/html functions fine but when added into the infowindow ...
1
vote
2answers
23 views

Counting points within range using CartoDB?

I have a dataset of users location and want to assign per user how many other users they have within a given range, and updating this value into a table.The dataset name is "users_20160410" and the ...
0
votes
0answers
16 views

Insert UTF-8 characters to CartoDB database

I'm using Cartodb.js and API to insert strings from jquery variables to my dataset table in Cartodb. //Store variable data.location = $('#location').val(); //Insert to SQL var SQL = 'INSERT INTO ...
0
votes
1answer
29 views

Arguments not working in cartoDB createLayer method

I added a cartoDB layer to an existing map using createLayer method and it loaded properly. Thereafter, created a variable params and parsed the arguments as sees on the code snippet below. ...
0
votes
0answers
10 views

Modify CartoDB bubble legend

I'm using a bubble map in CartoDB and have chosen four bins with custom breaks. The map part is working fine – I eliminated the other six bins that the wizard put there. But how can I get the legend ...
0
votes
0answers
19 views

How to add a timeline to a CartoDB.js map with sublayers?

I have a CartoDB.js map that loads two different datasets on the same display using sublayers, and I would like to add a timeline to this map. I created and tested the timeline using just one layer, ...
0
votes
1answer
70 views

I want to make an interactive map where the end user can filter the data

I've been looking at services like CartoDB and Mapbox for making and hosting some interactive maps. However, it doesn't seem like they provide the option for the end user to filter through the data ...
1
vote
1answer
64 views

How can I upload 10 million points with 100,000 categories?

How can I upload 10 million points with 100,000 categories and have CartoDB randomly assign a color to each cateogry? Currently, it only seems to color the first 10. And from what I've seen on other ...
1
vote
1answer
42 views

Extract Polygon Data from Google Maps / CartoDB

I am looking to extract the polygons on this website http://goo.gl/vXhDSG I am not sure how to do that as I can't see any references to a geo JSON file. I can see that they are using CartoDB ...
0
votes
0answers
23 views

Appending to a cartodb table - duplicate key value violates unique key constraint

I'm trying to insert rows from one cartodb table into another using the method outlined here: INSERT INTO gfw_mining_test (the_geom, the_geom_webmercator, objectid, country,type, gfwid, st_area_sh, ...
0
votes
0answers
17 views

Export Image function reverting title to serif font

The export image function in CartoDB is not honoring the chosen font for the map title (in my case Helvetica) when generating an image. All images are being reverted to a serif font. Any idea why this ...
1
vote
1answer
16 views

Changing the time to GMT+05:30 in twitter tool in cartodb

I am much more interested in exploring geotagged twitter maps using cartodb. By default, We will be giving a search term as well as the From/To (Date with time) usually it will be 30days. In this ...
1
vote
1answer
18 views

Creating geotagged twitter maps in cartodb for one country instead of entire world

I know we can create a geotagged twitter maps using cartodb http://docs.cartodb.com/tutorials/connect_twitter_datasource/#twitter-api-data-options. But by default, the cartodb will create a twitter ...
0
votes
0answers
19 views

Is it possible to view a cached esri map service in cartoDB?

The title pretty much speaks for itself. I'd like to view the output from a cached map service in cartoDB. I don't need (nor do I particularly want) the data in a cartoDB table, just want to visualize ...
0
votes
1answer
33 views

Creating a runtime visualization with CartoDb

I am trying to create a runtime visualization for a CartoDB map and I am quite the trouble with doing it. I have gone over the documentation and cannot get the code to work correctly at all unless it ...
0
votes
1answer
10 views

CartoDB Sync with Merged Tables

I'm trying to inspect town assets, like pavement and signs. I want to display that information on a web-based map (CartoDB). I also want to be able to pull the most up to date information to generate ...
0
votes
2answers
40 views

Incorrect data and time stamp

I am using the following select statement to enter the a record in a cartodb database. INSERT INTO catch ( site_code, have_catch, fishtype1, fishtype2, fishtype3, fishtype4, ...
1
vote
0answers
17 views

CartoDB geom (coordinates) join: without exact match

Trying to join two datasets (layers) on CartoDB based on their geographical fields (in CartoDB's the_geom created field). However, the basic ST_Intersection function does not work since its tolerance ...
0
votes
1answer
19 views

Creating conditional style using CartoCSS on a CartoDB view

I’m generating a view using the query like this in CartoDB SELECT table1.cartodb_id, table2.data_count, table2.event, table1.the_geom_webmercator FROM table1 JOIN table2 ON ...
0
votes
1answer
45 views

setSQL not working in CartoDB API?

I'm trying to use CartoDB API to retrieve a dataset from my account to a heatmap. I want to filter the data using SQL. The problem is the following: the sql query does not always work when using the ...
2
votes
1answer
28 views

Why am I getting a syntax error at “RETURN result;” when creating a CartoDB pl/pgsql function?

Despite CartoDB appearing to run PostGIS 2.2 (see below), it still doesn't support multi-point geometries in ST_Split. SELECT postgis_full_version(); POSTGIS="2.2.0" GEOS="3.5.0-CAPI-1.9.0 r4084" ...
1
vote
1answer
18 views

How to create buttons with Javascript that set a new view (extent and zoom)?

I am creating a web map using CartoDB, and am having trouble creating buttons that will set a new view when clicked. I am a novice when it comes to coding but i do have some basic knowledge. I'm ...
2
votes
1answer
81 views

Creating shapefile from polygon points for CartoDB?

I have an Excel file that contains polygon coordinates for different areas. The spreadsheet has three columns: latitude, longitude and area name. Each coordinate makes of a part of the boundary of a ...
0
votes
2answers
44 views

Create a line from points using cartodb.js

I would like to draw a line between multiple points without creating a new dataset. Using this tutorial I've been able to draw lines between points in the CartoDB Editor: ...
0
votes
1answer
34 views

Unfortunately you can only import up to 3 files at the same time

I'm importing datasets to CartoDB manually but the import queue seems to be stuck in 'Pending...'. I cannot delete these never ending imports as I can't see any button and when I try to upload more ...
0
votes
0answers
17 views

CartoDB filling polygon with image from url from database

I'm working on a project mapping attributes of world flags. Right now I have an Ok map. Still have to get more data (from 1900 -1986 and from 1986 to 2016) ...
0
votes
2answers
31 views

HTML file not loading for CartoDB.js using Leaflet

I am trying to create a web map that uses a layer hosted on CartoDB and a basemap created in Mapbox studio. Never mind adding the basemap to the L.map, I cannot get the cartoDB layer to draw at all. ...
1
vote
1answer
73 views

Create a named map with a base map - without Javascript or browser

I'm using the static maps API to retrieve a .jpg image from a CartoDB named map. It looks like this. It's a bunch of residential land parcels. I need to add a base map such as Here Nokia Reduced ...
1
vote
1answer
31 views

Export CSV from CartoDB with lat and lon?

If you create a point dataset in CartoDB then export it to CSV, you get a "the_geom" column in the WKB format. How do you get individual lat and lon columns?
2
votes
1answer
76 views

Can I get a .jpg from a CartoDB map created in the editor without using a browser?

Edit I'm actually starting to suspect that I can't get a .jpg image from a map created with the UI editor without using a browser. I think I might have to use the API to re-create the map my ...
0
votes
1answer
60 views

Is this a CartoDB named map?

I am a complete beginner with CartoDB. Somebody else in our organisation has created a CartoDB map of New Zealand. They created the map by interacting with the CartoDB web site. They didn't upload ...