Works on fields of type Number

Works on fields of type Number

Docs: https://dev.socrata.com/docs/functions/avg.html

Works on fields of type Point/MultiPoint/Line/MultiLine/Polygon/MultiPolygon

Returns the minimum convex geometry that encloses all of another geometry's points.

Docs: https://dev.socrata.com/docs/functions/convex_hull.html

Works like SELECT COUNT(*)

Docs: https://dev.socrata.com/docs/functions/count.html

Extracts the day from the date as an integer.

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_d.html

Extracts the day of the week as an integer between 0 and 6 (inclusive).

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_dow.html

Extracts the hour of the day as an integer between 0 and 23 (inclusive).

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_hh.html

Extracts the minute from the time as an integer.

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_mm.html

Extracts the month as an integer.

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_m.html

Extracts the second from the time as an integer.

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_ss.html

Extracts the week of the year as an integer between 0 and 51 (inclusive).

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_woy.html

Extracts the year as an integer.

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_extract_y.html

Truncates a calendar date at the year threshold

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_trunc_y.html

Truncates a calendar date at the year/month threshold

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_trunc_ym.html

Truncates a calendar date at the year/month/date threshold

Works on fields of type Floating Timestamp

Docs: https://dev.socrata.com/docs/functions/date_trunc_ymd.html

Works on fields of type Point

Docs: https://dev.socrata.com/docs/functions/distance_in_meters.html

Returns distinct set of records

Docs: https://dev.socrata.com/docs/functions/distinct.html

Returns a bounding box that encloses a set of geometries

Works on fields of type Point, MultiPoint, Line, MultiLine, Polygon, MultiPolygon

Docs: https://dev.socrata.com/docs/functions/extent.html

Works on fields of type Text

Works on fields of type Text

Returns the maximum of a given set of numbers

Works on fields of type Number/Text/FloatingTimestamp/FixedTimestamp

Docs: https://dev.socrata.com/docs/functions/max.html

Returns the minimum of a given set of numbers

Works on fields of type Number/Text/FloatingTimestamp/FixedTimestamp

Docs: https://dev.socrata.com/docs/functions/min.html

Returns the number of vertices in a geospatial data record

Works on fields of type Polygon, Line, Point, MultiPoint, MultiLine, MultiPolygon

Docs: https://dev.socrata.com/docs/functions/num_points.html

Reduces the number of vertices in a line or polygon

Reduces the number of vertices in a line or polygon, preserving topology

Works on fields of type Number

Docs: https://dev.socrata.com/docs/functions/sum.html

Works on fields of type Text