cartodb / cartodb

Location Intelligence & Data Visualization tool

[DEPRECATED]

Hey! This content applies only to previous CARTO products.

Please check if it's relevant to your use case. On October 2021 we released the current version of our platform. You can learn more and read the latest documentation at docs.carto.com

What is CARTO?

CARTO is an open, powerful, and intuitive platform for discovering and predicting the key insights underlying the location data in our world.

Empower organizations to optimize operational performance, strategic investments, and everyday decisions with CARTO Engine—our embeddable platform for web and mobile apps—and the new CARTO Builder, a drag and drop analysis tool.

It was built to make it easier for people to tell their stories by providing them with flexible and intuitive ways to create maps and design geospatial applications. CARTO can be installed on your own server and we also offer a hosted service at carto.com.

If you would like to see some live demos, check out our videos on Vimeo. We hope you like it!

What can I do with CARTO?

With CARTO, you can upload your geospatial data (Shapefiles, GeoJSON, etc) using a web form and then make it public or private.

After it is uploaded, you can visualize it in a dataset or on a map, search it using SQL, and apply map styles using CartoCSS. You can even access it using the CARTO APIs, or export it to a file.

In other words, with CARTO you can make awesome maps and build powerful geospatial applications! Definitely check out the CARTO Platform for interactive examples and code.

Installing

Read the installation guide in CARTO developers documentation

How do I upgrade CARTO?

See UPGRADE for instructions about upgrading CARTO.

For upgrade of Windshaft-CartoDB and CartoDB-SQL-API see the relative documentation.

Developing & Contributing to CARTO

See our contributing doc for how you can improve CARTO, but you will need to sign a Contributor License Agreement (CLA) before making a submission, learn more here.

Testing

Check the testing doc section.

Requirements

CARTO works in any modern browser, but if you want more info:

31+ ✔	38+ ✔	11+ ✔	31+ ✔	8+ ✔

cartodb's Issues

create_dev_user script fails, and never creates user

The databases and tables are created, but the entry for the user is not, which means I am never able to log in. I get the following error:

[sequel] Created database 'carto_db_development'
[sequel] Created database 'carto_db_test'

=================================
Done!
- Tables processed:      0
- Tables migrated:       0
- Tables skipped:        0
- Bubble maps hacks:     0
- Tables with errors:
rake aborted!
undefined method `y' for #<Migrator20:0x0000000763f478>

Tasks: TOP => cartodb:db:setup => db:migrate
(See full trace by running task with --trace)

OSM imports are failing mostly/ incorrect sometimes

When I import OSM it seems to fail most of the time. But when it does get in all the tables are named
map_line
OSM imports should, if using osm2pgsql, create 4 tables
line, point, polygon, road

400 error when adding new row

Sorry for blowing up your issue tracker guys. But I think resolving all these issue will go a long way towards making it easier (possible?) for others to contribute to the project.

I get 400 errors when I try to add a row to my table:

POST http://nbt.gis.io:3000/api/v1/tables/nbt_offices/records/ 400 (Bad Request)

The response from that request is actually this:

{
    id: 2,
    name: "nbt_offices",
    total_rows: 0,
    rows: [ ]
}

This from the logfile:

PL/Python function "update_timestamp": INSERT INTO "nbt_offices" DEFAULT VALUES RETURNING "cartodb_id"
[pool] Found a connection for cartodb_dev_user_2_db:development_cartodb_user_2 (2)
========== exception on records#create ==========
#<NoMethodError: undefined method `to_sym' for nil:NilClass>
=================================================
Completed 400 Bad Request in 114ms (Views: 0.5ms | Models: 0.0ms)

Strangley, though, adding a new column works just fine. Any idea how to fix this or what it means?

Always uses https for requesting tiles, even in development mode

CartoDB uses https when making requests to the Windshaft tile server, even though I have http set in my app_config.yml:

tile_protocol: 'http'

Store user's last login datetime

When a user logs in correctly we should store the exact time.

Animate API calls graph from the beginning

geocode a table using columns returns 400

even when it works

The tables counter is not working properly

Review with @javisantana.

Support for KML with nexted Document entries

Currently, CartoDB doesn't support complex KML files with nested entries.

Stop asking me to georeference

I have a table with no values in the_geom, but am using a query to get locations. Common relational method. but the map wont stop asking me if i want to georeference it. it should really only ask once.

Review table-tags specs

Review with @javisantana.

Cancel upload of a file

Table space stats is not updating correctly

Review with @xavijam.

Error when uploading SHP file on local dev instance

First of all, thank you guys so much for helping me finally get this thing running. Here's another one for ya:

I'm trying to upload a .zip file that contains a SHP file and all of the usual accessories. It uploads great through my account at cartodb.com. But when I try to upload it on my new dev instance, I get this error:

19:39:03 resque.1  | ERROR 6: No translation for Mercator to PROJ.4 format is known.
19:39:03 resque.1  | ERROR 6: No translation an empty SRS to PROJ.4 format is known.

Any help is appreciated, thanks.

Be able to drag tables to tags for classifying

Disappearing CartoCSS/InfoWindow buttons after a failed query

Try this on any table, change the query to

select the_geom from whatever_table_name_is

the buttons disappear. then clear query and they remain gone.

Manage tables pagination with Backbone

Review with @xavijam.

Cut the table title if it is too long

Only let users upload files with a size less than their quota

Drag file to the dashboard and create a new table

When a window or popover is opened, if you click out, it should close all opened

Manage in a different way the total of the tables requested in the api

Exporting to shapefiles doesn't work

Maybe the problem is that it usev the v1 API.

Manage accounts with Terabytes, Gigabytes,... in user stats

[KEYS] User api key is not being printed in the apy key view

Export a table before delete the table

Upon first install, says "Creating table" in the lower left corner and never disappears

My browser is sending a request every second to see if something is done. Problem is, this is immediately after a fresh install (an invocation of scripts/create_dev_user).

Can't set CartoCSS on any SQL

The style button keeps disappearing if I run this query,

SELECT 
    cartodb_id,
    the_geom_webmercator,
    the_geom,
    phone,
    class_size,
    (SELECT count(*) FROM daily_class_count WHERE phone = pr.phone) as check_ins
FROM phone_registration pr

It seems crazy. Is this a bug?

georeferencing often doesn't work at cartodb.com

Sometimes georeferencing will say it's completed, but will not populate the_geom and will not flip the cartodb_georef_status flag. Sometimes it works fine. Very flaky. No client-side errors that I can see.

When change the privacy of a table, it doesn't disappear smoothly

Due to the fact that the table is rendered. First remove and then print it.

Review with @javisantana.

Add specs for API keys pages

Review with @javisantana

Embedded maps should include google analytics tracking with tagged urls

Store user's last activity time

order does not work for queries api endpoint

Review new dashboard interface in IE9

Rewrite file import API endpoint

We need a single endpoint on the API to handle the whole importation process, it should be able to work sync and async.

1. Move the file upload functionality to ImportsController
2. Update ImportsController to handle sync and async imports via an http param (default should be async, except for the ruby client)
3. Update the frontend to work with this.
4. Map the actual /upload route to ImportsController#create
5. Remove Api::Json::UploadsController

Finish the process when uploads a new table

KML importer ignores ExtendedData

Exportation works ok, but when trying to import a KML file with
ExtendedData sections it just ignores that data.

We're using ogr2ogr command tool to
transform KML files to SHP before importation, I still don't know a
lot about this tool, but it isn't processing the ExtendedData entries.

Seems like a know issue:

http://www.mail-archive.com/[email protected]/msg11774.html

We'll need google's libkml as mentioned here:

http://www.mail-archive.com/[email protected]/msg11778.html

Google Earth is using that version of libkml and it correctly reads de
ExtendedData entries (example file attached).

/cc @lbosque

No CartoCSS transform path from 2.1.1 to 2.1.0

Originally reported here: CartoDB/Windshaft-cartodb#59 (comment). Was told to report it in this tracker instead.

Also happens with Mapnik 2.2.0: No CartoCSS transform path from 2.1.1 to 2.2.0

What versions of Mapnik will work??

Uploading of files, non synchronized fails

When uploading files, the importer that uses resque fails and ends up in some sort of infinite loop trying to upload the file and fails to create an enty in the data_imports table

Improve animation of the table stats (subheader)

Preset styles might be too restrictive

I would recommend in the style selector a little change.

Right now, if I'm on a Points table, the three presets I can see are

simple, bubbles, density

I would love it it if I could actually choose, Simple Polygon and Simple Line as well! The same when I am in a Polygon table, I'd love Simple Points

This is because often the SQL we run has a transform so it isn't in the same type anymore. It would make life easier, I have explained to so many users now how to change the style from markers to polygons to see their results.

The "change privacy window" is not well styled

400 when saving table if description is set

IE 10

Jeremy Barth says that this map "doesn't display ... in IE10."

Creating maps on empty tables wont work

I often use an empty table to run a new query and then store styles for that particular case. I know we are shifting to a new methodology, so maybe this wont matter. But right now that wont work. If I start a new blank table, and then run SQL to get points from an existing table, the points render. But... I'm not allowed to edit Carto, there is no button.

Issue with javascripts buing bundled together

After set up missing some javascripts. such as cdb/vendor/jquery.min

When removes a table, a flash red notification should appear

Review with @javisantana

Finish background importer

Add ESC binding for all popups and windows

Review with @javisantana.