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

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

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

        
0.046 seconds ⌛

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