25 places near 12502, Columbia, New York, United States
filter by placetype:
  1. Middle America
    Middle America, United States (Colloquial)
  2. Continental United States
    Continental United States, United States (Colloquial)
  3. Hudson River Valley
    Hudson River Valley, New York, United States (Colloquial)
  4. Appalachian Trail
    Appalachian Trail, United States (Colloquial)
  5. Columbia
    Columbia, New York, United States (County)
  6. Dutchess
    Dutchess, New York, United States (County)
  7. America/New_York
    America/New_York, United States (Timezone)
  8. Illinois
    Illinois, Illinois, United States (State)
  9. New York
    New York, New York, United States (State)
  10. United States
    United States, United States (Country)

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

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

        
0.044 seconds ⌛

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