The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [carto]

CARTO empowers any organization and individual to discover and predict key insights through location data. With CARTO’s intuitive location intelligence platform anyone can build self-service location based apps that help optimize operational performance, strategic investments, and everyday decisions.

Filter by
Sorted by
Tagged with
4
votes
2answers
2k views

What is this PostGIS query doing to show great circle connections?

I'm trying to draw a flight map in CartoDB. My starting point is a single lat long point. We'll pretend it is this: ST_GeomFromText('POINT(-71.060316 48.432044)', 4326) And I want draw lines between ...
3
votes
1answer
1k views

Displaying multiple items at same address using Carto?

I'm creating a map with specific information (name, DOB, etc) to be displayed for a street address, which is mapped to an exact lat and long. Problem I'm realizing is that for items such as apartment ...
3
votes
2answers
2k views

Linking search box to dataset column in Carto?

The search box in a published map of CartoDB isn't linked to the dataset which is shown in the CartoDB map. How can I link the search box to a certain column of a dataset?
3
votes
1answer
643 views

Georeferencing 1990 U.S. county names / FIPS for CartoDB?

I have a data table with columns of county and state names as well as FIPS codes for 1990 U.S. counties. I cannot easily merge shape data into the data (e.g. the Census ones), but CartoDB does not ...
3
votes
3answers
2k views

How do you embed iFrame content into a CartoDB infoWindow?

All, I'm trying to embed Youtube videos and SoundCloud audio clips into a CartoDB infoWindow. I'm trying to do this by simply using the {{embed}} column and entering it into the custom infoWindow ...
4
votes
1answer
2k views

Cartodb - SQL query of public visualization of a private table

The team at CartoDB have recently(last few days) made some useful updates that now allow public visualisation maps to reference data in private tables. The change has only been made in the last day ...
1
vote
1answer
1k views

Using PostGis BBox and ST_intersects Queries? [closed]

CartoDb Recommend here that the following query is faster than an St_intersects Query SELECT * FROM {table_name} WHERE the_geom && ST_SetSRID(ST_MakeBox2D(ST_Point(-73.9980, 40.726), ST_Point(...
1
vote
1answer
311 views

transform MULTILINESTRINGs to curves in cartodb

I have a table with a column that contains MULTILINESTRINGs, where every string contains the longitude and latitude of a starting- and an end point, e.g.: MULTILINESTRING((97.0253024 4.3685491,8....
0
votes
2answers
615 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 (...
2
votes
1answer
2k views

Including chart based on fields in CartoDB infowindow?

I would like to make graphs, pie charts, etc based on fields in my table within my infowindows. Is there a way to accomplish this?
1
vote
1answer
428 views

Importing data to CartoDB using ogr2ogr

First attempt, I want to create a table at CartoDB from another Postgis database: snow:Docker-Postgis alasarr$ ogr2ogr --config CARTODB_API_KEY daf3960b41733ef71e03ea77019642761d547f5b -f CartoDB "...
3
votes
1answer
510 views

CartoDB infowindows - only show title if data exists?

I have a data set in which not all tuples have info for all columns. I want to show those columns in the infowindow, but if the data value is inconsequential (doesn't exist, is zero in a field where ...
3
votes
4answers
3k views

Converting Esri ASCII raster to Shapefile for CartoDB?

I have an ArcGIS grid ascii file (Ramankutty Cropland at 5 minute resolution) that begins as follows: ncols 4320 nrows 2160 xllcorner -180 yllcorner -90 cellsize 0....
2
votes
2answers
1k views

Merge polygons in CartoDB?

I created this map in cartodb: http://cdb.io/1xBj4Xo Now I have to merge some of the districts to a bigger district. Is it possible to do this in Cartodb? Using a SQL query for instance? I can also ...
2
votes
1answer
423 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 ...
2
votes
1answer
820 views

Get list of all tables in CartoDB account with SQL statement?

How can I get a list of all available tables in my own authenticated CartoDB account with a SQL statement? This returns null: SELECT table_name as t FROM information_schema.tables WHERE table_schema ...
2
votes
1answer
1k views

Adding CartoDB basemap to QGIS

I am trying to add a CartoDB basemap to QGIS and am 1) trying to figure out if it is possible and 2) trying to figure out how to do it. I've installed the QGIS CartoDB plug-in and have connected to ...
1
vote
1answer
1k views

Hiding sublayer with toggle button using LayerActions?

I have a toggle map (like this example) with sublayers. I want all the sublayers to be visible when you open the map, but I would like to hide some sublayers when the toggle buttons are clicked. I've ...
3
votes
1answer
613 views

Can I change an existing Cartodb map to use a different dataset?

I've created a map with lots of layers and info box info and sql codes, but now I need to use a different dataset from the one I was originally using. Is there a quick way to just swap out the dataset ...
2
votes
2answers
221 views

Delete the vertex of a line in Carto Builder

How can I delete the vertex of a line that I have previously created? I´m doing tests. I know how to edit a line or create a new one and add vertexs clicking in a transparent circle between two ...
2
votes
1answer
932 views

How do you change the data type of a column for a synced table?

A synced table I setup against the 311 dataset at data.cityofnewyork.us works great! However, the date columns come over as string, preventing me from doing date functions in queries, and from using ...
2
votes
1answer
973 views

How do you add a search box to the map when creating a CartoDB 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 ...
2
votes
1answer
530 views

Map doesn't appear with custom CartoDB query

I'm trying to use CartoSQL from CartoDB.js to create a layer. Here is the SQL query I am trying to make: SELECT rpa_nj_hsip_hospitals_compressed.flood, rpa_nj_hsip_hospitals_compressed.the_geom ...
1
vote
1answer
640 views

Setting zIndex of 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 ...
1
vote
4answers
2k views

Using different colors on Torque CartoDB

We’re creating a new piece and we’re having some limitations using the Torque function. Could you answer these questions, please? Is it possible to insert multiple colors on this function? Is there ...
1
vote
1answer
2k views

How to use cartodb.js with API key for privacy of data

I would like to use cartodb.js in my web page reproduce a visualization that I created at CartoDB. But I want to keep private my visualization and data at CartoDB (and I am going to secure my web ...
0
votes
1answer
7k views

How can I show numbers as percentages in CartoDB?

I would like to format numbers as percentages in cartodb. What are the best functions to display numbers with decimals, comma separators or percentages?
0
votes
1answer
480 views

carto.com when 2 points have the same location

Carto.com: We are mapping homicides and when two deaths occur at the same location, how do I prevent 2 points with the same lat, lon from overwriting each other? I want to be able to view each point ...
0
votes
2answers
919 views

Drawing curved lines in CartoDB?

I am experimenting drawing curved line from Origin to Destination in Cartodb. I was able to do so once, however, failed the second and third time. Could anyone offer me some insights into the ...
0
votes
1answer
366 views

Does Cartodb have a function to change center location based on user location?

I would like to have the map open up a the users current location. I only see documentation for setting the center on init, I would like it to be dynamic..
0
votes
1answer
317 views

Animating quantitative values in Carto Torque Cat?

In Carto (CartoDB), is it possible to change the category classifications in “Torque Cat” to be qualitative instead of categorical, as you would have in the “Choropleth” map? Both the values and the ...
0
votes
1answer
906 views

Cartodb.js tooltip on a viz

I am having a hard time implementing a UI tooltip in a CartoDB.js viz. Could someone demonstrate how to implement using this fiddle on the variable {{NAME}}?
5
votes
4answers
1k views

Where to host private CartoDB/Leaflet web app

I am looking for suggestions/recommendations on where to host my cartodb/leaflet map site. It needs to be private with authorized users and have a document management system. So, I was thinking ...
2
votes
3answers
2k views

Is there a way to get a viz.json url from Carto Builder?

Questions for any Carto users/developers here. I am trying to find out a way to a get a viz.json url that can be used as an overlay on a Leaflet map using Carto.js API. However, I can't find it under ...
2
votes
1answer
1k 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 ...
6
votes
1answer
2k views

Invalid GeoJSON when inserting data to a CartoDB (PostGIS) table from Leaflet

I've been following along to this tutorial from CartoDB. I create the GeoJSON using: var drawing = "'"+JSON.stringify(layer.toGeoJSON())+"'"; and then inserting using a custom SQL function which ...
5
votes
1answer
2k views

is there any direct access to Mapbox data? (similar to CartoDB's sql api)

I've been asked to add a form to a map that will write data in the background (e.g., ajax to a magic file that does datawrites and some emailing, notifications etc) and a new marker will be added to ...
4
votes
2answers
2k views

CartoDB- Passing selected features bounds to map center parameter (Zoom to selected features)

Looking to build a light-weight viewer for some data we have hosted on CartoDB. I'm looking to have a user input their address into an input, pass a query to CartoDB and have the map zoom/pan to the ...
2
votes
2answers
1k views

How does Leaflet layer ordering work with CartoDB layers?

All, I'm trying to figure out how Leaflet layer ordering works when you have layers coming from CartoDB. I have a map with 1 polygon layer (cartodb), 3 point layers (cartodb), 1 basemap layer (mapbox)...
2
votes
2answers
547 views

Avoiding SQL injection when updating tables through CartoDB API

I'm trying to write a routine which synchronises data in our database with the CartoDB database, so we can display it on a map. It's simple things like names and contact details, which our users have ...
1
vote
0answers
1k views

Can I do a toggle map view with multiple layers in the cartodb UI?

I have successfully created a toggle map following the instructions in this tutorial http://developers.cartodb.com/tutorials/toggle_map_view.html. The toggle map is linked to a map in my cartodb ...
4
votes
2answers
442 views

Applying https to Carto map but requesting insecure data?

I am building a site using data from CartoDB that locates someone on a map, and Chrome requires that be over https. I added an SSL, but it was not working, the page showed up black. I found out that ...
4
votes
1answer
1k views

Choropleth Mapping Using Quantile Method in CartoDB

Does anyone know how CartoDB calculates the buckets for a choropleth map using the quantile method? My understanding of choropleth maps that use the quantile method is that they will assign an equal ...
3
votes
2answers
252 views

Link to another table in CartoDB infowindow

I have two layers in CartoDB, one with spatial data, school_count, and one without, heisman_winners. I want to visualize my spatial layer but when a user clicks on a feature I want it to display data ...
3
votes
1answer
524 views

How to include and format multiple rows in inforview from cartoDB

I have seen similar questions answered but I have not managed to find anything suitable. I have some buildings and when I click on a building I want the name and website of the companies in it. I ...
3
votes
1answer
325 views

Two cartodb visualization on the same html page

I need to display 2 maps separate by vertical line on the middle of the html, it means on diferents and make some buttoms or aplicate the same zoom on both at the same time. I managed to put one ...
2
votes
2answers
2k views

How to add rows from a Dataset to another?

The DB I have is divided in many datasets (shape format, each .zip I send to CartodDB consist of 4 files, .dbf, .prj, .shp, .shx). The problem is that the free account only allows 4 datasets, each one ...
2
votes
3answers
1k views

how to enable interactivity on named map in cartodb

I have created a named map that gets data from a private table. I can load it into a Leaflet map and can change its marker-fill color placeholder using layer.setParams. However, I cannot get ...
2
votes
2answers
1k views

CartoDB choropleth + bubble visualization with two independent value ranges in legend

I have been trying to display two values simultaneously i.e. one absolute value displayed by bubble size (as with layer wizard: bubble) and one relative value displayed by color (as with layer wizard: ...
2
votes
1answer
537 views

Can individual feature properties be retrieved from the CartoDB.js API?

I'm building an application that uses CartoDB to show users how a proposed redistricting plan would affect them. The user enters an address and that fires a ST_Intersects query to CartoDB, the result ...