30 places near Defreestville, Rensselaer, New York, United States
filter by placetype:
  1. Rosemont Park
    Rosemont Park, Rensselaer, New York, United States (Suburb)
  2. Van Allen Park
    Van Allen Park, Rensselaer, New York, United States (Suburb)
  3. Albany
    Albany, Albany, New York, United States (Town)
  4. Defreestville
    Defreestville, Rensselaer, New York, United States (Town)
  5. Rensselaer
    Rensselaer, Rensselaer, New York, United States (Town)
  6. North Greenbush
    North Greenbush, Rensselaer, New York, United States (Town)
  7. New England
    New England, United States (Colloquial)
  8. East Coast
    East Coast, United States (Colloquial)
  9. US Eastern States
    US Eastern States, United States (Colloquial)
  10. Middle Atlantic States
    Middle Atlantic States, United States (Colloquial)

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

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

        
0.032 seconds ⌛

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