Returns the rows that have locations within a specified circle, measured in meters

Works with the following datatypes:

This function works with 2.0 and 2.1 endpoint(s). What does this mean? »

The within_circle(...) function is used in the $where parameter filter for Point or Location values within a given radius of a point. It accepts four parameters:

  • The field name of a Location or Point
  • The latitude of your central point
  • The longitude of your central point
  • The radius of the circle in meters

For example, to query for all of the Seattle Fire 911 Calls calls within 500 meters of the Socrata offices in Seattle:

https://data.seattle.gov/resource/kzjm-xkqj.json?$where=within_circle(report_location, 47.59815, -122.334540, 500)