MultiPolygon Datatype

Some geometries may be polygons with “holes” in the center, or may be made up of multiple disconnected polygons. In that case, the GeoJSON “multipolygon” is used. Example:

{ 
  "type": "MultiPolygon",
  "coordinates": [
    [[[102.0, 2.0], [103.0, 2.0], [103.0, 3.0], [102.0, 3.0], [102.0, 2.0]]],
    [[[100.0, 0.0], [101.0, 0.0], [101.0, 1.0], [100.0, 1.0], [100.0, 0.0]],
     [[100.2, 0.2], [100.8, 0.2], [100.8, 0.8], [100.2, 0.8], [100.2, 0.2]]]
  ]
}
Heads up! Contrary to the normal convention of "latitude, longitude" ordering in the coordinates property, GeoJSON orders the coordinates as "longitude, latitude" (X coordinate, Y coordinate), as other GIS coordiate systems are encoded. Note that the SoQL within_box and within_circle functions use the more conventional ordering, however.

The following table describes the functions that can be used with MultiPolygon .

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 the geometries within a set 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
simplify(...) Reduces the number of vertices in a line or polygon 2.1
simplify_preserve_topology(...) Reduces the number of vertices in a line or polygon, preserving topology 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

Closely related to the MultiPolygon datatype is the Polygon .