29 places near 81038, Caserta, Campania, Italia
filter by placetype:
  1. Casal di Principe
    Casal di Principe, Caserta, Campania, Italia (Town)
  2. Napoli
    Napoli, Napoli, Campania, Italia (Town)
  3. Trentola Ducenta
    Trentola Ducenta, Caserta, Campania, Italia (Town)
  4. Casapesenna
    Casapesenna, Caserta, Campania, Italia (Town)
  5. Lusciano
    Lusciano, Caserta, Campania, Italia (Town)
  6. Parete
    Parete, Caserta, Campania, Italia (Town)
  7. San Marcellino
    San Marcellino, Caserta, Campania, Italia (Town)
  8. Villa di Briano
    Villa di Briano, Caserta, Campania, Italia (Town)
  9. Giugliano in Campania
    Giugliano in Campania, Napoli, Campania, Italia (LocalAdmin)
  10. San Marcellino
    San Marcellino, Caserta, Campania, Italia (LocalAdmin)

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

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

        
0.047 seconds ⌛

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