{
  "success": {
    "v": 2,
    "license": "CC-BY 4.0",
    "description": "Search and summarize columns based on unit properties or geographic location",
    "options": {
      "parameters": {
        "unit_id": "integer, a valid unit id",
        "section_id": "integer, a valid section id",
        "col_id": "integer, a valid column id",
        "col_type": "string, a column type",
        "interval_name": "string, chronostratigraphic time interval name",
        "int_id": "integer, a chronostratigraphic time interval ID from /defs/intervals",
        "age": "numerical age in millions of years before present",
        "age_top": "numerical age (Ma) - must be used with age_bottom and be less than age_bottom",
        "age_bottom": "numerical age (Ma) - must be used with age_top and be greater than age_top",
        "lith_id": "integer, ID of a lithology from /defs/lithologies",
        "lith": "string, specific lithology name (e.g., shale, sandstone)",
        "lith_type": "string, groups of lithologies (e.g., carbonate, siliciclastic)",
        "lith_class": "string, general lithologies (sedimentary, igneous, metamorphic)",
        "lith_att_id": "integer, ID of a lithology attribute from /defs/lithology_attributes",
        "lith_att": "string, specific lithology attribute name (e.g. fine, olivine, poorly washed)",
        "lith_att_type": "string, specific category of lithology attribute (e.g. grains, lithology, bedform)",
        "environ_id": "integer, specific environment ID from /defs/environments",
        "environ": "string, specific environment",
        "environ_type": "string, groups of environments",
        "environ_class": "string, general environments",
        "econ_id": "integer, ID of an economic attribute from /defs/econs",
        "econ": "string, name of an economic attribute",
        "econ_type": "string, name of an economic attribute type",
        "econ_class": "string, name of an economic attribute class",
        "cltn_id": "integer, one or more Paleobiology Database collection IDs",
        "strat_name": "a fuzzy stratigraphic name to match units to",
        "strat_name_id": "integer, a single or comma-separated list of stratigraphic IDs from /defs/strat_names",
        "strat_name_concept_id": "integer, a single or comma-separated list of stratigraphic name concept IDs from /defs/strat_name_concepts",
        "lat": "number, decimal degree latitude, WGS84",
        "lng": "number, decimal degree longitude, WGS84",
        "adjacents": "boolean, if lat/lng or col_id is specified, optionally return all units in columns that touch the polygon containing the supplied lat/lng",
        "project_id": "a Macrostrat project ID",
        "status_code": "string, column status codes, values 'active','in process','obsolete'. Defaults to 'active'",
        "response": "Any available response_type. Default is short.",
        "format": "string, desired output format"
      },
      "output_formats": [
        "json",
        "csv",
        "geojson",
        "geojson_bare",
        "topojson",
        "topojson_bare"
      ],
      "examples": [
        "/api/columns?interval_name=Permian",
        "/api/columns?age=271",
        "/api/columns?age_top=200&age_bottom=250",
        "/api/columns?strat_name=mancos&format=geojson_bare",
        "/api/columns?lat=43&lng=-89&adjacents=true"
      ],
      "response_types": [
        "short",
        "long"
      ],
      "fields": {
        "col_id": "integer, unique identifier for column",
        "col_name": "text, name of column",
        "lat": "decimal, latitude in WGS84",
        "lng": "decimal, longigtude in WGS84",
        "col_group": "text, name of group the column belongs to, generally corresponds to geologic provinces",
        "col_group_id": "integer, the ID of the group to which the column belongs",
        "group_col_id": "float, the original column ID assigned to the column (used in the original source)",
        "col_area": "float, area in square kilometers of the Macrostrat column",
        "project_id": "unique identifier for project, corresponds to general geographic region",
        "project_name": "",
        "max_thick": "number, maximum unit thickness in meters",
        "max_min_thick": "integer, the maximum possible minimum thickness in meters",
        "min_min_thick": "integer, the minimum possible minimum thickness in meters",
        "b_age": "number, continuous time age model estimated for initiation, in Myr before present",
        "t_age": "number, continuous time age model estimated for truncation, in Myr before present",
        "pbdb_collections": "integer, count of PBDB collections in units/column",
        "lith": "text, specific lithology, see /defs/lithologies",
        "environ": "text, specific environment, see /defs/environments",
        "econ": "text, name of econonomic use, see defs/econs",
        "t_units": "integer, total units",
        "t_sections": "integer, total sections"
      }
    }
  }
}