Simpler than you think: use Python to upload GIS layers to CartoDB

CartoDB has a nice dashboard you can use to upload shapefiles for viewing online. They have even included drag-and-drop functionality to help improve the experience. Nevertheless, uploading geographic files manually can be cumbersome and you can end up forgetting files sources, when you uploaded etc. Fortunately, CartoDB recently posted a Python script that you can […]

Continue reading →

MongoDB: Getting Started

For most of our projects that involve large datasets we use either PostgreSQL or MySQL to conduct analysis and feed data-driven web sites. In general, we’re happy with these tools, particularly PostgreSQL and its spatial functionality, and find that they meet our data needs. PostgreSQL has also been fairly innovative, recently adding functionality focused on […]

Continue reading →

Stamen Design’s watercolor basemap makes mapping more fun

For a recent project I was conducting some fairly dry quality assurance/quality control. In particular, I was comparing whether the population-weighted centroids of ZIP codes (ZCTA, to be specific) we computed in PostGIS matched those computed using QGIS. Given that I was creating temporary, internal maps, to make things more fun, I used the OpenLayers […]

Continue reading →