Week 4 - More advanced SQL and PostGIS

• Homework
• Lecture
  • Slide deck
  • Code snippets
• Lab
• Recommended Readings

Homework

• Code assignment (assigned Sept 24, due Oct 6th at 11:59pm ET)
• Signup for Google Cloud (free tier) to get access to Google BigQuery
  • Signup here: https://cloud.google.com/free
  • We will use Google BigQuery next week, it has a generous free tier
• Read the recommended readings. Add cache: before the URLs if the pages don't load

Lecture

Follow along: Lecture.md

Lab

See here

Recommended Reading

• PostGIS Indexing
• PostgreSQL Index types
• Lateral Join
• R-tree
• Spatial indexes in geopandas