13 places near Gamboula, Mambéré-Kadéï, Central African Republic
filter by placetype:
  1. Gamboula
    Gamboula, Mambéré-Kadéï, Central African Republic (County)
  2. Africa/Bangui
    Africa/Bangui (Timezone)
  3. Africa/Douala
    Africa/Douala (Timezone)
  4. Africa/Kinshasa
    Africa/Kinshasa, Democratic Republic of Congo (Timezone)
  5. Est
    Est, Est, Cameroon (State)
  6. Mambéré-Kadéï
    Mambéré-Kadéï, Mambéré-Kadéï, Central African Republic (State)
  7. Central African Republic
    Central African Republic, Central African Republic (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Africa
    Africa (Continent)

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

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

        
0.02 seconds ⌛

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