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
12
votes
6answers
28k views

3D perspective on maps in Leaflet, CartoDB?

Are there any JS library out there that would render normal, flat maps (like Leaflet) into a perspective map like this one, on the web: Also, anyone seen anything that could turn CartoDB data into 3D ...
11
votes
1answer
525 views

What is the future of CartoCSS (i.e. does it have one)? [closed]

MapBox recently announced that they would be moving away from CartoCSS towards a completely visual interface. Apparently the new style sheets that underlay that UI will be JSON based, so despite the ...
9
votes
1answer
2k 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 ...
9
votes
1answer
484 views

online map of 242,888 locations: which service to use? (what if temporal heat map?)

I have a 161.8 MB large CSV file with geocoded locations (with latitude and longitude) for 242,888 lines. I want to have an embeddable online map of all this. I wonder which service could deal with ...
8
votes
3answers
2k views

What is the simplest way to write data to CartoDB using Python?

I'm trying to write a function in Python that will use the CartoDB API to write data to one of my tables. Does anyone have a simple example that shows how to do this that I can use to start?
8
votes
1answer
3k views

CartoDB opensource vs paid one?

What's the difference between open source CartoDB version vs the paid one? this one the open source: https://github.com/CartoDB/cartodb and this one the "paid" version: https://carto.com/ i don't ...
7
votes
2answers
786 views

Show change in size over time

I'm a linguist, not a geographer, and a first-time poster here. I have some data about the use of a particular phrase in England between the years of 1225 and 1500. I have geolocations for the places ...
7
votes
0answers
268 views

Installing CartoDB on Raspberry Pi Model B? [closed]

Has anyone gotten CartoDB to work on a Raspberry Pi? I was able to install everything (minus the PPAs and the two node apps) on my Pi that are in the README. I'm wondering if anyone else has done ...
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 ...
6
votes
3answers
2k views

Seeking xyz basemap catalog? [closed]

I've been using cartodb odyssey.js for a couple of months and the https://khms1.googleapis.com/kh?v=152&hl=es-ES&x={x}&y={y}&z={z} XYZ basemap has sufficed so far. However, I'm working ...
6
votes
1answer
3k views

How to add a new permanent column that contains result from ST_AREA select queries

I have a bunch of polygons in my CartoDB map, and I want to create a new column called AREA in the table MY_TABLE that contains values from my area calculation query: select ST_Area(the_geom::...
5
votes
3answers
852 views

Cleaning up data in Excel for use in QGIS

I am trying to clean up a large .txt dataset in Excel. I think that a macro or another application may be able to clean up the data they way I want but I have limited programming skills. I need to ...
5
votes
1answer
2k views

Find number of points within certain radius of a set of points

I have two tables. One is a list of stores (with lat/long). The other is a list of customer addresses (with lat/long). What I want is a query that will return the number of customers within a certain ...
5
votes
3answers
499 views

How do I password protect a CartoDB Visualization

We have some data and a visualization that we would like to make available to a small user community. How do I password protect a CartoDB visualization without making it public.
5
votes
3answers
718 views

How do I make a public download page for my CartoDB table?

I have some CartoDB data that I'd like to make available to people as shapefile, geojson and csv. I just came across http://opensandiego.cartodb.com/tables/5037/public/map which has a great map ...
5
votes
2answers
464 views

How to use external CartoCSS/mss within JavaScript?

I am using CartoCSS to style features in a run-time CartoDB layer (as opposed to a pre-made visualization) but it gets messy doing this within JavaScript: sublayers: [{ cartocss: '#initvisitedfws {...
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 ...
5
votes
1answer
459 views

CartoDB Torque viz: make bubbles grow to show intensity/frequency?

I'm working on a project that maps the places of origin of the "letters to the editor" submitted to a magazine. I'm using CartoDB's Torque viz to show the evolution of this data through time. I ...
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 ...
5
votes
1answer
484 views

Can QGIS access cartodb tables via OGR?

I see that it is possible to access Google Fusion Tables in QGIS using OGRs Virtual Format layer. Shown here and details about the Google Fusion Table driver here. I was wondering whether something ...
5
votes
1answer
1k views

Cluster Markers with CartoDB

Is there an easy generic way to cluster Markers with CartoDB?
5
votes
1answer
85 views

Cartodb API Read Only

Is it possible to generate an API-key in Cartodb with read-only permission? Seems like the default API-key has full controll
4
votes
3answers
5k views

generate spatial geom from lat lon points for map in PostGIS

I am interested in a PostGIS implementation of the R-based soulution from a previous question, How can I convert data in the form of lat, lon, value into a raster file using R? Currently, I am hoping ...
4
votes
3answers
1k views

Can I have more than 4 layers on my map in Cartodb?

I know Cartodb has the layer feature where you can create four different layers within one map, but is there a way to create more? I want my viewers to be able to choose between more than four layers ...
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 ...
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 ...
4
votes
2answers
440 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
580 views

Where is Cluster point style in new Carto?

In the old interface for CartoDB (Carto Editor?) overlapping points could be displayed as clusters allowing users to click on a cluster to distribute the points visually and select one to read the pop-...
4
votes
1answer
502 views

Why can't Carto recognize the coordinates of my csv file?

Carto can't recognize the point geometry of some of my csv files. For example I can visualize in ArcGIS the point geometry of this csv file I have posted here. But when I upload the file to Carto it ...
4
votes
2answers
1k views

How to map places with zip codes that have leading zeros using CartoDB?

I have a large set of data that has several places on the East coast that have leading Zeros in the Zip. How do I map these when leading zeros are automatically removed?
4
votes
1answer
1k views

When we create a CartoDB table using SQL, is there a way to register it with the tables dashboard?

I have been able to create tables that conform to the CartoDB style by the following method: Create empty table [table name], no columns via SQL API SELECT CDB_Cartodbyfy([table name]) via SQL API ...
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 ...
4
votes
2answers
479 views

Is it possible to vary the sql query based on Zoom level?

I am trying to create a map where I have added a layer with place names. There are thousands of those in the database, and I am looking for a way to show only the most important ones on the lower zoom ...
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
1answer
820 views

Can CartoDB and Mapbox.js talk?

All, Back in December it seemed there was no way to bring in a CartoDB layer into a Mapbox.js or Tilemill project. Has this changed? (http://support.mapbox.com/discussions/mapbox-tiles/763-cartodb-...
4
votes
1answer
2k views

Adding CartoDB basemap in OpenLayers 3?

I'm trying to add a CartoDB basemap to my OpenLayers map but I can't get it to work. Here is the code I use to declare the basemap variable: var carto = new ol.layer.Tile({ source: new ol.source....
4
votes
1answer
911 views

Can a CartoDB-Torque map be used for polygon instead of a point data?

Can you use Torque for country data - polygons instead of points? Make animated maps with polygon data instead of point data? I would like the color of countries to change over time as a particular ...
4
votes
1answer
148 views

Error trying to import data to CartoDB using ogr2ogr

I have a local install of CartoDB in my Ubuntu 14.04. I have created a CartoDB account called "development" and been playing with it for a while. Now I'd like to import some data from a shapefile ...
4
votes
2answers
1k views

How do I add a CartoDB layer to a MapBox map?

I'm having some trouble adding a CartoDB layer to an L.mapbox.map, I thought it was a pretty simple thing to do in the HTML but it's just not working and I don't know why. My CartoDB layer has vector ...
4
votes
1answer
448 views

Showing Linestring from SQL statement with CartoDB

I have cartodb sql statement to return what polygons are intersected by a linestring, but I'd like to have the linestring visualized over the polygons on the results. Also not add the linestring to ...
4
votes
2answers
179 views

cartodb visualization ownership transfer

I have a visualization created in my cartodb personal account. Can I transfer this viz to my company's enterprise account without recreating it there?
4
votes
1answer
2k views

How to view a raster in CartoDB?

What is the easiest way to view a raster in CartoDB? From the list of formats that you can upload into CartoDB, I noticed that .tif is available, so I've tried adding a GeoTIFF, but it says that ...
4
votes
2answers
341 views

cartodb SQL API security?

I am studying CartoDB, and am wondering: To what extent is CartoDB SQL API secure? From their description about authentication, you can submit entire SQL statements in the URL by appending the ...
4
votes
2answers
470 views

Using a Nokia HERE map within CartoDB

I currently am developing a map that uses the following code to set the map background: //set the map background L.tileLayer('http://{s}.tile.thunderforest.com/transport/{z}/{x}/{y}.png', { ...
4
votes
2answers
323 views

Text codes keep coming in as numbers, stripping out leading zeros

I'm trying to merge census tract data with a census tract shapefile in CartoDB. Despite saving the tract ID codes as text/string in both .csv and .xlsx (including reimporting the .csv as text into ...
4
votes
1answer
93 views

Setting up and displaying many-to-many relationships with CartoDB

I have to display many-to-many relationships between offices and sub-offices for a client. Each office manages many sub-offices, each sub-office can be managed by many offices. The client is ...
4
votes
1answer
141 views

Using Czech republic (European) Postcodes in CartodDB?

I have dataset with columns country (contains only one country "Czech republic") and postcode (contains postcodes in NNNNN format) and other two cols (date and total). However when I try to use ...
4
votes
1answer
585 views

CartoDB data load from csv file error

I’m having some troubles importing data from a cvs file with street addresses and the logs are not providing any meaningful information. I installed CartoDB locally on Mac OSX 10.10. Following are ...
4
votes
2answers
299 views

Overwrite a table in CartoDB

I need to overwrite a table in CartoDB using the Import API, but the system instead of overwriting the table, it creates another one with the same name and attaches an id auto-generated. For instance:...
4
votes
2answers
1k views

Populating D3 Graph with Cartodb

I have been looking at D3 and following along with their basic tutorials. In the documentation you can use json files to create graphs, however I am confused on how to make the connection from my ...