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,438
questions
0
votes
1
answer
33
views
Opacity problem with Carto static maps API V1 and .JPG image type
EDIT
If I change the last three characters of the image request URL to be png instead of jpg, then the image renders nicely.
Original question
A few years ago, my Carto anonymous map was rendering ...
- 342
4
votes
1
answer
394
views
Styling vector tiles from Carto in QGIS
The CDRC have a range of useful maps online here: https://mapmaker.cdrc.ac.uk - previously they used XYZ Tiles which could be re-used in QGIS easily but the new system uses Vector Tiles hosted on ...
- 61.5k
0
votes
0
answers
23
views
Centering Carto on Europe instead of North America Default
I'm using Carto for a project that maps locations of a poet in NYC and Paris.
Is there a way to set the default map orientation to center on "Europe" instead of "North America"?
0
votes
1
answer
288
views
Converting SQL queries from PostGIS to BigQuery
I have a table called drawn_items with columns “the_geom”, “fsrn_db” , & “area” in Carto2 which is queried by SQL. Having recreated the table in Carto 3, in order to use the query, I must ...
- 63
3
votes
1
answer
315
views
Leaftlet Map with Carto database to recalculate area on polygon edits
I have a Carto database called drawn_items with the columns cartdb_id, the_geom, fsrn_db and area.
The following JavaScript code (which I will call code 1) inserts a new row into the carto table drawn ...
- 63
1
vote
1
answer
59
views
Can't rename old dataset and import/upload new one with the original name: Skipping Ghost Tables linking
I'm trying to run a script that renames the existing carto dataset to {CARTO_DATASET_NAME}_previous and then uses the import api to upload a file with the original name {CARTO_DATASET_NAME}. The ...
- 143
1
vote
1
answer
91
views
Carto workspace
I’ve been following the tutorials available here http://132.72.155.230:3838/js/databases.html which show you have to set up a database in carto 2 and query it using sql requests. It seems simple ...
- 63
0
votes
1
answer
91
views
Return CARTO Map in Flask
I am developing an app with Flask and Cartoframes.
How return Map in template?
My code:
from flask import Flask,render_template
from cartoframes.auth import set_default_credentials
from cartoframes....
- 141
0
votes
1
answer
18
views
"Edit feature properties directly from the map" by a user who has been sent a link, can then edit a pop-up directly on the map
Edit feature properties directly from the map:
https://carto.com/blog/edit-feature-properties-directly-from-the-map/
With the new feature editing modal window you are able to edit the
properties of ...
0
votes
1
answer
573
views
Convert latitude/longitude to carto geo points [closed]
I have a pandas df in databricks, with two column latitude and longitude, and I want to convert them to geom points in order to conduct the whitespace analysis. How can I use carto Python API do this?
0
votes
1
answer
28
views
Compositing Operations in CARTO VL
Is there any way to do (or emulate) the compositing operations that can be done in CartoCSS with CARTO VL? The closest I've been able to find (which hasn't been that close) is the ways to change the ...
- 243
1
vote
0
answers
564
views
Credit attribution and use of basemap
I am using a basemap (http://basemaps.cartocdn.com/light_nolabels/{z}/{x}/{y}.png) in QGIS to draw a map for a scientific paper.
I am trying to understand who is the "owner" of this map and ...
- 289
0
votes
1
answer
84
views
Uploading file geodatabase to CARTO
I'm new to Carto and I'm trying yo upload a gdb file but I cannot see the option in the display formats.
How can I upload it?
0
votes
1
answer
111
views
Carto time-series widget: how to change bucket labels?
I am using the Carto builder animated time-series widget based on a number column that contains a year as a four digit integer. In the widget's horizontal axis, the buckets are not labeled with ...
- 21
0
votes
1
answer
73
views
Return geocode information with Carto
I'm using the Carto API for a few functions and I'm looking for a way to return geocoded information similar to how Google does it here. With Google, you make a call with the Address like: https://...
0
votes
1
answer
223
views
How can you change the layer ordering of OpenStreetMap tiles?
I found this picture on the carto.com website and wondered how one can render tiles where the street and district names are above the data overlay. What are ways to achieve this?
I have the mod_tile ...
2
votes
1
answer
202
views
Zoomable world map with small countries highlighted
I'd like to create a zoomable world map where countries/territories are color-coded. This is a pretty standard request and Carto has a nice example.
However, in standard maps like this, small ...
- 195
0
votes
1
answer
73
views
Iterate through date columns in CARTO (frames, VL, etc.)
I currently have a data file that has columns for each day over an 8-month period.
I am seeking of a way to create an interactive CARTO map that displays the change over time. I want to know if there ...
- 55
0
votes
1
answer
29
views
Search Function Carto VL
I'm new to Carto VL and html, and could use some help. I'm currently building a map using Carto VL and want to implement a search feature that allows users to type in a location and have the map zoom ...
0
votes
1
answer
174
views
How to create an interactive based filter (checkboxes) with multiple layers using Carto VL
I'm relatively new to coding, and have been developing a map using Carto VL and Mapbox. I've found a way to create a filter within a map where users can turn off and on different categories within ...
0
votes
1
answer
336
views
Updating map after zoom change
I'm building a map that uses a conditional statement to determine what data to load based on the zoom level. However, the conditional statement is only fired when the map first loads, as opposed to ...
0
votes
1
answer
55
views
Displaying currency format in CARTO Builder scorecard widget
I am creating a map in CARTO Builder and I would like to have a scorecard widget showing the average income across all points on the map. In the scorecard, I want the average to be displayed with ...
0
votes
1
answer
63
views
Carto Bubble-legend class
I'm trying to Add a Bubble legend with Carto VL to my map but the Bubbles are rather showing as a block and not bubble.
Is the "Bubble-legend" class deprecated or should I style it myself ...
- 3
-1
votes
1
answer
98
views
Interactive filtering histogram widget with cartoJS
I would like an interactive filtering histogram widget like this one https://public.carto.com/builder/0c982e6d-b254-4e2b-86ed-e0f097f519c2/embed (the population density histogram widgets on right ...
- 99
1
vote
1
answer
301
views
How does Carto make it possible to interact with elements on their tiles? Can I do the same with Leaflet?
I was looking at this Carto Map. You can click on a building and it shows some extra information about it.
Then I noticed that these buildings weren't added as individual polygons or something like ...
- 123
0
votes
1
answer
57
views
Regenerate an isochrone through a widget in CARTOframes
Is there a way to re-generate an isochrone in a CARTOframes map from some kind of user interaction?
For example, modify the minute's value:
isochrones_gdf, _ = Isolines().isochrones(stadiums_df, [15*...
7
votes
1
answer
513
views
How to produce opposite semicircle maps in CARTO or QGIS?
I need to produce a map of opposite semicircles or concentric circles to represent two numerical columns on the same map simultaneously.
I have already tried to create a layer for each column's data ...
1
vote
1
answer
126
views
Carto: Can I use some “if/then/else” structure in popup custom HTML?
I believe I am asking a question similar to this question that was asked a few years ago about popup functionality in the old CartoDB. I just tried my best to replicate the solution to that question ...
- 1,080
0
votes
1
answer
104
views
Populate field with drive time values during isochrone creation in Carto
I'm creating isolines (isochrones) in Carto to show 15, 30, 45, and 60 minute drive times from a set of points in a shapefile. Here is the SQL I've written to create those isochrones in an empty table....
- 1,080
0
votes
1
answer
45
views
Is it possible to share CARTO datasets with password?
It's my understanding that only CARTO maps can be password-protected, not datasets. I'm currently using the datasets like so:
const source = new carto.source.Dataset(dataset);
const style = new carto....
0
votes
1
answer
28
views
Access feature data for all features in a NamedMap
For any Cartodb NamedMap, we load it using this function:
cartodb.createLayer(map, namedLayerSource, {https: true})
.addTo(map)
.done(function (layer) {
});
After that I need to ...
0
votes
1
answer
128
views
How to Use ST_MakeLine query in leaflet to connect to Carto
I want to run in leaflet a query that works in carto Builder to connect points in a line:
SELECT ST_MakeLine(the_geom_webmercator) as the_geom_webmercator, min(cartodb_id) as cartodb_id FROM my_table
...
- 21
0
votes
1
answer
87
views
Trouble working with a .TSV containing WKT
I'm working with a .TSV file that represents district boundaries in a portion of a country in Carto. The polygon data is represented in a string column of Well-Known Text lat/long vertices, which I'm ...
1
vote
0
answers
46
views
How to obtain a live route on a carto map? [duplicate]
My main goal is to build an app that send lat lon from my smartphone to my carto (postgis) database and show the route "live" (in real time) as a line and not as a lot of points.
i am able to save ...
- 21
0
votes
1
answer
50
views
How do I delete data older than 7 days in CartoDB? [closed]
I'm trying to delete data that's older than 7 days. I'm not sure how, though (no SQL experience). Everything I've tried to Google doesn't work.
The dates are formatted like "20200426" if that makes ...
- 1
2
votes
1
answer
427
views
What is the difference between the the_geom and the_geom_webmercator in CARTO?
I'm trying to use CARTO for a school project and so I've just been trying to get the hang of the basics of using it and Postgis at the same time. I've read their docs about the difference between ...
- 93
1
vote
1
answer
133
views
Map doesn't show up in CARTOframes
I'm new in Carto. I have been trying to figure out how Maps are used, I tried this code that is in the web; however the map is never displayed.
from cartoframes.auth import set_default_credentials, ...
- 11
0
votes
1
answer
148
views
Adding featureOver on map for multiple layers using carto.js and leaflet
How can I add featureOver on map for multiple layers(layers added dynamically) using carto.js and leaflet. This functionality have worked only for one layer. Here is my code:
layer.on(carto.layer....
1
vote
1
answer
213
views
Drawing a directed line based on dataframe indexes?
I trying to draw a directed graph based on a geopandas dataframe with the Cartoframe library.
The Geopandas dataframe has the following structure:
deviceId routeLoad longitude latitude ...
- 139
0
votes
1
answer
34
views
Does Carto.js v4.2 support Named Maps?
I was trying to update my carto.js code from v3.15.19 to v4.2. What I recognized that carto.js v4.2 is no longer supports Named Maps.
I researched a lot and checking into the documentation made me ...
0
votes
1
answer
33
views
CARTO.js changing the styling only on one segment of a line with multiple segments
I'm attempting to change the styling of a line segment when clicked on a layer that has 4 segments. Only one segment's style would be changed at a time. Each segment has it's own column within a CARTO ...
-1
votes
2
answers
101
views
Join dataset to geography in Carto (Python)
I'm subscribed to two datasets and one geography on Carto Data Observatory. How can I join them to each other using Python?
I have converted both datasets and geography into pandas dataframe, then ...
- 21
1
vote
1
answer
48
views
Checking status of layer calculation using API
I wrote a python script that updates the values in a dataset and then returns a static image of the map it's connected to.
The problem is if I download the image too soon after updating the dataset, ...
1
vote
0
answers
53
views
CARTO update existing table from external MySQL database
I would like my Carto data to be updated, using external data (MySQL database, I run and manage locally using PHP scripts), so that the Carto table gets updated with the most recent data, whenever the ...
- 11
2
votes
0
answers
41
views
Carto animation only showing data points in 1 min intervals
I'm trying to animate location data points, and instead of showing each point at its correct time, Carto seems to show a group of points every 1 minute (1 minute in the visualization, not real life).
...
- 33
1
vote
2
answers
99
views
Many to one join in Carto
I have two datasets:
A point shapefile of companies (each row/record is a unique company)
A list of awards given to those companies (each row is a unique award, but since companies can win multiple ...
- 1,080
1
vote
2
answers
54
views
Finding format of data source used in official Carto example
I'm trying to apply my own data to this example, but I'm not sure what format the original data was in. I've checked through Carto's stock datasets in the web dashboard, but I can't find it.
Is ...
- 33
0
votes
1
answer
256
views
How to use Facebook (GeoTIFF) maps on Carto?
My intuition is that the maps that Facebook generated for most countries are most useful on interactive maps like Carto's, as the killer feature is the resolution for which you'd need to zoom in.
...
- 379
1
vote
0
answers
108
views
Using Carto's "Static Maps" API from Python
I want to download a static image of a map to my local PC via a Python script.
I'm using carto-print: carto-print
I have tried this method:
from xlwings import Book, Range
from carto.auth import ...
0
votes
1
answer
37
views
How can I list all of the sites on my CARTO map on the side of the map for easy access?
I have created a map in CARTO that I would like to have all of the different sites in a list on the side of the map (similar to what the current widget does, but with more than 5 sites, and ideally ...
- 9