25 places near 81042, Caserta, Campania, Italia
filter by placetype:
  1. Croce
    Croce, Caserta, Campania, Italia (Town)
  2. Petrulo
    Petrulo, Caserta, Campania, Italia (Town)
  3. Rocchetta
    Rocchetta, Caserta, Campania, Italia (Town)
  4. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (Town)
  5. Rocchetta e Croce
    Rocchetta e Croce, Caserta, Campania, Italia (Town)
  6. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (LocalAdmin)
  7. Rocchetta e Croce
    Rocchetta e Croce, Caserta, Campania, Italia (LocalAdmin)
  8. Giano Vetusto
    Giano Vetusto, Caserta, Campania, Italia (LocalAdmin)
  9. Pignataro Maggiore
    Pignataro Maggiore, 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.016 seconds ⌛; show me the details?

        
0.016 seconds ⌛

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