36 places near La Crescenta Elementary School, Los Angeles, California, United States
filter by placetype:
  1. Crescenta Valley Senior High School
    Crescenta Valley Senior High School, Los Angeles, California, United States (POI)
  2. La Crescenta Elementary School
    La Crescenta Elementary School, Los Angeles, California, United States (POI)
  3. Rosemont Middle School
    Rosemont Middle School, Los Angeles, California, United States (POI)
  4. La Crescenta
    La Crescenta, Los Angeles, California, United States (Suburb)
  5. Montrose
    Montrose, Los Angeles, California, United States (Suburb)
  6. Crescenta Heights
    Crescenta Heights, Los Angeles, California, United States (Suburb)
  7. Hillside
    Hillside, Los Angeles, California, United States (Suburb)
  8. Whiting Woods
    Whiting Woods, Los Angeles, California, United States (Suburb)
  9. La Crescenta - Montrose
    La Crescenta - Montrose, Los Angeles, California, United States (Suburb)
  10. Glendale
    Glendale, Los Angeles, California, United States (Town)

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

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

        
0.014 seconds ⌛

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