Working with Data

Learn how to use the Direct SQL Connection feature to connect external applications like QGIS, Tableau, and Power BI to your CARTO PostgreSQL database.

SQL functions to geocode, create custom grids, and get statistical data in CARTO using PL/pgSQL.

Best practices for cleaning and formatting your data before geocoding in CARTO.

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

Learn how to create isolines (contour lines) in CARTO using Builder or the Data Services API.

Learn about the supported data types in CARTO including geometry, number, string, date/time, and advanced types.

Learn how to connect, sync, manage, and visualize datasets in the CARTO Editor.

Frequently asked questions about datasets, data formats, geocoding, and data management in the CARTO Editor.

Learn how to query and extract specific OpenStreetMap data using Overpass Turbo for use in CARTO.

Frequently asked questions about PostgreSQL expressions and PostGIS functions with CARTO.

Workaround for geocoding country name datasets that exceed CARTO's 500-row limitation.

Learn about the seven different geocoding types available in CARTO for converting addresses to geographic coordinates.

Learn how to geocode your data in CARTO, including different geocoder types, credit consumption, and provider details.

Tools built by CARTO teammates for working with data, including the Batch API UI and CDB Manager.

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

Learn how to generate routes from origins to destinations using CARTO Data Services API routing functions.

Learn how to assign polygon attribute values to intersecting points using PostGIS ST_Intersects.

Learn how to modify sync table data using Import API and PostgreSQL stored procedures in CARTO.

Learn how to access SQL in Builder layers to query your data and work around analysis chain limitations.

Learn how to combine several string column values and convert them into a date using PostgreSQL's to_timestamp function.

Learn how to convert arrays to JSON objects to display aggregated data in Builder popups using PostgreSQL.

Learn how to extract day, month, or year values from date columns in CARTO using PostgreSQL functions.

Learn how to transform straight lines into great circles using PostGIS ST_Segmentize to emulate flight routes.

Learn how to convert UTM X/Y coordinates to latitude/longitude using PostGIS ST_Transform in CARTO.

Learn how to use PostGIS ST_MakeLine to connect geographic points with straight lines in CARTO.

Learn how to use PostgreSQL to find the exact size of a dataset in your CARTO account, including indexes and TOAST tables.

Learn how to use .csvt files to force data types on your CSV imports into CARTO.

Learn how to convert date/timestamp values into numeric representations for histogram widgets in CARTO Builder.

Learn how to generate a fake cartodb_id column using PostgreSQL row_number() for nested queries in CARTO.

Learn how to properly attribute data sources, basemaps, and technologies when creating maps in CARTO.

Learn how to format your CSV or spreadsheet file with proper encoding to successfully import it into CARTO.

Learn how to insert geometries to a CARTO dataset by drawing them in a CARTO.js application using Leaflet.Draw.

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

Learn how to normalize numeric data by area using PostGIS ST_Area for meaningful polygon visualizations in CARTO.

Learn how to round numeric columns to a specific number of decimal places using SQL in CARTO Builder.

Learn how to dynamically select all column names in a CARTO dataset except specific ones using SQL.

Learn how to subscribe to public and premium datasets through CARTO's Spatial Data Catalog.

Learn how to turn off dataset auto-formatting and type/content guessing when importing data into CARTO.

Learn how to make calls to the CARTO SQL API using JavaScript Fetch API, Axios, or jQuery Ajax.

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

Learn how to split and merge large files to work around CARTO's import size and row limits.

Learn how to export and import OpenStreetMap data into CARTO for use in your maps.

Learn how to query and work with SQL and PostGIS in CARTO using PostgreSQL and the Franchise SQL client.

Overview of CARTO's Data Observatory, a spatial data platform with thousands of datasets from public and premium sources.

Learn how to manage your public and premium dataset subscriptions in the CARTO Data Observatory.

Learn how to geocode data, run SQL queries, merge datasets, and export data with the CARTO Editor.

Learn how to manipulate data in CARTO Editor, including filtering by region, hiding Named Map sublayers, and creating password-protected maps.

Learn how to split large SQL UPDATE queries into batches to avoid timeout errors in CARTO.

Learn how to add an Open in CARTO button to your website for easy data sharing and visualization.

Learn how to create and use PostgreSQL stored procedures (PL/pgSQL functions) in CARTO, including triggers, control structures, and PostGIS integration.

Tips for preparing and formatting your data before importing to CARTO, including geocoding, encoding, projections, and shapefiles.

Explore CARTO's Spatial Data Catalog to discover thousands of spatial datasets through the Data Observatory.

Learn how to work with bounding boxes, spatial joins, distance sorting, and common table expressions in CARTO SQL.

Learn how to work with geometries, centroids, buffers, areas, spatial intersections, and distance calculations in CARTO.

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

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

Understand how CARTO processes PostgreSQL tables into datasets with indexed columns for mapping and analysis.