Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

intersects(...), distance_in_meters(...)

We’re excited to announce that we’re making two new features of our SoQL query language public:

  • The intersects(...) function allows you to determine whether two geospatial datatypes overlap with each other. It can be used to determine what police district a given point is within, what school districts are served by by a given bus route, or census districts cover a particular neighborhood.
  • The distance_in_meters(...) function returns the distance between two Points in meters. It can be used to determine how far you are from a given location, or order results by distance.

We’re excited to see how people make use of these new features! If you have any questions or issues, or even if you just want to share what you’ve built, don’t be afraid to get in touch with us.