GeoJSON and SQL through CartoDB

• REMINDER: Always:clap:use:clap:the:clap:SQL:clap:console:clap:
• Using CartoDB SQL within applications
• You can use a REST client like Postman or Advanced REST Client

SQL Input/Output

• Adding geometries to your SQL queries
• Results as GeoJSON
• Results as JSON
• Others

SQL Performance

• Ask for only the columns you need
• Indices
• Geometry simplification
• Use the cartodb_id. Example:

• Tiling for TMS
• PostGIS analysis (this is painful)
• Alternatives