14 places near SGN, Malta Majjistral, Malta
filter by placetype:
  1. Attard
    Attard, Attard, Malta Majjistral, Malta (Town)
  2. Birkirkara
    Birkirkara, Birkirkara, Malta Majjistral, Malta (Town)
  3. Gżira
    Gżira, Gżira, Malta Majjistral, Malta (Town)
  4. Swieqi
    Swieqi, Swieqi, Malta Majjistral, Malta (Town)
  5. Msida
    Msida, Msida, Malta Majjistral, Malta (Town)
  6. Msieraħ
    Msieraħ, San Ġwann, Malta Majjistral, Malta (Town)
  7. Pietà
    Pietà, Pieta, Malta Majjistral, Malta (Town)
  8. San Ġiljan
    San Ġiljan, Swieqi, Malta Majjistral, Malta (Town)
  9. San Ġwann
    San Ġwann, San Ġwann, Malta Majjistral, Malta (Town)
  10. Santa Venera
    Santa Venera, Santa Venera, Malta Majjistral, Malta (Town)

Search again including deprecated places, unknown places, places that visit Null Island or everything?

This query took 0.031 seconds ⌛; show me the details?

        
0.031 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  14.4753,
                  35.9086
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "must_not": [
        {
          "terms": {
            "woe:placetype": [
              0,
              11,
              25
            ]
          }
        },
        {
          "term": {
            "geom:latitude": {
              "value": 0.0
            }
          }
        },
        {
          "term": {
            "geom:longitude": {
              "value": 0.0
            }
          }
        },
        {
          "exists": {
            "field": "woe:superseded_by"
          }
        }
      ]
    }
  },
  "aggs": {
    "placetypes": {
      "terms": {
        "field": "woe:placetype_name",
        "size": 10000
      }
    }
  },
  "sort": [
    {
      "woe:scale": {
        "order": "desc",
        "mode": "max"
      }
    },
    {
      "woe:id": {
        "order": "asc",
        "mode": "max"
      }
    }
  ]
}