25 places near Colțu de Jos, Prahova, România
filter by placetype:
  1. Cocorăștii-Colț
    Cocorăștii-Colț, Prahova, România (Town)
  2. Colțu de Jos
    Colțu de Jos, Prahova, România (Town)
  3. Satu de Sus
    Satu de Sus, Prahova, România (Town)
  4. Stăncești
    Stăncești, Prahova, România (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Olt River
    Olt River, România (Drainage)
  7. Transylvania
    Transylvania, România (Colloquial)
  8. Wallachia
    Wallachia, România (Colloquial)
  9. Europe/Bucharest
    Europe/Bucharest (Timezone)
  10. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)

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

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

        
0.053 seconds ⌛

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