Search the SFO Museum Collection
There are no results where
the object has not been digitized
and
the subcategory is 1511213351
and
the airline is 1159284309
.
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": "1511213351"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"should": [
{
"ids": {
"values": "1159284309"
}
},
{
"term": {
"wof:depicts": "1159284309"
}
},
{
"term": {
"millsfield:airline_id": "1159284309"
}
}
]
}
}
]
}
}
],
"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,
"1511213351"
],
"size": 1000,
"order": {
"_key": "asc"
}
}
},
"airline": {
"terms": {
"field": "millsfield:airline_id",
"exclude": [
-1,
"1159284309"
],
"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
}
}
}
}