Working with Data

Intro to Data

• How to Give Attribution

• What is a CARTO Dataset?

• Data Types

• Editor FAQs - Datasets and Data

• Editor Dataset Basics

• FAQs — PostgreSQL and PostGIS

• Preparing and Formatting Data

• Managing your data with CARTO Editor

• Manipulating your data with CARTO Editor

Import Data

• How can I import an unsupported CSV/spreadsheet file into CARTO?

• How can I force data types when importing csv files?

• Sugar for the Data Observatory

• How can I turn off import guessing?

• Open in CARTO

• Importing OpenStreetMap Data

• Export OpenStreetMap Data with Overpass Turbo

• Using Overpass Turbo to create CARTO Sync Tables

Analyse Data

• Cleaning Data for Geocoding

• Geocoding Types Explained

• Geocoding your Data

• Creating isolines

• Using routes

Development

• How to insert geometries to a CARTO dataset in a CARTO.js application

• Clusters of data aggregations in CARTO.js

• How can I use the CARTO SQL API from a CARTO.js or CARTO-VL application?

• Helpful Tools

• PostgreSQL Stored Procedures

• How can I change sync table data with SQL?

SQL

• How to convert arrays to json objects

• How to add indexes to CARTO datasets

• Introduction to databases in CARTO

• How to convert date data into a string or numeric value

• How to find the size of a dataset

• How to generate a fake cartodb_id

• I cannot geocode my country names dataset, although my column only has very few unique values

• How to generate a column for 24-hour or 7-day Builder histograms

• I'm having import limits warnings, what should I do?

• Manually Batching your SQL Jobs

• How to normalize data for animated visualizations

• How to work with NULL values in CARTO datasets

• How can I round decimal values in Builder?

• How to select all columns in a table except some of them

• How can I change the SQL query of my layer data source?

• How can I combine several string values/columns and convert them into a date?

• Tips for advanced analysis

PostGIS

• CARTO Functions

• How to convert straight lines to great circles

• How to apply routing functions in CARTO

• How can I normalize my numeric values in Builder?

• How to assign a column value from a polygon to a point

• How to create straight lines between points

• Tips for geospatial analysis

• How to convert UTM coordinates to lat/long values