Stack Exchange Network

Stack Exchange network consists of 174 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
Make your voice heard. Take the 2019 Developer Survey now

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.

1
vote
1answer
249 views

Showing user's location on Carto map?

I have a series of tram stops on a Carto map and would like to indicate the user's location. Is this doable in Carto? https://jamieparker.carto.com/builder/161cab96-859b-433d-8a72-5ae5653b1b8e/...
0
votes
2answers
89 views

My click infowindow does not change for nearby points.

My cartoDB map has several observations/points and sometimes they are clustered. I have infowindows setup for each point and it displays when I click on them. The problem happens when these points are ...
1
vote
1answer
43 views

Fixing line breaks in cartoDB infowindow?

I am having trouble with my cartoDB infowindow, the text breaks no matter if I resize the window. Please, take a look at the screen shot below. How can I resolve the issue? Where should I work, ...
1
vote
1answer
44 views

Displaying null locations using CARTO Builder? [closed]

I'm using CARTO to display locations of conference. Some of the conferences were "teleconference" so they don't have an actual location. Is it possible to display them on the map with the annotation ...
0
votes
1answer
139 views

How does one populate a column in Carto with calculated values that have rounded decimal places?

I am now able to populate a new column with a calculated percentage with this SQL: UPDATE <table> SET <newColumn>=subtotal/total Could you assist me with the required SQL query to set ...
0
votes
1answer
95 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 ...
-1
votes
1answer
198 views

how cartodb.createLayer function works

i am using cartodb.createLayer() function to prepare my web application. I have tried to pass vizjson url and metadata method both to get my layers from my carto account which has total of 8 layers in ...
0
votes
0answers
39 views

Refresh sublayer in CARTO.js [duplicate]

I've updated data in my carto account and wanting to see those changes reflected on the map I create using CARTO.js, however I'm unable to find a way to automatically refresh the respective sublayer ...
0
votes
1answer
115 views

Mapping traveller routes using Carto?

Hi have a database from one app that was used to register travels made by the staff. The recorded rows looks like: travel id (#) leg id (#) leg departure (date time and city) leg arrival (date time ...
0
votes
1answer
62 views

How to pull data from an existing PostGIS database into Carto?

I have an existing PostGIS database. I want to be able to access my tables from that DB on my Carto enterprise account. Any suggestions?
1
vote
1answer
50 views

Displaying a value as a symbol in Carto?

I am working in Carto and have a geography (NYC Community Districts) and values associated with each community district (# of units built). I is possible to display those values as graduated symbols ...
1
vote
2answers
27 views

How do you change the titles displayed inside infowindows in Carto?

The titles in my infowindows are copied straight from my column headings in the underlying data... So it says "STREET_ADDRESS" when I'd like it to display "Address" or "YEAR" when I'd like it to ...
1
vote
0answers
64 views

Map is not showing in Carto

I've created a map in Carto.com with two layers and two widgets. In the builder everything looks fine but somehow this map is not showing anything after I published the map. Find a link: https://wash-...
0
votes
1answer
217 views

Drawing curved lines in Carto?

I have a dataset that has the following structure: City_Start / Lat_City_Start / Long_City_Start / City_Dest / Lat_City_Dest / Long_City_Dest What I want to do is create a curved line between those ...
2
votes
1answer
56 views

carto sidebar not showing

just started learning how to use carto using the tutorial HERE. My sidebar isnt shown anywhere on my dashboard. How do i find this so that i can continue with the tutorial.
0
votes
1answer
33 views

How to designate a column of polygons as a georeference

I uploaded a dataset with a column of polygons, but the map is blank. It's been a few years since someone has asked this question and looks like the dashboard has changed since then. How do I ...
0
votes
2answers
208 views

CartoDb Response for preflight is invalid (redirect) error

I created a map in carto and then applied to my c# application like CartoDB source example that I saw on openlayers web page. like this: var mapConfig = { 'layers': [{ 'type'...
9
votes
1answer
1k views

Why is st_intersects faster than &&

It's a table of points. ~1M records SELECT COUNT(*) as value FROM alasarr_social_mv s; Output: 976270 It looks like st_intersects forces to use the spatial indexes but && doesn't. Sample ...
0
votes
2answers
85 views

How CARTO (or other GIS-software) decides where labels are located

I´m calculating the distances between different places in my region/country. I don´t know where I can find a database of all the towns/cities already geolocated, so I have a question for considering ...
1
vote
1answer
495 views

How to merge a dataset with geometry an another with number data?

I want to merge a dataset with geometry and another with the number data to use. In each one datasets are a field (codparr in one, and cod_parro in another dataset) with 51 values(3601701,3601702,...
-1
votes
1answer
173 views

How do I draw polygons in Carto Builder?

I am trying to add an area around a data point to show its reach. I.e. draw a polygon in reference to a point. How do I do this?
0
votes
0answers
54 views

Layers Zindex on charging Named Maps in carto

Right now I have an application that allows me to load a Named Map (NM) under petition. The problem is that when a NM is charged on the map, sometimes the features overlap one with another. I imagine ...
1
vote
2answers
305 views

How could you calculate the distance between multiple associated points, specifically a list of structures serving specific addresses within CartoDB?

I have loaded two point datasets into CartoDB. The first is a list of structures serving specific addresses, each structure has a unique code associated to it as well as the location of the structure ...
1
vote
2answers
673 views

How to save a Temporary Column in PostgreSQL?

I have a vector layer consisting of polygons. I'm calculating the area of each area by the query: SELECT *, ST_Area(the_geom::geography,true) alan FROM pl_park I'm using Carto to query the data. The ...
0
votes
1answer
52 views

show all points of carto-point-layer at low zoom-level

I have a Leaflet-map with a carto-layer(points), using the createLayer-method. It seems that Carto is doing something internally, that not all points are shown at low zoom-levels. Each time zooming ...
0
votes
1answer
30 views

How do I set map dot colors based on a JavaScript variable?

I'm trying to dynamically set my Carto map's dot colors based on a JavaScript variable. var queryAllRows= "SELECT+" + colNames.join(',') + "+FROM+MY_TABLE_NAME"; queryAllRows= queryAllRows....
1
vote
1answer
36 views

How to export a list of intersections of 2 datasets of boundries/polygons

I am using the following datasets: NYC Zip Codes: https://data.cityofnewyork.us/Business/Zip-Code-Boundaries/i8iw-xf4u NYC City Council Districts: https://data.cityofnewyork.us/City-Government/City-...
0
votes
1answer
591 views

Create a new column and update it with the results of a calculation in Carto

My dataset in Carto has columns with subtotals and a column with total - I would like to create a new column with the calculated percentage in Carto - is there a way to do this?
0
votes
0answers
63 views

Visualize a dynamic raster in web application (preferably via Carto)

I'm wondering about the best way to visualize a dynamic raster in a web application, particularly Carto. This would involve performing map algebra calculations on the fly, and visualizing the ...
0
votes
0answers
73 views

Why raster image uploaded in Carto has some blackened areas?

When I upload my geo-referenced raster file to Carto and display it in a web application I get the result below ; But When I use gdal2tiles for the same image and create tiles I'm not getting those ...
0
votes
1answer
39 views

How to let the right toolbar of CartoDB show out?

How to let the right toolbar of CartoDB show out? My page window is different from that in the guiding video.
1
vote
1answer
294 views

Making legends in Carto Builder reflect custom class breaks for graduated symbols?

I am trying to build a map using Carto Builder that compares the average price of single family housing and multi-family housing by neighborhood. The data are offset centroids for each neighborhood, ...
1
vote
0answers
172 views

CARTO: centered icons instead coloured countries

In CARTO I'm making a tourists per country map Instead of colouring countries, I'd like to put a centered Bagpack icon in the middle of every country, of size depending on the amount of tourists. ...
0
votes
0answers
27 views

How do I set styles by SQL query in Carto JS API? [duplicate]

Let's say my Carto data looks like this state, val1, val2 Alabama, 10, 20 Delaware, null, 100 I want to set each state's color based on the sum of val1 and val2. How do I do this in Carto's ...
0
votes
1answer
127 views

Sending carto a SQL API request for column names returns error

I got a tip from a previous question for getting a list of column names in a Carto table. I enter this into my browser: https://MY_CARTO_USERNAME.carto.com/api/v2/sql?q‌​=SELECT column_name FROM ...
0
votes
0answers
28 views

How can i reduce text size in CARTO metadata using markdown?

I have a lot of text (mostly data licences) that I need to include in the metadata of a CARTO map. Trying to find the right markdown syntax to reduce text size so it fits. Any suggestions?
0
votes
1answer
76 views

Carto JS only gets cartodb_id on click

Here's my code: function main() { // create leaflet map and define some properties var map= L.map( "map", { ...
1
vote
0answers
39 views

Configuring HERE maps on CartoDB Builder (config/app_config.yml) [closed]

I'm installing the CartoDB platform on productive environment. I'm working on about 2 weeks with all tutorials I can find with Google, reading the repository documentation, and all stuff that can help ...
0
votes
1answer
190 views

Two maps using Carto and Leaflet with same events (zoom, pan, etc)

I need a HTML page to compare two maps from Carto using Leaflet with same events, i.e. a Pan (or Zoom In/Out) event in Map1 aplicate the same in Map2. I saw this example (Two cartodb visualization on ...
0
votes
1answer
115 views

Refresh Map on HTML page when data change

I am new about Carto and I have a question. I would a HTML page with Carto Maps (using JavaScript) and I would refresh the page when the data on CartoDB change. So I ask if there is a sort of Push ...
0
votes
1answer
34 views

Close CartoDB Infowindow from Template

I have seen the different solutions that store the info window in a variable and close it from outside of the info window, however I would like to have a possibility to close the info window from ...
0
votes
2answers
85 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", { ...
0
votes
1answer
332 views

Setting a polygon-fill ramp to have minimum and maximum values

Using the Carto web-tool I've set up a map to fill polygons based on the value of one of its attributes. However, due to outliers in the data the attributes range in values from 0 to >600, where as I ...
1
vote
1answer
80 views

Having CARTO legend items act as Radio Button?

Currently, I have a web map with multiple layers. I would like the final user to be able to select one layer can be turned on at a time. Currently, multiple layers can be turned on, but only the ...
0
votes
1answer
62 views

several setSQL-calls in one function

I have a carto-map that consists of four layers. The users of my map should have the option to choose the map projection. For one layer this works fine: $('#selectProjection').on('click', function() ...
0
votes
2answers
104 views

Adding layers and visualizing data simultaneously from both

I am having a trouble showing data from a second level. For example, I have joined my two data sets with matching row: Community districts in NYC. The first layer has a thematically shaded map of ...
1
vote
1answer
95 views

Problem updating infowindow

I have a problem with the infowindow of one of my sublayers in a Carto map. First of all I'll show my code. I create the layer options and then I get my sublayer. I set its options and a first version ...
0
votes
1answer
213 views

Carto maps - get map scale / size

I'm looking for solution how to get current map size (in kilometers) with current zoom level. Is there a way how to calculate map scale?
1
vote
0answers
220 views

How to show a carto map in an ionic 2 app?

Has anyone shown a carto map in an ionic 2 app? When I used ionic 1 there was no problem, because it is angular js and I could add the library in the index.html: <link rel="stylesheet" href="http:/...
4
votes
1answer
161 views

How to remove the layer name in a legend in CARTO?

Is it possible to remove the layer name within the legend (bezirke & berlin_pts). I tried all the obvious ways, but could not manage it.