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 from 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.