Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. Our data
Points
Linestrings
Polygons
Summary

## Instruction

If you have already taken some of our Vertabelo Academy courses, you may have noticed that we usually introduce two or three simple tables in each part of a given course.

In this PostGIS course, things will be a bit different. We'll use the same set of roughly ten tables throughout all parts. Most of the tables will have something to do with the beautiful city of San Francisco, California, as Mark decided to settle there after his little trip around the world. You'll be tasked with helping him get to know the city through and through!

We'll be analyzing various hotels, bicycle routes, tram stops and other things that you'll typically find in any bigger city. The geographic data will all be real information for San Francisco.

• The geographic data in the tables sf_atms, sf_selected_railways, sf_tram_stops, sf_hotels, sf_bicycle_routes, sf_restaurants, sf_sights, usa_states, sf_chains were taken from OpenStreetMap.
• The geographic data in the table sf_planning_districts was taken from data.sfgov.org.
• The geographic data in the table sf_household_types were retrieved by the Census Bureau Data API.