17 places near Marrubiu, Oristano, Sardegna, Italia
filter by placetype:
  1. Marrubiu
    Marrubiu, Oristano, Sardegna, Italia (Town)
  2. Is Bangius
    Is Bangius, Oristano, Sardegna, Italia (Town)
  3. Marrubiu
    Marrubiu, Oristano, Sardegna, Italia (LocalAdmin)
  4. Isola di Sardinia
    Isola di Sardinia, Sardegna, Italia (Island)
  5. Oristano
    Oristano, Sardegna, Italia (County)
  6. Cagliari
    Cagliari, Sardegna, Italia (County)
  7. Medio Campidano
    Medio Campidano, Sardegna, Italia (County)
  8. Europe/Rome
    Europe/Rome (Timezone)
  9. Sardegna
    Sardegna, Italia (State)
  10. Italia
    Italia, Italia (Country)

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

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

        
0.022 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  8.67242,
                  39.77589
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}