Week 11

Class Outline

Introduction

SQL with CartoDB
- Manually writing SQL for analysis
- Always:clap:use:clap:the:clap:SQL:clap:console:clap:
- SQL types, special Carto columns, and PostGIS types
- Creating new tables
- Results as GeoJSON
SQL Resources
Examples
- Torque for time series
- SQL for persisting data changes, interaction, and GeoJSON

PostgreSQL & PostGIS Resources

SQL Related

Good

postgresql FAQ
postgresql.org documentation
Stack overflow

OK, not great

tutorialspoint.com
w3 schools

GIS Extension Related

Good

PostGIS special function index
PostGIS reference docs
Stack exchange's GIS-specific subdomain

Examples

CartoDB Torque Torque.js is an open source library for creating dynamic visualizations for your time series data on top of Leaflet (and with the help of CartoDB). If you're dealing with time and space, Torque can build compelling visualizations ranging over both dimensions.

CartoDB SQL API

Keeping API keys in client applications is NOT a safe practice. Do NOT use the techniques practiced in this lab in the wild.

It is possible to persist data with CartoDB. This demo illustrates how it can be done for an application which deals with user input.