Search the SFO Museum Collection
There are no results where
the object has not been digitized
and
the subcategory is 1511213367
and
aircraft is 1159290421
and
the airport is 102536579
and
decade is 1940
.
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:subcategory_id": "1511213367" } } ] } }, { "bool": { "should": [ { "bool": { "should": [ { "ids": { "values": "1159290421" } }, { "term": { "wof:depicts": "1159290421" } }, { "term": { "millsfield:aircraft_id": "1159290421" } } ] } } ] } }, { "bool": { "should": [ { "bool": { "should": [ { "ids": { "values": "102536579" } }, { "term": { "wof:depicts": "102536579" } }, { "term": { "millsfield:airport_id": "102536579" } } ] } } ] } }, { "range": { "date:inception_upper": { "gte": "1940-01-01", "format": "yyyy-mm-dd" } } }, { "range": { "date:cessation_lower": { "lte": "1949-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 ], "size": 1000, "order": { "_key": "asc" } } }, "subcategory": { "terms": { "field": "millsfield:subcategory_id", "exclude": [ -1, "1511213367" ], "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, "1159290421" ], "size": 1000, "order": { "_key": "asc" } } }, "airport": { "terms": { "field": "millsfield:airport_id", "exclude": [ -1, "102536579" ], "size": 1000, "order": { "_key": "asc" } } }, "images": { "value_count": { "field": "millsfield:images" } }, "exhibition": { "terms": { "field": "millsfield:exhibition_ids", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } } } }