38 places near Venarotta, Ascoli Piceno, Marche, Italia
filter by placetype:
  1. Palmiano
    Palmiano, Ascoli Piceno, Marche, Italia (Town)
  2. Roccafluvione
    Roccafluvione, Ascoli Piceno, Marche, Italia (Town)
  3. Venarotta
    Venarotta, Ascoli Piceno, Marche, Italia (Town)
  4. Arola
    Arola, Ascoli Piceno, Marche, Italia (Town)
  5. Castello
    Castello, Ascoli Piceno, Marche, Italia (Town)
  6. Casamaruccia
    Casamaruccia, Ascoli Piceno, Marche, Italia (Town)
  7. Cepparano
    Cepparano, Ascoli Piceno, Marche, Italia (Town)
  8. Colle-Lungo
    Colle-Lungo, Ascoli Piceno, Marche, Italia (Town)
  9. Ripe di Cepperano
    Ripe di Cepperano, Ascoli Piceno, Marche, Italia (Town)
  10. Spineta
    Spineta, Ascoli Piceno, Marche, Italia (Town)

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

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

        
0.014 seconds ⌛

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