15 places near Koffiefontein, Xhariep, Free State, South Africa
filter by placetype:
  1. Rooibult
    Rooibult, Xhariep, Free State, South Africa (Suburb)
  2. Boitumelong
    Boitumelong, Xhariep, Free State, South Africa (Suburb)
  3. Ditlhake
    Ditlhake, Xhariep, Free State, South Africa (Suburb)
  4. Koffiefontein
    Koffiefontein, Xhariep, Free State, South Africa (Town)
  5. Kopanong
    Kopanong, Xhariep, Free State, South Africa (LocalAdmin)
  6. Letsemeng
    Letsemeng, Xhariep, Free State, South Africa (LocalAdmin)
  7. Xhariep
    Xhariep, Free State, South Africa (County)
  8. Pixley Ka Seme
    Pixley Ka Seme, Northern Cape, South Africa (County)
  9. Africa/Johannesburg
    Africa/Johannesburg (Timezone)
  10. Free State
    Free State, Free State, South Africa (State)

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

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

        
0.009 seconds ⌛

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