Full control of your spatial data

Built on the PostgreSQL platform and supporting advanced PostGIS capabilities, CARTO enables you to seamlessly use basic PostgreSQL expressions and PostGIS functions.

1
2
3
4
5
6
7
8
9
10
11
12
filename=upload_example.csv
sql="COPY+upload_example+(the_geom,name,age)+FROM+STDIN+WITH+(FORMAT+csv,HEADER+true)"

cat $filename \
| gzip -1 \
| curl \
  -X POST \
  -H "Content-Encoding: gzip" \
  -H "Transfer-Encoding: chunked" \
  -H "Content-Type: application/octet-stream" \
  --data-binary @- \
  "http://${user}.carto.com/api/v2/sql/copyfrom?api_key=${key}&q=${sql}"
1
2
3
4
5
6
7
8
9
10
11
curl -X POST -H "Content-Type: application/json" -d '{
  "query": {
    "query": [{
      "query": "UPDATE nasdaq SET price = '$101.00' WHERE company = 'CARTO'"
    }, {
      "query": "UPDATE down_jones SET price = '$100.00' WHERE company = ‘CARTO’”
    }],
    "onsuccess": "UPDATE market_status SET status = 'updated', updated_at = NOW()",
    "onerror": "UPDATE market_status SET status = 'outdated'"
  }
}' "https://{username}.carto.com/api/v2/sql/job"
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<OGRVRTDataSource>
    <OGRVRTLayer name="sales_data">
        <SrcDataSource>Pg:dbname=username</SrcDataSource>
        <SrcLayer>sales.sales_data_2019</SrcLayer>
    </OGRVRTLayer>
    <OGRVRTLayer name="stores">
        <SrcDataSource>store_gis.gdb</SrcDataSource>
        <SrcLayer>Stores</SrcLayer>
    </OGRVRTLayer>
    <OGRVRTLayer name="joined">
        <SrcDataSource>joined_stores.vrt</SrcDataSource>
        <SrcSQL dialect="SQLITE">
            SELECT stores.*, sales_data.*
            FROM sales_data
            JOIN stores
            ON sales_data.store_id = stores.store_id
        </SrcSQL>
    </OGRVRTLayer>
</OGRVRTDataSource>
PostGIS core commiter
  • Geocode
    Geocode

    Create point geometries in your data.

  • Clusters
    Detect Outliers and Clusters

    Select spatially clustered and adjacent outliers.

  • filter
    Filter by Column Value

    Keep or discard rows with a column value.

  • columns
    Add Columns from 2nd Dataset

    Join a second dataset to current layer.

  • polygons
    Create Polygons from Points

    Using convex or concave hulls, or boundings.

  • trends
    Predict Trends and Volatility

    Using Markov chains.

Dynamic data in the cloud

Unlike other Location Intelligence platforms, you can create views and new tables directly in the platform without needing to download the data and then re-upload - saving you valuable time and resources.

File icon

Support for multiple geospatial formats

Shapefiles, KML, KMZ, GeoJSON, GPX, OSM, GeoPackage, GDB, as well as CSV, Excel or OpenDocument.

DB Icon

Plug and play database connectors

ArcGIS Server, DB Connectors via APIs (MySQL, PostgresSQL, Microsoft SQL Server, Hive on request).

Peace of mind

Enjoy the benefits of a fully managed database with automatic backups and regular upgrades - allowing your team to focus on what’s important to your organization.