25 places near Cavallari, Caserta, Campania, Italia
filter by placetype:
  1. Croce
    Croce, Caserta, Campania, Italia (Town)
  2. Formicola
    Formicola, Caserta, Campania, Italia (Town)
  3. Giano Vetusto
    Giano Vetusto, Caserta, Campania, Italia (Town)
  4. Cavallari
    Cavallari, Caserta, Campania, Italia (Town)
  5. Fondola
    Fondola, Caserta, Campania, Italia (Town)
  6. Lautoni
    Lautoni, Caserta, Campania, Italia (Town)
  7. Formicola
    Formicola, Caserta, Campania, Italia (LocalAdmin)
  8. Giano Vetusto
    Giano Vetusto, Caserta, Campania, Italia (LocalAdmin)
  9. Pontelatone
    Pontelatone, Caserta, Campania, Italia (LocalAdmin)
  10. Caserta
    Caserta, Campania, Italia (County)

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

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

        
0.025 seconds ⌛

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