Skip to content

Planning

Andy Eschbacher edited this page Aug 25, 2015 · 25 revisions

Welcome to the Map Academy wiki!

Lesson Tree

  • Overview of CartoDB (wiki)
    • Introduction Course
      • Making your First Map
      • Your First Choropleth Map
      • Thematic Maps with Point Data
      • Animated Maps with Point Data
      • Multilayer Visualizations
    • Intermediate Skills
      • Changing Basemaps (xyz, etc.)
      • Overview of CartoCSS
      • The problem of overlapping markers
      • Customizing Infowindows, tooltips
      • Customizing Legends
      • Quantification Methods
      • Torque
  • CartoDB.js (wiki)
    • cartodb.js from the ground up
      • Introduction to the library
      • Layer and sublayer methods
      • setSQL and setCartoCSS
      • Torque.js
      • infowindow/tooltip customization (in progress -- Andy)
      • look through examples pages for another basic example
        • sql.execute() and sql.getBounds()
        • Static maps API
    • Intermediate CartoDB.js
      • Named Maps (now exists as a tutorial)
      • Leaflet.js, options (the third argument in createVis and createLayer)
      • CartoDB.js + Google Maps API
      • SQL API to build charts (charts.js, D3 frameworks? C3, NVD3)
      • Maps with other libraries
    • Advanced CartoDB.js
      • Core API functionality
      • Need more ideas
  • SQL/PostGIS (wiki)
    • Introduction
      • Intro to SQL and PostGIS
      • PostGIS Basics
      • Joining Tables (tutorial, already written) (does it cover left joins?)
      • Group By, aggregate functions, UPDATE and SET statements
      • Other projections, ST_Intersection, other useful PostGIS functionality
      • Data munging: String functions, timestamps
    • Intermediate
      • Indices - how do they work
        • as well as string and geometric indices
      • Nested statements
      • WINDOWS, CTEs plus and minuses
      • Views
    • Advanced
      • Basic PL/pgSQL functions
      • Open to suggestions
  • Design/CartoCSS (wiki)
    • Introduction to Map Design
      • Getting Started with Map Design
      • Colors. Truth & Insights
      • Invisible and Visible Data
      • Placing Your Labels
    • Intermediate Design
      • What kind of map should I make?
      • Color
      • Typography
    • CartoCSS
      • Introduction to CartoCSS
      • More advanced selectors, overlapping features, variables, etc.
      • Torque-flavored CartoCSS
      • Advanced Labels
  • Academy Lite - Quick Skills in Five Minutes (wiki)
    • CartoCSS
    • Essential SQL
    • How to Normalize your Map's Data
  • Data (wiki)
    • Finding and Curating Data
      • Obtaining Data
      • Data attribution and licenses
      • Data formats and tools for dealing with different formats
  • How to make this map series
    • MK's GA Twitter
    • square/hex maps
    • election maps
    • Social media maps
    • what else?
  • Community-written Lessons (wiki)
    • Stace Maples' lesson on Odyssey.js
    • Kurt's QGIS lessons?
    • Andrew B's intro lesson
  • CartoDB for Educators (wiki)
    • Historical basemaps + data layers and interactivity
    • University Level
      • Maps in the classroom (Ecology, History, Social Studies, etc.)
      • Election Maps, Historical Battle Maps, sociological data visualizations (Census data)
      • Places to find appropriate data
    • High School
      • Printable lessons that teachers can easily use in the classroom
  • QGIS <-> CartoDB (wiki)

Lessons from solutions team

  • "Maps for corporate communication"/"Rapid Map Prototyping"? (Currently sitting in courses directory)