Posts by Paul Ramsey
Strategic Advisor
Strategic Advisor
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
There are only three certainties in life: death, taxes, and the constant growth in data sizes.
Data Processing
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
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
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
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 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
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
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
“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 TechCartoDB 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...
AcademyServing 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
Please fill out the below form and we'll be in touch real soon.
