Search the SFO Museum Collection

There are no results where the object has not been digitized and the subcategory is 1511213315 and the airline is 1159294431 and the query mode is to match the entire phrase . Would you like try the same search matching the individual words in your query rather than the whole phrase?

Click here to see the database query used to perform this search
{
    "query": {
        "function_score": {
            "query": {
                "bool": {
                    "must": [
                        {
                            "term": {
                                "sfomuseum:placetype": "object"
                            }
                        },
                        {
                            "bool": {
                                "should": [
                                    {
                                        "term": {
                                            "millsfield:subcategory_id": "1511213315"
                                        }
                                    }
                                ]
                            }
                        },
                        {
                            "bool": {
                                "should": [
                                    {
                                        "bool": {
                                            "should": [
                                                {
                                                    "ids": {
                                                        "values": "1159294431"
                                                    }
                                                },
                                                {
                                                    "term": {
                                                        "wof:depicts": "1159294431"
                                                    }
                                                },
                                                {
                                                    "term": {
                                                        "millsfield:airline_id": "1159294431"
                                                    }
                                                }
                                            ]
                                        }
                                    }
                                ]
                            }
                        }
                    ],
                    "must_not": [
                        {
                            "bool": {
                                "should": [
                                    {
                                        "exists": {
                                            "field": "millsfield:images"
                                        }
                                    }
                                ]
                            }
                        },
                        {
                            "exists": {
                                "field": "sfomuseum:image_id"
                            }
                        },
                        {
                            "exists": {
                                "field": "edtf:deprecated"
                            }
                        }
                    ]
                }
            },
            "functions": [],
            "boost_mode": "multiply",
            "score_mode": "multiply",
            "boost": 10,
            "max_boost": 500
        }
    },
    "sort": [
        {
            "_script": {
                "type": "number",
                "script": "doc['millsfield:images'].size()",
                "order": "desc"
            }
        },
        {
            "wof:name.keyword": "desc"
        },
        {
            "date:inception_inner_start": "desc",
            "date:cessation_outer_end": "desc"
        }
    ],
    "aggs": {
        "collection": {
            "terms": {
                "field": "millsfield:collection_id",
                "exclude": [
                    -1
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "category": {
            "terms": {
                "field": "millsfield:category_id",
                "exclude": [
                    -1
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "subcategory": {
            "terms": {
                "field": "millsfield:subcategory_id",
                "exclude": [
                    -1,
                    "1511213315"
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "airline": {
            "terms": {
                "field": "millsfield:airline_id",
                "exclude": [
                    -1,
                    "1159294431"
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "aircraft": {
            "terms": {
                "field": "millsfield:aircraft_id",
                "exclude": [
                    -1
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "airport": {
            "terms": {
                "field": "millsfield:airport_id",
                "exclude": [
                    -1
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "images": {
            "value_count": {
                "field": "millsfield:images"
            }
        },
        "year": {
            "date_histogram": {
                "field": "date:inception_lower",
                "calendar_interval": "year",
                "min_doc_count": 1
            }
        }
    }
}


You can also filter your query by manually selecting one or more of the following criteria below.

Collections
Airlines
Airlines (A - C)
Airlines (D - F)
Airlines (G - I)
Airlines (J - L)
Airlines (M - O)
Airlines (P - R)
Airlines (S - U)
Airlines (V - X)
Airlines (Y - Z)
Aircraft
Aircraft (A - C)
Aircraft (D - F)
Aircraft (G - I)
Aircraft (J - L)
Aircraft (M - O)
Aircraft (P - R)
Aircraft (S - U)
Aircraft (V - X)
Aircraft (Y - Z)
Airports
Airports (A - C)
Airports (D - F)
Airports (G - I)
Airports (J - L)
Airports (M - O)
Airports (P - R)
Airports (S - U)
Airports (V - X)
Airports (Y - Z)
Years
Years (2900)
Years (2000)
Years (1900)
Years (1800)
Years (1700)
Years (0100)
Date range