22 places near Rotelli, Macerata, Marche, Italia
filter by placetype:
  1. Passo di Treia
    Passo di Treia, Macerata, Marche, Italia (Town)
  2. Pollenza
    Pollenza, Macerata, Marche, Italia (Town)
  3. Treia
    Treia, Macerata, Marche, Italia (Town)
  4. Rotelli
    Rotelli, Macerata, Marche, Italia (Town)
  5. Pollenza
    Pollenza, Macerata, Marche, Italia (LocalAdmin)
  6. Treia
    Treia, Macerata, Marche, Italia (LocalAdmin)
  7. Macerata
    Macerata, Marche, Italia (County)
  8. Ascoli Piceno
    Ascoli Piceno, Marche, Italia (County)
  9. Ancona
    Ancona, Marche, Italia (County)
  10. Fermo
    Fermo, Marche, Italia (County)

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": [
                  13.35775,
                  43.28862
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}