Search the SFO Museum Collection

There are no results where the object has not been digitized and the category is 1762671311 and creditline is Gift of Gary G. Gulbransen and decade is 1980 . Would you like to try a new search?

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:category_id": "1762671311"
                                        }
                                    }
                                ]
                            }
                        },
                        {
                            "query_string": {
                                "default_field": "sfomuseum:creditline",
                                "default_operator": "AND",
                                "query": "Gift of Gary G. Gulbransen"
                            }
                        },
                        {
                            "range": {
                                "date:inception_upper": {
                                    "gte": "1980-01-01",
                                    "format": "yyyy-mm-dd"
                                }
                            }
                        },
                        {
                            "range": {
                                "date:cessation_lower": {
                                    "lte": "1989-12-13",
                                    "format": "yyyy-mm-dd"
                                }
                            }
                        }
                    ],
                    "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,
                    "1762671311"
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "subcategory": {
            "terms": {
                "field": "millsfield:subcategory_id",
                "exclude": [
                    -1
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        },
        "airline": {
            "terms": {
                "field": "millsfield:airline_id",
                "exclude": [
                    -1
                ],
                "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"
            }
        },
        "exhibition": {
            "terms": {
                "field": "millsfield:exhibition_ids",
                "exclude": [
                    -1
                ],
                "size": 1000,
                "order": {
                    "_key": "asc"
                }
            }
        }
    }
}