Get a hold on your spatial data
A simple geospatial database with multiple ways to connect and manipulate your data.
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
Create point geometries in your data.
-
Detect Outliers and Clusters
Select spatially clustered and adjacent outliers.
-
Filter by Column Value
Keep or discard rows with a column value.
-
Add Columns from 2nd Dataset
Join a second dataset to current layer.
-
Create Polygons from Points
Using convex or concave hulls, or boundings.
-
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.
Support for multiple geospatial formats
Shapefiles, KML, KMZ, GeoJSON, GPX, OSM, GeoPackage, GDB, as well as CSV, Excel or OpenDocument.
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.
