23 places near Tătărani, Prahova, România
filter by placetype:
  1. Bărcănești
    Bărcănești, Prahova, România (Town)
  2. Ploiești
    Ploiești, Prahova, România (Town)
  3. Tătărani
    Tătărani, Prahova, România (Town)
  4. Donau
    Donau, Magyarország (Drainage)
  5. Olt River
    Olt River, România (Drainage)
  6. Transylvania
    Transylvania, România (Colloquial)
  7. Wallachia
    Wallachia, România (Colloquial)
  8. Europe/Bucharest
    Europe/Bucharest (Timezone)
  9. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)
  10. Prahova
    Prahova, Prahova, România (State)

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

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

        
0.027 seconds ⌛

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