Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

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
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 ...
3
votes
1answer
630 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 ...
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
869 views

PostGis - BBox -vs- ST_intersects Queries

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
288 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
602 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
399 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
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....
3
votes
1answer
494 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 ...
2
votes
1answer
753 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
401 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
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 ...
1
vote
1answer
1k views

Can I hide a sublayer with a toggle button using the 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 ...
0
votes
2answers
89 views

How do I set color of map dots in Carto Javascript API?

I'm using Carto JS API. function main() { // create leaflet map and define some properties var map= L.map( "map", { ...
3
votes
1answer
552 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
278 views

Is there a way in Cartodb.js to include an autcomplete search bar?

I am using the code below to add a search bar to my mapping application, is there a way to include an autocomplete search bar? Something that would provide suggestions based on what the user is typing?...
2
votes
1answer
505 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 ...
2
votes
1answer
925 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
2answers
195 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
905 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 ...
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 ...
1
vote
1answer
624 views

Where to start with great circle maps in CartoDB?

I've pulled together a series of maps in R based on Nathan Yau's excellent Great Circles tutorial and a nice zipcode package The maps show how many people from many zip codes descended on a single zip ...
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
607 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 ...
0
votes
1answer
6k 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
904 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}}?
0
votes
1answer
270 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
403 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
1answer
100 views

Proper use of layer.invalidate() in Carto.js

According to the Carto.js documentation, layer.invalidate(): "Refreshes the data. If the data has been changed in the CARTO server those changes will be displayed. Nothing happens otherwise. Every ...
0
votes
1answer
516 views

How to use image_url from dataset in Carto Builder HOVER pop-up window?

I am creating a map in Carto Builder with several points. I want to set the pop-up (hover) to display information from my dataset, including an image which is dictated by the corresponding image_url ...
0
votes
2answers
911 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
356 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..
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
1k 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 ...
5
votes
1answer
1k 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
522 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
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 ...
4
votes
2answers
395 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 ...
3
votes
1answer
512 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
2answers
249 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
307 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 ...