Working with Data

Import Data

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

  Learn how to format your CSV/spreadsheet file in order to import it into your CARTO account.

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

  Learn how to use .csvt file to force data types on your csv imports

• Open in CARTO

  The next step in data sharing

• Importing OpenStreetMap Data

  Learn how import OSM data into CARTO.

• Export OpenStreetMap Data with Overpass Turbo

  Learn how to query and extract OSM data with Overpass Turbo.

• • Using Overpass Turbo to create CARTO Sync Tables

    Learn how to use Overpass Turbo to create a CARTO Sync Table and connect real time OSM data.

  See more

Analyse Data

• Geocoding your data

  Learn how to geocode your data.

• Creating isolines

  Learn to create isolines from your data.

• Using routes

  Learn how to calculate routes between two points with different modes.

Development

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

  Learn how to insert geometries to a CARTO dataset drawing them in a CARTO.js application.

• Clusters of data aggregations in CARTO.js

  Learn how to create clusters using CARTO's smart backend aggregation in a CARTO.js application.

• How can I use CARTO's SQL API in a CARTO.js application?

  Learn how to use CARTO's SQL API with a minimal example of axios

• PostgreSQL Stored Procedures

  Learn how to store SQL functions in your CARTO database.

• How can I change sync table data with SQL?

  Learn how to sync datasets using Import API and PostgreSQL stored procedures.

SQL

• How to convert arrays to json objects

  Learn how to convert arrays to json objects to display their data in Builder popups

• How to add indexes to CARTO datasets

  Learn how to add indexes to table columns to improve filtering and grouping performance.

• Introduction to databases in CARTO

  Learn how to query and work with SQL and PostGIS in CARTO with CARTO franchise.

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

  Learn how to extract day, month or year values from date columns.

• How to find the size of a dataset

  Learn how to use PostgreSQL to find the exact size of a dataset in your CARTO account.

• • How to generate a fake cartodb_id

    Learn how to generate fake cartodb_id values to make your query work.

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

    Learn a workaround to geocode more than 500 rows of country names with SQL and Builder analysis.

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

    Learn how to generate numeric values representing a day or week, to be used later with Builder histogram widgets

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

    Learn how to import big files into CARTO.

  • Manually Batching your SQL Jobs

    Learn how to split large SQL jobs to improve performance

  • How to normalize data for animated visualizations

    Learn how to generate normalized column values for animated (or Torque) visualizations.

  • How to work with NULL values in CARTO datasets

    Learn how to select, populate or delete NULL values in CARTO datasets.

  • How can I round decimal values in Builder?

    Learn how to round numeric columns in Builder with SQL.

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

    Learn how to select all column names in a CARTO dataset except some of them.

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

    Learn how to access SQL in Builder layers to query your data.

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

    Learn how to combine and convert several column values into a data with a PostgreSQL function.

  • Tips for advanced analysis

    Learn how to work with bbox and joins in SQL.

  See more

PostGIS

• CARTO Functions

  SQL functions to geocode, create custom grids and get statistical data in CARTO.

• How to convert straight lines to great circles

  Learn how to transform straight lines into great circles.

• How to apply routing functions in CARTO

  Learn how to generate routes from origins to destinations with CARTO routing functions.

• How can I normalize my numeric values in Builder?

  Learn how to normalize dataset columns by area with PostGIS functions.

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

  Learn how to assign a polygon attribute to intersecting points.

• • How to create straight lines between points

    Use SQL to connect points with straight lines.

  • Tips for geospatial analysis

    Learn how to work with geometries, centroids, buffers, areas and more!

  • How to convert UTM coordinates to lat/long values

    Use PostGIS to convert coordinates from UTM to latitude and longitude.

  See more