DataSF (San Francisco open data) / Query a dataset's rows with SoQL

Filter, sort and aggregate the rows of any public dataset on data.sf.gov with SoQL (Socrata's SQL-like language): select, where, order, group, having, full-text q, limit and offset. Rows come back as a GeoJSON FeatureCollection: each row is one feature, its columns are in properties (all values as strings) and geometry is the row's location or null. Up to 500 rows per call (default 100). Examples on this portal: building permits (i98e-djp9), business locations (g8m3-pdis), 311 cases (vw6y-z8j6), police incidents (wg3w-h783). A bad column name or SoQL syntax answers 400 at $0; an unknown dataset is a miss ($0). Free: the Socrata SODA API on data.sf.gov needs no key. Anonymous calls share an IP rate limit, so a burst can answer 429 (rate_limited, $0). Source: DataSF, City and County of San Francisco, public domain (PDDL) unless the dataset says otherwise; provided as is, without warranty.