Prepare, clean, and automate. Discover the power of data management.
A guide containing some tips that you can use to prepare and format your data before importing to CARTO.
Learn the supported data types in CARTO.
Frequently asked questions about Editor datasets and data in CARTO.
Learn how to work with data in Editor.
Frequently asked questions about PostgreSQL expressions and PostGIS functions with CARTO.
A guide containing some tips that you can use to prepare and format your data before importing to CARTO.
Learn how to manage your data with CARTO Editor.
Learn how to manipulate your data with CARTO Editor.
Learn how to format your CSV/spreadsheet file in order to import it into your CARTO account.
Learn how to use .csvt file to force data types on your csv imports
The next step in data sharing
Learn how import OSM data into CARTO.
Learn how to query and extract OSM data with Overpass Turbo.
Learn how to use Overpass Turbo to create a CARTO Sync Table and connect real time OSM data.
Learn how to geocode your data.
Learn to create isolines from your data.
Learn how to calculate routes between two points with different modes.
Learn how to insert geometries to a CARTO dataset drawing them in a CARTO.js application.
Learn how to create clusters using CARTO's smart backend aggregation in a CARTO.js application.
Learn how to use the CARTO SQL API
Learn how to store SQL functions in your CARTO database.
Learn how to sync datasets using Import API and PostgreSQL stored procedures.
Learn how to convert arrays to json objects to display their data in Builder popups
Learn how to add indexes to table columns to improve filtering and grouping performance.
Learn how to query and work with SQL and PostGIS in CARTO with CARTO franchise.
Learn how to extract day, month or year values from date columns.
Learn how to use PostgreSQL to find the exact size of a dataset in your CARTO account.
Learn how to generate fake cartodb_id values to make your query work.
Learn a workaround to geocode more than 500 rows of country names with SQL and Builder analysis.
Learn how to generate numeric values representing a day or week, to be used later with Builder histogram widgets
Learn how to import big files into CARTO.
Learn how to split large SQL jobs to improve performance
Learn how to generate normalized column values for animated (or Torque) visualizations.
Learn how to select, populate or delete NULL values in CARTO datasets.
Learn how to round numeric columns in Builder with SQL.
Learn how to select all column names in a CARTO dataset except some of them.
Learn how to access SQL in Builder layers to query your data.
Learn how to combine and convert several column values into a data with a PostgreSQL function.
Learn how to work with bbox and joins in SQL.
SQL functions to geocode, create custom grids and get statistical data in CARTO.
Learn how to transform straight lines into great circles.
Learn how to generate routes from origins to destinations with CARTO routing functions.
Learn how to normalize dataset columns by area with PostGIS functions.
Learn how to assign a polygon attribute to intersecting points.
Use SQL to connect points with straight lines.
Learn how to work with geometries, centroids, buffers, areas and more!
Use PostGIS to convert coordinates from UTM to latitude and longitude.