-
Written by Paul Ramsey on
Beyond the Shapefile with File Geodatabase and GeoPackage
Anyone who has programmed geospatial software has eventually come to a conclusion about data formats: there is only one truly de facto standard for geospatial data, the sha...
Core Tech -
Written by Paul Ramsey on
Bulk CARTO Import Using COPY
There are only three certainties in life: death, taxes, and the constant growth in data sizes.
Core Tech -
Crowd-funding core open source development
When you use CARTO to visualize a data set, or to run an analysis, it looks fairly lovely and seamless: just one piece of software doing your bidding. But, in fact, CARTO i...
News -
Written by Paul Ramsey on
CARTO in QGIS using OGR
You can use OGR to move data into and out of CARTO. And you can use QGIS to view and edit layers supported by OGR. So it would stand to reason that you should be able to us...
Core Tech -
Written by Paul Ramsey on
Patching Plain PostgreSQL for Parallel PostGIS Plans
CARTO users want to see maps drawn quickly, and drawing maps quickly means rendering every geometry in a table to an output format. By deploying the latest version of Postg...
Core Tech -
Written by Paul Ramsey on
CARTO's Use of Foreign Data Wrappers
PostgreSQL is packed full of under-appreciated features (pg_trgm, full-text search, logical replication, ranges, to name a few) but I’d like to highlight one feature tha...
Core Tech -
CARTO Core Team and 5x
CARTO is open source, and is built on core open source components, but historically most of the code we have written has been in the “CARTO” parts, and we have used the cor...
Core Tech -
Written by Paul Ramsey on
ETL into CARTO with ogr2ogr
The default CARTO data importer is a pretty convenient way to quickly get data into the platform, but for enterprises setting up automated update it has some limitations:
Core Tech -
Written by Paul Ramsey on
PostGIS Performance Profiling
More and more CARTO users are asking to render more and more data onto maps, and they want to see the results on their screen quickly. In order to get a whole map drawn in ...
Core Tech -
-
Written by Paul Ramsey on
Bulk Nearest Neighbor using Lateral Joins
“Find me the nearest…” is a common way to start a geographical query, and we’ve talked about how to write such queries for single points, but it can be tricky to carry out ...
Core Tech -
-
-
-
Written by Paul Ramsey on
Data Synchronization with OGR
CartoDB has an excellent and easy-to-use synced tables feature, that reads data from a public URL on a regular schedule and keeps an associated CartoDB table up-to-date. Ho...
Academy -
Written by Paul Ramsey on
OGC Web Map Server support in CartoDB
WMS! What, more stuff? We make software, with map standards: Web Map Server. That is to say, CartoDB now offers the possibility of making its visualizations viewable via th...
News -
-
Written by Paul Ramsey on
Whitepaper: Dynamic High Performance Web Mapping
Serving up dynamic web maps that render live and changing data can be challenging enough, but what about when those maps are also under extreme load as millions of users ac...
Location Intelligence
