[
  {
    "op": "core/column-addition-by-fetching-urls",
    "description": "Create column JSON at index 24 by fetching URLs based on column locality using expression grel:\"http://www.museum.tulane.edu/webservices/geolocatesvcv2/glcwrap.aspx?Country=USA&state=\"+escape(cells.state.value,'url')+\"&county=\"+escape(cells.county.value,'url')+\"&locality=\"+escape(cells.locality.value,'url')",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "value",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "state",
          "omitBlank": false,
          "columnName": "state",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": "Idaho",
                "l": "Idaho"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "newColumnName": "JSON",
    "columnInsertIndex": 24,
    "baseColumnName": "locality",
    "urlExpression": "grel:\"http://www.museum.tulane.edu/webservices/geolocatesvcv2/glcwrap.aspx?Country=USA&state=\"+escape(cells.state.value,'url')+\"&county=\"+escape(cells.county.value,'url')+\"&locality=\"+escape(cells.locality.value,'url')",
    "onError": "set-to-blank",
    "delay": 1000
  },
  {
    "op": "core/column-addition",
    "description": "Create column decimalLatitude at index 25 based on column JSON using expression grel:value.parseJson().resultSet.features[0].geometry.coordinates[1]",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "value",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "state",
          "omitBlank": false,
          "columnName": "state",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": "Idaho",
                "l": "Idaho"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "newColumnName": "decimalLatitude",
    "columnInsertIndex": 25,
    "baseColumnName": "JSON",
    "expression": "grel:value.parseJson().resultSet.features[0].geometry.coordinates[1]",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column decimalLongitude at index 25 based on column JSON using expression grel:value.parseJson().resultSet.features[0].geometry.coordinates[0]",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "value",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "state",
          "omitBlank": false,
          "columnName": "state",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": "Idaho",
                "l": "Idaho"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "newColumnName": "decimalLongitude",
    "columnInsertIndex": 25,
    "baseColumnName": "JSON",
    "expression": "grel:value.parseJson().resultSet.features[0].geometry.coordinates[0]",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column reconcileScientificName at index 3 based on column scientificName using expression grel:value",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "reconcileScientificName",
    "columnInsertIndex": 3,
    "baseColumnName": "scientificName",
    "expression": "grel:value",
    "onError": "set-to-blank"
  },
  {
    "op": "core/recon",
    "description": "Reconcile cells in column reconcileScientificName to type http://uat.gbif.org/species/",
    "columnName": "reconcileScientificName",
    "config": {
      "mode": "standard-service",
      "service": "http://refine.taxonomics.org/gbifchecklists/reconcile",
      "identifierSpace": "http://uat.gbif.org/species/",
      "schemaSpace": "http://rs.tdwg.org/dwc/terms/",
      "type": {
        "id": "http://uat.gbif.org/species/",
        "name": "http://uat.gbif.org/species/"
      },
      "autoMatch": true,
      "columnDetails": []
    },
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    }
  }
]