18 places near Palo Alto, San Onofre, Sucre, Colombia
filter by placetype:
  1. Palo Alto
    Palo Alto, San Onofre, Sucre, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Maria la Baja
    Maria la Baja, Bolivar, Colombia (County)
  4. San Onofre
    San Onofre, Sucre, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Bolivar
    Bolivar, Bolivar, Colombia (State)
  7. Sucre
    Sucre, Sucre, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Caribbean Sea
    Caribbean Sea (Sea)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.042 seconds ⌛

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