Skip to content
Architectural features that are part of SFO and the SFO Museum collection.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
data
docs/stats
utils
.gitignore
LICENSE
Makefile
README.md

README.md

sfomuseum-data-architecture

Architectural features that are part of SFO and the SFO Museum collection.

Background

For background we recommend reading the Who's On First at SFO Museum and Where is Gate A1? blog posts.

Catalog

SFO Terminal Complex (2017~ - open)

belongs_to id parent_id placetype label
1159157271 1159157339 1159157333 concourse Boarding Area A (2017~ - open)
1159157271 1159396217 1159157317 concourse Boarding Area B (2017~ - open)
1159157271 1159157323 1159157317 concourse Boarding Area C (2017~ - open)
1159157271 1159396181 1159396121 concourse Boarding Area D (2017~ - open)
1159157271 1159396267 1159157307 concourse Boarding Area E (2017~ - open)
1159157271 1159396301 1159157307 concourse Boarding Area F (2017~ - open)
1159157271 1159157337 1159157333 concourse Boarding Area G (2017~ - open)
1159157271 1159157335 1159157333 concourse International Terminal Main Hall (2017~ - open)
1159157271 1159157319 1159157317 concourse Terminal 1 Main Hall (2017~ - open)
1159157271 1159157327 1159396121 concourse Terminal 2 Main Hall (2017~ - open)
1159157271 1159157309 1159157307 concourse Terminal 3 Main Hall (2017~ - open)
1159157271 1159157333 1159157271 wing International Terminal (2017~ - open)
1159157271 1159157317 1159157271 wing Terminal 1 (2017~ - open)
1159157271 1159396121 1159157271 wing Terminal 2 (2017~ - open)
1159157271 1159157307 1159157271 wing Terminal 3 (2017~ - open)

SFO Terminal Complex (2014~ - 2017~)

belongs_to id parent_id placetype label
1159396321 1159396177 1159396153 concourse Boarding Area A (2014~ - 2017~)
1159396321 1159396237 1159396151 concourse Boarding Area B (2014~ - 2017~)
1159396321 1159396285 1159396151 concourse Boarding Area C (2014~ - 2017~)
1159396321 1159396193 1159157325 concourse Boarding Area D (2014~ - 2017~)
1159396321 1159157315 1159396157 concourse Boarding Area E (2014~ - 2017~)
1159396321 1159396315 1159396157 concourse Boarding Area F (2014~ - 2017~)
1159396321 1159396213 1159396153 concourse Boarding Area G (2014~ - 2017~)
1159396321 1159396153 1159396321 wing International Terminal (2014~ - 2017~)
1159396321 1159396151 1159396321 wing Terminal 1 (2014~ - 2017~)
1159396321 1159157325 1159396321 wing Terminal 2 (2014~ - 2017~)
1159396321 1159396157 1159396321 wing Terminal 3 (2014~ - 2017~)

SFO Terminal Complex (2011~ - 2014~)

belongs_to id parent_id placetype label
1159396333 1159396201 1159396159 concourse Boarding Area A (2011~ - 2014~)
1159396333 1159396211 1159396163 concourse Boarding Area B (2011~ - 2014~)
1159396333 1159396309 1159396163 concourse Boarding Area C (2011~ - 2014~)
1159396333 1159396261 1159396109 concourse Boarding Area D (2011~ - 2014~)
1159396333 1159396295 1159396141 concourse Boarding Area F (2011~ - 2014~)
1159396333 1159396239 1159396159 concourse Boarding Area G (2011~ - 2014~)
1159396333 1159396159 1159396333 wing International Terminal (2011~ - 2014~)
1159396333 1159396163 1159396333 wing Terminal 1 (2011~ - 2014~)
1159396333 1159396109 1159396333 wing Terminal 2 (2011~ - 2014~)
1159396333 1159396141 1159396333 wing Terminal 3 (2011~ - 2014~)

SFO Terminal Complex (2006~ - 2011~)

belongs_to id parent_id placetype label
1159396337 1159396269 1159396147 concourse Boarding Area A (2006~ - 2011~)
1159396337 1159396297 1159396139 concourse Boarding Area B (2006~ - 2011~)
1159396337 1159396229 1159396139 concourse Boarding Area C (2006~ - 2011~)
1159396337 1159396185 1159396167 concourse Boarding Area E (2006~ - 2011~)
1159396337 1159396221 1159396167 concourse Boarding Area F (2006~ - 2011~)
1159396337 1159396303 1159396147 concourse Boarding Area G (2006~ - 2011~)
1159396337 1159396147 1159396337 wing International Terminal (2006~ - 2011~)
1159396337 1159396139 1159396337 wing Terminal 1 (2006~ - 2011~)
1159396337 1159396167 1159396337 wing Terminal 3 (2006~ - 2011~)

SFO Terminal Complex (2000~ - 2006~)

belongs_to id parent_id placetype label
1159396319 1159396273 1159396115 concourse Boarding Area A (2000~ - 2006~)
1159396319 1159396291 1159396115 concourse Boarding Area B (2000~ - 2006~)
1159396319 1159396243 1159396115 concourse Boarding Area C (2000~ - 2006~)
1159396319 1159396199 1159396123 concourse Boarding Area E (2000~ - 2006~)
1159396319 1159396205 1159396123 concourse Boarding Area F (2000~ - 2006~)
1159396319 1159396311 1159396107 concourse Boarding Area G (2000~ - 2006~)
1159396319 1159396231 1159396107 concourse International Boarding Area A (2000~ - 2006~)
1159396319 1159396107 1159396319 wing International Terminal (2000~ - 2006~)
1159396319 1159396115 1159396319 wing Terminal 1 (2000~ - 2006~)
1159396319 1159396123 1159396319 wing Terminal 3 (2000~ - 2006~)

SFO Terminal Complex (1988~ - 2000~)

belongs_to id parent_id placetype label
1159554803 1159554845 1159554817 concourse Boarding Area A (1988~ - 2000~)
1159554803 1159554847 1159554817 concourse Boarding Area B (1988~ - 2000~)
1159554803 1159554849 1159554817 concourse Boarding Area C (1988~ - 2000~)
1159554803 1159554851 1159554829 concourse Boarding Area D (1988~ - 2000~)
1159554803 1159554853 1159554821 concourse Boarding Area E (1988~ - 2000~)
1159554803 1159554855 1159554821 concourse Boarding Area F (1988~ - 2000~)
1159554803 1159554829 1159554803 wing International Terminal (1988~ - 2000~)
1159554803 1159554821 1159554803 wing North Terminal (1988~ - 2000~)
1159554803 1159554817 1159554803 wing South Terminal (1988~ - 2000~)

SFO Terminal Complex (1983~ - 1988~)

belongs_to id parent_id placetype label
1159554801 1159554831 1159554815 concourse Boarding Area A (1983~ - 1988~)
1159554801 1159554833 1159554815 concourse Boarding Area B (1983~ - 1988~)
1159554801 1159554835 1159554815 concourse Boarding Area C (1983~ - 1988~)
1159554801 1159554837 1159554827 concourse Boarding Area D (1983~ - 1988~)
1159554801 1159554839 1159554819 concourse Boarding Area E (1983~ - 1988~)
1159554801 1159554841 1159554819 concourse Boarding Area F (1983~ - 1988~)
1159554801 1159554827 1159554801 wing International Terminal (1983~ - 1988~)
1159554801 1159554819 1159554801 wing North Terminal (1983~ - 1988~)
1159554801 1159554815 1159554801 wing South Terminal (1983~ - 1988~)

SFO Terminal Complex (1981~ - 1983~)

belongs_to id parent_id placetype label
1159396327 1159396251 1159396135 concourse Boarding Area A (1981~ - 1983~)
1159396327 1159396313 1159396135 concourse Boarding Area B (1981~ - 1983~)
1159396327 1159396215 1159396135 concourse Boarding Area C (1981~ - 1983~)
1159396327 1159396283 1159396133 concourse Boarding Area D (1981~ - 1983~)
1159396327 1159396179 1159396129 concourse Boarding Area E (1981~ - 1983~)
1159396327 1159396233 1159396129 concourse Boarding Area F (1981~ - 1983~)
1159396327 1159396133 1159396327 wing Central Terminal (1981~ - 1983~)
1159396327 1159396129 1159396327 wing North Terminal (1981~ - 1983~)
1159396327 1159396135 1159396327 wing South Terminal (1981~ - 1983~)

SFO Terminal Complex (1979~ - 1981~)

belongs_to id parent_id placetype label
1159396331 1159396277 1159396143 concourse Boarding Area A (1979~ - 1981~)
1159396331 1159396289 1159396143 concourse Boarding Area B (1979~ - 1981~)
1159396331 1159396247 1159396143 concourse Boarding Area C (1979~ - 1981~)
1159396331 1159396257 1159396149 concourse Boarding Area D (1979~ - 1981~)
1159396331 1159396207 1159396145 concourse Boarding Area F (1979~ - 1981~)
1159396331 1159396149 1159396331 wing Central Terminal (1979~ - 1981~)
1159396331 1159396145 1159396331 wing North Terminal (1979~ - 1981~)
1159396331 1159396143 1159396331 wing South Terminal (1979~ - 1981~)

SFO Terminal Complex (1974~ - 1979~)

belongs_to id parent_id placetype label
1159396339 1159396203 1159396169 concourse Pier A (1974~ - 1979~)
1159396339 1159396183 1159396165 concourse Pier B (1974~ - 1979~)
1159396339 1159396265 1159396165 concourse Pier C (1974~ - 1979~)
1159396339 1159396219 1159396165 concourse Pier D (1974~ - 1979~)
1159396339 1159396305 1159396169 concourse Pier E (1974~ - 1979~)
1159396339 1159396259 1159396169 concourse Pier F (1974~ - 1979~)
1159396339 1159396271 1159396169 concourse Pier FF (1974~ - 1979~)
1159396339 1159396189 1159396169 concourse Pier G (1974~ - 1979~)
1159396339 1159396165 1159396339 wing Central Terminal (1974~ - 1979~)
1159396339 1159396169 1159396339 wing South Terminal (1974~ - 1979~)

SFO Terminal Complex (1963~ - 1974~)

belongs_to id parent_id placetype label
1159396325 1159396255 1159396171 concourse Pier B (1963~ - 1974~)
1159396325 1159396197 1159396171 concourse Pier C (1963~ - 1974~)
1159396325 1159396293 1159396171 concourse Pier D (1963~ - 1974~)
1159396325 1159396241 1159396127 concourse Pier E (1963~ - 1974~)
1159396325 1159396175 1159396127 concourse Pier F (1963~ - 1974~)
1159396325 1159396223 1159396127 concourse Pier FF (1963~ - 1974~)
1159396325 1159396275 1159396127 concourse Pier G (1963~ - 1974~)
1159396325 1159396171 1159396325 wing Central Terminal (1963~ - 1974~)
1159396325 1159396127 1159396325 wing South Terminal (1963~ - 1974~)

SFO Terminal Complex (1954~ - 1963~)

belongs_to id parent_id placetype label
1159396329 1159396287 1159396131 concourse Pier B (1954~ - 1963~)
1159396329 1159396235 1159396131 concourse Pier C (1954~ - 1963~)
1159396329 1159396249 1159396131 concourse Pier D (1954~ - 1963~)
1159396329 1159396195 1159396131 concourse Pier E (1954~ - 1963~)
1159396329 1159396131 1159396329 wing Central Terminal (1954~ - 1963~)

Breadcrumbs

Boarding Area A (2017~ - open)

step id label
1 1159157339 Boarding Area A (2017~ - open)
2 1159396177 Boarding Area A (2014~ - 2017~)
3 1159396201 Boarding Area A (2011~ - 2014~)
4 1159396269 Boarding Area A (2006~ - 2011~)
5 1159396231 International Boarding Area A (2000~ - 2006~)

Boarding Area B (2017~ - open)

step id label
1 1159396217 Boarding Area B (2017~ - open)
2 1159396237 Boarding Area B (2014~ - 2017~)
3 1159396211 Boarding Area B (2011~ - 2014~)
4 1159396297 Boarding Area B (2006~ - 2011~)
5 1159396291 Boarding Area B (2000~ - 2006~)
6 1159554847 Boarding Area B (1988~ - 2000~)
7 1159554833 Boarding Area B (1983~ - 1988~)
8 1159396313 Boarding Area B (1981~ - 1983~)
9 1159396289 Boarding Area B (1979~ - 1981~)
10 1159396259 Pier F (1974~ - 1979~)
11 1159396175 Pier F (1963~ - 1974~)
12 1159396271 Pier FF (1974~ - 1979~)
13 1159396223 Pier FF (1963~ - 1974~)

Boarding Area C (2017~ - open)

step id label
1 1159157323 Boarding Area C (2017~ - open)
2 1159396285 Boarding Area C (2014~ - 2017~)
3 1159396309 Boarding Area C (2011~ - 2014~)
4 1159396229 Boarding Area C (2006~ - 2011~)
5 1159396243 Boarding Area C (2000~ - 2006~)
6 1159554849 Boarding Area C (1988~ - 2000~)
7 1159554835 Boarding Area C (1983~ - 1988~)
8 1159396215 Boarding Area C (1981~ - 1983~)
9 1159396247 Boarding Area C (1979~ - 1981~)
10 1159396305 Pier E (1974~ - 1979~)
11 1159396241 Pier E (1963~ - 1974~)
12 1159396195 Pier E (1954~ - 1963~)

Boarding Area D (2017~ - open)

step id label
1 1159396181 Boarding Area D (2017~ - open)
2 1159396193 Boarding Area D (2014~ - 2017~)
3 1159396261 Boarding Area D (2011~ - 2014~)
4 1159554851 Boarding Area D (1988~ - 2000~)
5 1159554837 Boarding Area D (1983~ - 1988~)
6 1159396283 Boarding Area D (1981~ - 1983~)
7 1159396257 Boarding Area D (1979~ - 1981~)
8 1159396219 Pier D (1974~ - 1979~)
9 1159396293 Pier D (1963~ - 1974~)
10 1159396249 Pier D (1954~ - 1963~)
11 1159396265 Pier C (1974~ - 1979~)
12 1159396197 Pier C (1963~ - 1974~)
13 1159396235 Pier C (1954~ - 1963~)

Boarding Area E (2017~ - open)

step id label
1 1159396267 Boarding Area E (2017~ - open)
2 1159157315 Boarding Area E (2014~ - 2017~)
3 1159396185 Boarding Area E (2006~ - 2011~)
4 1159396199 Boarding Area E (2000~ - 2006~)
5 1159554853 Boarding Area E (1988~ - 2000~)
6 1159554839 Boarding Area E (1983~ - 1988~)
7 1159396179 Boarding Area E (1981~ - 1983~)

Boarding Area F (2017~ - open)

step id label
1 1159396301 Boarding Area F (2017~ - open)
2 1159396315 Boarding Area F (2014~ - 2017~)
3 1159396295 Boarding Area F (2011~ - 2014~)
4 1159396221 Boarding Area F (2006~ - 2011~)
5 1159396205 Boarding Area F (2000~ - 2006~)
6 1159554855 Boarding Area F (1988~ - 2000~)
7 1159554841 Boarding Area F (1983~ - 1988~)
8 1159396233 Boarding Area F (1981~ - 1983~)
9 1159396207 Boarding Area F (1979~ - 1981~)

Boarding Area G (2017~ - open)

step id label
1 1159157337 Boarding Area G (2017~ - open)
2 1159396213 Boarding Area G (2014~ - 2017~)
3 1159396239 Boarding Area G (2011~ - 2014~)
4 1159396303 Boarding Area G (2006~ - 2011~)
5 1159396311 Boarding Area G (2000~ - 2006~)

International Terminal Main Hall (2017~ - open)

step id label
1 1159157335 International Terminal Main Hall (2017~ - open)

Terminal 1 Main Hall (2017~ - open)

step id label
1 1159157319 Terminal 1 Main Hall (2017~ - open)

Terminal 2 Main Hall (2017~ - open)

step id label
1 1159157327 Terminal 2 Main Hall (2017~ - open)

Terminal 3 Main Hall (2017~ - open)

step id label
1 1159157309 Terminal 3 Main Hall (2017~ - open)

International Terminal (2017~ - open)

step id label
1 1159157333 International Terminal (2017~ - open)
2 1159396153 International Terminal (2014~ - 2017~)
3 1159396159 International Terminal (2011~ - 2014~)
4 1159396147 International Terminal (2006~ - 2011~)
5 1159396107 International Terminal (2000~ - 2006~)

Terminal 1 (2017~ - open)

step id label
1 1159157317 Terminal 1 (2017~ - open)
2 1159396151 Terminal 1 (2014~ - 2017~)
3 1159396163 Terminal 1 (2011~ - 2014~)
4 1159396139 Terminal 1 (2006~ - 2011~)
5 1159396115 Terminal 1 (2000~ - 2006~)
6 1159554817 South Terminal (1988~ - 2000~)
7 1159554815 South Terminal (1983~ - 1988~)
8 1159396135 South Terminal (1981~ - 1983~)
9 1159396143 South Terminal (1979~ - 1981~)
10 1159396169 South Terminal (1974~ - 1979~)
11 1159396127 South Terminal (1963~ - 1974~)

Terminal 2 (2017~ - open)

step id label
1 1159396121 Terminal 2 (2017~ - open)
2 1159157325 Terminal 2 (2014~ - 2017~)
3 1159396109 Terminal 2 (2011~ - 2014~)
4 1159554829 International Terminal (1988~ - 2000~)
5 1159554827 International Terminal (1983~ - 1988~)
6 1159396133 Central Terminal (1981~ - 1983~)
7 1159396149 Central Terminal (1979~ - 1981~)
8 1159396165 Central Terminal (1974~ - 1979~)
9 1159396171 Central Terminal (1963~ - 1974~)
10 1159396131 Central Terminal (1954~ - 1963~)

Terminal 3 (2017~ - open)

step id label
1 1159157307 Terminal 3 (2017~ - open)
2 1159396157 Terminal 3 (2014~ - 2017~)
3 1159396141 Terminal 3 (2011~ - 2014~)
4 1159396167 Terminal 3 (2006~ - 2011~)
5 1159396123 Terminal 3 (2000~ - 2006~)
6 1159554821 North Terminal (1988~ - 2000~)
7 1159554819 North Terminal (1983~ - 1988~)
8 1159396129 North Terminal (1981~ - 1983~)
9 1159396145 North Terminal (1979~ - 1981~)

See also

License

This data is published under the Community Data License Agreement – Permissive – Version 1.0 license, but we'd love a shout-out and generally to hear what you're doing if you use the data.

You can’t perform that action at this time.