26 places near Marzano Appio, Caserta, Campania, Italia
filter by placetype:
  1. Marzano
    Marzano, Caserta, Campania, Italia (Town)
  2. Ameglio
    Ameglio, Caserta, Campania, Italia (Town)
  3. Grottola
    Grottola, Caserta, Campania, Italia (Town)
  4. Tuorofunaro
    Tuorofunaro, Caserta, Campania, Italia (Town)
  5. Casinove
    Casinove, Caserta, Campania, Italia (Town)
  6. Marzano Appio
    Marzano Appio, Caserta, Campania, Italia (LocalAdmin)
  7. Caianello
    Caianello, Caserta, Campania, Italia (LocalAdmin)
  8. Conca della Campania
    Conca della Campania, Caserta, Campania, Italia (LocalAdmin)
  9. Roccamonfina
    Roccamonfina, Caserta, Campania, Italia (LocalAdmin)
  10. Tora e Piccilli
    Tora e Piccilli, Caserta, Campania, Italia (LocalAdmin)

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

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

        
0.04 seconds ⌛

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