A simple geospatial database with multiple ways to connect and manipulate your 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>
Create point geometries in your data.
Select spatially clustered and adjacent outliers.
Keep or discard rows with a column value.
Join a second dataset to current layer.
Using convex or concave hulls, or boundings.
Using Markov chains.
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.
Shapefiles, KML, KMZ, GeoJSON, GPX, OSM, GeoPackage, GDB, as well as CSV, Excel or OpenDocument.
ArcGIS Server, DB Connectors via APIs (MySQL, PostgresSQL, Microsoft SQL Server, Hive on request).
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.