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.

MultiPoint Datatype

The MultiPoint datatype is very similar to the Location datatype. It represents one or more locations on the Earth as a WGS84 Latitude and Longitude. The location is encoded as a GeoJSON “multipoint”. Example:

  "type": "MultiPoint",
  "coordinates": [ [100.0, 0.0], [101.0, 1.0] ]
Heads up! Contrary to the normal convention of "latitude, longitude" ordering in the coordinates property, the GeoJSON orders the coordinates as "longitude, latitude" (X coordinate, Y coordinate), as other GIS coordinate systems are encoded. Note that the SoQL within_box and within_circle functions use the more conventional ordering, however.

The following operators can be used on multipoint fields:

Operator Description
IS NULL TRUE for values that are NULL.
IS NOT NULL TRUE for values that are not NULL.

And the following functions can be used with them:

Keyword Name Description Availability
distinct Returns distinct set of records 2.1
Function Name Description Availability
case(...) Returns different values based on the evaluation of boolean comparisons 2.1
convex_hull(...) Returns the minimum convex geometry that encloses all of another geometry 2.1
count(...) Returns a count of a given set of records 2.0 and 2.1
extent(...) Returns a bounding box that encloses a set of geometries 2.1
intersects(...) Allows you to compare two geospatial types to see if they intersect or overlap each other 2.1
num_points(...) Returns the number of vertices in a geospatial data record 2.1
within_box(...) Returns the rows that have geodata within the specified box, defined by latitude, longitude corners 2.0 and 2.1
within_circle(...) Returns the rows that have locations within a specified circle, measured in meters 2.0 and 2.1
within_polygon(...) Returns the rows that have locations within the specified box, defined by latitude, longitude corners 2.1