27 places near 12523, Columbia, New York, United States
filter by placetype:
  1. Snyderville
    Snyderville, Columbia, New York, United States (Suburb)
  2. Clermont
    Clermont, Columbia, New York, United States (Town)
  3. Gallatin
    Gallatin, Columbia, New York, United States (Town)
  4. Livingston
    Livingston, Columbia, New York, United States (Town)
  5. Taghkanic
    Taghkanic, Columbia, New York, United States (Town)
  6. East Coast
    East Coast, United States (Colloquial)
  7. US Eastern States
    US Eastern States, United States (Colloquial)
  8. Middle Atlantic States
    Middle Atlantic States, United States (Colloquial)
  9. Northeastern States
    Northeastern States, United States (Colloquial)
  10. Canada International Border States
    Canada International Border States, United States (Colloquial)

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

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

        
0.034 seconds ⌛

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