30 places near Portico di Caserta, Caserta, Campania, Italia
filter by placetype:
  1. Capodrise
    Capodrise, Caserta, Campania, Italia (Town)
  2. Casapulla
    Casapulla, Caserta, Campania, Italia (Town)
  3. Caserta
    Caserta, Caserta, Campania, Italia (Town)
  4. Macerata Campania
    Macerata Campania, Caserta, Campania, Italia (Town)
  5. Portico di Caserta
    Portico di Caserta, Caserta, Campania, Italia (Town)
  6. Recale
    Recale, Caserta, Campania, Italia (Town)
  7. Musicile
    Musicile, Caserta, Campania, Italia (Town)
  8. Caturano
    Caturano, Caserta, Campania, Italia (Town)
  9. Caserta
    Caserta, Caserta, Campania, Italia (LocalAdmin)
  10. Macerata Campania
    Macerata Campania, Caserta, Campania, Italia (LocalAdmin)

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

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

        
0.023 seconds ⌛

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