17 places near Sagama, Oristano, Sardegna, Italia
filter by placetype:
  1. Sagama
    Sagama, Oristano, Sardegna, Italia (Town)
  2. Suni
    Suni, Oristano, Sardegna, Italia (Town)
  3. Sagama
    Sagama, Oristano, Sardegna, Italia (LocalAdmin)
  4. Scano di Montiferro
    Scano di Montiferro, Oristano, Sardegna, Italia (LocalAdmin)
  5. Tinnura
    Tinnura, Oristano, Sardegna, Italia (LocalAdmin)
  6. Isola di Sardinia
    Isola di Sardinia, Sardegna, Italia (Island)
  7. Oristano
    Oristano, 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.01 seconds ⌛; show me the details?

        
0.01 seconds ⌛

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