25 places near 81040, Caserta, Campania, Italia
filter by placetype:
  1. Pontelatone
    Pontelatone, Caserta, Campania, Italia (Town)
  2. Prea
    Prea, Caserta, Campania, Italia (Town)
  3. Strangolagalli
    Strangolagalli, Caserta, Campania, Italia (Town)
  4. Casalicchio
    Casalicchio, Caserta, Campania, Italia (Town)
  5. Cisterna
    Cisterna, Caserta, Campania, Italia (Town)
  6. Castel di Sasso
    Castel di Sasso, Caserta, Campania, Italia (Town)
  7. Formicola
    Formicola, Caserta, Campania, Italia (LocalAdmin)
  8. Castel di Sasso
    Castel di Sasso, 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.03 seconds ⌛; show me the details?

        
0.03 seconds ⌛

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