DataSF (San Francisco open data) / Read one dataset's columns and metadata

Metadata for one dataset on data.sf.gov: name, description, owner, licence and attribution, row and data update times, and every column with its field name (use these names in SoQL), data type and description. Call it before the query route to learn the column names. An unknown dataset id 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.